Thread
:
If statement - 2 tests
View Single Post
#
2
William
Posts: n/a
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
Reply With Quote