Rounding Down

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi
I have a form which calulates and shows my VAT on each product and labour
charge.
The problem is when a value is equal to or above .5 ie 4.25
This is automatically changed to 4.26 which throws out my VAT by 1 every
time.
I need the value to be exactly what is calculated not the value after
rounding.
How can I overcome this problem.

Regards

John
 

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

Similar Threads

historic VAT Rate lookup 10
IIF in subform 3
Rounding 3
Rounding 2
Excel Stop Excel from displaying rounded values 4
1p out again! 5
rounding values in Access 4
Tax Invoice 1

Back
Top