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