For example if there are 3 items A, B and C in a set, you can choose 2 items in 6 different ways, namely AA, AB, AC, BB, BC and CC.ĬOMBINA implements the formula: (Count1+Count2-1)! / (Count2!(Count1-1)!) ExampleĬonverts a value from one unit of measurement to another unit of measurement. SyntaxĬOMBINA returns the number of unique ways to choose these items, where the order of choosing is irrelevant, and repetition of items is allowed. Returns the number of combinations of a subset of items including repetitions. For example if there are 3 items A, B and C in a set, you can choose 2 items in 3 different ways, namely AB, AC and BC.ĬOMBIN implements the formula: Count1!/(Count2!*(Count1-Count2)!) Example SyntaxĬount1 is the number of items in the set.Ĭount2 is the number of items to choose from the set.ĬOMBIN returns the number of ordered ways to choose these items. 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.

Libre calculator