Results 1 to 11 of 11

Calculating Monthly Premium rates base on age

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    11

    Calculating Monthly Premium rates base on age

    Attached is sheet that I want to use to calculate monthly premium rates based on applicants age over 1,3,4,5, and 10 year terms (see "Assurant" tab). I have figured out how to calculate for one age group (i.e. 51-60) using the IF statement, but don't know how to add a multi-string to accomidate all the other age groups. Can I do this with IF or is there anouther formula I should be using?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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