domh87 0 Newbie Poster

I have to make a calculator on a site to determine a lump sum payout on life insurance, the user would enter all of 1. Gender, 2. Smoker or Not, 3. Monthly Payment. For each of the different variables there is a unique lump sum amount but no way of creating a formula to work out the different amounts, for each variant of answers how could i get the lump sum?

Example:
Gender: Male
Non Smoker
Monthly Payment: £5.00
Would return
Lump Sum = £73,814.00

Example 2:
Gender: Female
Smoker
Monthly Payment: £6.00
Would return
Lump Sum = £90,921.00

Thanks in advance