Manuals/calci/ALL
Jump to navigation
Jump to search
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.
LIST OF ALL FUNCTIONS
Statistical Functions
- AVEDEV
- AVERAGE
- AVERAGEA
- Bartlett's Test
- BERNOULLI
- BETADIST
- BETAINV
- BINOMDIST
- BINOMIAL
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COVAR
- COVARIANCE
- CRITBINOM
- DESCRIPTIVESTATISTICS
- DEVSQ
- DISCRETE
- EXPONDIST
- EXPONENTIALSMOOTHING
- FDIST
- FINV
- FISHER
- FISHERINV
- FORECAST
- FREQUENCY
- FTEST
- FTESTANALYSIS
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- GROWTH
- HARMEAN
- HISTOGRAM
- HYPGEOMDIST
- INTERCEPT
- KURT
- LARGE
- LINEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MEDIAN
- MIN
- MINA
- MODE
- MOVINGAVERAGE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PASCALTRIANGLE
- PATTERNED
- PEARSON
- PERCENTILE
- PERCENTRANK
- PERMUT
- poisson
- POISSONDISTRIBUTION
- PROB
- QUARTILE
- RANK
- RANKANDPERCENTILE
- REGRESSION
- RSQ
- SAMPLING
- SKEW
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- STEYX
- TDIST
- TINV
- TREND
- TRIMMEAN
- TTEST
- TTESTEQUALVARIANCES
- TTESTPAIRED
- TTESTUNEQUALVARIANCES
- UNIFORM
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
- ZTESTEQUALMEANS
- NORMAL
- LEVENESTEST
- MULTIPLEREGRESSIONANALYSIS
- WILCOXONSIGNEDRANKTEST
- MANNWHITNEYUTEST
- KRUSKALWALLISTEST
- SIGNTEST
- STATS
- BINOMIALPROBABILITY
- FRIEDMANTEST
- MOODSMEDIANTEST
- KSTESTNORMAL
- RIEMANNZETA
Database and List Management
Date and Time
- DATE
- DATEVALUE
- DAY
- DAYS360
- DAYSBETWEEN
- EDATE
- EOMONTH
- HOUR
- MINUTE
- MONTH
- NETWORKDAYS
- SECOND
- TIME
- TIMEVALUE
- WEEKDAY
- WEEKNUM
- WORKDAY
- YEAR
- YEARFRAC
Engineering
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- BIN2DEC
- BIN2HEX
- BIN2OCT
- COMPLEX
- CONVERT
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DELTA
- ERF
- ERFC
- GESTEP
- HEX2BIN
- HEX2DEC
- HEX2OCT
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSIN
- IMSQRT
- IMSUB
- IMSUM
- OCT2BIN
- OCT2DEC
- OCT2HEX
Financial
- ACCRINT
- accrintm
- AMORDEGRC
- AMORLINC
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- coupncd
- COUPNUM
- couppcd
- cumipmt
- cumprinc
- db
- DDB
- DISC
- DOLLAR
- DOLLARDE
- DOLLARFR
- DURATION
- EFFECT
- FV
- FVSCHEDULE
- INTRATE
- IPMT
- IRR
- ISPMT
- LOGEST
- MDURATION
- MIRR
- NOMINAL
- NPER
- NPV
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- SLN
- SYD
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
Geometry
Information
- CELL
- EUROCONVERT
- GOLDENANGLE
- GOLDENRATIO
- help
- IS FUNCTIONS
- ISBLANK
- ISEVEN
- ISLEAPYEAR
- ISLOGICAL
- ISNUMBER
- ISODD
- ISPRIME
- ISTEXT
- N
Logical
Lookup and Reference
- ADDRESS
- AREAS
- CHOOSE
- COLUMN
- COLUMNS
- HLOOKUP
- HYPERLINK
- INDEX
- INDIRECT
- LOOKUP
- MATCH
- NOT
- OFFSET
- ROW
- ROWS
- TRANSPOSE
- VLOOKUP
Math
- ABS
- calci_sum
- CEILING
- COMBIN
- COS
- COSEC
- COSH
- COTAN
- COTH
- CSCH
- DEGREES
- EVEN
- EXP
- FACT
- FACTDOUBLE
- FIBONNACI
- FLOOR
- FOURIERANALYSIS
- GCD
- INT
- ITHPRIME
- LCM
- LISTPRIMES
- LN
- LOG
- LOG10
- LUCAS
- MDETERM
- MINVERSE
- MMULT
- MOD
- MROUND
- MULTINOMIAL
- ODD
- PI
- POWER
- PRODUCT
- QUOTIENT
- RADIANS
- RAND
- RANDBETWEEN
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- SEC
- SECH
- SERIESSUM
- SIGN
- SIN
- SINH
- SQRT
- SQRTPI
- SUBTOTAL
- SUM
- SUMIF
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TAN
- TANH
- TRUNC
- VECTOR
Text and Data
- CHAR
- CLEAN
- CODE
- CONCATENATE
- DOLLAR
- EXACT
- FIND
- FINDB
- FIXED
- LEFT
- LEFTB
- LEN
- LENB
- LOWER
- MID
- MIDB
- PROPER
- REPLACE
- REPLACEB
- REPT
- RIGHT
- RIGHTB
- SEARCH
- SEARCHB
- SUBSTITUTE
- T
- TRIM
- UPPER
- VALUE
Matrix Functions
- ANTIDIAGONAL
- ANTISYMMETRIC
- ARROWHEAD
- BIDIAGONAL
- BLOCKDIAGONAL
- CENTROSYMMETRIC
- CHOLESKY
- CIRCULANT
- CONFERENCE
- EXCHANGE
- FROBENIUS
- HADAMARD
- HANKEL
- HERMITIAN
- HESSENBERG
- HILBERT
- HOLLOW
- IDEMPOTENT
- IDENTITY
- INTEGER
- LEHMER
- MATRIXOPERATORS
- METZLER
- MONOMIAL
- MOORE
- NEGZEROPOS
- PASCAL
- PENTADIAGONAL
- PERMUTATION
- PERSYMMETRIC
- REDHEFFER
- SHIFT
- SIGNATURE
- SYMMETRIC
- TOEPLITZ
- TRIANGULAR
- TRIDIAGONAL
- VANDERMONDE