**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.