Formula for 3 columns

H

Hank Laskin

Example as to a formula I need

Add Subtract Balance
Column C Column I Column J
$1000 -$500 =$500

All columns are set up to start with row C14 and finish with C100
I column starts with row I14 and finish with I 100
J column starts with row J14 and finish with J100

Columns C & I presently have amounts in each cell. Where there are no
actual amounts, I have $0.00 to fill cell
Column J has no figures at all except all cells have $0.00

Could someone please create a formula for me that would give me a continous
running balance in Column J based on the above information
 
E

Earl Kiosterud

Hank,
C I J
14 1000 500 =C14-I14
15 =J14+C15-I15

Copy the formula in J15 down to J100 by dragging the Fill Handle down. You
might instead want to put a starting balance in J14 instead of the formula
(though it could also go in C14)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top