Hi Robert

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

--


XL2003
Regards

William
willwest22@yahoo.com


"RobertLees" <RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com> wrote
in message news:RobertLees.1uod2i_1125569131.2171@excelforum-nospam.com...
>
> 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
>