Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

when pulling data from one worksheet to another, if the original cell is blank it comes through as a "0" of the destination cell. I want it to show as blank
Solved by T. S. in 6 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 05/03/2018 - 01:19
Welcome to excel got it pro.
Excelchat Expert 05/03/2018 - 01:19
I'm here to help you today.
User 05/03/2018 - 01:19
Excelchat Expert 05/03/2018 - 01:20
I understand you want blank if the the other cell is blank, right? What is the formula currently you are using?
User 05/03/2018 - 01:20
a simple "= (cell name)"
Excelchat Expert 05/03/2018 - 01:21
You can wrap the current formula inside a IF formula to make it blank. Let me show you how.
Excelchat Expert 05/03/2018 - 01:22
=IF(A1="","",A1) please look at column B. I have used this formula there.
Excelchat Expert 05/03/2018 - 01:22
Does it make sense?
Excelchat Expert 05/03/2018 - 01:22
If not please ask me.
User 05/03/2018 - 01:23
Yes it does - let me just try it
Excelchat Expert 05/03/2018 - 01:23
Sure, take your time.
Excelchat Expert 05/03/2018 - 01:24
A friendly reminder, we appreciate your feedback on our service. Once we are done, click on the end session button and after that you will be asked for the feedback.
User 05/03/2018 - 01:24
fantastic - just what i was looking for - thank you :-)
Excelchat Expert 05/03/2018 - 01:24
It is important to end session once you no longer need my service, otherwise I won't be able to help others.
Excelchat Expert 05/03/2018 - 01:24
Glad to be in assistance.
Excelchat Expert 05/03/2018 - 01:24
Anything you want to know about the solution?
User 05/03/2018 - 01:25
Nope - i was missing a "" when i was doing it all makes sense now - thank you for your help

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc