If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula Help
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,""))) |
#2
|
|||
|
|||
Formula Help
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,""))) |
#3
|
|||
|
|||
Formula Help
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,""))) |
#4
|
|||
|
|||
Formula Help
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,""))) |
Thread Tools | |
Display Modes | |
|
|