|
| |
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:
01-Apr-2007 19:11 |
