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

From The Document Foundation Wiki
Jump to: navigation, search
Formula Description Returns
=FLOOR.XCL(14.5;4) rounds down 14.5 to nearest multiple of 4 12
=FLOOR.XCL(-11;2) rounds down -11 to nearest multiple of 2 -12
=FLOOR.XCL(-11;-2) rounds up -11 to nearest multiple of 2 and negative sign will round up i.e. towards 0 -10
=FLOOR.XCL(7;4) rounds down 7 to nearest multiple of 4 4
=FLOOR.XCL(11.5) Significance value is required so it will return an error value Err:511
=FLOOR.XCL(11,-2) Significance value is negative but Number is positive so it will return an error value Err:502