CEILING.PRECISE Function Explained

The CEILING.PRECISE Function in Microsoft Excel rounds a number up to the nearest multiple of significance. It takes two arguments: the number to be rounded and the multiple of significance. It returns a number that is rounded up to the nearest multiple of significance.

CEILING.PRECISE Function Syntax

CEILING.PRECISE(number, significance)

  • number: The number you want to round up to the nearest multiple of significance.
  • significance: The multiple to which you want to round number.