If statement - 2 tests

RobertLees · Sep 1, 2005

Hi

How can I test 2 criteria to set a cell value? I think there is an
=if(or---etc, but what syntax should I use.

Thanks
Robert

William · Sep 1, 2005

Hi Robert

=IF(OR(A1=5,A1=10),"Its 5 or 10","")

--

XL2003
Regards

William
[email protected]