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$...
=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.
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.
- Does excel have a function to cap the output to the previous columns output * a number?
..................................................................................................................................................................................
I am starting with: =MIN((E13+E24)/$C$14*$C$15,$C$15), and the output is 5.13 (all good).
I switch to: =IF((E13+E24)>=0,MAX((E13+E24)/$C$14*$C$15,E14*$C$16),0) in the next column and the output is 6.15, then 7.38, 8.86,10.63,29.34, 61.2 108 end larger and larger.
Once the out reaches 10.63 it starts to go geometric, so is there anyway to cap the output and the previous column's output * a constant (*$C$16)... what that happens to scale at because it is fixed growth vs runaway growth.
It's almost like I need an IF with a MAX and a MIN or at least a cap on the MAX.Helprequested123 Attach a screenshot or send me the file via a direct message!