How can I track numbered inventory?

[Guest]

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

 

[Paul B]

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

 

[L. Howard Kittle]

Hi Debbie,
Not sure but try this,

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

HTH
Regards,
Howard

 

[L. Howard Kittle]

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

Regards,
Howard

 

[Guest]

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

 

[Guest]

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

 

[Paul B]

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