Aug 05 2021 12:17 PM
Aug 05 2021 12:28 PM
If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!
Please include the following info to help others answer your question: Click on the Link
Welcome to your Excel discussion space!
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Aug 05 2021 12:33 PM
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.
Aug 05 2021 12:55 PM