If to determine lessor of three values

[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

 

[Harlan Grove]

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

....

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

 

[Duke Carey]

use

=Min(H42,G44:G45)

 

[David Biddulph]

If you really wanted to use an IF statement, then you could change your
formula to
=IF(AND(H42<G44,H42<G45),H42,IF(G44<G45,G44,G45))
because the syntax of an IF statement is IF(condition,value if true,value if
false),
but of course MIN is the simpler way.