Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help setting up a financial formulain in Excell
Example:
Date closed Gain + or - % + or - 12/30/70 838.92 12/31/71 890.20 +51.28 + 6.11% 12/29/72 1020.02 +129.82 +14.58% 12/31/73 850.86 -169.82 -16.58% I would ike to keep a running total as I add the date and closed data for as long as I can, say 30 years or more. Thanks, Ed |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help setting up a financial formulain in Excell
If your example is from A1:D5, then...
E1: 'Total Gain or Loss' F1: 'Total & Gain or Loss' E3: =B3-$B$2 F3: =E3/$B$2 Copy E3 and F3 down 30 years. Format Column F to be % HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "ozarkfellow" wrote: Example: Date closed Gain + or - % + or - 12/30/70 838.92 12/31/71 890.20 +51.28 + 6.11% 12/29/72 1020.02 +129.82 +14.58% 12/31/73 850.86 -169.82 -16.58% I would ike to keep a running total as I add the date and closed data for as long as I can, say 30 years or more. Thanks, Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Financial modelling from Excel to Access | Excel Discussion (Misc queries) | |||
setting up excell to add and subtract numbers. | Excel Discussion (Misc queries) | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
lable ranges in Excell | Excel Discussion (Misc queries) |