How can I track numbered inventory?

D

DJ

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
 
P

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

L. Howard Kittle

Hi Debbie,
Not sure but try this,

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

HTH
Regards,
Howard
 
P

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
 
Top