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
 
Sorry I have made a mistake.
I meant to type 4.255 is rounded to 4.26

Regards

John
 
You must log in or register to reply here.

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

Vat and Zero Rated 18
historic VAT Rate lookup 10
IIF in subform 3
Rounding 3
Rounding 2
1p out again! 5
Excel Stop Excel from displaying rounded values 4
Tax Invoice 1

Back
Top