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.