If statement - 2 tests
 

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


--
RobertLees
------------------------------------------------------------------------
RobertLees's Profile: http://www.excelforum.com/member.php...o&userid=26580
View this thread: http://www.excelforum.com/showthread...hreadid=401072

Hi Robert

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

--


XL2003
Regards

William



"RobertLees" wrote
in message ...

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


--
RobertLees
------------------------------------------------------------------------
RobertLees's Profile:
http://www.excelforum.com/member.php...o&userid=26580
View this thread: http://www.excelforum.com/showthread...hreadid=401072