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...
I don't think the formula is correct. There is no " after NA, and the formula returns FALSE in several situations. Perhaps it should be
=IF(AND(N3=1,P3=0),IF(AND(R3>=E3-90,R3<=F3),R3,IF(AND(R3>=E3,R3<=F3),R3,IF(AJ3=1,R3,"NA"))),"NA")
but of course I don't know what the person who wrote it intended.
- 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")
