# Excel - IF Function Problem - Expert Solution

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
User 13/04/2018 - 02:52
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.

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.