3 replies
by mattiasw
Define the calculations by creating a spreadsheet that does it. ExcelEverywhere will create a web page where JavaScript is used for the calculations, so Excel is only needed when creating the webpage. The users doesn't need Excel. For a sample see
http://www.xleverywhere.com/samples/order_form/order_form1.htm
Just enter values into the Qty-column and press tab and the values are updated immediately.
More info at http://www.exceleverywhere.com
Regards,
Mattias
I presume you are talking about a form on an HTML page, since you didn't say.
Basically you need to use some JavaScript. You need to script the OnChange event of your control (assuming that's what you meant when you said they selected a quantity - a drop-down). If it's just a regular control, there's a different event (I think OnChange).
HOWEVER, you really have to keep in mind that some users will have JavaScript turned off. So, although you can offer immediate feedback for some users, you either have to prevent users with JavaScript turned off from using the page (via a
by rjclawson
Try this, you do not need any special references.
Total = bQuantity.text * EurosPerUnit + VAT
If the VAT is a percent of the Total try
Total = (bQuantity.text * EurosPerUnit) * (1 + VatRate)
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending