ROUND ()
This function rounds a number to a specified amount of
decimal places.
If 0 is used the number is rounded to the nearest whole
number. If a negative amount of rounding is used the figures to the left of the
decimal point are rounded.
Best view in desktop mode.
A
|
B
|
C
|
D
|
E
|
|
1
|
Number
|
Places To Round
|
Rounded Number
|
||
2
|
1.47589
|
0
|
1
|
=ROUND(A2,B2)
|
|
3
|
1.47589
|
1
|
1.5
|
=ROUND(A3,B3)
|
|
4
|
1.47589
|
2
|
1.48
|
=ROUND(A4,B4)
|
|
5
|
13643.47589
|
-1
|
13640
|
=ROUND(A5,B5)
|
|
6
|
13643.47589
|
-2
|
13600
|
=ROUND(A6,B6)
|
|
7
|
13643.47589
|
-3
|
14000
|
=ROUND(A7,B7)
|
|
8
|
Syntax
=ROUND(NumberToRound,DecimalPlacesToUse)
=ROUND(number,
num_digits)
Formatting
No special
formatting is needed.
No comments:
Post a Comment