Sure....you need to tell Excel when you're using text strings by enclosing
them in quotes....otherwise, it thinks the text is a reference.

Try this:
=IF(OR(C1={"3H",4,"5W"}),4,7)

Note: if the 4 will be text....then use this:
=IF(OR(C1={"3H","4","5W"}),4,7)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Sam Commar" wrote:

Ron
Thanks a ton. Do you know how i can incorpate a leter in there eg
=IF(OR(C1={3H,4,5W}),4,7)
"Ron Coderre" wrote in message
...
Try this:

=IF(OR(C1={3,4,5}),4,7)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Sam Commar" wrote:

I Am using if C1 = 3
4 = Value if True
7 = Value if False

What i wanted to do is
if C1 is 3 or 4 or 5
4 = Value if True
7 = Value if False

What is the syntax I would use if i wnat to check for multiple values i.e
3
or 4 or 5 as against just 3

Thank you very much for your assistnacce

Sam Commar