CEILING.PRECISE Function in Excel

In this post you will learn about the Ceiling.precise Function in Excel. This Function has a similar working as the Ceiling Function, it rounds up the number to the nearest high value and hence the name Ceiling.

CEILING.PRECISE Function in Excel

Syntax

=CEILING.PRECISE(number, significance)

Arguments

The syntax of the Ceiling function has two arguments

  • number – The number you want to round up
  • significance – The multiple to which you want to round the number, default value is 1.
  • The arguments in syntax can have be an integer or a decimal numbers.
  • Note that the number is rounded up to the nearest significance value multiples and not the number itself; Example =CEILING.PRECISE(5, 3) answer is 9 a multiple of 3.
  • The significance argument is optional as it has a default value.

How to use Ceiling.precise function in Excel?

  • This function rounds up the number towards the nearest integer or the multiple of the given significance.
  • For negative numbers this function always rounds up the number towards zero, as it does not consider the the sign of the significance argument.

Examples:

In the following example the Ceiling.precise function works with the default significance argument value (1).

How to use Ceiling.precise function in Excel?

When the significance value is 1, the function sometimes returns the number unchanged this is happens when there is no need to round up the number as it satisfies the significance value.

In the examples below the Ceiling.precise function syntax has:

  • Positive number and positive significance argument value (3)
How to use Ceiling.precise function in Excel?
  • Positive number and negative significance argument value (-3)
How to use Ceiling.precise function in Excel?
  • Negative number and positive significance argument value (5)
How to use Ceiling.precise function in Excel?
  • Negative number and negative significance argument value (-2)
How to use Ceiling.precise function in Excel?

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...