if then statement
 

hi, i need help on an if then comparing 3 fields, a,b and c. I need to
pick the smallest number from the 3 fields.

Thanks


--
wab_77
------------------------------------------------------------------------
wab_77's Profile: http://www.excelforum.com/member.php...o&userid=33875
View this thread: http://www.excelforum.com/showthread...hreadid=536547

if then statement
 

Try using Excel formula =IF(MIN(number1,number2...),true,false).

"wab_77" wrote:


hi, i need help on an if then comparing 3 fields, a,b and c. I need to
pick the smallest number from the 3 fields.

Thanks


--
wab_77
------------------------------------------------------------------------
wab_77's Profile: http://www.excelforum.com/member.php...o&userid=33875
View this thread: http://www.excelforum.com/showthread...hreadid=536547

if then statement
 

=MIN(a,b,c)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"wab_77" wrote in
message ...

hi, i need help on an if then comparing 3 fields, a,b and c. I need to
pick the smallest number from the 3 fields.

Thanks


--
wab_77
------------------------------------------------------------------------
wab_77's Profile:
http://www.excelforum.com/member.php...o&userid=33875
View this thread: http://www.excelforum.com/showthread...hreadid=536547

if then statement
 

How about
=MIN(cell address, cell address, cell address)

if then statement
 

Thanks very much for your help!


--
wab_77
------------------------------------------------------------------------
wab_77's Profile: http://www.excelforum.com/member.php...o&userid=33875
View this thread: http://www.excelforum.com/showthread...hreadid=536547