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$...
I have a scenario where if there is money, I have to expand the business by one of two numbers:
The previous months output* a constant *$C$16, or K13+K24)/$C$14*$C$15 -- whichever is less.
The previous months output* a constant *$C$16, or K13+K24)/$C$14*$C$15 -- whichever is less.
and if K13+K24 = $0, then no expansion at all.