# Documentation/Calc Functions/FLOOR.PRECISE

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

FLOOR.PRECISE

## Category:

Mathematical

## Summary:

Rounds a number down to the nearest multiple of a significance value.

For a positive number the function rounds down (towards zero). For a negative number, the function rounds down (away form zero). The sign of the significance value is ignored.

## Syntax:

FLOOR.PRECISE(**Number** [; **Significance**])

## Returns:

Returns an integer value.

## Arguments:

**Number** is the number that is to be rounded, or a reference to a cell containing the number.

**Significance** (optional) is the value, or a reference to a cell containing the value, to whose multiple **Number** is to be rounded. It defaults to 1.

## Additional details:

## Examples:

Formula | Description | Returns |
---|---|---|

=FLOOR.PRECISE(11.5) | rounds down 11.5 to nearest multiple of 1(default) | 11 |

=FLOOR.PRECISE(-11.5) | rounds down -11.5 to nearest multiple of 1(default) | -12 |

=FLOOR.PRECISE(-11;-2) | rounds down -11 to nearest multiple of 2, ignoring the sign | -12 |

=FLOOR.PRECISE(-11;2) | rounds down -11 to nearest multiple of 2, ignoring the sign of significance being passed | -12 |

## Related LibreOffice functions:

## ODF standard:

None

## Equivalent Excel functions:

FLOOR.PRECISE