Hello! I am trying to calculate my 'Potential Profit' per $100 in Ranges I20:I22 and I24:I26. When I enter my wager amounts in Ranges F20:F22 and F24:F26, some of the Potential Profit amounts return incorrect values. This problem may relate to either the negative or positive values in D12:J1 or my formulas are incorrect in Ranges I20:I22 and I24:I26. Thanks for any suggestions to correct this issue.
FORMULAS:
I20
=IF(OR(D12="",D13="",F12="",I12="",I13="",F20=""),"",
IF(D13<0,100/ABS(D13)*F20,ABS(D13/100)*F20))
I21
=IF(OR(D12="",D13="",F12="",I12="",I13="",F21=""),"",
IF(F12<0,100/ABS(F12)*F21,ABS(F12/100)*F21))
I22
=IF(OR(D12="",D13="",F12="",I12="",I13="",F22=""),"",
IF(I13<0,100/ABS(I13)*F22,ABS(I13/100)*F22))
I24
=IF(OR(D14="",D15="",F14="",I14="",I15="",F24=""),"",
IF(D15<0,100/ABS(D15)*F24,ABS(D15/100)*F24))
I25
=IF(OR(D14="",D15="",F14="",I14="",I15="",F25=""),"",
IF(F14<0,100/ABS(F14)*F25,ABS(F14/100)*F25))
I26
=IF(OR(D14="",D15="",F14="",I14="",I15="",F26=""),"",
IF(I15<0,100/ABS(I15)*F26,ABS(I15/100)*F26))