formular
 

if 30<a1<40 after that write in a2 ,"no".what is formular

formular
 

Hi

=IF(AND(A1=30,A1<=40),"No","Something else")
Replace something else with what you want if the condition is not met.
--
Regards
Roger Govier

"readmynote student" <readmynote wrote in
message ...
if 30<a1<40 after that write in a2 ,"no".what is formular

formular
 

IF PLUS AND IS USEFUL FOR UNLIMITED LOGICAL FUNCTION BUT WITH JUST IF YOU
HAVE LIMITED.YOU CAN USE THIS IF(AND(30A1,A140),A1,"NO")

"readmynote student" wrote:

if 30<a1<40 after that write in a2 ,"no".what is formular