Correction:
Your suggestion does work - I was picking up the wrong cell when I tested it
in haste (oops!). It has been a long day.

Many thanks for your quick and very helpful reply.
VERY SORRY for not testing it properly before replying
Annie

"Annie" wrote:

Thanks for your reply. I tried it but unfortunately 1.298701 is rounded down
to 1.298 and should be 1.299.

I need to be able to round a figure in accordance with the following
government regulations:
Amounts calculated to three decimal places only:
a) adding one thousandth where there would be more than five
ten-thousandths; and
b) ignoring the ten-thousandths where there would be five, or less than
five, ten-thousandths.

I've tried ROUND and ROUNDDOWN but neither seem to work in all scenarios.

Annie

" wrote:

Hi Annie

For some strange reason you are shifting the general rounding rule by
0.0001. Normally 5 would round up but you want it to round down. So you
have to adjust your number.

E.g. if you number is in A1. The formula in B1 is =Round(A1-0.0001,3)
That way you shift it and then round to 3.