Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula
I have rows of inventory numbers and I need to add a single number to the
number already in the cell, make sence? I am adding additional inventory to the number in the cell and I don't want to have to add the numbers. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula
It would be clear if you can post an example.
-- Jacob "Shelley" wrote: I have rows of inventory numbers and I need to add a single number to the number already in the cell, make sence? I am adding additional inventory to the number in the cell and I don't want to have to add the numbers. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula
store 001 004 005 006
item1 50 42 32 74 item2 45 36 22 98 above is similar how my spreadsheet is set up, but with several locations and several item #s. I have an inventory of each item, say 50 that I need to add to each of the numbers above for item1. I tried to just create a new row and add 50 to each but it would not stay on the cell I had 50 in when I copied over. "Jacob Skaria" wrote: It would be clear if you can post an example. -- Jacob "Shelley" wrote: I have rows of inventory numbers and I need to add a single number to the number already in the cell, make sence? I am adding additional inventory to the number in the cell and I don't want to have to add the numbers. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula
If you want to add 50 to each of the below numbers; then
item1 50 42 32 74 1. Type 50 in a unused cell and copy the cell 2. Keeping the copy select the cells with numbers in item 1 (which are to be incremented) 3. Right clickPasteSpecialselect 'Add' and click OK 4. This will add 50 to the selected numbers -- Jacob "Shelley" wrote: store 001 004 005 006 item1 50 42 32 74 item2 45 36 22 98 above is similar how my spreadsheet is set up, but with several locations and several item #s. I have an inventory of each item, say 50 that I need to add to each of the numbers above for item1. I tried to just create a new row and add 50 to each but it would not stay on the cell I had 50 in when I copied over. "Jacob Skaria" wrote: It would be clear if you can post an example. -- Jacob "Shelley" wrote: I have rows of inventory numbers and I need to add a single number to the number already in the cell, make sence? I am adding additional inventory to the number in the cell and I don't want to have to add the numbers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions |