Always rounding down from .5 or below and up from above .5

[slselwyn]

I need to match an accounting program where all calculations ending wit
a 5 or below at the last digit after the decimal point rounds down an
all above round up.
i.e 10.465 = 10.46, 10.466 = 10.47
VBA Round uses bankers round which rounds up odd numbers and down eve
numbers.
Worksheet Round always rounds the last 5 up.
Rounddown always rounds down so 10.465 = 10.46 and 10.466 still equal
10.46.
Can anyone please suggest a way to deal with this exact situation o
the 3 decimal points rounded to 2 as per the above rules.
I have for the moment solved it in a very clumsy way in the workshee
with a mixture of functions.

Regards

Stephe

 

[Ken Wright]

One way, but possibly no different to what you already have:-

With data in A1

=IF(MOD(A1*1000,5)=0,ROUNDDOWN(A1,2),ROUND(A1,2))

 

[Rob van Gelder]

Please advise if the following suits?

=-INT(-A1*100+0.5)/100