IF Statement question
 

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.




--
peg84

IF Statement question
 

too many parentheses, try
=IF(B1=" "," ",LEFT(B1,1)&".")
peg84 wrote:

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.

IF Statement question
 

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.

--
Cheers,
Michelle
"Anyone who says he can see through women is missing a lot." Groucho Marx


"peg84" wrote:


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.




--
peg84

IF Statement question
 

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


Replace @mailinator.com with @tiscali.co.uk


"peg84" wrote in message
...

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.




--
peg84