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

From The Document Foundation Wiki
Jump to: navigation, search
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