|
| 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
November 18th, 2009, 08:00 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
November 18th, 2009, 08:03 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
November 18th, 2009, 08:04 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
November 18th, 2009, 08:42 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
