• Formula Reference
• Contacting Us
• Getting Technical Support
• Formula Overview
  • What is a Formula?
    • Sample Formula
  • Cell References in a Formula
    • A1 (Letter-Number) Notation
    • R1C1 (Number-Number) Notation
    • Relative and Absolute
    • Scope of Cell References
  • Sheet References in a Formula
  • Operators in a Formula
    • Order of Precedence
    • Using Operators with Dates and Times
  • Functions in a Formula
    • Categories of Functions
      • Database Functions
      • Date and Time Functions
      • Engineering Functions
        • Complex Numbers in Engineering Functions
      • Financial Functions
        • Day Count Basis
      • Information Functions
      • Logical Functions
      • Lookup Functions
      • Math and Trigonometry Functions
      • Statistical Functions
      • Text Functions
    • Optional Arguments
    • Missing Arguments
    • Volatile Functions
  • Array Formulas
  • Arrays in a Formula
  • Data Types in a Formula
  • Custom Functions in Formulas
  • Custom Names in Formulas
  • Resultant Error Values
• Formula Functions
  • Functions A to C
    • ABS
    • ACCRINT
    • ACCRINTM
    • ACOS
    • ACOSH
    • ADDRESS
    • AMORDEGRC
    • AMORLINC
    • AND
    • ASIN
    • ASINH
    • ATAN
    • ATAN2
    • ATANH
    • AVEDEV
    • AVERAGE
    • AVERAGEA
    • AVERAGEIF
    • AVERAGEIFS
    • BESSELI
    • BESSELJ
    • BESSELK
    • BESSELY
    • BETADIST
    • BETAINV
    • BIN2DEC
    • BIN2HEX
    • BIN2OCT
    • BINOMDIST
    • CEILING
    • CHAR
    • CHIDIST
    • CHIINV
    • CHITEST
    • CHOOSE
    • CLEAN
    • CODE
    • COLUMN
    • COLUMNS
    • COMBIN
    • COMPLEX
    • CONCATENATE
    • CONFIDENCE
    • CONVERT
    • CORREL
    • COS
    • COSH
    • COUNT
    • COUNTA
    • COUNTBLANK
    • COUNTIF
    • COUNTIFS
    • COUPDAYBS
    • COUPDAYS
    • COUPDAYSNC
    • COUPNCD
    • COUPNUM
    • COUPPCD
    • COVAR
    • CRITBINOM
    • CUMIPMT
    • CUMPRINC
  • Functions D to G
    • DATE
    • DATEDIF
    • DATEVALUE
    • DAVERAGE
    • DAY
    • DAYS360
    • DB
    • DCOUNT
    • DCOUNTA
    • DDB
    • DEC2BIN
    • DEC2HEX
    • DEC2OCT
    • DEGREES
    • DELTA
    • DEVSQ
    • DGET
    • DISC
    • DMAX
    • DMIN
    • DOLLAR
    • DOLLARDE
    • DOLLARFR
    • DPRODUCT
    • DSTDEV
    • DSTDEVP
    • DSUM
    • DURATION
    • DVAR
    • DVARP
    • EDATE
    • EFFECT
    • EOMONTH
    • ERF
    • ERFC
    • ERRORTYPE
    • EURO
    • EUROCONVERT
    • EVEN
    • EXACT
    • EXP
    • EXPONDIST
    • FACT
    • FACTDOUBLE
    • FALSE
    • FDIST
    • FIND
    • FINV
    • FISHER
    • FISHERINV
    • FIXED
    • FLOOR
    • FORECAST
    • FREQUENCY
    • FTEST
    • FV
    • FVSCHEDULE
    • GAMMADIST
    • GAMMAINV
    • GAMMALN
    • GCD
    • GEOMEAN
    • GESTEP
    • GROWTH
  • Functions H to L
    • HARMEAN
    • HEX2BIN
    • HEX2DEC
    • HEX2OCT
    • HLOOKUP
    • HOUR
    • HYPGEOMDIST
    • IF
    • IFERROR
    • IMABS
    • IMAGINARY
    • IMARGUMENT
    • IMCONJUGATE
    • IMCOS
    • IMDIV
    • IMEXP
    • IMLN
    • IMLOG10
    • IMLOG2
    • IMPOWER
    • IMPRODUCT
    • IMREAL
    • IMSIN
    • IMSQRT
    • IMSUB
    • IMSUM
    • INDEX
    • INT
    • INTERCEPT
    • INTRATE
    • IPMT
    • IRR
    • ISBLANK
    • ISERR
    • ISERROR
    • ISEVEN
    • ISLOGICAL
    • ISNA
    • ISNONTEXT
    • ISNUMBER
    • ISODD
    • ISPMT
    • ISREF
    • ISTEXT
    • KURT
    • LARGE
    • LCM
    • LEFT
    • LEN
    • LINEST
    • LN
    • LOG
    • LOG10
    • LOGEST
    • LOGINV
    • LOGNORMDIST
    • LOOKUP
    • LOWER
  • Functions M to Q
    • MATCH
    • MAX
    • MAXA
    • MDETERM
    • MDURATION
    • MEDIAN
    • MID
    • MIN
    • MINA
    • MINUTE
    • MINVERSE
    • MIRR
    • MMULT
    • MOD
    • MODE
    • MONTH
    • MROUND
    • MULTINOMIAL
    • N
    • NA
    • NEGBINOMDIST
    • NETWORKDAYS
    • NOMINAL
    • NORMDIST
    • NORMINV
    • NORMSDIST
    • NORMSINV
    • NOT
    • NOW
    • NPER
    • NPV
    • OCT2BIN
    • OCT2DEC
    • OCT2HEX
    • ODD
    • ODDFPRICE
    • ODDFYIELD
    • ODDLPRICE
    • ODDLYIELD
    • OFFSET
    • OR
    • PEARSON
    • PERCENTILE
    • PERCENTRANK
    • PERMUT
    • PI
    • PMT
    • POISSON
    • POWER
    • PPMT
    • PRICE
    • PRICEDISC
    • PRICEMAT
    • PROB
    • PRODUCT
    • PROPER
    • PV
    • QUARTILE
    • QUOTIENT
  • Functions R to S
    • RADIANS
    • RAND
    • RANDBETWEEN
    • RANK
    • RATE
    • RECEIVED
    • REPLACE
    • REPT
    • RIGHT
    • ROMAN
    • ROUND
    • ROUNDDOWN
    • ROUNDUP
    • ROW
    • ROWS
    • RSQ
    • SEARCH
    • SECOND
    • SERIESSUM
    • SIGN
    • SIN
    • SINH
    • SKEW
    • SLN
    • SLOPE
    • SMALL
    • SQRT
    • SQRTPI
    • STANDARDIZE
    • STDEV
    • STDEVA
    • STDEVP
    • STDEVPA
    • STEYX
    • SUBSTITUTE
    • SUBTOTAL
    • SUM
    • SUMIF
    • SUMIFS
    • SUMPRODUCT
    • SUMSQ
    • SUMX2MY2
    • SUMX2PY2
    • SUMXMY2
    • SYD
  • Functions T to Z
    • T
    • TAN
    • TANH
    • TBILLEQ
    • TBILLPRICE
    • TBILLYIELD
    • TDIST
    • TEXT
    • TIME
    • TIMEVALUE
    • TINV
    • TODAY
    • TRANSPOSE
    • TREND
    • TRIM
    • TRIMMEAN
    • TRUE
    • TRUNC
    • TTEST
    • TYPE
    • UPPER
    • VALUE
    • VAR
    • VARA
    • VARP
    • VARPA
    • VDB
    • VLOOKUP
    • WEEKDAY
    • WEEKNUM
    • WEIBULL
    • WORKDAY
    • XIRR
    • XNPV
    • YEAR
    • YEARFRAC
    • YIELD
    • YIELDDISC
    • YIELDMAT
    • ZTEST