I’ve been working with the FORECAST worksheet function a little lately and it’s been a struggle. First a quick look at the function
The known x’s and known y’s form a trendline based on linear regression, and the function returns the y coordinate on that line for the provided x.
The worksheet function seems to handle [...] Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/11/11/forecast-doesnt-like-dates/
Nov 11 2010, 06:30 AM
Daily Dose of Excel