Apache OpenOffice Calc Functions
From Apache OpenOffice Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
This is a user-generated collection of Wikibooks pages that can be easily saved, rendered electronically, and ordered as a printed book. If you are the creator of this collection and need help, see Help:Collections. |
Calc Functions
- Arrays Functions
- Frequency
- Growth
- Linest
- Longest
- Mdeterm
- Minverse
- Mmult
- Munit
- Sumproduct
- vSumx2my2
- Sumx2py2
- Sumxmy2
- Transpose
- Trend
- Complex Number functions
- Complex
- Imabs
- Imaginary
- Imargument
- Imconjugate
- Imcos
- Imcosh
- Imcsc
- Imcsch
- Imcot
- Imdiv
- Imexp
- Imln
- Imlog10
- Imlog2
- Impower
- Improduct
- Imreal
- Imsec
- Imsech
- Imsin
- Imsinh
- Imsqrt
- Imsub
- Imsum
- Imtan
- Data & Time Functions
- Today
- Now
- Year
- Month
- Day
- Weekday
- Hour
- Minute
- Second
- Date
- Datevalue
- Time
- Timevalue
- Eomonth
- Edate
- Workday
- Networkdays
- Days
- Days360
- Daysinmonth
- Daysinyear
- Weeks
- Weeksinyear
- Weeknum
- Weeknum_add
- Months
- Years
- Isleapyear
- Eastersunday
- Yearfrac
Depreciation
Payment Streams, Annuities, Loans
- Cumipmt
- Cumipmt Add
- Cumprinc
- Cumpinc Add
- Fv
- Fvschedule
- Ipmt
- Irr
- Ispmt
- Mirr
- Nper
- Npv
- Pmt
- Ppmt
- Pv
- Rate
- Rri
- Xirr
- Xnpv
Securities
- Accrint
- Accrintm
- Disc
- Duration
- Duration Add
- Effective
- Effect Add
- Intrate
- Mduration
- Duration Add
- Nominal
- Nominal Add
- Oddfprice
- Oddfyield
Coupons
Miscellaneous
- Information Functions
- Cell
- Current
- Formula
- Isblank
- Iserr
- Iserror
- Iseven
- Iseven Add
- Islogical
- Isna
- Isnontext
- Isnumber
- Isodd
- Isodd Add
- Isref
- Istext
- N
- Na
- Type
Trigonometric
Hyperbolic
Rounding and remainders
Logarithm/Powers
Bessel functions
Miscellaneous
- Abs
- Combin
- Combina
- Convert
- Convert Add
- Countblank
- Countif
- Delta
- Erf
- Erfc
- Fact
- Factdouble
- Gcd
- Gcd Add
- Gestep
- Iseven
- Isodd
- Lcm
- Lcm Add
- Multinomial
- Product
- Rand
- Randbetween
- Seriessum
- Sign
- Sqrt
- Sqrtpi
- Subtotal
- Sum
- Sumif
- Sumsq
- Number Conversion Functions
- Bin2dec
- Bin2hex
- Bin2oct
- Dec2bin
- Dec2hex
- Dec2oct
- Hex2bin
- Hex2dec
- Hex2oct
- Oct2bin
- Oct2dec
- Oct2hex
- Arabic
- Bahttext
- Decimal
- Roman
Spreadsheet Lookup functions
Spreadsheet Information functions
Other functions
Measures of Central Tendency
Measures of dispersion / spread
Probability and statistics
- B
- Betadist
- Betainv
- Binomdist
- Chidist
- Chinv
- Chisqinv
- Chitest
- Confidence
- Critbinom
- Expondist
- Finv
- Fisher
- Fisherinv
- Fdist
- Ftest
- Gamma
- Gammainv
- Gammaln
- Gammadist
- Gauss
- Hypgeomdist
- Loginv
- Lognormdist
- Negbinomdist
- Norminv
- Normdist
- Normsinv
- Normsdist
- Permut
- Permutationa
- Phi
- Poisson
- Prob
- Standardize
- Tdist
- Tinv
- Ttest
- Weibull
- Ztest
Correlation and line fitting
Ranking