Articles

Excel: How To Auto Fill Formula?

December 7, 2009 at 09:02:22
Specs: Windows XP

A simple addition and subtraction in columns, as follows:
Take the original balance, then add to it the first amount in one column, subtract the line amount in another column, then end up with the answer in a "running balance" column. Go to the next line, and in the ADDITION column, add it, go over to the SUBTRACTION column and subtract that amount, then go over and end up with the answer in the "running balance" column. After MANUALLY computing three or four of the lines, THEN "PULL DOWN" the long column and end up AUTOMATIcally with the individual line balances. [I USED TO KNOW HOW TO DO THIS!]

See More: Excel: How To Auto Fill Formula?

Report •


#1
December 7, 2009 at 09:30:42

Hi,

In cells A1, B1 & C1 headings: Add Subtract Running Balance
In Cell C2 the opening balance
In cells A3 and below values to add
In cells B3 and below values to subtract
In cell C3 this formula:

=C2+A3-B3
and just drag it down as many rows as required.

	A	B	C
1	Add	Sub	Balance
2			100
3	17	18	99
4	38	89	48
5	75	95	28
6	64	58	34
7	44	43	35
8	40	38	37
9	91	42	86

Hope this is what you were after

Regards


Report •

#2
December 7, 2009 at 10:56:26

Thank you for responding; HOWEVER, your suggested method is EXACTLY what I have tried --and what I was trying all along, and what I thought I had always used-- BUT

Report •

#3
December 7, 2009 at 10:59:05

Thank you for responding; HOWEVER, your suggested method is EXACTLY what I have tried --and what I was trying all along, and what I thought I had always PREVIOUSLY used-- BUT it will not work! I have opened the cells to see if there is any "restriction" or otherwise therein, but, no luck.

Any other suggestion(s)?

Thank you.


Report •

Related Solutions

#4
December 7, 2009 at 12:33:15

BUT it will not work!

In what way does it not work?
Do you get an error message?
Are the figures incorrect? How are they incorrect?

I have opened the cells to see if there is any "restriction" or otherwise

Don't understand what you mean by this?

MIKE

http://www.skeptic.com/


Report •

#5
December 7, 2009 at 12:39:14

Hi,

Using the sample data I provided:
1. Can you post the contents of cell C9, taken from the Formula bar,
2. What does cell C9 show on your screen
3. When you say it doesn't work, what do you see. Do any of the cells in column C below the opening balance (100) show anything?

Regards


Report •


Ask Question