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,
As I can understand by your formulae, you are trying to use the formulae in below format:
- First IF checks if D23=0 → returns D17-(D17*C24)
- If not, it checks D22=0 → returns D17-(D17*C24)
- If not, it checks D21=0 → returns D17-(D17*C24)
- If none are 0 → returns 0
If my assumption is correct then, there are some issues with the formula which I have tried to explain below:
- You wrote ...C24)IF(D22... → So you are missing a comma between the IF functions.
- Each IF must be closed properly with parentheses.
- Try to update your formulae as given below:
=IF(OR(D21=0,D22=0,D23=0), D17-(D17*C24), 0)