IF / AND statements w/3 conditions

[fedgett]

I'm trying to get a statement that would compare 3 numbers and select the lower of the three.
I have so far, =IF(AND(B1<B2,B1<B3),B1,IF(AND(B2<B3,B2<B1),B2)) .

but this only covers the first 2 numbers, and will return "FALSE" if the 3rd number is the lowest.
any help would be appreciated.

it does not seem to be posting the complete formula that I have?
=IF(AND(B1<B2,B1<B3),B1,IF(AND(B2<B3,B2<B1),B2))

 

[texasalynn]

your formula didn't come thru

 

[MrKowz]

Greater than and less than signs cause problems with these forums, since they are interpreted in HTML. Put a space before and after these characters to ensure it copies over properly.

ex:
=IF(A1 > 0,B1,C1)

 

[Scott Huish]

Here is the op's formula:

IF(AND(B1<B2,B1<B3),B1,IF(AND(B2<B3,B2<B1),B2))

 

[Scott Huish]

Wouldn't this work just as well?

=MIN(B1:B3)

 

[fedgett]

=MIN works!
Not sure why I was trying to make it so difficult.

thanks . . .