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?
