Inside Microsoft Excel


Use past data to hit future goals with the FORECAST function

Inside Microsoft Excel

by T. L. Thomas

Sometimes, the data you have in front of you just isn’t enough. Predicting your future financial situation can help you prepare for whatever may come your way – especially during these tough economic times. Instead of relying on questionable guesswork, let the FORECAST function help you out.

FORECAST function syntax

The FORECAST function uses the following syntax:

=FORECAST(x,known_y’s,known_x’s)

Don’t let the function’s syntax and argument names intimidate you. The FORECAST function is simply about one set of values’ relationship to[…]

 

Subscribe to Inside Microsoft Excel

(get full access to archives and more)