Transcript
Page 1: Excel functions reference

!Database'functions'

DAVERAGE! DCOUNTA! DMAX! DPRODUCT! DSTDEVP! DVAR!DCOUNT! DGET! DMIN! DSTDEV! DSUM! DVARP!!Date'and'time'functions'

DATE! DAYS360! HOUR! NETWORKDAYS! TIME! WEEKDAY! YEAR!

DATEVALUE! EDATE! MINUTE! NOW! TIMEVALUE! WEEKNUM! YEARFRAC!

DAY! EOMONTH! MONTH! SECOND! TODAY! WORKDAY! !

!Engineering'functions'

BESSELI! BIN2OCT! DELT! HEX2OCT! IMDIV! IMPRODUCT! OCT2BIN!

BESSELJ! COMPLEX! ERF! IMABS! IMEXP! IMREAL! OCT2DEC!

BESSELK! CONVERT! ERFC! IMAGINARY! IMLN! IMSIN! OCT2HEX!

BESSELY! DEC2BIN! GESTEP! IMARGUMENT! IMLOG10! IMSQRT! !

BIN2DEC! DEC2HEX! HEX2BIN! IMCONJUGATE! IMLOG2! IMSUB! !

BIN2HEX! DEC2OCT! HEX2DEC! IMCOS! IMPOWER! IMSUM! !

!Financial'functions'

ACCRINT! COUPNUM! DOLLARFR! ISPMT! PMT! SLN! YIELD!

ACCRINTM! COUPPCD! DURATION! MDURATION! PPMT! SYD! YIELDDISC!

AMORDEGRC! CUMIPMT! EFFECT! MIRR! PRICE! TBILLEQ! YIELDMAT!

AMORLINC! CUMPRINC! FV! NOMINAL! PRICEDISC! TBILLPRICE! !

COUPDAYBS! DB! FVSCHEDULE! NPER! PRICEMAT! TBILLYIELD! !

COUPDAYS! DDB! INTRATE! NPV! PV! VDB! !

COUPDAYSNC! DISC! IPMT! ODDFPRICE! RATE! XIRR! !

COUPNCD! DOLLARDE! IRR! ODDFYIELD! RECEIVE! XNPV! !

!Information'functions'

CELL! ISBLANK! ISEVEN! ISNONTEXT! ISREF! NA!

ERROR.TYPE! ISERR! ISLOGICAL! ISNUMBER! ISTEXT! TYPE!

INFO! ISERROR! ISNA! ISODD! N! !

!Logical'functions'

AND! FALSE! IF! NOT! OR! TRUE!

! !

!Lookup'and'reference'functions'

ADDRESS! COLUMN! HLOOKUP! INDIRECT! OFFSET! RTD!

AREAS! COLUMNS! HYPERLINK! LOOKUP! ROW! TRANSPOSE!

CHOOSE! GETPIVORTDATA! INDEX! MATCH! ROWS! VLOOKUP!

!Maths'and'trigonometry'functions'

ABS! COMBIN! GCD! MOD! RAND! SINH! SUMX2PY2!ACOS! COS! INT! MROUND! RANDBETWEEN! SQRT! TAN!ACOSH! COSH! LCM! MULTINOMIAL! ROMAN! SQRTPI! TANH!ASIN! DEGREES! LN! ODD! ROUND! SUBTOTAL! TRUNC!ASINH! EVEN! LOG! PI! ROUNDDOWN! SUM! !ATAN! EXP! LOG10! POWER! ROUNDUP! SUMIF! !ATAN2! FACT! MDETERM! PRODUCT! SERIESSUM! SUMPRODUCT! !ATANH! FACTDOUBLE! MINVERSE! QUOTIENT! SIGN! SUMQ! !CEILING! FLOOR! MMULT! RADIANS! SIN! SUMX2MY2! !!

!Text'functions'

ASC! CODE! FIND,!FINDB! LEN,!LENB! PHONETIC! RIGHT,!RIGHTB! TEXT!

BAHTTEXT! CONCATENATE! FIXED! LO! PROPER! SEARCH,!SEARCHB! TRIM!

CHAR! DOLLAR! JIS! WER! REPLACE,!REPLACEB! SUBSTITUTE! UPPER!

CLEAN! EXACT! LEFT,!LEFTB! MID,!MIDB! REPT! T! VALUE!

!!External'functions'

EUROCONVERT! SQL.REQUEST!

!! !

Statistical'functions'

AVEDEV! COUNTA! FREQUENCY! LINEST! NORMINV! SKEW! TRIMMEAN!AVERAGE! COUNTBLANK! FTEST! LOGEST! NORMSDIST! SLOPE! TTEST!AVERAGEA! COUNTIF! GAMMADIST! LOGINV! NORMSINV! SMALL! VAR!BETADIST! COVAR! GAMMAINV! LOGNORMDIST! PEARSON! STANDARDIZE! VARA!BETAINV! CRITBINOM! GAMMALN! MAX! PERCENTILE! STDEV! VARP!BINOMDIST! DEVSQ! GEOMEAN! MAXA! PERCENTRANK! STDEVA! VARPA!CHIDIST! EXPONDIST! GROWTH! MEDIAN! PERMUT! STDEVP! WEIBULL!CHIINV! FDIST! HARMEAN! MIN! POISSON! STDEVPA! ZTEST!CHITEST! FINV! HYPGEOMDIST! MINA! PROB! STEYX! !CONFIDENCE! FISHER! INTERCEPT! MODE! QUARTILE! TDIST! !CORREL! FISHERINV! KURT! NEGBINOMDIST! RANK! TINV! !COUNT! FORECAST! LARGE! NORMDIST! RSQ! TREND! !

Owain Evans
Excel functions reference
Owain Evans

Top Related