if then statement

[wab_77]

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

[Ronco]

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
>
>

[Dave O]

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

[Bob Phillips]

=MIN(a,b,c)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"wab_77" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[wab_77]

Thanks very much for your help!