6 Replies Latest reply on Jul 1, 2017 2:57 AM by jaimec77

    Using lookup correct rate using age to calculate

    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?