Difference between revisions of "Documentation/How Tos/Calc: COMBINA function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
−
{{Documentation/MasterTOC
+
{{DISPLAYTITLE:COMBINA function}}
−
|bookid=1234'''
+
{{Documentation/CalcFunc MathematicalTOC
−
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
+
|ShowPrevNext=block
−
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Mathematical_functions|<div style="font-size: 140%;">Mathematical Functions]]
+
|PrevPage=Documentation/How_Tos/Calc:_COMBIN_function
−
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_CONVERT_function
+
|NextPage=Documentation/How_Tos/Calc:_CONVERT_function
−
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_COMBIN_function
+
}}__NOTOC__
−
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Logical_functions
+
−
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Number_Conversion_functions
+
−
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Trigonometric</div>
+
−
* [[Documentation/How_Tos/Calc:_COS_function|<div style="font-size: 120%;">Cos]]
+
−
* [[Documentation/How_Tos/Calc:_SIN_function|<div style="font-size: 120%;">Sin]]
+
−
* [[Documentation/How_Tos/Calc:_TAN_function|<div style="font-size: 120%;">Tan]]
+
−
* [[Documentation/How_Tos/Calc:_COT_function|<div style="font-size: 120%;">Cot]]
+
−
* [[Documentation/How_Tos/Calc:_ACOS_function|<div style="font-size: 120%;">Acos]]
+
−
* [[Documentation/How_Tos/Calc:_ACOT_function|<div style="font-size: 120%;">Acot]]
+
−
* [[Documentation/How_Tos/Calc:_ASIN_function|<div style="font-size: 120%;">Asin]]
+
−
* [[Documentation/How_Tos/Calc:_ATAN_function|<div style="font-size: 120%;">Atan]]
+
−
* [[Documentation/How_Tos/Calc:_ATAN2_function|<div style="font-size: 120%;">Atan2]]
+
−
* [[Documentation/How_Tos/Calc:_DEGREES_function|<div style="font-size: 120%;">Degrees]]
+
−
* [[Documentation/How_Tos/Calc:_RADIANS_function|<div style="font-size: 120%;">Radians]]
+
−
* [[Documentation/How_Tos/Calc:_PI_function|<div style="font-size: 120%;">Pi]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Hyperbolic</div>
+
−
* [[Documentation/How_Tos/Calc:_COSH_function|<div style="font-size: 120%;">Cosh]]
+
−
* [[Documentation/How_Tos/Calc:_SINH_function|<div style="font-size: 120%;">Sinh]]
+
−
* [[Documentation/How_Tos/Calc:_TANH_function|<div style="font-size: 120%;">Tanh]]
+
−
* [[Documentation/How_Tos/Calc:_COTH_function|<div style="font-size: 120%;">Coth]]
+
−
* [[Documentation/How_Tos/Calc:_ACOSH_function|<div style="font-size: 120%;">Acosh]]
+
−
* [[Documentation/How_Tos/Calc:_ACOTH_function|<div style="font-size: 120%;">Acoth]]
+
−
* [[Documentation/How_Tos/Calc:_ASINH_function|<div style="font-size: 120%;">Asinh]]
+
−
* [[Documentation/How_Tos/Calc:_ATANH_function|<div style="font-size: 120%;">Atanh]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Rounding and remainders</div>
+
−
* [[Documentation/How_Tos/Calc:_TRUNC_function|<div style="font-size: 120%;">Trunc]]
+
−
* [[Documentation/How_Tos/Calc:_ROUND_function|<div style="font-size: 120%;">Round]]
+
−
* [[Documentation/How_Tos/Calc:_ROUNDDOWN_function|<div style="font-size: 120%;">Rounddown]]
+
−
* [[Documentation/How_Tos/Calc:_ROUNDUP_function|<div style="font-size: 120%;">Roundup]]
+
−
* [[Documentation/How_Tos/Calc:_CEILING_function|<div style="font-size: 120%;">Ceiling]]
+
−
* [[Documentation/How_Tos/Calc:_FLOOR_function|<div style="font-size: 120%;">Floor]]
+
−
* [[Documentation/How_Tos/Calc:_EVEN_function|<div style="font-size: 120%;">Even]]
+
−
* [[Documentation/How_Tos/Calc:_ODD_function|<div style="font-size: 120%;">Odd]]
+
−
* [[Documentation/How_Tos/Calc:_MROUND_function|<div style="font-size: 120%;">Mround]]
+
−
* [[Documentation/How_Tos/Calc:_INT_function|<div style="font-size: 120%;">Int]]
+
−
* [[Documentation/How_Tos/Calc:_QUOTIENT_function|<div style="font-size: 120%;">Quotient]]
+
−
* [[Documentation/How_Tos/Calc:_MOD_function|<div style="font-size: 120%;">Mod]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Logarithm/Powers</div>
+
−
* [[Documentation/How_Tos/Calc:_EXP_function|<div style="font-size: 120%;">Exp]]
+
−
* [[Documentation/How_Tos/Calc:_POWER_function|<div style="font-size: 120%;">Power]]
+
−
* [[Documentation/How_Tos/Calc:_LOG_function|<div style="font-size: 120%;">Log]]
+
−
* [[Documentation/How_Tos/Calc:_LN_function|<div style="font-size: 120%;">Ln]]
+
−
* [[Documentation/How_Tos/Calc:_LOG10_function|<div style="font-size: 120%;">Log10]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Bessel functions</div>
+
−
* [[Documentation/How_Tos/Calc:_BESSELI_function|<div style="font-size: 120%;">Besseli]]
+
−
* [[Documentation/How_Tos/Calc:_BESSELJ_function|<div style="font-size: 120%;">Besselj]]
+
−
* [[Documentation/How_Tos/Calc:_BESSELK_function|<div style="font-size: 120%;">Besselk]]
+
−
* [[Documentation/How_Tos/Calc:_BESSELY_function|<div style="font-size: 120%;">Bessely]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Miscellaneous</div>
+
−
* [[Documentation/How_Tos/Calc:_ABS_function|<div style="font-size: 120%;">Abs]]
+
−
* [[Documentation/How_Tos/Calc:_COMBIN_function|<div style="font-size: 120%;">Combin]]
+
−
* [[Documentation/How_Tos/Calc:_COMBINA_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Combina]]
+
−
* [[Documentation/How_Tos/Calc:_CONVERT_function|<div style="font-size: 120%;">Convert]]
+
−
* [[Documentation/How_Tos/Calc:_CONVERT_ADD_function|<div style="font-size: 120%;">Convert Add]]
+
−
* [[Documentation/How_Tos/Calc:_COUNTBLANK_function|<div style="font-size: 120%;">Countblank]]
+
−
* [[Documentation/How_Tos/Calc:_COUNTIF_function|<div style="font-size: 120%;">Countif]]
+
−
* [[Documentation/How_Tos/Calc:_DELTA_function|<div style="font-size: 120%;">Delta]]
+
−
* [[Documentation/How_Tos/Calc:_ERF_function|<div style="font-size: 120%;">Erf]]
+
−
* [[Documentation/How_Tos/Calc:_ERFC_function|<div style="font-size: 120%;">Erfc]]
+
−
* [[Documentation/How_Tos/Calc:_FACT_function|<div style="font-size: 120%;">Fact]]
+
−
* [[Documentation/How_Tos/Calc:_FACTDOUBLE_function|<div style="font-size: 120%;">Factdouble]]
+
−
* [[Documentation/How_Tos/Calc:_GCD_function|<div style="font-size: 120%;">Gcd]]
+
−
* [[Documentation/How_Tos/Calc:_GCD_ADD_function|<div style="font-size: 120%;">Gcd Add]]
+
−
* [[Documentation/How_Tos/Calc:_GESTEP_function|<div style="font-size: 120%;">Gestep]]
+
−
* [[Documentation/How_Tos/Calc:_ISEVEN_function|<div style="font-size: 120%;">Iseven]]
+
−
* [[Documentation/How_Tos/Calc:_ISODD_function|<div style="font-size: 120%;">Isodd]]
+
−
* [[Documentation/How_Tos/Calc:_LCM_function|<div style="font-size: 120%;">Lcm]]
+
−
* [[Documentation/How_Tos/Calc:_LCM_ADD_function|<div style="font-size: 120%;">Lcm Add]]
+
−
* [[Documentation/How_Tos/Calc:_MULTINOMIAL_function|<div style="font-size: 120%;">Multinomial]]
+
−
* [[Documentation/How_Tos/Calc:_PRODUCT_function|<div style="font-size: 120%;">Product]]
+
−
* [[Documentation/How_Tos/Calc:_RAND_function|<div style="font-size: 120%;">Rand]]
+
−
* [[Documentation/How_Tos/Calc:_RANDBETWEEN_function|<div style="font-size: 120%;">Randbetween]]
+
−
* [[Documentation/How_Tos/Calc:_SERIESSUM_function|<div style="font-size: 120%;">Seriessum]]
+
−
* [[Documentation/How_Tos/Calc:_SIGN_function|<div style="font-size: 120%;">Sign]]
+
−
* [[Documentation/How_Tos/Calc:_SQRT_function|<div style="font-size: 120%;">Sqrt]]
+
−
* [[Documentation/How_Tos/Calc:_SQRTPI_function|<div style="font-size: 120%;">Sqrtpi]]
+
−
* [[Documentation/How_Tos/Calc:_SUBTOTAL_function|<div style="font-size: 120%;">Subtotal]]
+
−
* [[Documentation/How_Tos/Calc:_SUM_function|<div style="font-size: 120%;">Sum]]
+
−
* [[Documentation/How_Tos/Calc:_SUMIF_function|<div style="font-size: 120%;">Sumif]]
+
−
* [[Documentation/How_Tos/Calc:_SUMSQ_function|<div style="font-size: 120%;">Sumsq]]
+
−
}}__TOC__
+
  
 
== COMBINA ==
 
== COMBINA ==
Line 116: Line 28:
 
: returns <tt>'''10'''</tt>.
 
: returns <tt>'''10'''</tt>.
  
−
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: COMBIN function|COMBIN]]
 
* [[Documentation/How_Tos/Calc: COMBIN function|COMBIN]]
 
* [[Documentation/How_Tos/Calc: PERMUT function|PERMUT]]
 
* [[Documentation/How_Tos/Calc: PERMUT function|PERMUT]]

Latest revision as of 15:08, 31 January 2024

COMBINA

Returns the number of combinations of a subset of items.

Syntax:

COMBINA(n; k)

n is the number of items in the set.
k 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 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; you can choose 3 items in 10 different ways, namely AAA, AAB, AAC, ABB, ABC, ACC, BBB, BBC, BCC, CCC.
COMBINA implements the formula:
(n+k-1)!/(k!(n-1)!)

Example:

COMBINA(3,2)

returns 6.

COMBINA(3,3)

returns 10.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_COMBINA_function&oldid=259882"
Views
Personal tools
Navigation
Tools
In other languages