Translations:Documentation/Calc Functions/FLOOR.PRECISE/19/en

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