Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to use multiple values in the If function in Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to use multiple values in the If function in Excel
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to use multiple values in the If function in Excel
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Function with multiple return values | Excel Worksheet Functions | |||
HELP ON THE VLOOK UP FUNCTION FOR MULTIPLE VALUES. | Excel Discussion (Misc queries) | |||
Finding multiple values of a function | Excel Worksheet Functions | |||
Multiple If function for more than 7 values | Excel Worksheet Functions | |||
VBA function returning multiple values? | Excel Programming |