Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to add or subtract from two cells into one
I am new to formulas. I would like to run an inventory. 3 columns, A1
recieve,B1 Shipped, C1 Balance. I want C1 to give total weither I place a number in A1 or B1. Thanks |
#2
|
|||
|
|||
Hi,
If you need a total of A1 and B1, then enter this formula (without quotes) in cell C1 "=A1+B1" But if A1 is received and B1 is shipped, shouldn't your inventory be net of A1 and B1? If you need that, then enter "=A1-B1" in cell C1 REgards Govind. labjr1231 wrote: I am new to formulas. I would like to run an inventory. 3 columns, A1 recieve,B1 Shipped, C1 Balance. I want C1 to give total weither I place a number in A1 or B1. Thanks |
#3
|
|||
|
|||
labjr1231 Wrote: I am new to formulas. I would like to run an inventory. 3 columns, A1 recieve,B1 Shipped, C1 Balance. I want C1 to give total weither I place a number in A1 or B1. Thanks Hi labjr1231 with the info you have given try in C2 =A1-B1 However to keep your inventory balance you will surely need a column for Opening Stock? In which case if Opening Stock was in A1, recieve B1 Shipped C1 and Balance D1, try in D2 =A1+B1-C1 -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=402021 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Deselect Cells while using ctrl | Excel Discussion (Misc queries) | |||
Condensing a list/range with blank cells to a new list/range without blanks | Excel Worksheet Functions | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |