Jan 10 2022 10:03 PM
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$15 = 65.8 and that is what excel is outputting.
I understand that K13+K24)/$C$14*$C$15 = 65.8 is greater than or equal to zero, so that condition is met, but how can I get the cell to choose the MINIMUM number which is the latter J14*$C$16 = 46.8???
Jan 10 2022 10:23 PM
Jan 10 2022 10:38 PM
Jan 10 2022 10:47 PM
Jan 10 2022 10:51 PM
Jan 10 2022 10:53 PM
=IF((K13+K24)>=0,MIN((K13+K24)/$C$14*$C$15,J14*$C$16),0)
Jan 10 2022 10:53 PM
Jan 10 2022 10:55 PM
Jan 10 2022 11:07 PM
Jan 10 2022 11:15 PM
Jan 10 2022 11:17 PM
Jan 10 2022 11:23 PM
@Helprequested123 Attach a screenshot or send me the file via a direct message!
Jan 10 2022 11:43 PM
Jan 10 2022 11:47 PM
Jan 10 2022 11:48 PM
Jan 11 2022 12:08 AM
@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.
Jan 11 2022 12:09 AM
Jan 11 2022 01:51 AM
Jan 11 2022 02:04 AM - edited Jan 11 2022 02:06 AM
This formula should give what you need (based on what I understood):
=IF(MIN(IF(F13+F24>=0,(F13+F24)/$C$14*$C$15,E14*$C$16),E14*$C$16)<>0,MIN(IF(F13+F24>=0,(F13+F24)/$C$14*$C$15,E14*$C$16),E14*$C$16),E14*$C$16)
Also, this formula does not take Column D into consideration, so it gives 0 result in column E which then travels forward. If you can resolve what the formula should do in column D or what the results would be in column E, this should help you.