Aug 05 2022 08:36 AM
Aug 05 2022 12:14 PMSolution
More specifically, attach an Excel file with one or more examples.
Click the "browse" link near the bottom of the reply window.
If you do not see a "browse" link, upload the Excel file to a file-sharing website, and post the download URL in a reply here. I like box.net/files; others like dropbox.com. You might like onedrive.live.com because it uses the same login as this forum. Do not use Google Sheets.
If the forum does not allow you to enter a URL (yet), spell it out as text. For example, this discussion is at techcommunity dot microsoft dot com /t5/excel/forecast-function-doesn-t-return-good-data/td-p/3592388.
There are many reason why FORECAST not return "good data".
First and foremost, because your actual data does not fit a linear treadline closely.
Second, because you are using a different "flavor" of the (new) family of FORECAST functions, not FORECAST per se (without qualifier).
Finally, because you are misusing the FORECAST function. We cannot know one way or the other unless and until you show us your formula and data -- again, preferably in an Excel file that we can download.
Aug 08 2022 03:48 AM