Excel - IF Function Problem - Expert Solution

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

hello i need help creating a formula, if a value does not exsits put 0, if a value exist do nothing
Solved by M. F. in 9 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 24/09/2018 - 05:19
Hello, I understand that you would like to check if a value exists, if it does then 0 else nothing, right?
User 24/09/2018 - 05:20
see form
[Uploaded an Excel file]
Excelchat Expert 24/09/2018 - 05:20
Alright, I'm downloading the file. Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question. We also currently do not support VBA/Macro solutions.
User 24/09/2018 - 05:20
just one question
Excelchat Expert 24/09/2018 - 05:20
May I know which cell should I be looking into?
User 24/09/2018 - 05:21
F6
Excelchat Expert 24/09/2018 - 05:21
Okay, may I know the logic of what you are trying to accomplish so I can translate it to words Excel understands.
User 24/09/2018 - 05:22
i want the actual sale
User 24/09/2018 - 05:22
to not calculate on f6 if there is no value
User 24/09/2018 - 05:23
if there is no value then var sale should be 0
Excelchat Expert 24/09/2018 - 05:23
And if there's a value, what is the formula to calculate it?
User 24/09/2018 - 05:24
deference between e6-d6
Excelchat Expert 24/09/2018 - 05:24
I see. I think I have a clear understanding of your requirement.
Excelchat Expert 24/09/2018 - 05:24
So if there's not value in E, then 0 else e-d.
User 24/09/2018 - 05:25
yes
Excelchat Expert 24/09/2018 - 05:25
Please paste this formula in F6:
Excelchat Expert 24/09/2018 - 05:25
=IF([@[ACTUAL SALES]]="",0,[@[ACTUAL SALES]]-[@TARGET])
User 24/09/2018 - 05:25
you are the man,
User 24/09/2018 - 05:25
or woman!
User 24/09/2018 - 05:25
thank you!!!
Excelchat Expert 24/09/2018 - 05:26
You are welcome! Glad to have helped. :)
Excelchat Expert 24/09/2018 - 05:26
So the function I used is called the IF() function.
Excelchat Expert 24/09/2018 - 05:26
Basically this allows you to have a condition and a return value depending on the result of the condition.
Excelchat Expert 24/09/2018 - 05:26
In this case, our condition is that E must not be empty.
Excelchat Expert 24/09/2018 - 05:27
=IF(condition,value if condition is true, value if condition is false)
Excelchat Expert 24/09/2018 - 05:27
Would there be anything else that I can help you with regards to the original question?
User 24/09/2018 - 05:27
no my freind
User 24/09/2018 - 05:27
thank so much
Excelchat Expert 24/09/2018 - 05:27
Alright, if you have no other questions regarding the original concern, I'd appreciate a 5-star rating and your feedback if you think I deserve it.
Excelchat Expert 24/09/2018 - 05:27
I'll be giving you high ratings as well so the other experts will know that you are a good client and should be taken care of.
Excelchat Expert 24/09/2018 - 05:27
Please do not forget to click the End Session button otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.
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.