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 am getting error when I remove K13+K24>=0
You have to remove the IF function completely from consideration:
MIN((K13+K24)/$C$14*$C$15,J14*$C$16))
MIN((K13+K24)/$C$14*$C$15,J14*$C$16))
- 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.- and if K13+K24 = $0, then no expansion at all.
- Now the out is always 0.
The condition is that if IF(K13+K24>=0, then there is money to expand.
However, if there is money to expand, I want to expand at the pace the money allows for, yet never faster than the previous months tally **$C$16 (which is set at 1.2 or whatever we change it to).=IF((K13+K24)>=0,MIN((K13+K24)/$C$14*$C$15,J14*$C$16),0)
- Thank you for the formula, it is getting closer. If I change the MIN to a MAX, I am getting closer than if I leave it as MIN, but when the larger (MAX) answer comes back how can I cap that so it is the previous columns output * a constant ($C$16).
If I leave the MIN, I get one case where the output is a zero and all answers thereafter are '0', as that is the minimum.
If I change the MIN to MAX, I get growth, but it is run away growth that I need to cap.
