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$...
This formula should give what you need (based on what I understood):
=IF(MIN(IF(F13+F24>=0,(F13+F24)/$C$14*$C$15,E14*$C$16),E14*$C$16)<>0,MIN(IF(F13+F24>=0,(F13+F24)/$C$14*$C$15,E14*$C$16),E14*$C$16),E14*$C$16)
Also, this formula does not take Column D into consideration, so it gives 0 result in column E which then travels forward. If you can resolve what the formula should do in column D or what the results would be in column E, this should help you.