How to Use Excel's FORECAST Function

Microsoft has built a wealth of powerful functions into its Excel spreadsheet to help users. The FORECAST function is a useful addition that forms forecasted values for use in estimates and projections in a spreadsheeet. The FORECAST function is something you can do to a formula, to program cell values in Excel worksheets for results that you can see in a target cell.

Instructions

Difficulty: Challenging

1. Open the function bar, a text box with the = sign to the left, that symbolizes the programming of the cell value for your selected cell. For Excel programs that are more guidance-driven, you'll have to open the function bar using "Insert" and "Function" from the menu.
2. Start off by including the FORECAST operator.
3. Start parentheses. The rest of your equation with be inside parentheses.
4. Input your target value for the forecast. This is the X number for which you can expect to get your desired Y value. The FORECAST function returns the corresponding projected Y value for your X number according to logical extension of the value range you program into it.
5. Put in your range of Y values. You can enter range of cells, like A2:A7, or a range of values in brackets, like {1,2,3,4,5}.
6. Enter a similar array of X values. Remember, the Excel sheet will take all of your X values, and all of your Y values, and project the Y number that will correspond to the X number you provided at the beginning of your equation.
7. Close parentheses. You should have a finished FORECAST command. For example, if your X and Y values are included in a set of cells between A2 and B7, your equation would look like this: FORECAST (100, A2:A7, B2:B7).

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.