Syntax for IF with multiple criteria

[Guest]

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

 

[Peo Sjoblom]

One way

=IF(OR(B2={4,8,10,12}),"Jones","Smith")

 

[BenjieLop]

Hi Sue,

Try this ...

=IF(OR(B2=4,B2=8,B2=10,B2=12),\"JONES\",\"SMITH\")

Regards.

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

 

[Guest]

Works perfectly, many thanks Peo!

Sue

One way

=IF(OR(B2={4,8,10,12}),"Jones","Smith")


--

Regards,

Peo Sjoblom

 

[Guest]

Many thanks BenjieLop, much appreciated!

Sue

Hi Sue,

Try this ...

=IF(OR(B2=4,B2=8,B2=10,B2=12),\"JONES\",\"SMITH\")

Regards.

 

[Bernard Liengme]

Can you please explain the point of the backward slashes in your formula?

 

[Dave Peterson]

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?)

Can you please explain the point of the backward slashes in your formula?

 

[BenjieLop]

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.