# Translations:Documentation/Calc Functions/FLOOR/20/en

From The Document Foundation Wiki

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

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

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

=FLOOR(-11;-2) | rounds down -11 to nearest multiple of -2 | -12 |

=FLOOR(-10;-3;1) | rounds up -10 to nearest multiple of -3 under mode 1 which is not 0 hence result will be towards 0(rounded up) | -9 |

=FLOOR(-11.67;-2;0) | rounds down -11.67 to nearest multiple of -2 under mode 0 i.e. away from 0(rounded down) | -12 |

=FLOOR(-11.67;-2;1) | rounds up -11.67 to nearest multiple of -2 under mode 1 which is not 0 hence result will be towards 0(rounded up) | -10 |

=FLOOR(11.5;-1) | rounds down 11.5 to nearest multiple of -1 but due to opposite sign this will return an error value | Err:502 |