Dell / Inspiron n4020

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

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.

Ask Your Question

Weekly Poll