Returns the number of combinations for elements without repetition. ![]() This function exists for interoperability with Microsoft Excel 2007 or older versions. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero. negative numbers are rounded away from zero. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. Significance is the number to whose multiple the value is to be rounded up. Number is the number that is to be rounded up. Rounds a number up to the nearest multiple of Significance. =CEILING(-11 -2 1) returns -12 CEILING.MATH Note that CEILING.XCL always rounds away from zero. ![]() If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013.
0 Comments
Leave a Reply. |