value that the number is to be rounded up to a multiple of. Mode is an optional value. If the Mode parameter is supplied and is not equal to zero and if Number and Significance are negative, rounding up is carried out based on the absolute value of Number. This parameter is omitted when exporting to Microsoft Excel since Excel does not support a third parameter for this function Example: =CEILING ( .
; ; ) returns , =CEILING(- ;- ) returns - =CEILING (- ;- ; ) returns - , =CEILING(- ;- ; ) returns - COMBIN (Count1; Count2) Returns the number of combinations for a given number of objects (without repetition). Count1 is the number of items in the set. Count2 is the number of items to choose from the set. COMBIN returns the number of ordered ways to choose these items.
For example if there are items A, B and C in a set, you can choose items in different ways, namely AB, AC and BC. COMBIN implements the formula: Count1!/(Count2!*(Count1-Count2)!) Example: =COMBIN ( ; ) returns , =COMBIN( ; ) returns . COMBINA (Count1; Count2) Returns the number of combinations of a subset of items including repetitions. Count1 is the number of items in the set.
Count2 is the number of items to choose from the set. COMBINA returns the number of unique ways to choose these items, where the order of choosing is irrelevant, and repetition of items is allowed. For example if there are items A, B and C in a set, you can choose items in different ways, namely AB, BA, AC, CA, BC and CB. COMBINA implements the formula: (Count1+Count2- )!
/ (Count2!(Count1- )!) Example =COMBINA( ; ) returns , =COMBINA( ; ) returns COS (Number) Returns the (trigonometric) cosine of Number, whose angle is in radians. To return the cosine of an angle in degrees, use the RADIANS function. Examples: =COS(PI()/ ) returns , the cosine of PI/ in radians. =COS(RADIANS( )) returns .
, the cosine of degrees. COUNTBLANK (Range) Returns the number of empty cells in the cell range. Example: =COUNTBLANK (A1:B2) returns if cells A1, A2, B1 and B2 are all empty. COUNTIF (Range;