if then statement

wab_77 · Apr 26, 2006

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

Thank

Ronco · Apr 26, 2006

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

Bob Phillips · Apr 26, 2006

=MIN(a,b,c)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

Dave O · Apr 26, 2006

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

wab_77 · Apr 26, 2006

Thanks very much for your help!