Thread: "if" formulas
View Single Post
  #2   Report Post  
Alan
 
Posts: n/a
Default

=IF(OR(A3="Sunny",A3="Windy"),1,0)
Regards,
Alan.
"Paul" wrote in message
...
Hi i've got a if formula working well but I need to give it an
alternative.
eg if a3 = sunny OR windy = 1

Any suggestion on how to make this work?