0Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE.
Eg. =AND(A2>1, A2<100) which means answer displays TRUE if A2 is greater than 1 AND less than 100, otherwise it
displays FALSE.
Eg. =IF(AND(A3>1, A3<100), A3, "The value is out of range") which means, answer displays the value in cell A3 if it is
greater than 1 AND less than 100, otherwise it displays a message. You can substitute any message of your choice.
