how to add or subtract from two cells into one

L

labjr1231

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
 
G

Govind

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.
 
P

Paul Sheppard

labjr1231 said:
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
Click to expand...

Hi labjr1231

with the info you have given try in C2 =A1-B1

However to keep your inventory balance you will surely need a colum
for Opening Stock?

In which case if Opening Stock was in A1, recieve B1 Shipped C1 an
Balance D1, try in D2 =A1+B1-C
 
Top