|
| |
Functions Index
| Function Name |
Classification |
| ABS |
Maths |
| ACCRINT |
Financial |
| ACCRINTM |
Financial |
| ACOS |
Maths |
| ACOSH |
Maths |
| ADDRESS |
Lookup and Reference |
| AMORDEGRC |
Financial |
| AMORLINC |
Financial |
| AND |
Logical |
| AREAS |
Lookup and Reference |
| ASIN |
Maths |
| ASINH |
Maths |
| ATAN |
Maths |
| ATAN2 |
Maths |
| ATANH |
Maths |
| AVEDEV |
Statistical |
| AVERAGE |
Statistical |
| AVERAGEA |
Statistical |
| BESSELI |
Engineering |
| BESSELJ |
Engineering |
| BESSELK |
Engineering |
| BESSELY |
Engineering |
| BETADIST |
Statistical |
| BETAINV |
Statistical |
| BIN2DEC |
Engineering |
| BIN2HEX |
Engineering |
| BIN2OCT |
Engineering |
| BINOMDIST |
Statistical |
| CEILING |
Maths |
| CELL |
Information |
| CHAR |
Text |
| CHIDIST |
Statistical |
| CHIINV |
Statistical |
| CHITEST |
Statistical |
| CHOOSE |
Lookup and Reference |
| CLEAN |
Text |
| CODE |
Text |
| COLUMN |
Lookup and Reference |
| COLUMNS |
Lookup and Reference |
| COMBIN |
Maths |
| COMPLEX |
Engineering |
| CONCATENATE |
Text |
| CONFIDENCE |
Statistical |
| CONVERT |
Engineering |
| CORREL |
Statistical |
| COS |
Maths |
| COSH |
Maths |
| COUNT |
Statistical |
| COUNTA |
Statistical |
| COUNTBLANK |
Information |
| COUNTIF |
Maths |
| COUPDAYBS |
Financial |
| COUPDAYS |
Financial |
| COUPDAYSNC |
Financial |
| COUPNCD |
Financial |
| COUPNUM |
Financial |
| COUPPCD |
Financial |
| COVAR |
Statistical |
| CRITBINOM |
Statistical |
| CUMIPMT |
Financial |
| CUMPRINC |
Financial |
| DATE |
Data and Time |
| DATEDIF |
Data and Time |
| DATEVALUE |
Data and Time |
| DAVERAGE |
Database |
| DAY |
Data and Time |
| DAYS360 |
Data and Time |
| DB |
Financial |
| DCOUNT |
Database |
| DCOUNTA |
Database |
| DDB |
Financial |
| DEC2BIN |
Engineering |
| DEC2HEX |
Engineering |
| DEC2OCT |
Engineering |
| DEGREES |
Maths |
| DELTA |
Engineering |
| DEVSQ |
Statistical |
| DGET |
Database |
| DISC |
Financial |
| DMAX |
Database |
| DMIN |
Database |
| DOLLAR |
Text |
| DOLLARDE |
Financial |
| DOLLARFR |
Financial |
| DPRODUCT |
Database |
| DSTDEV |
Database |
| DSTDEVP |
Database |
| DSUM |
Database |
| DURATION |
Financial |
| DVAR |
Database |
| DVARP |
Database |
| EDATE |
Data |
| EFFECT |
Financial |
| EOMONTH |
Data |
| ERF |
Engineering |
| ERFC |
Engineering |
| ERROR.TYPE |
Information |
| EVEN |
Maths |
| EXACT |
Text |
| EXP |
Maths |
| EXPONDIST |
Statistical |
| FACT |
Maths |
| FACTDOUBLE |
Maths |
| FALSE |
Logical |
| FDIST |
Statistical |
| FIND |
Text |
| FINV |
Statistical |
| FISHER |
Statistical |
| FISHERINV |
Statistical |
| FIXED |
Text |
| FLOOR |
Maths |
| FORECAST |
Statistical |
| FREQUENCY |
Statistical |
| FTEST |
Statistical |
| FV |
Financial |
| FVSCHEDULE |
Financial |
| GAMMADIST |
Statistical |
| GAMMAINV |
Statistical |
| GAMMALN |
Statistical |
| GCD |
Maths |
| GEOMEAN |
Statistical |
| GESTEP |
Engineering |
| GETPIVOTDATA |
Database |
| GROWTH |
Statistical |
| HARMEAN |
Statistical |
| HEX2BIN |
Engineering |
| HEX2DEC |
Engineering |
| HEX2OCT |
Engineering |
| HLOOKUP |
Lookup and Reference |
| HOUR |
Data and Time |
| HYPERLINK |
Lookup and Reference |
| HYPGEOMDIST |
Statistical |
| IF |
Logical |
| IMABS |
Engineering |
| IMAGINARY |
Engineering |
| IMARGUMENT |
Engineering |
| IMCONJUGATE |
Engineering |
| IMCOS |
Engineering |
| IMDIV |
Engineering |
| IMEXP |
Engineering |
| IMLN |
Engineering |
| IMLOG10 |
Engineering |
| IMLOG2 |
Engineering |
| IMPOWER |
Engineering |
| IMPRODUCT |
Engineering |
| IMREAL |
Engineering |
| IMSIN |
Engineering |
| IMSQRT |
Engineering |
| IMSUB |
Engineering |
| IMSUM |
Engineering |
| INDEX |
Lookup and Reference |
| INDIRECT |
Lookup and Reference |
| INFO |
Information |
| INT |
Maths |
| INTERCEPT |
Statistical |
| INTRATE |
Financial |
| IPMT |
Financial |
| IRR |
Financial |
| ISBLANK |
Information |
| ISERR |
Information |
| ISERROR |
Information |
| ISEVEN |
Information |
| ISLOGICAL |
Information |
| ISNA |
Information |
| ISNONTEXT |
Information |
| ISNUMBER |
Information |
| ISODD |
Information |
| ISREF |
Information |
| ISTEXT |
Information |
| KURT |
Statistical |
| LARGE |
Statistical |
| LCM |
Maths |
| LEFT |
Text |
| LEN |
Text |
| LINEST |
Statistical |
| LN |
Maths |
| LOG |
Maths |
| LOG10 |
Maths |
| LOGEST |
Statistical |
| LOGINV |
Statistical |
| LOGNORMDIST |
Statistical |
| LOOKUP |
Lookup and Reference |
| LOWER |
Text |
| MATCH |
Lookup and Reference |
| MAX |
Statistical |
| MAXA |
Statistical |
| MDETERM |
Maths |
| MDURATION |
Financial |
| MEDIAN |
Statistical |
| MID |
Text |
| MIN |
Statistical |
| MINA |
Statistical |
| MINUTE |
Data and Time |
| MINVERSE |
Maths |
| MIRR |
Financial |
| MMULT |
Maths |
| MOD |
Maths |
| MODE |
Statistical |
| MONTH |
Data and Time |
| MROUND |
Maths |
| MULTINOMIAL |
Maths |
| N |
Information |
| NA |
Information |
| NEGBINOMDIST |
Statistical |
| NETWORKDAYS |
Data and Time |
| NOMINAL |
Financial |
| NORMDIST |
Statistical |
| NORMINV |
Statistical |
| NORMSDIST |
Statistical |
| NORMSINV |
Statistical |
| NOT |
Logical |
| NOW |
Data and Time |
| NPER |
Financial |
| NPV |
Financial |
| OCT2BIN |
Engineering |
| OCT2DEC |
Engineering |
| OCT2HEX |
Engineering |
| ODD |
Maths |
| ODDFPRICE |
Financial |
| ODDFYIELD |
Financial |
| ODDLPRICE |
Financial |
| ODDLYIELD |
Financial |
| OFFSET |
Lookup and Reference |
| OR |
Logical |
| PEARSON |
Statistical |
| PERCENTILE |
Statistical |
| PERCENTRANK |
Statistical |
| PERMUT |
Statistical |
| PI |
Maths |
| PMT |
Financial |
| POISSON |
Statistical |
| POWER |
Maths |
| PPMT |
Financial |
| PRICE |
Financial |
| PRICEDISC |
Financial |
| PRICEMAT |
Financial |
| PROB |
Statistical |
| PRODUCT |
Maths |
| PROPER |
Text |
| PV |
Financial |
| QUARTILE |
Statistical |
| QUOTIENT |
Maths |
| RADIANS |
Maths |
| RAND |
Maths |
| RANDBETWEEN |
Maths |
| RANK |
Statistical |
| RATE |
Financial |
| RECEIVED |
Financial |
| REPLACE |
Text |
| REPT |
Text |
| RIGHT |
Text |
| ROMAN |
Maths |
| ROUND |
Maths |
| ROUNDDOWN |
Maths |
| ROUNDUP |
Maths |
| ROW |
Lookup and Reference |
| ROWS |
Lookup and Reference |
| RSQ |
Statistical |
| SEARCH |
Text |
| SECOND |
Data and Time |
| SERIESSUM |
Maths |
| SIGN |
Maths |
| SIN |
Maths |
| SINH |
Maths |
| SKEW |
Statistical |
| SLN |
Financial |
| SLOPE |
Statistical |
| SMALL |
Statistical |
| SQRT |
Maths |
| SQRTPI |
Maths |
| STANDARDIZE |
Statistical |
| STDEV |
Statistical |
| STDEVA |
Statistical |
| STDEVP |
Statistical |
| STDEVPA |
Statistical |
| STEYX |
Statistical |
| SUBSTITUTE |
Text |
| SUBTOTAL |
Maths |
| SUM |
Maths |
| SUMIF |
Maths |
| SUMPRODUCT |
Maths |
| SUMSQ |
Maths |
| SUMX2MY2 |
Maths |
| SUMX2PY2 |
Maths |
| SUMXMY2 |
Maths |
| SYD |
Financial |
| T |
Text |
| TAN |
Maths |
| TANH |
Maths |
| TBILLEQ |
Financial |
| TBILLPRICE |
Financial |
| TBILLYIELD |
Financial |
| TDIST |
Statistical |
| TEXT |
Text |
| TIME |
Data and Time |
| TIMEVALUE |
Data and Time |
| TINV |
Statistical |
| TODAY |
Data and Time |
| TRANSPOSE |
Lookup and Reference |
| TREND |
Statistical |
| TRIM |
Text |
| TRIMMEAN |
Statistical |
| TRUE |
Logical |
| TRUNC |
Maths |
| TTEST |
Statistical |
| TYPE |
Information |
| UPPER |
Text |
| VALUE |
Text |
| VAR |
Statistical |
| VARA |
Statistical |
| VARP |
Statistical |
| VARPA |
Statistical |
| VDB |
Financial |
| VLOOKUP |
Lookup and Reference |
| WEEKDAY |
Data and Time |
| WEIBULL |
Statistical |
| WORKDAY |
Data and Time |
| XIRR |
Financial |
| XNPV |
Financial |
| YEAR |
Data and Time |
| YEARFRAC |
Data and Time |
| YIELD |
Financial |
| YIELDDISC |
Financial |
| YIELDMAT |
Financial |
| ZTEST |
Statistical |
Published: 12-Mar-2003
Last edited:
01-Apr-2007 19:11
|
