Hi im trying to create an if statement for number that are beyond ±4 but doesnt works here is my statement:
im trying to make for example if number is 5 or -3 then write NOT PASS in cell, but if number is 2 or -5 write PASS so if the number is beyond ±4 write NOT PASS in cell but if its not true then write PASS i dont know what im doing wrong.![]()
=IF(AND(G5>I5,G5>I6), "NOT PASS", IF(AND(G5<I5,G5<I6), "PASS", "NOT PASS"))
thank you very much.
Bookmarks