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.
