Excel help please

You will need to create workbook with only one sheet in it for this assignment.

A common rule of thumb for determining the cost of a house that you can afford the "2.5 to 3" rule. Everyone has different expenses, so you can expect to be able to afford a house that is somewhere between 2.5 to 3 times your annual income (before taxes).

So, if you have a job that pays $40000 per year, you can expect to afford a house that sells in the price range of $100K to $120K.

Let's say you have your heart set on a house in a neighborhood where houses average about $140000.

Set up a workbook with one worksheet to find a range of annual income you should seek so that you can afford a house in that neighborhood.

Possible Set Up

	A	B
1	House Price	=B3*2.5
2	Low Salary	=B1/3
3	High Salary

If you use this set up, you'll need to set one target cell, most likely B1, to a target value of 140000, by changing cell B3. This is not the only way you can set up this Goal Seek.

Make sure that you run the Goal Seek tool and save its results.