Forum Discussion
Formula Confusion
Can someone please explain where this formula is wrong. It was provided to me in a statistics class as a means of problem solution, however Excel does not like it. =SUM(LINEST(C2:C31, B2:B31)*(B...
You cannot use something like (B4,1) in Excel. Use this formula instead:
=FORECAST.LINEAR(B4,$C$2:$C$31,$B$2:$B$31)-C4
If you have Excel 2013 or earlier, use FORECAST instead of FORECAST.LINEAR