Formula for 3 columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hank Laskin - 09 Nov 2006 02:14 GMT

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

Signature

Thank you in advance for your assistance
HankL

Reply to this Message

Earl Kiosterud - 09 Nov 2006 03:52 GMT

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)

Signature

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

> Example as to a formula I need
>
[quoted text clipped - 12 lines]
> Could someone please create a formula for me that would give me a
> continous running balance in Column J based on the above information

Reply to this Message