ROUNDING

There are a number of functions that can round figures.

For these examples, the source cell is A1 and it contains the value 123.456

Formula Result Comments
=ROUND(A1,2) 123.46  
=ROUND(A1,-1) 120  
=ROUND(A1,-2) 100  
=ROUNDDOWN(A1,2) 123.45  
=ROUNDUP(A1,2) 123.46  
=ODD(A1) 125  
=EVEN(A1) 124  
=CEILING(A1,0.03) 123.48  
=FLOOR(A1,0.03) 123.45  
=INT(A1) 123  
=TRUNC(A1,2) 123.45  
=MOD(A1,2) 1.456  
     

Notes:

Published: 20-Jul-2005
Last edited: 10-Apr-2011 16:04