Excel - Round to nearest integer

December 2016


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.

Related :

This document entitled « Excel - Round to nearest integer » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.