Problem With Formula

Visitor

Capture.PNG

I am trying to write a formula for AL4. Basically what I want is that if AG4 is less than AH4 the number in AG4 will show in AL4, and if the number is higher then AH4 in AL4 will show 173.33

 

But the number in AL4 must not exceed the 173.33. for some reason when the number in AG4 is between the number AH4 example 174.00 will show in AL4 even though I am giving instructions not to. 

1 Reply

@jon1994 Try this:

=MAX(IF(AG4<AH4,AG4,AH4),173.33)