number < 0 = 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to conduct inventory of hardware. I need to know based on what i
have, what i need to order. When i place the needed qty, and subtract the
instock qty, sometimes i receive a neg. number. What formula do i use, so
that instead of a neg. number, it automatically shows up as a "0"?
 
maybe...

=max(0,youroriginalformulahere)
I am trying to conduct inventory of hardware. I need to know based on what i
have, what i need to order. When i place the needed qty, and subtract the
instock qty, sometimes i receive a neg. number. What formula do i use, so
that instead of a neg. number, it automatically shows up as a "0"?
Click to expand...
 
Supose A1 was Instock, B1 was Needed and C1 was your answer of A1-B1
In D11 use this =If(C1<=0,0,C1
 
Supose A1 was Instock, B1 was Needed and C1 was your answer of A1-B1
In D1 use this =If(C1<=0,0,C1) or make C1 this formul
=If(A1-B1<=0,0,A1-B1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add/Subtract columns from tab to tab in same file 3
Formula nesting with IF statements 2
Counting multiple criteria across columns and rows??? 1
tracking inventory 6
One part number with several substitute numbers 16
need advice on 0, "" , " " 2
Formula for spreadsheet total 1
Vlookup help 2

Back
Top