=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