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
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
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
>
>
How about
=MIN(cell address, cell address, cell address)
=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
>
Thanks very much for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks