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)*(B4,1))-C4
Excel just doesn't like it but I can't seem to find why
1 Reply
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
