Forum Discussion
Excel formula
Hi I want to thank the excel community for helping me try to understand complex formulas. I have another formula and may have a few more in the upcoming weeks. =IF(AND(N3=1,P3=0),IF(AND(R3>=E3-90,R3...
But was my translation of the original formula correct?
With the exception of the missing " on the NA which would cause errors I believe your interpretation of the formula to be correct. So the following might be an alternative:
=IF(OR( AND(N3=1,P3=0,R3>=E3-90,R3<=F3),AND(R3>=E3,R3<=F3),AJ3=1),R3,"NA")
=IF(OR( AND(N3=1,P3=0,R3>=E3-90,R3<=F3),AND(R3>=E3,R3<=F3),AJ3=1),R3,"NA")