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

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

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