software

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 quot;0quot;?

maybe...

=max(0,youroriginalformulahere)

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

--

Dave Peterson


Supose A1 was Instock, B1 was Needed and C1 was your answer of A1-B1
In D11 use this =If(C1lt;=0,0,C1)--
intruder9
------------------------------------------------------------------------
intruder9's Profile: www.excelforum.com/member.php...oamp;userid=30107
View this thread: www.excelforum.com/showthread...hreadid=524547
Supose A1 was Instock, B1 was Needed and C1 was your answer of A1-B1
In D1 use this =If(C1lt;=0,0,C1) or make C1 this formula
=If(A1-B1lt;=0,0,A1-B1)--
intruder9
------------------------------------------------------------------------
intruder9's Profile: www.excelforum.com/member.php...oamp;userid=30107
View this thread: www.excelforum.com/showthread...hreadid=524547Thank you so much. =If(A1-B1lt;=0,0,A1-B1) did exactly what i needed it to do.

quot;intruder9quot; wrote:

gt;
gt; Supose A1 was Instock, B1 was Needed and C1 was your answer of A1-B1
gt; In D1 use this =If(C1lt;=0,0,C1) or make C1 this formula
gt; =If(A1-B1lt;=0,0,A1-B1)
gt;
gt;
gt; --
gt; intruder9
gt; ------------------------------------------------------------------------
gt; intruder9's Profile: www.excelforum.com/member.php...oamp;userid=30107
gt; View this thread: www.excelforum.com/showthread...hreadid=524547
gt;
gt;