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 |
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 |
All times are GMT +1. The time now is 03:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com