To do this task, use the ROUNDUP, EVEN, or ODD functions.
The example may be easier to understand if you copy it to a blank worksheet.
|
A |
Data |
20.3 |
-5.9 |
12.5493 |
Formula | Description (Result) |
=ROUNDUP(A2,0) | Rounds 20.3 up to the nearest whole number (21) |
=ROUNDUP(A3,0) | Rounds -5.9 up (-6) |
=ROUNDUP(A4,2) | Rounds 12.5493 up to the nearest hundredth, two decimal places (12.55) |
=EVEN(A2) | Rounds 20.3 up to the nearest even number (22) |
=ODD(A2) | Rounds 20.3 up to the nearest odd number (21) |
|
Posts
0 comments:
Post a Comment