Difference between revisions of "Manuals/calci/ALL"
Jump to navigation
Jump to search
| Line 30: | Line 30: | ||
===Other Functions=== | ===Other Functions=== | ||
| − | |||
*[[Manuals/calci/ABS | ABS ]] | *[[Manuals/calci/ABS | ABS ]] | ||
*[[Manuals/calci/ACCRINT | ACCRINT ]] | *[[Manuals/calci/ACCRINT | ACCRINT ]] | ||
| − | |||
| − | |||
*[[Manuals/calci/ADDRESS | ADDRESS ]] | *[[Manuals/calci/ADDRESS | ADDRESS ]] | ||
*[[Manuals/calci/AMORDEGRC | AMORDEGRC ]] | *[[Manuals/calci/AMORDEGRC | AMORDEGRC ]] | ||
| Line 43: | Line 40: | ||
*[[Manuals/calci/ANOVATWOFACTORWITHREPLICATION | ANOVATWOFACTORWITHREPLICATION ]] | *[[Manuals/calci/ANOVATWOFACTORWITHREPLICATION | ANOVATWOFACTORWITHREPLICATION ]] | ||
*[[Manuals/calci/AREAS | AREAS ]] | *[[Manuals/calci/AREAS | AREAS ]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
*[[Manuals/calci/AVEDEV | AVEDEV ]] | *[[Manuals/calci/AVEDEV | AVEDEV ]] | ||
*[[Manuals/calci/AVERAGE | AVERAGE ]] | *[[Manuals/calci/AVERAGE | AVERAGE ]] | ||
| Line 109: | Line 101: | ||
*[[Manuals/calci/DAYS360 | DAYS360 ]] | *[[Manuals/calci/DAYS360 | DAYS360 ]] | ||
*[[Manuals/calci/DAYSBETWEEN | DAYSBETWEEN ]] | *[[Manuals/calci/DAYSBETWEEN | DAYSBETWEEN ]] | ||
| − | |||
| − | |||
| − | |||
*[[Manuals/calci/DCOUNT | DCOUNT ]] | *[[Manuals/calci/DCOUNT | DCOUNT ]] | ||
*[[Manuals/calci/DCOUNTA | DCOUNTA ]] | *[[Manuals/calci/DCOUNTA | DCOUNTA ]] | ||
| Line 132: | Line 121: | ||
*[[Manuals/calci/DOLLARFR | DOLLARFR ]] | *[[Manuals/calci/DOLLARFR | DOLLARFR ]] | ||
*[[Manuals/calci/DPRODUCT | DPRODUCT ]] | *[[Manuals/calci/DPRODUCT | DPRODUCT ]] | ||
| − | |||
| − | |||
*[[Manuals/calci/DSTDEV | DSTDEV ]] | *[[Manuals/calci/DSTDEV | DSTDEV ]] | ||
*[[Manuals/calci/DSTDEVP | DSTDEVP ]] | *[[Manuals/calci/DSTDEVP | DSTDEVP ]] | ||
*[[Manuals/calci/DSUM | DSUM ]] | *[[Manuals/calci/DSUM | DSUM ]] | ||
| − | |||
*[[Manuals/calci/DURATION | DURATION ]] | *[[Manuals/calci/DURATION | DURATION ]] | ||
*[[Manuals/calci/DVAR | DVAR ]] | *[[Manuals/calci/DVAR | DVAR ]] | ||
| Line 327: | Line 313: | ||
*[[Manuals/calci/SEARCH | SEARCH ]] | *[[Manuals/calci/SEARCH | SEARCH ]] | ||
*[[Manuals/calci/SEARCHB | SEARCHB ]] | *[[Manuals/calci/SEARCHB | SEARCHB ]] | ||
| − | |||
| − | |||
*[[Manuals/calci/SECOND | SECOND ]] | *[[Manuals/calci/SECOND | SECOND ]] | ||
*[[Manuals/calci/SERIESSUM | SERIESSUM ]] | *[[Manuals/calci/SERIESSUM | SERIESSUM ]] | ||
*[[Manuals/calci/SIGN | SIGN ]] | *[[Manuals/calci/SIGN | SIGN ]] | ||
| − | |||
| − | |||
*[[Manuals/calci/SKEW | SKEW ]] | *[[Manuals/calci/SKEW | SKEW ]] | ||
*[[Manuals/calci/SLOPE | SLOPE ]] | *[[Manuals/calci/SLOPE | SLOPE ]] | ||
| Line 357: | Line 339: | ||
*[[Manuals/calci/SUMXMY2 | SUMXMY2 ]] | *[[Manuals/calci/SUMXMY2 | SUMXMY2 ]] | ||
*[[Manuals/calci/T | T ]] | *[[Manuals/calci/T | T ]] | ||
| − | |||
| − | |||
*[[Manuals/calci/TDIST | TDIST ]] | *[[Manuals/calci/TDIST | TDIST ]] | ||
*[[Manuals/calci/TIME | TIME ]] | *[[Manuals/calci/TIME | TIME ]] | ||
Revision as of 03:43, 4 February 2014
LIST OF ALL FUNCTIONS
Trignometric Functions
- ACOS
- ASIN
- ATAN
- COS
- COSEC
- COSH
- COTAN
- COTH
- DCOS
- DCOSEC
- DCOTAN
- DSEC
- DSIN
- DTAN
- SEC
- SECH
- SIN
- SINH
- TAN
- ACOSH
- ASINH
- ATAN2
- ATANH
- IMCOS
- IMSIN
- TANH
- CSCH
Other Functions
- ABS
- ACCRINT
- ADDRESS
- AMORDEGRC
- AMORLINC
- AND
- ANOVASINGLEFACTOR
- ANOVATWOFACTORWITHOUTREPLICATION
- ANOVATWOFACTORWITHREPLICATION
- AREAS
- AVEDEV
- AVERAGE
- AVERAGEA
- BERNOULLI
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- BETADIST
- BETAINV
- BIN2DEC
- BIN2HEX
- BIN2OCT
- BINOMDIST
- BINOMIAL
- calci_sum
- CEILING
- CELL
- CHAR
- CHIDIST
- CHIINV
- CHINV
- CHITEST
- CHOOSE
- CIRCLE
- CLEAN
- CODE
- COLUMN
- COLUMNS
- COMBIN
- COMPLEX
- CONCATENATE
- CONE
- CONFIDENCE
- CONVERT
- CORREL
- CORRELATION
- COS
- COSEC
- COSH
- COTAN
- COTH
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNUM
- COVAR
- COVARIANCE
- CRITBINOM
- CYLINDER
- DATE
- date1
- datevalue
- DAVERAGE
- DAY
- DAYS360
- DAYSBETWEEN
- DCOUNT
- DCOUNTA
- DDB
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DEGREES
- DELTA
- DESCRIPTIVESTATISTICS
- DEVSQ
- DGET
- DISC
- DISCRETE
- DISTANCE
- DMAX
- DMIN
- DOLLAR
- DOLLARDE
- DOLLARFR
- DPRODUCT
- DSTDEV
- DSTDEVP
- DSUM
- DURATION
- DVAR
- DVARP
- EDATE
- EFFECT
- ELLIPSE
- EOMONTH
- ERF
- ERFC
- EUROCONVERT
- EVEN
- EXACT
- EXP
- EXPONDIST
- EXPONENTIALSMOOTHING
- FACT
- FACTDOUBLE
- FDIST
- FIBONNACI
- FIND
- FINV
- FISHER
- FISHERINV
- FIXED
- FLOOR
- FORECAST
- FOURIERANALYSIS
- FREQUENCY
- FTEST
- FTESTANALYSIS
- GAMMADIST
- GAMMAINV
- GAMMALN
- GCD
- GEOMEAN
- GESTEP
- GOLDENANGLE
- GOLDENRATIO
- GROWTH
- HARMEAN
- help
- HEX2BIN
- HEX2DEC
- HEX2OCT
- HISTOGRAM
- HLOOKUP
- HOUR
- HYPERLINK
- HYPGEOMDIST
- HYPOTENUSE
- IF
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSIN
- IMSQRT
- IMSUB
- IMSUM
- INDEX
- INDIRECT
- INT
- INTERCEPT
- INTRATE
- IPMT
- IS FUNCTIONS
- ISBLANK
- ISEVEN
- ISLEAPYEAR
- ISLOGICAL
- ISNUMBER
- ISODD
- ISPMT
- ISPRIME
- ISTEXT
- ITHPRIME
- KURT
- LARGE
- LCM
- LEFT
- LEFTB
- LEN
- LENB
- LINEST
- LISTPRIMES
- LN
- LOG
- LOG10
- LOGEST
- LOGINV
- LOGNORMDIST
- LOOKUP
- LOWER
- LOWER1
- LUCAS
- MATCH
- MAX
- MAX1
- MAXA
- MAXA1
- MDETERM
- MDURATION
- MEDIAN
- MID
- MIDB
- MIN
- MIN1
- MINA
- MINA1
- MINUTE
- MINVERSE
- MMULT
- MOD
- MODE
- MONTH
- MOVINGAVERAGE
- MROUND
- MULTINOMIAL
- N
- NEGBINOMDIS
- NEGBINOMDIST
- NETWORKDAYS
- NORMAL
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- NOT
- OCT2BIN
- OCT2DEC
- OCT2HEX
- ODD
- OFFSET
- OR
- PASCALTRIANGLE
- PATTERNED
- PEARSON
- PERCENTILE
- PERCENTRANK
- PERMUT
- PI
- POINT
- poisson
- POISSONDISTRIBUTION
- POWER
- PRICE
- PRICEDISC
- PRICEMAT
- PROB
- PRODUCT
- PROPER
- QUARTILE
- QUOTIENT
- RADIANS
- RAND
- RANDBBETWEEN
- RANDBETWEEN
- RANDOMNUMBERGENERATION
- RANDOMNUMBERGENERATIONUNIFORM
- RANDOMUNIFORM
- RANK
- RANKANDPERCENTILE
- RATE
- RECEIVED
- REGRESSION
- REPLACE
- REPLACEB
- REPT
- RIGHT
- RIGHTB
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- ROW
- ROWS
- RSQ
- SAMPLING
- SEARCH
- SEARCHB
- SECOND
- SERIESSUM
- SIGN
- SKEW
- SLOPE
- SMALL
- SPHERE
- SQRT
- SQRTPI
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- STEYX
- SUBSTITUTE
- SUBTOTAL
- SUM
- sum1
- SUMIF
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- T
- TDIST
- TIME
- TIMEVALUE
- TINV
- TRANSPOSE
- TREND
- TRIANGLE
- TRIM
- TRIMMEAN
- TRUNC
- TTEST
- TTESTEQUALVARIANCES
- TTESTPAIRED
- TTESTUNEQUALVARIANCES
- UNIFORM
- UPPER
- UPPER1
- VALUE
- VAR
- VARA
- VARP
- VARPA
- VECTOR
- VLOOKUP
- WEEKDAY
- WEEKNUM
- WEIBULL
- WORKDAY
- YEAR
- YEARFRAC
- ZTEST
- ZTESTEQUALMEANS