Excel Warriors,
I Have a small commission table similar to:
From / To
Month / Month / Comission
1 / 15/ 5.00%
16/ 20/ 6.00%
21/ 30/ 10.00%
31/ 49/ 11.00%
50/ 57/ 15.00%
58/ 180/ 20.00%
..
..
..
..
This example only has 6 intervals, but the actual workbook has 15 intervals. The "From" and "To" months are variable cells.
Now, I also have another table with:
Index Month / Commission Month
1 / Missing Formula????
2
3
4
5
.
.
.
178
179
180
What I need to develop is a reference formula that I can copy once under the cell "Commission Month" (Missing formula) then copy down to 180 and have as a result the same commission assigned in the original small commission table. Do not forget that the original "small table" has 15 intervals. Can somebody take the challenge?
Thanks for your help!
I Have a small commission table similar to:
From / To
Month / Month / Comission
1 / 15/ 5.00%
16/ 20/ 6.00%
21/ 30/ 10.00%
31/ 49/ 11.00%
50/ 57/ 15.00%
58/ 180/ 20.00%
..
..
..
..
This example only has 6 intervals, but the actual workbook has 15 intervals. The "From" and "To" months are variable cells.
Now, I also have another table with:
Index Month / Commission Month
1 / Missing Formula????
2
3
4
5
.
.
.
178
179
180
What I need to develop is a reference formula that I can copy once under the cell "Commission Month" (Missing formula) then copy down to 180 and have as a result the same commission assigned in the original small commission table. Do not forget that the original "small table" has 15 intervals. Can somebody take the challenge?
Thanks for your help!