Forum Discussion
Min Function Nested inside an IF and/or the other way, but can't get it to work on formulas nested
I am using this formula: =MIN(IF(K13+K24>=0,(K13+K24)/$C$14*$C$15,J14*$C$16)) The end is the lower of the two results (J14*$C$16). In this case J14*$C$16 = 46.8 However, K13+K24)/$C$14*$C$...
Helprequested123 Attach a screenshot or send me the file via a direct message!
- I am thinking there must be an AND, OR I need so that when the J14 jumps to 29.34, I can limit that to I14*$C$15.
$C$15 is set at 1.2 and not shown