Returns a number that is
rounded up to the nearest integer or to the nearest multiple of significance.
Regardless of the sign of the number, the number is rounded up. However, if the
number or the significance is zero, zero is returned.
Syntax
The
syntax for the Ceiling.Precise function in Microsoft Excel is:
=CEILING.PRECISE( number, [significance] )
Parameters or Arguments
number
The number that you wish to
round up.
significance
Optional. It is the multiple
of significance that you wish to round a number to.
Ceiling.Precise Function Examples
In column B of the following
spreadsheet, the Excel Ceiling.Precise function is used to round up the
positive and negative numbers 22.25 and -22.25, to different significance
values.
Formulas:
|
|
A
|
B
|
|
1
|
number
|
ceiling.precise
|
|
2
|
22.25
|
=CEILING.PRECISE(
A2, 0.1 )
|
|
3
|
22.25
|
=CEILING.PRECISE(
A3, 0.5 )
|
|
4
|
22.25
|
=CEILING.PRECISE(
A4, 1 )
|
|
5
|
22.25
|
=CEILING.PRECISE(
A5 )
|
|
6
|
22.25
|
=CEILING.PRECISE(
A6, 10 )
|
|
7
|
22.25
|
=CEILING.PRECISE(
A7, 0 )
|
|
8
|
-22.25
|
=CEILING.PRECISE(
A8, 1 )
|
|
9
|
-22.25
|
=CEILING.PRECISE(
A9, -1 )
|
|
10
|
-22.25
|
=CEILING.PRECISE(
A10, 5 )
|
Results:
|
|
A
|
B
|
|
1
|
number
|
ceiling.precise
|
|
2
|
22.25
|
22.3
|
|
3
|
22.25
|
22.5
|
|
4
|
22.25
|
23
|
|
5
|
22.25
|
23
|
|
6
|
22.25
|
30
|
|
7
|
-22.25
|
0
|
|
8
|
-22.25
|
-22
|
|
9
|
-22.25
|
-22
|
|
10
|
-22.25
|
-20
|
The above examples show how:
Ø If
the [significance] argument is omitted, it takes on the default value of 1 (see
cell B5).
Ø If
the [significance] argument is zero, the function returns the value 0 (see cell
B7).
Ø The
arithmetic sign of the [significance] argument is ignored. The function gives
the same result for both positive and negative [significance] values (see cells
B8 & B9).
Ø the
Ceiling.Precise function always rounds the supplied number up. ie. If the
supplied number is positive, it is rounded up away from zero, but if the number
is negative it is rounded up towards zero.
References
follow us on http://arivilm.blogspot.in
like us on https://www.facebook.com/Arivilm2501
No comments:
Post a Comment