 
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: 20Jul2005
Last edited:
10Apr2011 16:04 