chucky48316
New Member
- Joined
- Oct 1, 2006
- Messages
- 1
Don't know how to even word this so I couldn't search for an answer but any help would be appreciated....
What I'm looking to do is get cells to work together, sort of like a 2 way trigger.. i.e.
setting up a loan payment....
one cell is rate, one cell is duration, and the other cell is value of loan, than you have a solution cell=pmt(rate, nper, pv).
I want it so if you put in any 3 of the 4 values it will solve for the last one.
Again thanks for any help even if just pointing me to a already answered post.
What I'm looking to do is get cells to work together, sort of like a 2 way trigger.. i.e.
setting up a loan payment....
one cell is rate, one cell is duration, and the other cell is value of loan, than you have a solution cell=pmt(rate, nper, pv).
I want it so if you put in any 3 of the 4 values it will solve for the last one.
Again thanks for any help even if just pointing me to a already answered post.