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