excel functions reference

1
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

Upload: owain-evans

Post on 19-Apr-2015

23 views

Category:

Documents


2 download

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