SvassUK
asked on
EXCEL formula in ASP Classic
Hello,
I have a formula in Excel which I would like to present online in a HTML form and then calculate the result in ASP Classic, however if someone has a way of doing it in Javascript that would be great as well.
This is the formula in Excel and potential values for each fields. The financial formulas result C14 is how much you will have to have saved up when you retire if you like to withdraw C14 each year if the interest is D14 over E14 years.
Result Field:
=C14*(1+D14%)*((1-(1/((1+D 14%)^E14)) )/D14%)
C14: (how much you want to withdraw each year)
10000
D14: (% interest each year)
5
E14: (how many years)
20
I have a form with three fields, one for C14, D14 and E14 which I will POST or GET depening on what you recommend.
Now my biggest problem is the ^ in ASP which I haven't been able to figure out and I'm probably getting a lot of the formula wrong anyways..
Appreciate any help.
I have a formula in Excel which I would like to present online in a HTML form and then calculate the result in ASP Classic, however if someone has a way of doing it in Javascript that would be great as well.
This is the formula in Excel and potential values for each fields. The financial formulas result C14 is how much you will have to have saved up when you retire if you like to withdraw C14 each year if the interest is D14 over E14 years.
Result Field:
=C14*(1+D14%)*((1-(1/((1+D
C14: (how much you want to withdraw each year)
10000
D14: (% interest each year)
5
E14: (how many years)
20
I have a form with three fields, one for C14, D14 and E14 which I will POST or GET depening on what you recommend.
Now my biggest problem is the ^ in ASP which I haven't been able to figure out and I'm probably getting a lot of the formula wrong anyways..
Appreciate any help.
ASKER
Hi Slim81
Getting error for the code,
Getting error for the code,
Expected ')'
/calculation.asp, line 20
resultField = C14 * (1+(D14/100)) * ((1-(1/((1+(D14/100))Exp(E14))))/(D14/100))
---------------------------------------------------------^
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window