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