EXCEL Formula Dictionary
EXCEL Formula Dictionary
EXCEL Formula Dictionary
Function Dictionary
ABS ISBLANK STDEVP
ADDRESS ISERR SUBSTITUTE
Analysis ToolPak ISERROR SUM
AND ISLOGICAL SUM_as_Running_Total
AREAS ISNA SUM_using_names
AVERAGE ISNONTEXT SUM_with_OFFSET
CEILING ISNUMBER SUMIF
CELL ISREF SUMPRODUCT
CHAR ISTEXT SYD
CHOOSE LARGE T
CLEAN LEFT TEXT
CODE LEN TIME
COMBIN LOOKUP (Array) TIMEVALUE
CONCATENATE LOOKUP (Vector) TODAY
CORREL LOWER TRANSPOSE
COUNT MATCH TREND
COUNTA MAX TRIM
COUNTBLANK MEDIAN TRUNC
COUNTIF MID UPPER
DATE MIN VALUE
DATEDIF MINUTE VAR
DATEVALUE MMULT VARP
DAVERAGE MOD VLOOKUP
DAY MODE WEEKDAY
DAYS360 MONTH YEAR
DB N
DCOUNT NA
DCOUNTA NOT
DGET NOW
DMAX ODD These functions show #NAME if
DMIN OR the Analysys Toolpak is
Documentation PACKERS not installed.
DOLLAR PERMUT
DSUM PI BIN2DEC
EAST POWER CONVERT
ERROR.TYPE PRODUCT DEC2BIN
EVEN PROPER DEC2HEX
EXACT QUARTILE DELTA
FACT RAND EDATE
FIND RANK EOMONTH
FIXED REPLACE GCD
FLOOR REPT GESTEP
FORECAST RIGHT HEX2DEC
FREQUENCY ROMAN ISEVEN
FREQUENCY 2 ROUND ISODD
HLOOKUP ROUNDDOWN LCM
HOUR ROUNDUP MROUND
IF SECOND NETWORKDAYS
INDEX SIGN QUOTIENT
INDIRECT SLN RANDBETWEEN
INFO SMALL WORKDAY
INT STDEV YEARFRAC
(c) 2003 - 2009 Peter Noneley www.xlfdic.com Excel Function Dictionary v3