In this post, you will learn about a simple Excel function – Floor.precise function how to use it with-in the excel-spreadsheets.
The Floor.precise function rounds off a number towards the closest multiple of significance. This is a rounding function similar to the Ceiling function but, it rounds down the number towards zero, that is towards the number lesser than it, hence the name floor.
FLOOR.PRECISE Function in Excel
Syntax
=FLOOR.PRECISE(number, significance)
The syntax has two arguments
number – This argument holds the number that you want to round down.
significance -This argument holds multiple to which you want to round the number, default value 1.
- The number argument is a required whereas the significance argument is optional as it has a default value.
- Both the arguments in the syntax can be an integer or a decimal number.
- Note that the number is rounded off according to the multiples and not the number itself Example =FLOOR.PRECISE(15, 4) answer is 12 a multiple of 4.
How does the Floor.precise function work?
- The Floor.precise function rounds down the number to the closest multiple of the significance value.
- The functions rounds down the positive numbers towards zero and the negative numbers away from zero, by the default significance value.
- The Floor.precise function ignores the sign of the significance argument for both the positive and negative numbers.
How to use FLOOR.PRECISE Function in Excel?
The below example works with the default significance value with both positive and negative numbers.
Sometimes when the significance value is 1, the function returns the number unchanged as the answer. This happens when there is no need to round up the number as it satisfies the significance value.
The following example has data for both the arguments.
The following example uses negative numbers
The bellow repetition of the previous example shows that the sign of the significance value is not considered.
The syntax returns the value #VALUE! when non – numeric values are used
