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)