Solved how to round off a number in excel

Dell / Inspiron n4020
April 26, 2014 at 00:28:19
Specs: Windows 7, 2.3 GHz / 3544 MB
for example I want to round off:
1.1. or 1.2. or 1.3 or 1.4 or 1.5 this should equal to 1
but if it is 1.5.or 1.6 or 1.7 or 1.8 or 1.9 it should equal to 2.

Abdul Naseer Ansari
Afghanistan


See More: how to round off a number in excel

Report •

#1
April 26, 2014 at 05:19:27
✔ Best Answer
You have requested that 1.5 be rounded down to 1 and also rounded up to to 2. You can't do both.

This formula will do almost everything you asked for, except that 1.5 will always round up to 2:

=ROUND(A1,0)

If you must round 1.5 down to 1, you can combine the IF, ROUNDDOWN and ROUND functions:

=IF(A1=1.5,ROUNDDOWN(A1,0),ROUND(A1,0))

For some other ways to round numbers, see this site:

http://chandoo.org/wp/2012/09/28/ro...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question