|
Index match formula required
So I think what I need is a index match formula but not 100% sure.
Basically what I need is an insurance calculator based on age, sex and smoking status this is what your premium would be. One work sheet one are my variables. Colum B I have used validations so only the specific cl can not change them. 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 Worksheet 2 rates per $1,000 of coverage Male Female Age Band Smoker Non Smoker Smoker Non Smoker Up to 24 0.085 0.043 0.034 0.026 25 - 29 0.085 0.043 0.034 0.026 30 - 34 0.094 0.043 0.051 0.034 35 - 39 0.153 0.060 0.085 0.051 40 - 44 0.281 0.102 0.153 0.085 45 - 49 0.476 0.187 0.247 0.136 50 - 54 0.808 0.349 0.374 0.221 55 - 59 1.080 0.468 0.451 0.272 60 + 1.420 0.663 0.604 0.400 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/201003/1 |
Index match formula required
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 |
| All times are GMT +1. The time now is 06:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com