forecast a financial value at year end

J

Jock

Cell J3 displays the total values listed in all columns on the sheet. When
another value is added to any column, J3 reflects this.
Now, to manually predict what J3 will say at year end (Dec 31st) ie an
estimate, I can simply divide J3 by the number of days passed (since Jan 1st)
and multiply by 365. This will be close enough for my purposes.
How can I put this into a formula?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

search for first value greater than zero in a row 2
Serious help needed for this project Can anyone help me with this 7
Forecasting with formulas HELP 1
Calculate value at the end of nth year using CAGR 4
Forecast with two unknown variables 4
(Part 2) - Retrieve Numeric Label for Max Value by Specific Day & Month 4
Using a date (datevalue) to trigger adding a value to a cell 10
View Year end overview 1

Top