documentation.HELP! MS Excel Spreadsheet Documentation

HOST

MS Excel Spreadsheet

previous page next page

HOST

This function is no longer supported.

previous page start next page

Menu

Homepage

Table of contents

Getting Started
Database
- DAVERAGE
- DCOUNT
- DCOUNTA
- DGET
- DMAX
- DMIN
- DPRODUCT
- DSTDEV
- DSTDEVP
- DSUM
- DVAR
- DVARP
- Example for database functions
Date and Time
- DATE
- DATEVALUE
- DAY
- DAYS360
- HOUR
- MINUTE
- MONTH
- NOW
- SECOND
- TIME
- TIMEVALUE
- TODAY
- WEEKDAY
- YEAR
Financial
- DB
- DDB
- EUROCONVERT
- FV
- IPMT
- IRR
- ISPMT
- MIRR
- NPER
- NPV
- PMT
- PPMT
- PV
- RATE
- SLN
- SYD
- VDB
Information
- CELL
- COUNTBLANK
- ERROR.TYPE
- IS Functions
- N
- NA
- TYPE
Logical
- AND
- FALSE
- IF
- NOT
- OR
- TRUE
Lookup
- ADDRESS
- AREAS
- CHOOSE
- COLUMN
- COLUMNS
- HLOOKUP
- HYPERLINK
- INDEX
- INDIRECT
- LOOKUP
- MATCH
- OFFSET
- ROW
- ROWS
- TRANSPOSE
- VLOOKUP
Math
- ABS
- ACOS
- ACOSH
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- CEILING
- COMBIN
- COS
- COSH
- COUNTIF
- DEGREES
- EVEN
- EXP
- FACT
- FLOOR
- INT
- LN
- LOG
- LOG10
- MDETERM
- MINVERSE
- MMULT
- MOD
- ODD
- PI
- POWER
- PRODUCT
- RADIANS
- RAND
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- SIGN
- SIN
- SINH
- SQRT
- SUBTOTAL
- SUM
- SUMIF
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TAN
- TANH
- TRUNC
Object
- CREATEOBJECT
- HOST
- OBJECT
- XMLDOM
Statistical
- AVEDEV
- AVERAGE
- AVERAGEA
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FISHER
- FISHERINV
- FORECAST
- FREQUENCY
- FTEST
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- GROWTH
- HARMEAN
- HYPGEOMDIST
- INTERCEPT
- KURT
- LARGE
- LINEST
- LOGEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MEDIAN
- MIN
- MINA
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PEARSON
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- RSQ
- SKEW
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- STEYX
- TDIST
- TINV
- TREND
- TRIMMEAN
- TTEST
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
Text and Data
- ASC
- CHAR
- CLEAN
- CODE
- CONCATENATE
- DOLLAR
- EXACT
- FIND
- FIXED
- LEFT
- LEN
- LOWER
- MID
- PROPER
- REPLACE
- REPT
- RIGHT
- SEARCH
- SUBSTITUTE
- T
- TEXT
- TRIM
- UPPER
- VALUE
Analysis Toolpak Functions
- Use the Analysis ToolPak function add-in
- Analysis ToolPak functions

Get in touch

Submit feedback about this site to:

[email protected]

© documentation.help. Design: rehmann.co.