Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Repeating Formulas
This should be really easy, I am just terrible with excel.
I want to set up a personal finance database. It is a very easy worksheet that just looks like this A B C 1| Date | Change | Result | 2| Initial 0 500 3| 5/24/06 30 530 4| 5/25/06 -45 495 So on and so forth. Now for C3 I wrote =SUM(C2,B3) and it gave me the right answer. However, how do I make it so that every cell in the C column it always adds the number above it to the number in the cell before it, without having to write the individual equation in every cell? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Repeating Formulas
Just Copy cell C3 and paste it to the cells below.........
Or, select C3 and left-click on the black square in the lower right cornerof C3 and drag down comulm C......... Vaya con Dios, Chuck, CABGx3 "Striderider" wrote in message ... This should be really easy, I am just terrible with excel. I want to set up a personal finance database. It is a very easy worksheet that just looks like this A B C 1| Date | Change | Result | 2| Initial 0 500 3| 5/24/06 30 530 4| 5/25/06 -45 495 So on and so forth. Now for C3 I wrote =SUM(C2,B3) and it gave me the right answer. However, how do I make it so that every cell in the C column it always adds the number above it to the number in the cell before it, without having to write the individual equation in every cell? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Repeating Formulas
Hi
More logical will be: Date Change Result Initial 500 500 5/24/06 30 530 5/25/06 -45 495 Then into C2 enter the formula =IF(A2="","",SUM(C1,B2)) , and copy it down for any reasonable amount of rows (the date check allows you to have formulas in column C ready for input) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Striderider" wrote in message ... This should be really easy, I am just terrible with excel. I want to set up a personal finance database. It is a very easy worksheet that just looks like this A B C 1| Date | Change | Result | 2| Initial 0 500 3| 5/24/06 30 530 4| 5/25/06 -45 495 So on and so forth. Now for C3 I wrote =SUM(C2,B3) and it gave me the right answer. However, how do I make it so that every cell in the C column it always adds the number above it to the number in the cell before it, without having to write the individual equation in every cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
locking formulas?? | Excel Discussion (Misc queries) | |||
repeating formulas by the same row or colum increment as the last. | Excel Discussion (Misc queries) | |||
repeating formulas by the same row or colum increment as the last. | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |