Need help implementing EPA rounding method
"plb2882" wrote in message
...
wrote in message
oups.com...
PapaDos wrote:
=ROUND( a1, 0 ) - AND( MOD( a1, 1 ) = 0.5, ISEVEN( a1 ) )
That was my answer. But to avoid the anomalous failure of MOD() with
large numbers, try:
=round(a1,0) - and(a1-int(a1)=0.5, iseven(a1))
This one works for positive numbers, when you get in the negative numbers
it rounds the wrong way.
Sorry this one does work with negative numbers.
|