0
Thanks

A few words of thanks would be greatly appreciated.

Excel - Round to nearest integer




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.
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Related

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 (ccm.net).

0 Comments