I have three columns. Only 1 column may have a name and the other 2 columns
would be blank. What is the best formula to give me the name listed in either
of the three columns.

I started this formula but it isn't working:
IF(Z4=" ",AA4,IF(AA4=" ",AB4,IF(AB4=" ",Z4,"")))

If the candidate columns are A,B,C then

=A1 & B1 & C1

You don't need to test with IFs, the concatenate will pick the proper value.
--
Gary''s Student - gsnu200908


"Nikki" wrote:

I have three columns. Only 1 column may have a name and the other 2 columns
would be blank. What is the best formula to give me the name listed in either
of the three columns.

I started this formula but it isn't working:
IF(Z4=" ",AA4,IF(AA4=" ",AB4,IF(AB4=" ",Z4,"")))

If you are looking for a blank, not for a space, you could try
=IF(Z4="",AA4,IF(AA4="",AB4,IF(AB4="",Z4,"")))
instead of
=IF(Z4=" ",AA4,IF(AA4=" ",AB4,IF(AB4=" ",Z4,"")))
But it looks as if you'd still have problems, for example if Z4 is empty
you'd get AA4, even if that's blank.

Isn't the simple answer to use =Z4&AA4&AB4 ?
--
David Biddulph

"Nikki" wrote in message
...
I have three columns. Only 1 column may have a name and the other 2 columns
would be blank. What is the best formula to give me the name listed in
either
of the three columns.

I started this formula but it isn't working:
IF(Z4=" ",AA4,IF(AA4=" ",AB4,IF(AB4=" ",Z4,"")))

I used =concatenate formula it worked perfectly. I "overthunk" it. Thanks

"Gary''s Student" wrote:

If the candidate columns are A,B,C then

=A1 & B1 & C1

You don't need to test with IFs, the concatenate will pick the proper value.
--
Gary''s Student - gsnu200908


"Nikki" wrote:

I have three columns. Only 1 column may have a name and the other 2 columns
would be blank. What is the best formula to give me the name listed in either
of the three columns.

I started this formula but it isn't working:
IF(Z4=" ",AA4,IF(AA4=" ",AB4,IF(AB4=" ",Z4,"")))