Need to use multiple values in the If function in Excel
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
|