I have a table in which i have tenure in months in column A from 1 month to 60 months.
I have categorize months in 3 parts , (12 - 23) , (24-35) and (36 to 60)
(12-23) is 8%
(24-35) is 8.15%
(36-60) is 8.75%
I need to build a calculator with the help of macro that will calculate premium...