Thread: formular
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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