Formula Help

[junior1505]

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 ID	Employee Name	Age	Sum Insured	Premium
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]

crosspost: https://www.excelforum.com/excel-fo...8620-formula-needed-to-calculate-premium.html

and

Help with formula

Dear Experts, Have the following data on Insurance premium based on age and insured amount. Wish to tabulate the insurance amount for a particular person based on age. 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...

www.mrexcel.com

 

[vletm]

junior1505
As a new member, You have just read Forum Rules:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

... but seems that You have forgotten already some basic rules.
Please, reread those.

 

[Fluff13]

Also posted here https://www.mrexcel.com/board/threads/help-with-formula.1146992/

 

[junior1505]

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]

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.