Forum Discussion
Nested IF, IFS, AND, OR Functions
Hello, I am attempting to set up an excel sheet to give one of three answers (TRUE, FALSE, or NA) based on different combinations of two criteria (for simplicity, "a" and "b") which have differe...
=IFS(A1="F","NA",AND(A1="M",B1>=60,B1<=100),"TRUE",AND(A1="M",OR(B1<60,B1>100)),"FALSE")
You can use this formula.