G
Guest
I need to be able to round values to this specification using vba in Access2003
As the law requires that £0.005 or less is disregarded, we only look at the
third
decimal place in calculating NICs due where such calculation results in more
than
two decimal places.
If it is 5 or less round down.
If it is 6 or more round up.
For example, if the NIC calculated was to result in:
£67.5558 the NIC payable would be £67.55, but if the NIC payable came to
£67.5568 the NIC payable would be £67.56.
ive been using the round function but it rounds up at 5 and down at 4 but i
need it to round up at 6 and down at 5.
Can anyone help please??
As the law requires that £0.005 or less is disregarded, we only look at the
third
decimal place in calculating NICs due where such calculation results in more
than
two decimal places.
If it is 5 or less round down.
If it is 6 or more round up.
For example, if the NIC calculated was to result in:
£67.5558 the NIC payable would be £67.55, but if the NIC payable came to
£67.5568 the NIC payable would be £67.56.
ive been using the round function but it rounds up at 5 and down at 4 but i
need it to round up at 6 and down at 5.
Can anyone help please??