if 30<a1<40 after that write in a2 ,"no".what is formular
R Roger Govier Aug 18, 2008 #2 Hi =IF(AND(A1>=30,A1<=40),"No","Something else") Replace something else with what you want if the condition is not met.
Hi =IF(AND(A1>=30,A1<=40),"No","Something else") Replace something else with what you want if the condition is not met.
A abolbashari Aug 19, 2008 #3 IF PLUS AND IS USEFUL FOR UNLIMITED LOGICAL FUNCTION BUT WITH JUST IF YOU HAVE LIMITED.YOU CAN USE THIS IF(AND(30>A1,A1>40),A1,"NO")
IF PLUS AND IS USEFUL FOR UNLIMITED LOGICAL FUNCTION BUT WITH JUST IF YOU HAVE LIMITED.YOU CAN USE THIS IF(AND(30>A1,A1>40),A1,"NO")
