Difference between revisions of "MediaWiki talk:Collections/Calc functions"
From Apache OpenOffice Wiki
Javier Lopez (talk | contribs) |
Javier Lopez (talk | contribs) |
||
Line 177: | Line 177: | ||
;[[Documentation/How_Tos/Calc:_Mathematical_functions|Matematical Functions]] | ;[[Documentation/How_Tos/Calc:_Mathematical_functions|Matematical Functions]] | ||
+ | Trigonometric | ||
+ | :[[Documentation/How_Tos/Calc:_COS_function|Cos]] | ||
+ | :[[Documentation/How_Tos/Calc:_SIN_function|Sin]] | ||
+ | :[[Documentation/How_Tos/Calc:_TAN_function|Tan]] | ||
+ | :[[Documentation/How_Tos/Calc:_COT_function|Cot]] | ||
+ | :[[Documentation/How_Tos/Calc:_ACOS_function|Acos]] | ||
+ | :[[Documentation/How_Tos/Calc:_ACOT_function|Acot]] | ||
+ | :[[Documentation/How_Tos/Calc:_ASIN_function|Asin]] | ||
+ | :[[Documentation/How_Tos/Calc:_ATAN_function|Atan]] | ||
+ | :[[Documentation/How_Tos/Calc:_ATAN2_function|Atan2]] | ||
+ | :[[Documentation/How_Tos/Calc:_DEGREES_function|Degrees]] | ||
+ | :[[Documentation/How_Tos/Calc:_RADIANS_function|Radians]] | ||
+ | :[[Documentation/How_Tos/Calc:_PI_function|Pi]] | ||
+ | Hyperbolic | ||
+ | :[[Documentation/How_Tos/Calc:_COSH_function|Cosh]] | ||
+ | :[[Documentation/How_Tos/Calc:_SINH_function|Sinh]] | ||
+ | :[[Documentation/How_Tos/Calc:_TANH_function|Tanh]] | ||
+ | :[[Documentation/How_Tos/Calc:_COTH_function|Coth]] | ||
+ | :[[Documentation/How_Tos/Calc:_ACOSH_function|Acosh]] | ||
+ | :[[Documentation/How_Tos/Calc:_ACOTH_function|Acoth]] | ||
+ | :[[Documentation/How_Tos/Calc:_ASINH_function|Asinh]] | ||
+ | :[[Documentation/How_Tos/Calc:_ATANH_function|Atanh]] | ||
+ | Rounding and remainders</div> | ||
+ | :[[Documentation/How_Tos/Calc:_TRUNC_function|Trunc]] | ||
+ | :[[Documentation/How_Tos/Calc:_ROUND_function|Round]] | ||
+ | :[[Documentation/How_Tos/Calc:_ROUNDDOWN_function|Rounddown]] | ||
+ | :[[Documentation/How_Tos/Calc:_ROUNDUP_function|Roundup]] | ||
+ | :[[Documentation/How_Tos/Calc:_CEILING_function|Ceiling]] | ||
+ | :[[Documentation/How_Tos/Calc:_FLOOR_function|Floor]] | ||
+ | :[[Documentation/How_Tos/Calc:_EVEN_function|Even]] | ||
+ | :[[Documentation/How_Tos/Calc:_ODD_function|Odd]] | ||
+ | :[[Documentation/How_Tos/Calc:_MROUND_function|Mround]] | ||
+ | :[[Documentation/How_Tos/Calc:_INT_function|Int]] | ||
+ | :[[Documentation/How_Tos/Calc:_QUOTIENT_function|Quotient]] | ||
+ | :[[Documentation/How_Tos/Calc:_MOD_function|Mod]] | ||
+ | Logarithm/Powers | ||
+ | :[[Documentation/How_Tos/Calc:_EXP_function|Exp]] | ||
+ | :[[Documentation/How_Tos/Calc:_POWER_function|Power]] | ||
+ | :[[Documentation/How_Tos/Calc:_LOG_function|Log]] | ||
+ | :[[Documentation/How_Tos/Calc:_LN_function|Ln]] | ||
+ | :[[Documentation/How_Tos/Calc:_LOG10_function|Log10]] | ||
+ | Bessel functions</div> | ||
+ | :[[Documentation/How_Tos/Calc:_BESSELI_function|Besseli]] | ||
+ | :[[Documentation/How_Tos/Calc:_BESSELJ_function|Besselj]] | ||
+ | :[[Documentation/How_Tos/Calc:_BESSELK_function|Besselk]] | ||
+ | :[[Documentation/How_Tos/Calc:_BESSELY_function|Bessely]] | ||
+ | Miscellaneous | ||
+ | :[[Documentation/How_Tos/Calc:_ABS_function|Abs]] | ||
+ | :[[Documentation/How_Tos/Calc:_COMBIN_function|Combin]] | ||
+ | :[[Documentation/How_Tos/Calc:_COMBINA_function|Combina]] | ||
+ | :[[Documentation/How_Tos/Calc:_CONVERT_function|Convert]] | ||
+ | :[[Documentation/How_Tos/Calc:_CONVERT_ADD_function|Convert Add]] | ||
+ | :[[Documentation/How_Tos/Calc:_COUNTBLANK_function|Countblank]] | ||
+ | :[[Documentation/How_Tos/Calc:_COUNTIF_function|Countif]] | ||
+ | :[[Documentation/How_Tos/Calc:_DELTA_function|Delta]] | ||
+ | :[[Documentation/How_Tos/Calc:_ERF_function|Erf]] | ||
+ | :[[Documentation/How_Tos/Calc:_ERFC_function|Erfc]] | ||
+ | :[[Documentation/How_Tos/Calc:_FACT_function|Fact]] | ||
+ | :[[Documentation/How_Tos/Calc:_FACTDOUBLE_function|Factdouble]] | ||
+ | :[[Documentation/How_Tos/Calc:_GCD_function|Gcd]] | ||
+ | :[[Documentation/How_Tos/Calc:_GCD_ADD_function|Gcd Add]] | ||
+ | :[[Documentation/How_Tos/Calc:_GESTEP_function|Gestep]] | ||
+ | :[[Documentation/How_Tos/Calc:_ISEVEN_function|Iseven]] | ||
+ | :[[Documentation/How_Tos/Calc:_ISODD_function|Isodd]] | ||
+ | :[[Documentation/How_Tos/Calc:_LCM_function|Lcm]] | ||
+ | :[[Documentation/How_Tos/Calc:_LCM_ADD_function|Lcm Add]] | ||
+ | :[[Documentation/How_Tos/Calc:_MULTINOMIAL_function|Multinomial]] | ||
+ | :[[Documentation/How_Tos/Calc:_PRODUCT_function|Product]] | ||
+ | :[[Documentation/How_Tos/Calc:_RAND_function|Rand]] | ||
+ | :[[Documentation/How_Tos/Calc:_RANDBETWEEN_function|Randbetween]] | ||
+ | :[[Documentation/How_Tos/Calc:_SERIESSUM_function|Seriessum]] | ||
+ | :[[Documentation/How_Tos/Calc:_SIGN_function|Sign]] | ||
+ | :[[Documentation/How_Tos/Calc:_SQRT_function|Sqrt]] | ||
+ | :[[Documentation/How_Tos/Calc:_SQRTPI_function|Sqrtpi]] | ||
+ | :[[Documentation/How_Tos/Calc:_SUBTOTAL_function|Subtotal]] | ||
+ | :[[Documentation/How_Tos/Calc:_SUM_function|Sum]] | ||
+ | :[[Documentation/How_Tos/Calc:_SUMIF_function|Sumif]] | ||
+ | :[[Documentation/How_Tos/Calc:_SUMSQ_function|Sumsq]] | ||
+ | |||
;[[Documentation/How_Tos/Calc:_Number_Conversion_functions|Number Conversion Functions]] | ;[[Documentation/How_Tos/Calc:_Number_Conversion_functions|Number Conversion Functions]] | ||
+ | :[[Documentation/How_Tos/Calc:_BIN2DEC_function|Bin2dec]] | ||
+ | :[[Documentation/How_Tos/Calc:_BIN2HEX_function|Bin2hex]] | ||
+ | :[[Documentation/How_Tos/Calc:_BIN2OCT_function|Bin2oct]] | ||
+ | :[[Documentation/How_Tos/Calc:_DEC2BIN_function|Dec2bin]] | ||
+ | :[[Documentation/How_Tos/Calc:_DEC2HEX_function|Dec2hex]] | ||
+ | :[[Documentation/How_Tos/Calc:_DEC2OCT_function|Dec2oct]] | ||
+ | :[[Documentation/How_Tos/Calc:_HEX2BIN_function|Hex2bin]] | ||
+ | :[[Documentation/How_Tos/Calc:_HEX2DEC_function|Hex2dec]] | ||
+ | :[[Documentation/How_Tos/Calc:_HEX2OCT_function|Hex2oct]] | ||
+ | :[[Documentation/How_Tos/Calc:_OCT2BIN_function|Oct2bin]] | ||
+ | :[[Documentation/How_Tos/Calc:_OCT2DEC_function|Oct2dec]] | ||
+ | :[[Documentation/How_Tos/Calc:_OCT2HEX_function|Oct2hex]] | ||
+ | :[[Documentation/How_Tos/Calc:_ARABIC_function|Arabic]] | ||
+ | :[[Documentation/How_Tos/Calc:_BAHTTEXT_function|Bahttext]] | ||
+ | :[[Documentation/How_Tos/Calc:_DECIMAL_function|Decimal]] | ||
+ | :[[Documentation/How_Tos/Calc:_ROMAN_function|Roman]] | ||
+ | |||
;[[Documentation/How_Tos/Calc:_Spreadsheet_functions|Spreadsheet Functions]] | ;[[Documentation/How_Tos/Calc:_Spreadsheet_functions|Spreadsheet Functions]] | ||
+ | Spreadsheet Lookup functions | ||
+ | :[[Documentation/How_Tos/Calc:_ADDRESS_function|Address]] | ||
+ | :[[Documentation/How_Tos/Calc:_CHOOSE_function|Choose]] | ||
+ | :[[Documentation/How_Tos/Calc:_HLOOKUP_function|Hlookup]] | ||
+ | :[[Documentation/How_Tos/Calc:_INDEX_function|Index]] | ||
+ | :[[Documentation/How_Tos/Calc:_INDIRECT_function|Indirect]] | ||
+ | :[[Documentation/How_Tos/Calc:_LOOKUP_function|Lookup]] | ||
+ | :[[Documentation/How_Tos/Calc:_MATCH_function|Math]] | ||
+ | :[[Documentation/How_Tos/Calc:_OFFSET_function|Offset]] | ||
+ | :[[Documentation/How_Tos/Calc:_VLOOKUP_function|Vlookup]] | ||
+ | Spreadsheet Information functions | ||
+ | :[[Documentation/How_Tos/Calc:_AREAS_function|Areas]] | ||
+ | :[[Documentation/How_Tos/Calc:_COLUMN_function|Column]] | ||
+ | :[[Documentation/How_Tos/Calc:_COLUMNS_function|Columns]] | ||
+ | :[[Documentation/How_Tos/Calc:_ERRORTYPE_function|Errortype]] | ||
+ | :[[Documentation/How_Tos/Calc:_INFO_function|Info]] | ||
+ | :[[Documentation/How_Tos/Calc:_ROW_function|Row]] | ||
+ | :[[Documentation/How_Tos/Calc:_ROWS_function|Rows]] | ||
+ | :[[Documentation/How_Tos/Calc:_SHEET_function|Sheet]] | ||
+ | :[[Documentation/How_Tos/Calc:_SHEETS_function|Sheets]] | ||
+ | Other functions | ||
+ | :[[Documentation/How_Tos/Calc:_DDE_function|Dde]] | ||
+ | :[[Documentation/How_Tos/Calc:_HYPERLINK_function|Hyperlink]] | ||
+ | :[[Documentation/How_Tos/Calc:_STYLE_function|Style]] | ||
+ | |||
;[[Documentation/How_Tos/Calc:_Statistical_functions|Statistical Functions]] | ;[[Documentation/How_Tos/Calc:_Statistical_functions|Statistical Functions]] | ||
+ | Measures of Central Tendency | ||
+ | :[[Documentation/How_Tos/Calc:_AVEDEV_function|Avedev]] | ||
+ | :[[Documentation/How_Tos/Calc:_AVERAGE_function|Average]] | ||
+ | :[[Documentation/How_Tos/Calc:_AVERAGEA_function|Averagea]] | ||
+ | :[[Documentation/How_Tos/Calc:_COUNT_function|Count]] | ||
+ | :[[Documentation/How_Tos/Calc:_COUNTA_function|Counta]] | ||
+ | :[[Documentation/How_Tos/Calc:_GEOMEAN_function|Geomean]] | ||
+ | :[[Documentation/How_Tos/Calc:_HARMEAN_function|Hearmean]] | ||
+ | :[[Documentation/How_Tos/Calc:_MEDIAN_function|Median]] | ||
+ | :[[Documentation/How_Tos/Calc:_MODE_function|Mode]] | ||
+ | :[[Documentation/How_Tos/Calc:_TRIMMEAN_function|Trimmean]] | ||
+ | Measures of dispersion / spread | ||
+ | :[[Documentation/How_Tos/Calc:_DEVSQ_function|Devsq]] | ||
+ | :[[Documentation/How_Tos/Calc:_KURT_function|Kurt]] | ||
+ | :[[Documentation/How_Tos/Calc:_SKEW_function|Skew]] | ||
+ | :[[Documentation/How_Tos/Calc:_STDEV_function|Stdev]] | ||
+ | :[[Documentation/How_Tos/Calc:_STDEVA_function|Stedeva]] | ||
+ | :[[Documentation/How_Tos/Calc:_STDEVP_function|Stdevp]] | ||
+ | :[[Documentation/How_Tos/Calc:_STDEVPA_function|Stdevpa]] | ||
+ | :[[Documentation/How_Tos/Calc:_VAR_function|Var]] | ||
+ | :[[Documentation/How_Tos/Calc:_VARA_function|Vara]] | ||
+ | :[[Documentation/How_Tos/Calc:_VARP_function|Varp]] | ||
+ | :[[Documentation/How_Tos/Calc:_VARPA_function|Varpa]] | ||
+ | Probability and statistics | ||
+ | :[[Documentation/How_Tos/Calc:_B_function|B]] | ||
+ | :[[Documentation/How_Tos/Calc:_BETADIST_function|Betadist]] | ||
+ | :[[Documentation/How_Tos/Calc:_BETAINV_function|Betainv]] | ||
+ | :[[Documentation/How_Tos/Calc:_BINOMDIST_function|Binomdist]] | ||
+ | :[[Documentation/How_Tos/Calc:_CHIDIST_function|Chidist]] | ||
+ | :[[Documentation/How_Tos/Calc:_CHIINV_function|Chinv]] | ||
+ | :[[Documentation/How_Tos/Calc:_CHISQINV_function|Chisqinv]] | ||
+ | :[[Documentation/How_Tos/Calc:_CHITEST_function|Chitest]] | ||
+ | :[[Documentation/How_Tos/Calc:_CONFIDENCE_function|Confidence]] | ||
+ | :[[Documentation/How_Tos/Calc:_CRITBINOM_function|Critbinom]] | ||
+ | :[[Documentation/How_Tos/Calc:_EXPONDIST_function|Expondist]] | ||
+ | :[[Documentation/How_Tos/Calc:_FINV_function|Finv]] | ||
+ | :[[Documentation/How_Tos/Calc:_FISHER_function|Fisher]] | ||
+ | :[[Documentation/How_Tos/Calc:_FISHERINV_function|Fisherinv]] | ||
+ | :[[Documentation/How_Tos/Calc:_FDIST_function|Fdist]] | ||
+ | :[[Documentation/How_Tos/Calc:_FTEST_function|Ftest]] | ||
+ | :[[Documentation/How_Tos/Calc:_GAMMA_function|Gamma]] | ||
+ | :[[Documentation/How_Tos/Calc:_GAMMAINV_function|Gammainv]] | ||
+ | :[[Documentation/How_Tos/Calc:_GAMMALN_function|Gammaln]] | ||
+ | :[[Documentation/How_Tos/Calc:_GAMMADIST_function|Gammadist]] | ||
+ | :[[Documentation/How_Tos/Calc:_GAUSS_function|Gauss]] | ||
+ | :[[Documentation/How_Tos/Calc:_HYPGEOMDIST_function|Hypgeomdist]] | ||
+ | :[[Documentation/How_Tos/Calc:_LOGINV_function|Loginv]] | ||
+ | :[[Documentation/How_Tos/Calc:_LOGNORMDIST_function|Lognormdist]] | ||
+ | :[[Documentation/How_Tos/Calc:_NEGBINOMDIST_function|Negbinomdist]] | ||
+ | :[[Documentation/How_Tos/Calc:_NORMINV_function|Norminv]] | ||
+ | :[[Documentation/How_Tos/Calc:_NORMDIST_function|Normdist]] | ||
+ | :[[Documentation/How_Tos/Calc:_NORMSINV_function|Normsinv]] | ||
+ | :[[Documentation/How_Tos/Calc:_NORMSDIST_function|Normsdist]] | ||
+ | :[[Documentation/How_Tos/Calc:_PERMUT_function|Permut]] | ||
+ | :[[Documentation/How_Tos/Calc:_PERMUTATIONA_function|Permutationa]] | ||
+ | :[[Documentation/How_Tos/Calc:_PHI_function|Phi]] | ||
+ | :[[Documentation/How_Tos/Calc:_POISSON_function|Poisson]] | ||
+ | :[[Documentation/How_Tos/Calc:_PROB_function|Prob]] | ||
+ | :[[Documentation/How_Tos/Calc:_STANDARDIZE_function|Standardize]] | ||
+ | :[[Documentation/How_Tos/Calc:_TDIST_function|Tdist]] | ||
+ | :[[Documentation/How_Tos/Calc:_TINV_function|Tinv]] | ||
+ | :[[Documentation/How_Tos/Calc:_TTEST_function|Ttest]] | ||
+ | :[[Documentation/How_Tos/Calc:_WEIBULL_function|Weibull]] | ||
+ | :[[Documentation/How_Tos/Calc:_ZTEST_function|Ztest]] | ||
+ | Correlation and line fitting | ||
+ | :[Documentation/How_Tos/Calc:_CORREL_function|Correl]] | ||
+ | :[[Documentation/How_Tos/Calc:_COVAR_function|Covar]] | ||
+ | :[[Documentation/How_Tos/Calc:_FORECAST_function|Forecast]] | ||
+ | :[[Documentation/How_Tos/Calc:_INTERCEPT_function|Intercept]] | ||
+ | :[[Documentation/How_Tos/Calc:_PEARSON_function|Pearson]] | ||
+ | :[[Documentation/How_Tos/Calc:_RSQ_function|Rsq]] | ||
+ | :[[Documentation/How_Tos/Calc:_SLOPE_function|Slope]] | ||
+ | :[[Documentation/How_Tos/Calc:_STEYX_function|Steyx]] | ||
+ | Ranking | ||
+ | :[[Documentation/How_Tos/Calc:_LARGE_function|Large]] | ||
+ | :[[Documentation/How_Tos/Calc:_MAX_function|Max]] | ||
+ | :[[Documentation/How_Tos/Calc:_MAXA_function|Maxa]] | ||
+ | :[[Documentation/How_Tos/Calc:_MIN_function|Min]] | ||
+ | :[[Documentation/How_Tos/Calc:_MINA_function|Mina]] | ||
+ | :[[Documentation/How_Tos/Calc:_PERCENTILE_function|Percentile]] | ||
+ | :[[Documentation/How_Tos/Calc:_PERCENTRANK_function|Percentrank]] | ||
+ | :[[Documentation/How_Tos/Calc:_QUARTILE_function|Quartile]] | ||
+ | :[[Documentation/How_Tos/Calc:_RANK_function|Rank]] | ||
+ | :[[Documentation/How_Tos/Calc:_SMALL_function|Small]] | ||
+ | |||
;[[Documentation/How_Tos/Calc:_Text_functions|Text Functions]] | ;[[Documentation/How_Tos/Calc:_Text_functions|Text Functions]] | ||
+ | :[[Documentation/How_Tos/Calc:_BASE_function|Base]] | ||
+ | :[[Documentation/How_Tos/Calc:_CHAR_function|Char]] | ||
+ | :[[Documentation/How_Tos/Calc:_CLEAN_function|Clean]] | ||
+ | :[[Documentation/How_Tos/Calc:_CODE_function|Code]] | ||
+ | :[[Documentation/How_Tos/Calc:_CONCATENATE_function|Concatenate]] | ||
+ | :[[Documentation/How_Tos/Calc:_DECIMAL_function|Decimal]] | ||
+ | :[[Documentation/How_Tos/Calc:_DOLLAR_function|Dollar]] | ||
+ | :[[Documentation/How_Tos/Calc:_EXACT_function|Exact]] | ||
+ | :[[Documentation/How_Tos/Calc:_FIND_function|Find]] | ||
+ | :[[Documentation/How_Tos/Calc:_FIXED_function|Fixed]] | ||
+ | :[[Documentation/How_Tos/Calc:_LEFT_function|Left]] | ||
+ | :[[Documentation/How_Tos/Calc:_LEN_function|Len]] | ||
+ | :[[Documentation/How_Tos/Calc:_LOWER_function|Lower]] | ||
+ | :[[Documentation/How_Tos/Calc:_MID_function|Mid]] | ||
+ | :[[Documentation/How_Tos/Calc:_PROPER_function|Proper]] | ||
+ | :[[Documentation/How_Tos/Calc:_REPLACE_function|Replace]] | ||
+ | :[[Documentation/How_Tos/Calc:_REPT_function|Rept]] | ||
+ | :[[Documentation/How_Tos/Calc:_RIGHT_function|Right]] | ||
+ | :[[Documentation/How_Tos/Calc:_SEARCH_function|Search]] | ||
+ | :[[Documentation/How_Tos/Calc:_SUBSTITUTE_function|Substitute]] | ||
+ | :[[Documentation/How_Tos/Calc:_T_function|T]] | ||
+ | :[[Documentation/How_Tos/Calc:_TEXT_function|Text]] | ||
+ | :[[Documentation/How_Tos/Calc:_TRIM_function|Trim]] | ||
+ | :[[Documentation/How_Tos/Calc:_UPPER_function|Upper]] | ||
+ | :[[Documentation/How_Tos/Calc:_VALUE_function|Value]] | ||
+ | |||
[[Category:Books]] | [[Category:Books]] |
Revision as of 05:04, 22 June 2013
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
- [Documentation/How_Tos/Calc:_CORREL_function|Correl]]
- Covar
- Forecast
- Intercept
- Pearson
- Rsq
- Slope
- Steyx
Ranking