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

[jaimec77]

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?

[Ussnorway]

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

[jaimec77]

Whoops! Sorry!

How do I transfer my post? Or, remove?

[Nancy OShea · Accepted solution]

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

Nancy