IF / Min statements

[fedgett]

I'm trying to use the lower of 2 or 3 numbers, depending upon a condition. (I think thats right).

Data is like this

A1-"YES" (options would be "no", "maybe", I can rework the formula for the 3 options)

B1 5
B2 18
B3 7


What I have is
=IF(A1="yes",(MIN,(B1,B2,B3)),IF(A1 < > "Yes",(MIN(B2,B3)).

What I'm looking for, if "A1" has "yes", then I want the MIN of cells b1, b2, b3.
If A1 is not "yes", then I'm looking for the min between b2 and b3.

Thanks in advance

 

[hallingh]

Try this

=IF(A1="yes",MIN(B1,B2,B3),MIN(B2,B3))

 

[AlisaA]

Just needs a minor tweak:

=IF(A1="yes",MIN(B1:B3),MIN(B2:B3))

That will handle YES and anything else that is not YES.

Does that help?

 

[fedgett]

That works.
Thanks, a real big help . . .

 

[Scott Huish]

=MIN(IF(A1="yes",B1:B3,B2:B3))