Skip to main content
Participating Frequently
July 1, 2017
Answered

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

  • July 1, 2017
  • 3 replies
  • 356 views

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 has been closed for replies.
Correct answer Nancy OShea

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

Nancy

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

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

Whoops! Sorry!

How do I transfer my post? Or, remove?

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