Function for Rounding of Number

  • Thread starter Thread starter aries0070
  • Start date Start date
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
 
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.
 
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)
 
Generally 1.4 is rounded down and 1.5 and above is rounded up.

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

=Round(a1-0.1,0)


Elioch
 
Last edited:
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
 
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. :)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round it off 3
Round Function 5
I am stuck 1
Found a Bug or Error in Access 2002-2003 Round Function 3
rounding 7
Formula needed 1
Last value 6
Formula help 1

Back
Top