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$...
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.
..................................................................................................................................................................................
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!
- Thank you. I understand. I'm getting closer, just not there yet.
Helprequested123 Sorry, this is useless. You are not showing the formulae in place, nor does it show the constants that you reference in column C.
- I am thinking there must be an AND, OR I need so that when the J14 jumps to 29.34, I can limit that to I14*$C$15.
$C$15 is set at 1.2 and not shown
