| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with a formula in inventory
I want to add number to A1 show total in A2 -A3 -- I want to be able to add new amounts to A1 and have A2 incress total. Example Recived On Hand Used 25 20 5 I recived 25 more pcs. same item my on hand should incress to 45 until I use more. Can anyone Help me -- zipper21 ------------------------------------------------------------------------ zipper21's Profile: http://www.excelforum.com/member.php...o&userid=33025 View this thread: http://www.excelforum.com/showthread...hreadid=528481 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with a formula in inventory
Hi zipper:
There are a numbre of good inventory templates available. Checkout: http://office.microsoft.com/en-us/te...827171033.aspx -- Gary's Student "zipper21" wrote: I want to add number to A1 show total in A2 -A3 -- I want to be able to add new amounts to A1 and have A2 incress total. Example Recived On Hand Used 25 20 5 I recived 25 more pcs. same item my on hand should incress to 45 until I use more. Can anyone Help me -- zipper21 ------------------------------------------------------------------------ zipper21's Profile: http://www.excelforum.com/member.php...o&userid=33025 View this thread: http://www.excelforum.com/showthread...hreadid=528481 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with a formula in inventory
Hi zipper
Are you hoping to just be able to use those cells, or are you willing to enter subsequent receipts into the rows below? To do it as you state means using an accumulator-type of function which means that you will have no history of what has been entered. Andy. "zipper21" wrote in message ... I want to add number to A1 show total in A2 -A3 -- I want to be able to add new amounts to A1 and have A2 incress total. Example Recived On Hand Used 25 20 5 I recived 25 more pcs. same item my on hand should incress to 45 until I use more. Can anyone Help me -- zipper21 ------------------------------------------------------------------------ zipper21's Profile: http://www.excelforum.com/member.php...o&userid=33025 View this thread: http://www.excelforum.com/showthread...hreadid=528481 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
