+ Reply to Thread
Results 1 to 3 of 3

Formula needed to calculate premium

  1. #1
    Registered User
    Join Date
    01-03-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    20

    Formula needed to calculate premium

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

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: Formula needed to calculate premium

    Please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    01-03-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Formula needed to calculate premium

    Greetings of the day,
    Thanks @AlanSidman for your message.
    Some expert did answer my question.
    Sorry about cross posting.
    Regards.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate inurance premium based on age bands
    By kbrownac1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-30-2020, 02:12 PM
  2. Excel Formula to Calculate Premium or Night Hours worked on any Shift.
    By Fran99 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-25-2019, 07:04 PM
  3. [SOLVED] Medical Premium Function/Formula Needed
    By endarmalk01 in forum Excel General
    Replies: 3
    Last Post: 02-26-2015, 07:42 PM
  4. Replies: 7
    Last Post: 10-07-2014, 10:00 PM
  5. Formula to Convert Gross Insurance Premium to Net Insurance Premium
    By jaguar1317 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-19-2014, 08:18 PM
  6. [SOLVED] Help with Nested VLOOKUP function to calculate estimated annual insurance premium
    By rinaki09 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-26-2013, 01:47 PM
  7. Replies: 1
    Last Post: 12-16-2011, 11:22 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1