Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
formula that will provide the least of three variables
- Thread starter lkrxa
- Start date
synapsevampire
Programmer
The obvious is an IF or SWITCH statement:
If A < b then
(
if a < c then
a
else
c
)
else
If b < a then
(
if b < c then
b
else
c
);
Looks right.
There's probably a more elegant solution but it eludes me right now.
-k
If A < b then
(
if a < c then
a
else
c
)
else
If b < a then
(
if b < c then
b
else
c
);
Looks right.
There's probably a more elegant solution but it eludes me right now.
-k
Minimum(Value1,Value2,Value3)
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
- Status
Similar threads
- Locked
- Question
- Locked
- Question