The items listed down on the left-hand side are as follows:
~ 2 Months
~ 3 Months
The top of the cells are from 1 - 10.
The interest increase both as they go down, and across to the right.
My question about this, is if I were to have a different table, and in that table I have people who sign up people, and I have (I have cell referenced each part)
A1 - Name
A2 - People signed up
A3 - Interest rate
B1 - John
B2 - 3
B3 - (the interest rate)
C1 - Aimee
C2 - 7
C3 - (the interest rate)
I was to know that from the first table set up, how can I get Column 3 to represent the cell from the amount of people that have signed up. So, that in Column 3, the interest rate that is shown is from the first table, and gets the amount of interest from the people signed up.
No, it's not just simple "cell referencing" because I want the interest rate to be based on both the, time period, and how many people signed up, and I want it to be automatic instead of me doing it manually.
Is it possible?
NOTE: Here is a perfect example of what I want to achieve, just some things change.
Edited by ill_Nino, 09 June 2008 - 06:40 PM.