Is there a way to have cells be interdependant on the same formula(s)?

Basically, there are three cells. They are all related by the same formulas. When I change one, it should recalculate the others.

Example - Mortgage loan:
Now, if I change the down payment to 120,000, the down payment % should change to 40%. If I change the % to 10%, then the down payment should change to 30,000.

Is there a way to do this?

 

yes, but I forget the name of the function and how to do it.

EDIT: nevermind that's simple

You just need the down payment percentage cell to have the down payment/mortgage price

 

However, you'll need two separate lists because you'll form a circular reference if you want to have two different variables in one formula.

 

data table is the function you are looking for. Use the help and you can easily apply this.
you can do single or dual variables

 

Please elaborate on what you're referring to. Are you talking about data tables, too?
I'm not sure if the data table is what I'm looking for or if I'm just not doing this right. I copied the example from the help, but I'm not seeing what the point of the table is. The table doesn't affect in input cells (which are the numbers I want to change)

 

You put all of the potential inputs along the left and top of the table
DOWN PAYMENT AMOUNTS HERE______>
L
O
A
N This populates with the calculated numbers
A as a grid of percentages
M
T
S
H
E
R
E

 

^^ That just seems like more work than should be necessary. I shouldn't need to create a table to calculate a formula. What I'm trying to emulate is the "Solver" function on an HP calculator. I have three variables and one equation. If I set any two of the variables, I should be able to solve for the remaining variable. Perhaps Excel just doesn't have this cabaility?

 

This would create a circular reference.

Just make two rows

-------------A-------------------------B-----------------C--------------D
1 Down based on %------$160,000.00----"=D1*B1"--------10%
2 % based on Down------$160,000.00----$20,000.00------"=C2/B2"

 

Goal seek and solver are both functions which can fill this gap.

Solver is complex, gaol seek is more basic.
Data>Goal seek

 

Thanks for the suggestions, but it seems that Excel just isn't geared toward doing this.

 

Goal seek uses a static value when conditions change. This won't acomplish what he is trying to do.

You can not have a cell contain a formula, and expect to place a value in it for another cell to make a calculation later. The cell will either contain a formula to provide a result, or a value for other cells to perform calculations off of with thier formulas.