Percentage in a form field used for formula calculation

[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!

 

[Trevor L.]

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)..........

 

[ChristineP]

Thank you Trevor - that works perfectly!

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/