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$...
The problem in your formula is that the MIN function is only seeing the end result of the IF function. You need to show both the results to the MIN function for comparison at the same time.
I could hand you the formula but try to see if you can find a way.
Hint: Since you need the minimum of two, do you really need the condition 'K13+K24>=0'?
I could hand you the formula but try to see if you can find a way.
Hint: Since you need the minimum of two, do you really need the condition 'K13+K24>=0'?
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))- 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)
