**Question description:**

*This user has given permission to use the problem statement for this blog.*

I want to put in a formula that subtracts one number from another but enters a zero if it is a negative number.

Solved by C. C. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
13/04/2018 - 02:46

Hi there!

User
13/04/2018 - 02:46

hello

Excelchat Expert
13/04/2018 - 02:46

I'm sure I can help with your formula! Let me make a quick example in the google sheet ----->

Excelchat Expert
13/04/2018 - 02:48

So in that example in the green cell - C5 is subtracted from B5. If the result is a negative, then it puts 0

Excelchat Expert
13/04/2018 - 02:48

If not, it just does the subtraction. Is that what you're after?

User
13/04/2018 - 02:49

That is what I want it to do!

Excelchat Expert
13/04/2018 - 02:49

amazing!

Excelchat Expert
13/04/2018 - 02:49

Can you try that formula on your sheet and let me know if it works?

User
13/04/2018 - 02:49

I am sure it is something simple that I am missing

User
13/04/2018 - 02:49

I don't see what the formula is???

Excelchat Expert
13/04/2018 - 02:50

These types of formulas can be tricky.

Excelchat Expert
13/04/2018 - 02:50

Oh it's in the green cell - here I will paste it here as well

Excelchat Expert
13/04/2018 - 02:50

=if(B5-C5<0,0,B5-C5)

User
13/04/2018 - 02:51

I 't know I could click on it. Just a second

Excelchat Expert
13/04/2018 - 02:51

Take your time

User
13/04/2018 - 02:52

Perfect! Thanks for your help!

Excelchat Expert
13/04/2018 - 02:53

Perfect! My pleasure and don't hesitate to reach back out if you need further assistance.

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