Caluclations

[Guest]

I have a spreadsheet that i would like to make available online and ideally
want to write it in HTML / Javascript

My knowledge of HTML is good, but Javascript is very poor!
Can anyone please help?

The Excel sheet has the following calulation that i would like to mimic but
just have no clue how to: -

B3 = A writable figure in £ - ie £50.00 (Users can change)
B5 = Number of years - ie 5 (Users can change)
B7 = Static price (Users cant change) ie £4.50
B9 = B3*12*B5
B11 = B3*B5
B13 = B9+B11
B15 = B13/B7
B17 = A wirtable figure in £ - ie £7.00 (Users can change)
B19 = B15*B17
B21 = B19-B13

I am looking to use CSS to build the form but i can write in HTML if needed.

Any help would be brilliant!!!!

Thanks
PaulW

 

[Stefan B Rusynko]

You need JavaScript
See http://javascript.internet.com/math-related/

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I have a spreadsheet that i would like to make available online and ideally
| want to write it in HTML / Javascript
|
| My knowledge of HTML is good, but Javascript is very poor!
| Can anyone please help?
|
| The Excel sheet has the following calulation that i would like to mimic but
| just have no clue how to: -
|
| B3 = A writable figure in £ - ie £50.00 (Users can change)
| B5 = Number of years - ie 5 (Users can change)
| B7 = Static price (Users cant change) ie £4.50
| B9 = B3*12*B5
| B11 = B3*B5
| B13 = B9+B11
| B15 = B13/B7
| B17 = A wirtable figure in £ - ie £7.00 (Users can change)
| B19 = B15*B17
| B21 = B19-B13
|
| I am looking to use CSS to build the form but i can write in HTML if needed.
|
| Any help would be brilliant!!!!
|
| Thanks
| PaulW