• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula Help

junior1505

New Member
Dear Experts,
Have tabulated the premium amount for age range and insured amount.
Wish to apply the formula to find the premium amount based on age and insured amount, table pasted.
please help.
Regards

Age To
₹ 2,00,000.00​
₹ 2,50,000.00​
₹ 3,00,000.00​
₹ 3,50,000.00​
₹ 4,00,000.00​
₹ 4,50,000.00​
₹ 5,00,000.00​
40​
₹ 876.74​
₹ 1,033.68​
₹ 1,099.76​
₹ 1,251.98​
₹ 1,327.50​
₹ 1,470.28​
₹ 1,517.48​
60​
₹ 1,168.20​
₹ 1,378.24​
₹ 1,466.74​
₹ 1,668.52​
₹ 1,770.00​
₹ 1,959.98​
₹ 2,022.52​
100​
₹ 1,752.30​
₹ 2,067.36​
₹ 2,199.52​
₹ 2,503.96​
₹ 2,655.00​
₹ 2,939.38​
₹ 3,034.96​
Employee IDEmployee NameAgeSum InsuredPremium
50001​
Ramesh K
58​
₹ 2,00,000.00​
₹ 1,168.20​
50002​
Kareena B
40​
₹ 2,50,000.00​
50003​
Sanjay S
32​
₹ 4,00,000.00​
50004​
Sam C
41​
₹ 3,50,000.00​
50005​
Arpita D
65​
₹ 5,00,000.00​
 

AlanSidman

Well-Known Member
Last edited:

vletm

Excel Ninja
junior1505
As a new member, You have just read Forum Rules:
... but seems that You have forgotten already some basic rules.
Please, reread those.
 

junior1505

New Member
Greetings of the day,
Appreciate you all, @Fluff13 , @vletm and @AlanSidman for bringing it to my notice. To be honest, had not read the rules about cross posting, but went thru them now.
My Sincere apologies to the forum and you all.
Would never attempt again.
Regards.
 

vletm

Excel Ninja
junior1505
As You wrote that You went thru them now.
Should it also mean that You could follow those?
Please, You should reread those again.
 
Top