Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Setting up Inventory
I have a workbook and what I am looking to do is, when I put RECEIVED in
column "C" I would like it to add Column "C" with the running total of Column "H". If i don't put received in "C" I would like it to subtract the number I put in "E". To summerize I want it to subtract.. but add when i put in Received. Any help would be great |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Setting up Inventory
I am going to assume that if you dont receive any inventory that you put 0 in
column C Do you always subtract column E, or just when there is 0 in Column C? If only when Column C is 0, Column I (or where ever you want the result) would be: =if(C1="0",H1-E1,C1+H1) This says: If Column C is 0, subtract Column E from Column H, otherwise add Column C and column H If always subtract, then use =(C1+H1)-E1 This will always subtract Column E no matter what "S.H.C" wrote: I have a workbook and what I am looking to do is, when I put RECEIVED in column "C" I would like it to add Column "C" with the running total of Column "H". If i don't put received in "C" I would like it to subtract the number I put in "E". To summerize I want it to subtract.. but add when i put in Received. Any help would be great |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Setting up Inventory
Column "C" It has a 7 digit order number in it. But when i get more, I put
Received in that box and do the addition manualy. I would like it to do it all, incase I'm not the one who does the receiving order. A C E G H Date Order# Quantity employee Running total 9/23 3512231 90 SSS 500 9/23 3512232 180 SSS 320 9/23 RECEIVED 600 SSS 920 This is an example(copy) of my page. If ya need anything else let me know. Thanks for responding "JasonP CCTM LV" wrote: I am going to assume that if you dont receive any inventory that you put 0 in column C Do you always subtract column E, or just when there is 0 in Column C? If only when Column C is 0, Column I (or where ever you want the result) would be: =if(C1="0",H1-E1,C1+H1) This says: If Column C is 0, subtract Column E from Column H, otherwise add Column C and column H If always subtract, then use =(C1+H1)-E1 This will always subtract Column E no matter what "S.H.C" wrote: I have a workbook and what I am looking to do is, when I put RECEIVED in column "C" I would like it to add Column "C" with the running total of Column "H". If i don't put received in "C" I would like it to subtract the number I put in "E". To summerize I want it to subtract.. but add when i put in Received. Any help would be great |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Setting up Inventory
Enter your opening balance in the first cell of column H and enter the
following formula in the cell immediately below and copy down as far as necessary (change the row number to suit your situation): =IF(E2="","",IF(C2="RECEIVED",H1+E2,H1-E2)) "S.H.C" wrote: Column "C" It has a 7 digit order number in it. But when i get more, I put Received in that box and do the addition manualy. I would like it to do it all, incase I'm not the one who does the receiving order. A C E G H Date Order# Quantity employee Running total 9/23 3512231 90 SSS 500 9/23 3512232 180 SSS 320 9/23 RECEIVED 600 SSS 920 This is an example(copy) of my page. If ya need anything else let me know. Thanks for responding "JasonP CCTM LV" wrote: I am going to assume that if you dont receive any inventory that you put 0 in column C Do you always subtract column E, or just when there is 0 in Column C? If only when Column C is 0, Column I (or where ever you want the result) would be: =if(C1="0",H1-E1,C1+H1) This says: If Column C is 0, subtract Column E from Column H, otherwise add Column C and column H If always subtract, then use =(C1+H1)-E1 This will always subtract Column E no matter what "S.H.C" wrote: I have a workbook and what I am looking to do is, when I put RECEIVED in column "C" I would like it to add Column "C" with the running total of Column "H". If i don't put received in "C" I would like it to subtract the number I put in "E". To summerize I want it to subtract.. but add when i put in Received. Any help would be great |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) | |||
inventory Help | Excel Worksheet Functions | |||
bar inventory | Excel Worksheet Functions | |||
bar inventory | Excel Worksheet Functions | |||
Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) |