The title is a little confusing, but what I would like to do is this;
in cell 1A, I input a number between 1 & 10 (representing years), in cell1D the value would change depending upon which value you placed in 1A,
1 = 0.99
2 = 0.97
3 = 0.95
4 = 0.93
5 = 0.91, and so on. This will be the divisible for cell 1Cto give an answer in 1F.
I'm not sure this is possible, but if it is and I could get a solution it would really make my day
Thank you in advance for your efforts
Bookmarks