How can I track numbered inventory?
 

I cannot find a formula to give me a figure for exact # in a numbered
inventory. For example: My items are numbered 800 to 819 if I just
subtract it gives me an answer of 19 when I actually have 20 items. I need
a formula that is inclusive. I tried subtracting with +1 but then on 0 item
lines, the final inventory gives me 1 item (not good) :) Please Help!!
Debbie

How can I track numbered inventory?
 

Debbie, see if using and if statement will work for you, something like
this,

=IF(B1-A1=0,0,B1-A1+1)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"DJ" wrote in message
...
I cannot find a formula to give me a figure for exact # in a numbered
inventory. For example: My items are numbered 800 to 819 if I just
subtract it gives me an answer of 19 when I actually have 20 items. I
need
a formula that is inclusive. I tried subtracting with +1 but then on 0
item
lines, the final inventory gives me 1 item (not good) :) Please Help!!
Debbie

How can I track numbered inventory?
 

Hi Debbie,
Not sure but try this,

=IF(A2-A1=1,0,A2-A1)

HTH
Regards,
Howard

"DJ" wrote in message
...
I cannot find a formula to give me a figure for exact # in a numbered
inventory. For example: My items are numbered 800 to 819 if I just
subtract it gives me an answer of 19 when I actually have 20 items. I
need
a formula that is inclusive. I tried subtracting with +1 but then on 0
item
lines, the final inventory gives me 1 item (not good) :) Please Help!!
Debbie

How can I track numbered inventory?
 

Woops, I believe, as Paul has indicated, I forgot the +1.

Regards,
Howard

"DJ" wrote in message
...
I cannot find a formula to give me a figure for exact # in a numbered
inventory. For example: My items are numbered 800 to 819 if I just
subtract it gives me an answer of 19 when I actually have 20 items. I
need
a formula that is inclusive. I tried subtracting with +1 but then on 0
item
lines, the final inventory gives me 1 item (not good) :) Please Help!!
Debbie

How can I track numbered inventory?
 

Thank you Paul. This works perfectly, Thanks again. Debbie

How can I track numbered inventory?
 

Thank you Howard. This works great, Thanks again. Debbie

How can I track numbered inventory?
 

Your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"DJ" wrote in message
...
Thank you Paul. This works perfectly, Thanks again. Debbie