Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Incremental Formulae in Excel
I'm sure I have done this in the past but can't remember how.
I am setting up a worksheet to record monthly payments. I want a running total of these payments and a decreasing running total of the initial lump sum. ie. C2 = C1 +A2 extended for say 60 months. E2 = E1 - A2 _______,,_______________ There must be an easier way than entering each new formula. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Incremental Formulae in Excel
Please post some example showing the layout of your data
-- AP "leonperrins" a écrit dans le message de news: ... I'm sure I have done this in the past but can't remember how. I am setting up a worksheet to record monthly payments. I want a running total of these payments and a decreasing running total of the initial lump sum. ie. C2 = C1 +A2 extended for say 60 months. E2 = E1 - A2 _______,,_______________ There must be an easier way than entering each new formula. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Incremental Formulae in Excel
This is a sample Date Payment £ Running Total utstanding 17/05/2006 531 531 63720 531 1062 63189 531 1593 62658 "Ardus Petus" wrote: Please post some example showing the layout of your data -- AP "leonperrins" a écrit dans le message de news: ... I'm sure I have done this in the past but can't remember how. I am setting up a worksheet to record monthly payments. I want a running total of these payments and a decreasing running total of the initial lump sum. ie. C2 = C1 +A2 extended for say 60 months. E2 = E1 - A2 _______,,_______________ There must be an easier way than entering each new formula. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
Excel : Hiding/Locking Formulae | Excel Discussion (Misc queries) | |||
formulae have stoped working on an excel sheet | Excel Worksheet Functions | |||
Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel |