Function for Rounding of Number

A

aries0070

I want to round of number for example:

1.5 = 1
1.6 = 2

What function should I use. Please help me. Thank
 
J

JE McGimpsey

That will give a syntax error, since you didn't include the second
argument.

Note that even =ROUND(A1,0) will give the wrong answer for the OP's
requirements. =ROUND(1.5,0) = 2, not 1.
 
J

JE McGimpsey

Note: that works only for non-negative numbers. If you may be rounding
negative numbers using the same pattern, use

=ROUND(A1,0)-SIGN(A1)*(MOD(A1,1)=0.5)
 
E

elioch

Generally 1.4 is rounded rounded down and 1.5 and above is rounded up.

=Round(a1,0) will behave as above. If you want to roun
down at 1.5 you need to apply as

=Round(a1-1,0)


Elioc
 
E

elioch

CORRECTION

=Round(a1,0) will behave as above. If you want to round down at 1.5 yo
need to apply as

=Round(a1-0.1,0) it ishould be minus 0.1 and not minus 1 as state
before.

Sorry

Elioc
 
B

Bernard Liengme

Not always! Some people, when rounding a number 5 as the test digit will
round to even value.
1.35 -> 1.4
1.45 -> 1.4
I have seen this called Banker's Rounding, New Math rounding, Australian
rounding.
Best wishes
 
A

Anne Troy

Thanks. I blew that one, completely. Tried to get back to it when I saw they
wanted to round DOWN on .5, and got tied up. Thanks. :)
 
Top