Difference between revisions of "Manuals/calci/ALL"
Jump to navigation
Jump to search
| Line 233: | Line 233: | ||
*[[Manuals/calci/OR | OR ]] | *[[Manuals/calci/OR | OR ]] | ||
| − | ===Lookup and Refrence== | + | ===Lookup and Refrence=== |
*[[Manuals/calci/ADDRESS | ADDRESS ]] | *[[Manuals/calci/ADDRESS | ADDRESS ]] | ||
*[[Manuals/calci/AREAS | AREAS ]] | *[[Manuals/calci/AREAS | AREAS ]] | ||
Revision as of 03:33, 20 March 2014
LIST OF ALL FUNCTIONS
Statistical Functions
- AVEDEV
- AVERAGE
- AVERAGEA
- 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
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
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSQRT
- IMSUB
- IMSUM
- OCT2BIN
- OCT2DEC
- OCT2HEX
Financial
- ACCRINT
- AMORDEGRC
- AMORLINC
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNUM
- DDB
- DISC
- DOLLARDE
- DOLLARFR
- EFFECT
- INTRATE
- IPMT
- ISPMT
- LOGEST
- MDURATION
- PRICE
- PRICEDISC
- PRICEMAT
- RATE
- RECEIVED
Geometry
Information
- CELL
- EUROCONVERT
- GOLDENANGLE
- GOLDENRATIO
- help
- IS FUNCTIONS
- ISBLANK
- ISEVEN
- ISLEAPYEAR
- ISLOGICAL
- ISNUMBER
- ISODD
- ISPRIME
- ISTEXT
- N
Logical
Lookup and Refrence
- 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
- 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
- SERIESSUM
- SIGN
- SQRT
- SQRTPI
- SUBTOTAL
- SUM
- SUMIF
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TRUNC
- VECTOR
Text and Data
- CHAR
- CLEAN
- CODE
- CONCATENATE
- DOLLAR
- EXACT
- FIND
- FIXED
- LEFT
- LEFTB
- LEN
- LENB
- LOWER
- MID
- MIDB
- PROPER
- REPLACE
- REPLACEB
- REPT
- RIGHT
- RIGHTB
- SEARCH
- SEARCHB
- SUBSTITUTE
- T
- TRIM
- UPPER
- VALUE