WHAT IF ANALYSIS

Data-->What If Analysis-->Goal Seek

Set Cell:

to Value:

By Changing:

This gives one answer at a time.

To arrive at more than one answer, create a table.

Create a formula.

Reference this formula in another cell where you want to create the table.

In the column left to this cell formula create your own increments of one value you would like to change. Eg. Borrowed Amounts. You cell formula = monthly payment.

Draw a rectangle around these cells

Data-->What if Analysis-->Data Table

(1 Variable Table) + (2 Variable Table) ?

Row input Cell

Column input Cell

1 Variable

Row input Cell - Blank

Column input Cell - Reference the original cell which you used when deciding what increments to put in the rectangular box. The original cell lays outside of the rectangle, since that is where you created the original formula.

2 Variable

To arrive at more than one answer, create a table.

Create a formula.

Reference this formula in another cell where you want to create the table.

(NOT - In the column left) Under the cell formula create your own increments of one value you would like to change. Eg. Borrowed Amounts. You cell formula = monthly payment.

Add a variable left to the formula cell which relates to a new variable. Eg. Formula = € Pymt, given n, % and Loan. Columnar values = Various Loan Amoungs, Row values = n in increments of 12 months.

Create a rectangle around your values (but not row or column headings)

Data-->What If Analysis-->Data Table

You can then format your table.

Values > X = red

Values < X = yellow

Values between X+ and X- = green

Because you referenced your original cell that of Pymt, if you go into the area where you created the formula and change any other value, your whole table will change and update automatically.

Your table which is formatted has applied formatting which you can use paint formatting to transfer to another data table.