| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I track numbered inventory?
Thank you Paul. This works perfectly, Thanks again. Debbie
|
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I track numbered inventory?
Thank you Howard. This works great, Thanks again. Debbie
|
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to track inventory? | Excel Worksheet Functions | |||
| Inventory sheet to track, order & reduce quantity from master. | New Users to Excel | |||
| Make inventory sheet to track, order & reduce quantity from master | Excel Worksheet Functions | |||
| track inventory | Excel Discussion (Misc queries) | |||
| How do I create a spreadsheet to track monthly inventory | New Users to Excel | |||
Linear Mode
