Skip to main content
Participating Frequently
July 1, 2017
Answered

age based rate calculations - I need help with a form i'm putting together.

I need help with a form I am putting together.

The formula i use on excel is:

=IF(AGE>70,0,AmountSelected*VLOOKUP(AGE,RatesBelow$A$15:$E$69,IF(GENDER="Male",1,2),FALSE)/1000)*(EDATE(STARTDATE,12)-TODAY())/365)))))

the table i have for the ages and rates is as below:

Age     Male      Female

18       0.31        0.17

19       0.43        0.21

20       0.49        0.21

and so on and so forth...

so if the user selects an amount of 10,000 and the user is an 18yr old male then => (10,000(18Male=0.31)/1000=3.1) *(01/06/17-30/06/17)/365)

(3.1) *(43252-42916)/365)

(3.1 *336)/365)

(1041.6/365)

=2.85

How do I translate the above into javascript?

This topic is closed to new replies. Start a new post to keep the conversation going.
Nancy OShea
Nancy OSheaCorrect answer
Community Expert
July 2, 2017

This looks like a Life Insurance Rate Calculator or similar.  Do a Google search for same. 

Nancy

Nancy O'Shea— Product User & Community Expert

3 replies

Nancy OShea
Community Expert
Nancy OSheaCommunity ExpertCorrect answer
Community Expert
July 2, 2017

This looks like a Life Insurance Rate Calculator or similar.  Do a Google search for same. 

Nancy

Translate
Nancy O'Shea— Product User & Community Expert
jaimec77Author
Participating Frequently
July 1, 2017

Whoops! Sorry!

How do I transfer my post? Or, remove?

Translate
Ussnorway7605025
Legend
July 1, 2017

jaimec77  wrote

How do I translate the above into javascript?

I may use jquery but javascript?

p.s, moved to Dreamweaver as this is a web code question and the guys there will be able to help you better

Translate