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

See More: how to round off a number in excel

Report •

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:


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


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

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

Report •
Related Solutions

Ask Question