Formulas and Functions Help

• Welcome
• Formulas
  • Formulas overview
  • Add and edit formulas
  • Review formula errors and best practices
  • Copy or move formulas
  • Refer to cells in formulas
  • Use string operators and wildcards
  • Tips for using double quotations in formulas
• Functions
  • Functions overview
  • List of functions by category
  • Types of arguments and values
  • Use string operators and wildcards
  • Tips for selecting financial functions
  • Functions used to round values
  • Functions that accept conditions and wildcards as arguments
• Date and time functions
  • DATE
  • DATEDIF
  • DATEVALUE
  • DAY
  • DAYNAME
  • DAYS360
  • EDATE
  • EOMONTH
  • HOUR
  • ISOWEEKNUM
  • MINUTE
  • MONTH
  • MONTHNAME
  • NETWORKDAYS
  • NOW
  • SECOND
  • TIME
  • TIMEVALUE
  • TODAY
  • WEEKDAY
  • WEEKNUM
  • WORKDAY
  • YEAR
  • YEARFRAC
• Duration functions
  • DUR2DAYS
  • DUR2HOURS
  • DUR2MILLISECONDS
  • DUR2MINUTES
  • DUR2SECONDS
  • DUR2WEEKS
  • DURATION
  • STRIPDURATION
• Engineering functions
  • BASETONUM
  • BESSELJ
  • BESSELY
  • BIN2DEC
  • BIN2HEX
  • BIN2OCT
  • BITAND
  • BITOR
  • BITXOR
  • BITLSHIFT
  • BITRSHIFT
  • CONVERT
  • DEC2BIN
  • DEC2HEX
  • DEC2OCT
  • DELTA
  • ERF
  • ERFC
  • GESTEP
  • HEX2BIN
  • HEX2DEC
  • HEX2OCT
  • NUMTOBASE
  • OCT2BIN
  • OCT2DEC
  • OCT2HEX
• Financial functions
  • ACCRINT
  • ACCRINTM
  • BONDDURATION
  • BONDMDURATION
  • COUPDAYBS
  • COUPDAYS
  • COUPDAYSNC
  • COUPNUM
  • CUMIPMT
  • CUMPRINC
  • CURRENCY
  • CURRENCYCODE
  • CURRENCYCONVERT
  • CURRENCYH
  • DB
  • DDB
  • DISC
  • EFFECT
  • FV
  • INTRATE
  • IPMT
  • IRR
  • ISPMT
  • MIRR
  • NOMINAL
  • NPER
  • NPV
  • PMT
  • PPMT
  • PRICE
  • PRICEDISC
  • PRICEMAT
  • PV
  • RATE
  • RECEIVED
  • SLN
  • STOCK
  • STOCKH
  • SYD
  • VDB
  • XIRR
  • XNPV
  • YIELD
  • YIELDDISC
  • YIELDMAT
• Logical and information functions
  • AND
  • FALSE
  • IF
  • IFERROR
  • IFS
  • ISBLANK
  • ISDATE
  • ISERROR
  • ISEVEN
  • ISNUMBER
  • ISODD
  • ISTEXT
  • NOT
  • OR
  • SWITCH
  • TRUE
• Numeric functions
  • ABS
  • CEILING
  • COMBIN
  • EVEN
  • EXP
  • FACT
  • FACTDOUBLE
  • FLOOR
  • GCD
  • INT
  • LCM
  • LN
  • LOG
  • LOG10
  • MOD
  • MROUND
  • MULTINOMIAL
  • ODD
  • PI
  • POLYNOMIAL
  • POWER
  • PRODUCT
  • QUOTIENT
  • RAND
  • RANDBETWEEN
  • ROMAN
  • ROUND
  • ROUNDDOWN
  • ROUNDUP
  • SERIESSUM
  • SIGN
  • SQRT
  • SQRTPI
  • SUBTOTAL
  • SUM
  • SUMIF
  • SUMIFS
  • SUMPRODUCT
  • SUMSQ
  • SUMX2MY2
  • SUMX2PY2
  • SUMXMY2
  • TRUNC
• Reference functions
  • ADDRESS
  • AREAS
  • CHOOSE
  • COLUMN
  • COLUMNS
  • FORMULATEXT
  • GETPIVOTDATA
  • HLOOKUP
  • HYPERLINK
  • INDEX
  • INDIRECT
  • INTERSECT.RANGES
  • LOOKUP
  • MATCH
  • OFFSET
  • REFERENCE.NAME
  • ROW
  • ROWS
  • TRANSPOSE
  • UNION.RANGES
  • VLOOKUP
  • XLOOKUP
  • XMATCH
• Statistical functions
  • AVEDEV
  • AVERAGE
  • AVERAGEA
  • AVERAGEIF
  • AVERAGEIFS
  • BETADIST
  • BETAINV
  • BINOMDIST
  • CHIDIST
  • CHIINV
  • CHITEST
  • CONFIDENCE
  • CORREL
  • COUNT
  • COUNTA
  • COUNTBLANK
  • COUNTIF
  • COUNTIFS
  • COVAR
  • CRITBINOM
  • DEVSQ
  • EXPONDIST
  • FDIST
  • FINV
  • FORECAST
  • FREQUENCY
  • GAMMADIST
  • GAMMAINV
  • GAMMALN
  • GEOMEAN
  • HARMEAN
  • INTERCEPT
  • LARGE
  • LINEST
  • LOGINV
  • LOGNORMDIST
  • MAX
  • MAXA
  • MAXIFS
  • MEDIAN
  • MIN
  • MINA
  • MINIFS
  • MODE
  • NEGBINOMDIST
  • NORMDIST
  • NORMINV
  • NORMSDIST
  • NORMSINV
  • PERCENTILE
  • PERCENTRANK
  • PERMUT
  • POISSON
  • PROB
  • QUARTILE
  • RANK
  • SLOPE
  • SMALL
  • STANDARDIZE
  • STDEV
  • STDEVA
  • STDEVP
  • STDEVPA
  • TDIST
  • TINV
  • TTEST
  • VAR
  • VARA
  • VARP
  • VARPA
  • WEIBULL
  • ZTEST
• Text functions
  • CHAR
  • CLEAN
  • CODE
  • CONCAT
  • CONCATENATE
  • COUNTMATCHES
  • DOLLAR
  • EXACT
  • FIND
  • FIXED
  • LEFT
  • LEN
  • LOWER
  • MID
  • PLAINTEXT
  • PROPER
  • REGEX
  • REGEX.EXTRACT
  • REPLACE
  • REPT
  • RIGHT
  • SEARCH
  • SUBSTITUTE
  • T
  • TEXTAFTER
  • TEXTBEFORE
  • TEXTBETWEEN
  • TEXTJOIN
  • TRIM
  • UPPER
  • VALUE
• Trigonometric functions
  • ACOS
  • ACOSH
  • ASIN
  • ASINH
  • ATAN
  • ATAN2
  • ATANH
  • COS
  • COSH
  • DEGREES
  • RADIANS
  • SIN
  • SINH
  • TAN
  • TANH
• Copyright