Best answer:
you dont need the SUM() function if you already use the +
try this formula
=IF(B2="C", (G2+H2)*D2*100, (G2-H2)*D2*100)
edit
i think opurt got it right, you have to think about your order of operations
try this...
=IF(B2="C", G2+H2*D2*100, G2-H2*D2*100)
Best answer: you dont need the SUM() function if you already use the +
try this formula
=IF(B2="C", (G2+H2)*D2*100, (G2-H2)*D2*100)
edit
i think opurt got it right, you have to think about your order of operations
try this...
=IF(B2="C", G2+H2*D2*100, G2-H2*D2*100)
4 answers
·
1 week ago