Difference between revisions of "Documentation/How Tos/Calc: GAMMA function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
m |
||
Line 34: | Line 34: | ||
: <math>\displaystyle \Gamma(x)=(x-1)\mathrm ! </math> | : <math>\displaystyle \Gamma(x)=(x-1)\mathrm ! </math> | ||
But be aware, that OpenOffice.org has only a precision of 15 digits and results, which would consists of more than 15 significant digits, are rounded. | But be aware, that OpenOffice.org has only a precision of 15 digits and results, which would consists of more than 15 significant digits, are rounded. | ||
+ | |||
+ | === Issues === | ||
+ | This function is expected for OOo3.1. {{Bug|94555}} | ||
=== See also === | === See also === | ||
Line 47: | Line 50: | ||
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
− | |||
− | |||
− |
Revision as of 10:29, 2 March 2009
GAMMA
Returns the values of the Gamma function.
Syntax
GAMMA(x)
- x is a number.
- Constraint: If x is an integer, then x must be positive.
Semantic
GAMMA(x) calculates
- .
Example
GAMMA(4) = 6.0 exact
GAMMA(34.56) ≈ 6.2336323276E+037 GAMMA(−4) not defined |
Remarks
For x < 0.5 Eulers reflection formula is used.
The Gamma function has poles for negative integers and for zero. Near the poles the values are less accurate.
If x is a positive integer, then
But be aware, that OpenOffice.org has only a precision of 15 digits and results, which would consists of more than 15 significant digits, are rounded.
Issues
This function is expected for OOo3.1. Issue 94555