Kristina1976 wrote:
So I think what I need is a index match formula but not 100% sure.

Basically what I need is an insurance premium calculator. So depending on the individual's age, sex and smoking status, I need to know what their premium will be.

On work sheet #1 are my variables, here in column B I have used validations so
only what has been idenified in the lists are options. These of course will change depending on age sex and smoking status and coverage required.

A B
Enter current age 30 - 34

Male or Female Male

Smoker or Non Smoker Non-smoker

Desired amount of coverage 50,000

Units of coverage required 50


cost of premium ??????? So the answer whould be $2.15
But how do I get the formula to work.


Worksheet 2

rates per $1,000 of coverage

A B C
D E
Male Female
Age Band Smoker Non Smoker Smoker Non Smoker
Up to 24 0.083 0.040 0.032 0.020
25 - 29 0.085 0.042 0.033 0.025
30 - 34 0.094 0.043 0.051 0.034
35 - 39 0.153 0.060 0.085 0.051

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/201003/1