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
|