Forum Discussion
IF Statement Problem
=IF(D23,0,D17-(D17*C24)IF(D22,0,D17-(D17*C24)IF(D21,0,D17-(D17*C24)))) Hello everybody new boy just joined, I am having problems with this statement could anybody help out, I have done...
Hi Lee59,
Your original formula was very close.
It just needed some commas and parentheses in the right places.
Here’s a working version, plus a few simpler alternatives.
Nested IF
=IF(B2,0,IF(C2,0,IF(D2,0,E2-(E2*F2))))
OR
=IF(OR(B2,C2,D2),0,E2-(E2*F2))
SUM
=IF(SUMPRODUCT(--(B2:D2=TRUE)) + SUMPRODUCT(--(B2:D2="TRUE"))>0,0,E2-(E2*F2))
COUNTIF
=IF(COUNTIF(B2:D2,TRUE) + COUNTIF(B2:D2,"TRUE")>0,0,E2-(E2*F2))
Keep experimenting, Lee every formula you try builds your Excel skills.
You were really close already, and now you’ve got four different ways to solve it!