Formula Help

  • Thread starter Thread starter Nikki
  • Start date Start date
N

Nikki

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.
 
Back
Top