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