Question description:
This user has given permission to use the problem statement for this
blog.
I am trying to add a name to column C when column B is null
=IF(B2 is null,E2,B2)
I am getting the #NAME?
Solved by O. S. in 6 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
15/05/2018 - 02:06
Hello :)
User
15/05/2018 - 02:06
Good morning
Excelchat Expert
15/05/2018 - 02:06
Can you show me an example of what you're looking for on the sheet to the right?
User
15/05/2018 - 02:08
some of my A2 fields have names in them, the ones that don't need to have the name from D2
Excelchat Expert
15/05/2018 - 02:08
Okay, so in this is example, is C and D acting as A and D?
User
15/05/2018 - 02:09
yes
Excelchat Expert
15/05/2018 - 02:09
Okay, I'm going to adjust so that it is exact how you want it.
Excelchat Expert
15/05/2018 - 02:10
=if(A2="",E2,A2)
Excelchat Expert
15/05/2018 - 02:10
Please see the formula in F2.
User
15/05/2018 - 02:10
that works perfectly - thank you!
Excelchat Expert
15/05/2018 - 02:11
You're very welcome.
Excelchat Expert
15/05/2018 - 02:11
Did you have any questions?
User
15/05/2018 - 02:11
no sir...thank you very much!
Excelchat Expert
15/05/2018 - 02:11
My pleasure. Please sure to end the session and rate the service received today :)
Excelchat Expert
15/05/2018 - 02:12
Also, kind words for positive ratings go a long way :)
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
