What if excel 2007

Criteria must have a column label and at least one condition in the cell below its range. For more information, refer to Establishing Criteria. Before performing a database function, you must create the criteria for the function.

If you have not already established your criteria, refer to Establishing Criteria. From the Formulas tab, click Insert Function. The Insert Function dialog box appears. From the Or select a category pull-down list, select Database. Click OK. The Function Arguments dialog box appears. For more information on how to perform any of these functions, refer to Performing Database Functions above, which provides information on the Insert Function dialog box.

The Table in this section summarizes the most commonly used database functions and is based on the following Excel database:. Was this article helpful? You need a loan to buy a new car. You know how much money you want to borrow, how long of a period of time you want to take to pay off the loan the term , and what payment you can afford to make each month. The what-if analysis tool will allow you to easily calculate the interest rate.

The formula that appears in cell B5 in the example image is a function. It isn't part of the what-if analysis tool, so you will need to understand functions thoroughly before you use what-if analysis.

Note: to see the result of a scenario, select the scenario and click on the Show button. Excel will change the value of cell C4 accordingly for you to see the corresponding result on the sheet. That's how easy what-if analysis in Excel can be. You can use Excel's Goal Seek feature to find the answer. Note: visit our page about Goal Seek for more examples and tips.

What-If Analysis.