Excel - Round to nearest integer

December 2016




Issue


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.

Solution


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.