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.