IF Statement question

P

peg84

Something is wrong with my formula below and I am hoping someone can
help me.

=IF(B1=" "," ",((LEFT(B1,1)&".")))

The formula should direct it so that if the cell B1 is blank, then this
cell (C1) should be blank as well. Otherwise, put the 1st letter of B1
and a "." It puts the "." regardless. How do I fix this.

What I am shooting for is to get the last initial if I have the last
name, but to leave blank if I don't.
 
M

Michelle

Change your formula to this...
=IF(B1="","",LEFT(B1,1)&".")

The previous way you had it you were checking if the cell had a space, not
if it was blank. If you leave the space out between the quotes you will get
the result you want. Hope that helps.
 
S

Sandy Mann

You are not testing for an empty cell, you are tesing for a cell with a
space in it. Try:

=IF(B1="","",=IF(B1="","",LEFT(B1,1)&".")

or:

=IF(ISBLANK(B1),"",LEFT(B1,1)&".")


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top