Percentage in a form field used for formula calculation

C

ChristineP

I have created a form for creating invoices. In a table cell I've put a
number form field with the number format set to 0.00%, in which the user is
to enter the percentage of VAT/sales tax. In the next cell, I have another
calculation form field where the expression is:

=(e3*f3)\# "£#,##0.00;(£#,##0.00);' '"

The problem is that, if the user enters 17.5 for the VAT/sales tax, the
resulting value becomes 1750.00%, which is obviously incorrect. The value of
17.5 that the user enters needs to be divided by 100, but how?

I'm thinking that an OnExit macro might work, but I'm not sure how to do it,
especially since each row in the table (there are 10) must undergo the same
calculation. Is there an easier way?

Any help as soon as possible will be greatly appreciated!
 
T

Trevor L.

ChristineP said:
I have created a form for creating invoices. In a table cell I've put
a number form field with the number format set to 0.00%, in which the
user is to enter the percentage of VAT/sales tax. In the next cell, I
have another calculation form field where the expression is:

=(e3*f3)\# "£#,##0.00;(£#,##0.00);' '"

Try (e3*f3/100)..........
 
C

ChristineP

Thank you Trevor - that works perfectly!

Trevor L. said:
ChristineP said:
I have created a form for creating invoices. In a table cell I've put
a number form field with the number format set to 0.00%, in which the
user is to enter the percentage of VAT/sales tax. In the next cell, I
have another calculation form field where the expression is:

=(e3*f3)\# "£#,##0.00;(£#,##0.00);' '"

Try (e3*f3/100)..........
--
Cheers,
Trevor L.
[ Microsoft MVP - FrontPage ]
MVPS Website: http://trevorl.mvps.org/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top