Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Syntax for IF with multiple criteria
Hello all
Would any kind soul help me here? I've read all the posts around this but they're just not sinking in today. I need to put a text value in column C based on a numerical value in column B based on: If B2=4,8,10 or 12 then C2="Jones" else C2="Smith" I'm sure it will be simple :-( Thanks in advance Sue |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Syntax for IF with multiple criteria
One way
=IF(OR(B2={4,8,10,12}),"Jones","Smith") -- Regards, Peo Sjoblom "SueJB" wrote in message ... Hello all Would any kind soul help me here? I've read all the posts around this but they're just not sinking in today. I need to put a text value in column C based on a numerical value in column B based on: If B2=4,8,10 or 12 then C2="Jones" else C2="Smith" I'm sure it will be simple :-( Thanks in advance Sue |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Syntax for IF with multiple criteria
Hi Sue, Try this ... =IF(OR(B2=4,B2=8,B2=10,B2=12),\"JONES\",\"SMITH\") Regards. SueJB Wrote: Hello all Would any kind soul help me here? I've read all the posts around this but they're just not sinking in today. I need to put a text value in column C based on a numerical value in column B based on: If B2=4,8,10 or 12 then C2="Jones" else C2="Smith" I'm sure it will be simple :-( Thanks in advance Sue -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=494922 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Syntax for IF with multiple criteria
Works perfectly, many thanks Peo!
Sue "Peo Sjoblom" wrote: One way =IF(OR(B2={4,8,10,12}),"Jones","Smith") -- Regards, Peo Sjoblom "SueJB" wrote in message ... Hello all Would any kind soul help me here? I've read all the posts around this but they're just not sinking in today. I need to put a text value in column C based on a numerical value in column B based on: If B2=4,8,10 or 12 then C2="Jones" else C2="Smith" I'm sure it will be simple :-( Thanks in advance Sue |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Syntax for IF with multiple criteria
Many thanks BenjieLop, much appreciated!
Sue "BenjieLop" wrote: Hi Sue, Try this ... =IF(OR(B2=4,B2=8,B2=10,B2=12),\"JONES\",\"SMITH\") Regards. SueJB Wrote: Hello all Would any kind soul help me here? I've read all the posts around this but they're just not sinking in today. I need to put a text value in column C based on a numerical value in column B based on: If B2=4,8,10 or 12 then C2="Jones" else C2="Smith" I'm sure it will be simple :-( Thanks in advance Sue -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=494922 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Syntax for IF with multiple criteria
Can you please explain the point of the backward slashes in your formula?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "BenjieLop" wrote in message ... Hi Sue, Try this ... =IF(OR(B2=4,B2=8,B2=10,B2=12),\"JONES\",\"SMITH\") Regards. SueJB Wrote: Hello all Would any kind soul help me here? I've read all the posts around this but they're just not sinking in today. I need to put a text value in column C based on a numerical value in column B based on: If B2=4,8,10 or 12 then C2="Jones" else C2="Smith" I'm sure it will be simple :-( Thanks in advance Sue -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=494922 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Syntax for IF with multiple criteria
I think they're coming from the way the message is posted. BenjieLop uses that
web based CDO stuff. I'm not sure if it's some formatting that being changed or just an "escape" character for the double quotes. I've seen other posts (I forget the authoring tool) that bold some characters. But the bolding is changed to leading/trailing asterisks. This is *bold*. (It's kind of irritating, huh?) Bernard Liengme wrote: Can you please explain the point of the backward slashes in your formula? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "BenjieLop" wrote in message ... Hi Sue, Try this ... =IF(OR(B2=4,B2=8,B2=10,B2=12),\"JONES\",\"SMITH\") Regards. SueJB Wrote: Hello all Would any kind soul help me here? I've read all the posts around this but they're just not sinking in today. I need to put a text value in column C based on a numerical value in column B based on: If B2=4,8,10 or 12 then C2="Jones" else C2="Smith" I'm sure it will be simple :-( Thanks in advance Sue -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=494922 -- Dave Peterson |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Syntax for IF with multiple criteria
Bernard, I did not have any back slashes in the formula that I suggested. All I had were quotation marks and nothing more. I really do not know where the back slashes came from. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=494922 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Criteria | Excel Worksheet Functions | |||
Counting by multiple criteria | Excel Worksheet Functions | |||
Multiple Criteria (add or subtract) | Excel Discussion (Misc queries) | |||
Multiple Criteria IF Nesting | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) |