Forum Discussion
Lee59
Sep 16, 2025Copper Contributor
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...
Lee59
Sep 26, 2025Copper Contributor
Hi, After using it I realised it is not returning the correct values and would need to address the second part of the statement. I have added what I thought was right but it does not still work, could you help with this.
=IF(OR(D25=0,D26=0,D27=0),D21-(D21*C28),(D25>0,D26>0,D27>0),(C25/10,C26/10,C27/10,),0)))) |