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

sum a column range basing on financial year. 5
Financial Functions, in particular, the INTRATE function 5
Moving data in financial forecast 1
Calculate Days Left in Current Year 3
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
Forecast with two unknown variables 4

Top