Forum Discussion
Problem With Formula
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 ...
jon1994 Try this:
=MAX(IF(AG4<AH4,AG4,AH4),173.33)