The CEILING.PRECISE function returns the number rounded up to the nearest multiple of significance.
Formula:
=CEILING.PRECISE(number, significance)
Explanations:
– The number is required, which is the number that you want to round.
– The significance is optional, which is the multiple to which you want to round.
Cautions:
– The number is rounded up regardless of the sign of the number.
– When significance is omitted, its default value is 1.
