Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula that fills in from one cell, but if it's empty, uses the information in another cell.
Solved by E. H. in 6 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
20/12/2017 - 04:42
Welcome to excel got it pro.
Excelchat Expert
20/12/2017 - 04:42
I'm here to help you today.
User
20/12/2017 - 04:42
thanks
Excelchat Expert
20/12/2017 - 04:42
Please tell me details on the problem.
User
20/12/2017 - 04:42
lets say I'm in C1 to write a formula
User
20/12/2017 - 04:42
I want it to pull the data in B1, unless B1 is empty
User
20/12/2017 - 04:43
then I want it to pull A1
User
20/12/2017 - 04:43
that's it!
Excelchat Expert
20/12/2017 - 04:43
So, if B1 is empty then pull from A1 otherwise use B1, right?
User
20/12/2017 - 04:44
yes!
Excelchat Expert
20/12/2017 - 04:44
got it, gimme a few minutes please.
User
20/12/2017 - 04:45
no problem, thanks
Excelchat Expert
20/12/2017 - 04:46
=IF(B1<>"",B1,A1)
Excelchat Expert
20/12/2017 - 04:46
Here's the formula
Excelchat Expert
20/12/2017 - 04:47
Please try it and let me know.
User
20/12/2017 - 04:47
perfect!
Excelchat Expert
20/12/2017 - 04:47
A friendly reminder, Please close the session when you are done by clicking on the "end session" button.
User
20/12/2017 - 04:47
it's working!
User
20/12/2017 - 04:47
will do, thank you!
Excelchat Expert
20/12/2017 - 04:47
Also I would appreciate if you leave a good feedback for me.
User
20/12/2017 - 04:47
definitely!
Excelchat Expert
20/12/2017 - 04:47
Thanks and have a great day!
User
20/12/2017 - 04:48
you too!
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.