Forum Discussion
Helprequested123
Jan 11, 2022Copper Contributor
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$...
Riny_van_Eekelen
Jan 11, 2022Platinum Contributor
Helprequested123 Attach a screenshot or send me the file via a direct message!
Helprequested123
Jan 11, 2022Copper Contributor
- Helprequested123Jan 11, 2022Copper ContributorThank you. I understand. I'm getting closer, just not there yet.
- Riny_van_EekelenJan 11, 2022Platinum Contributor
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.