Excel - Round to nearest integer

April 2018


I have a table in Excel 2010 or I would round up to whole number.
Example: If if have 15.01 it must be rounded to 16.


We should therefore use =ROUND(cellule,numbers_to_be_rounded)

If you have 3.141597 in cell A1:
=ROUND(A1,0) gives 3 as a result   
=ROUND(A1,1) gives 3.1 as result   
=ROUND(A1,2) gives 3.14 as a result   
=ROUND(A1,3) gives 3.142 as a result

etc ...

And for rounding up:
=ROUND(A1+1,0) gives 4 as a result

and with the transitivity of the addition
=ROUND(A1,0)+1, also gives 4 as a result

Thanks to Bruce Willix for this tip.
Published by aakai1056. Latest update on April 12, 2012 at 05:43 AM by aquarelle.
This document, titled "Excel - Round to nearest integer," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Recover a previous version of an Excel file
Excel/VBA - Select cells between 2 keywords