Hi, my formula works right now as it is. However, I want to be able to also type NA on cell CF8 and also give me a warning. Right now it just defaults to #value because it expects a number. What can I do?
=IF(OR(AND(CE8>CF8-2.5,CE8<CF8+2.5),CF8=""),"PASS","WARNING")
Bookmarks