software

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=quot;Jonesquot; else C2=quot;Smithquot;

I'm sure it will be simple :-(

Thanks in advance
Sue

One way

=IF(OR(B2={4,8,10,12}),quot;Jonesquot;,quot;Smithquot;)--

Regards,

Peo Sjoblom

quot;SueJBquot; gt; wrote in message
...
gt; Hello all
gt;
gt; Would any kind soul help me here? I've read all the posts around this but
gt; they're just not sinking in today.
gt;
gt; I need to put a text value in column C based on a numerical value in
column
gt; B based on:
gt;
gt; If B2=4,8,10 or 12 then C2=quot;Jonesquot; else C2=quot;Smithquot;
gt;
gt; I'm sure it will be simple :-(
gt;
gt; Thanks in advance
gt; Sue

Hi Sue,

Try this ...

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

Regards.SueJB Wrote:
gt; Hello all
gt;
gt; Would any kind soul help me here? I've read all the posts around this
gt; but
gt; they're just not sinking in today.
gt;
gt; I need to put a text value in column C based on a numerical value in
gt; column
gt; B based on:
gt;
gt; If B2=4,8,10 or 12 then C2=quot;Jonesquot; else C2=quot;Smithquot;
gt;
gt; I'm sure it will be simple :-(
gt;
gt; Thanks in advance
gt; Sue--
BenjieLop------------------------------------------------------------------------
BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
View this thread: www.excelforum.com/showthread...hreadid=494922Works perfectly, many thanks Peo!

Sue

quot;Peo Sjoblomquot; wrote:

gt; One way
gt;
gt; =IF(OR(B2={4,8,10,12}),quot;Jonesquot;,quot;Smithquot;)
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; quot;SueJBquot; gt; wrote in message
gt; ...
gt; gt; Hello all
gt; gt;
gt; gt; Would any kind soul help me here? I've read all the posts around this but
gt; gt; they're just not sinking in today.
gt; gt;
gt; gt; I need to put a text value in column C based on a numerical value in
gt; column
gt; gt; B based on:
gt; gt;
gt; gt; If B2=4,8,10 or 12 then C2=quot;Jonesquot; else C2=quot;Smithquot;
gt; gt;
gt; gt; I'm sure it will be simple :-(
gt; gt;
gt; gt; Thanks in advance
gt; gt; Sue
gt;
gt;
gt;

Many thanks BenjieLop, much appreciated!

Sue

quot;BenjieLopquot; wrote:

gt;
gt; Hi Sue,
gt;
gt; Try this ...
gt;
gt; =IF(OR(B2=4,B2=8,B2=10,B2=12),\quot;JONES\quot;,\quot;SMITH\quot;)
gt;
gt; Regards.
gt;
gt;
gt; SueJB Wrote:
gt; gt; Hello all
gt; gt;
gt; gt; Would any kind soul help me here? I've read all the posts around this
gt; gt; but
gt; gt; they're just not sinking in today.
gt; gt;
gt; gt; I need to put a text value in column C based on a numerical value in
gt; gt; column
gt; gt; B based on:
gt; gt;
gt; gt; If B2=4,8,10 or 12 then C2=quot;Jonesquot; else C2=quot;Smithquot;
gt; gt;
gt; gt; I'm sure it will be simple :-(
gt; gt;
gt; gt; Thanks in advance
gt; gt; Sue
gt;
gt;
gt; --
gt; BenjieLop
gt;
gt;
gt; ------------------------------------------------------------------------
gt; BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
gt; View this thread: www.excelforum.com/showthread...hreadid=494922
gt;
gt;

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

quot;BenjieLopquot; gt; wrote
in message ...
gt;
gt; Hi Sue,
gt;
gt; Try this ...
gt;
gt; =IF(OR(B2=4,B2=8,B2=10,B2=12),\quot;JONES\quot;,\quot;SMITH\quot;)
gt;
gt; Regards.
gt;
gt;
gt; SueJB Wrote:
gt;gt; Hello all
gt;gt;
gt;gt; Would any kind soul help me here? I've read all the posts around this
gt;gt; but
gt;gt; they're just not sinking in today.
gt;gt;
gt;gt; I need to put a text value in column C based on a numerical value in
gt;gt; column
gt;gt; B based on:
gt;gt;
gt;gt; If B2=4,8,10 or 12 then C2=quot;Jonesquot; else C2=quot;Smithquot;
gt;gt;
gt;gt; I'm sure it will be simple :-(
gt;gt;
gt;gt; Thanks in advance
gt;gt; Sue
gt;
gt;
gt; --
gt; BenjieLop
gt;
gt;
gt; ------------------------------------------------------------------------
gt; BenjieLop's Profile:
gt; www.excelforum.com/member.php...oamp;userid=11019
gt; View this thread: www.excelforum.com/showthread...hreadid=494922
gt;
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 quot;escapequot;
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:
gt;
gt; Can you please explain the point of the backward slashes in your formula?
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;BenjieLopquot; gt; wrote
gt; in message ...
gt; gt;
gt; gt; Hi Sue,
gt; gt;
gt; gt; Try this ...
gt; gt;
gt; gt; =IF(OR(B2=4,B2=8,B2=10,B2=12),\quot;JONES\quot;,\quot;SMITH\quot;)
gt; gt;
gt; gt; Regards.
gt; gt;
gt; gt;
gt; gt; SueJB Wrote:
gt; gt;gt; Hello all
gt; gt;gt;
gt; gt;gt; Would any kind soul help me here? I've read all the posts around this
gt; gt;gt; but
gt; gt;gt; they're just not sinking in today.
gt; gt;gt;
gt; gt;gt; I need to put a text value in column C based on a numerical value in
gt; gt;gt; column
gt; gt;gt; B based on:
gt; gt;gt;
gt; gt;gt; If B2=4,8,10 or 12 then C2=quot;Jonesquot; else C2=quot;Smithquot;
gt; gt;gt;
gt; gt;gt; I'm sure it will be simple :-(
gt; gt;gt;
gt; gt;gt; Thanks in advance
gt; gt;gt; Sue
gt; gt;
gt; gt;
gt; gt; --
gt; gt; BenjieLop
gt; gt;
gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; BenjieLop's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=11019
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=494922
gt; gt;

--

Dave Peterson


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: www.excelforum.com/member.php...oamp;userid=11019
View this thread: www.excelforum.com/showthread...hreadid=494922