If to determine lessor of three values

  • Thread starter Thread starter Jo-Anne
  • Start date Start date
J

Jo-Anne

I am trying to build an IF statement that will return the lessor of three
values and although I think this should be easy, it's not working.

So my values are:
H42 = 500
G44 = 400
G45 = 425

Here's my statement that's not working...
=IF(AND(H42<G44,H42<G45),IF(G44<G45,G44),H42)

thanks in advance
 
Jo-Anne said:
I am trying to build an IF statement that will return the lessor of three
values and although I think this should be easy, it's not working.

So my values are:
H42 = 500
G44 = 400
G45 = 425
Click to expand...
....

Why not use =MIN(H42,G44,G45) ?
 
Back
Top