excel functions reference
TRANSCRIPT
!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! !