Please see the attachment.
Is there a formula that I can put next to the final date that will "forecast" the number?
Please see the attachment.
Is there a formula that I can put next to the final date that will "forecast" the number?
Please explain the logic?
My car contract allows 12,000 miles per year and I'm checking if I'm estimated to hit it :P
Last edited by AliGW; 10-29-2019 at 05:07 AM. Reason: Please don't quote unnecessarily!
Try this:
Excel 2016 (Windows) 32 bit
A B 1Date Amount 2 06/08/2019 77 3 16/08/2019 480 4 29/08/2019 889 5 12/09/2019 1302 6 24/09/2019 1703 7 09/10/2019 2083 8 24/10/2019 2500 9 28/07/2020 10985.25
Sheet: Sheet1
Excel 2016 (Windows) 32 bit
B 9 =FORECAST.LINEAR(A9,B2:B8,A2:A8)
Sheet: Sheet1
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You legend.
Last edited by AliGW; 10-29-2019 at 04:50 AM. Reason: Please don't quote unnecessarily!
No worries. I just hunted through the FORECAST functions and checked how to use them, then it was an easy matter of applying this one. Simples!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
You should know better!
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
And you didn't even credit this thread when you got your answer!!!
I have a new one if possible, please.
A 1 5514 2 7869 3 10987 4 14691 5 18854 6 ?
Last edited by King Mustard; 07-22-2020 at 04:24 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks