Round a number to a near fraction
To do this task, use the ROUND function.
The example may be easier to understand if you copy it to a blank worksheet.
|
A |
Data |
1.25 |
30.452 |
Formula | Description (Result) |
=ROUND(A2,1) | Rounds the number to the nearest tenth (one decimal place). Because the portion to be rounded is 0.05 or greater, the number is rounded up (result: 1.3) |
=ROUND(A3,2) | Rounds the number to the nearest hundredth (two decimal places). Because the portion to be rounded, 0.002, is less than 0.005, the number is rounded down (result: 30.45) |
|
Posts
0 comments:
Post a Comment