"if" formulas

Paul · Jul 31, 2005

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?

Alan · Jul 31, 2005

=IF(OR(A3="Sunny",A3="Windy"),1,0)
Regards,
Alan.

Paul · Jul 31, 2005

Cheers Alan

Only taking me weeks to work that out and it was as simple as that! thanks
again!

Alan · Jul 31, 2005

You're welcome,
Regards,
Alan.

Paul said:
Cheers Alan

Only taking me weeks to work that out and it was as simple as that! thanks
again!