• Apple
      • Store
      • Mac
      • iPad
      • iPhone 
      • Watch
      • Vision
      • AirPods
      • TV & Home
      • Entertainment
      • Accessories
      • Support
    • 0+
    Formulas and Functions Help
    Open Menu Close Menu
    • Communities

    Table of Contents

    • Welcome
      • 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 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
      • DATEDIF
      • DATEVALUE
      • DAY
      • DAYNAME
      • DAYS360
      • EDATE
      • EOMONTH
      • HOUR
      • ISOWEEKNUM
      • MINUTE
      • MONTH
      • MONTHNAME
      • NETWORKDAYS
      • NOW
      • SECOND
      • TIME
      • TIMEVALUE
      • TODAY
      • WEEKDAY
      • WEEKNUM
      • WORKDAY
      • YEAR
      • YEARFRAC
      • DUR2DAYS
      • DUR2HOURS
      • DUR2MILLISECONDS
      • DUR2MINUTES
      • DUR2SECONDS
      • DUR2WEEKS
      • DURATION
      • STRIPDURATION
      • 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
      • 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
      • AND
      • BYCOL
      • BYROW
      • FALSE
      • IF
      • IFERROR
      • IFS
      • ISBLANK
      • ISDATE
      • ISERROR
      • ISEVEN
      • ISNUMBER
      • ISNUMBERORDATE
      • ISODD
      • ISOMITTED
      • ISTEXT
      • LAMBDA
      • LAMBDA.APPLY
      • LET
      • MAKEARRAY
      • MAP
      • NOT
      • OR
      • REDUCE
      • SCAN
      • SWITCH
      • TRUE
      • ABS
      • CEILING
      • COMBIN
      • EVEN
      • EXP
      • FACT
      • FACTDOUBLE
      • FLOOR
      • GCD
      • INT
      • LCM
      • LN
      • LOG
      • LOG10
      • MDETERM
      • MINVERSE
      • MMULT
      • MOD
      • MROUND
      • MULTINOMIAL
      • MUNIT
      • ODD
      • PI
      • POLYNOMIAL
      • POWER
      • PRODUCT
      • QUOTIENT
      • RAND
      • RANDARRAY
      • RANDBETWEEN
      • ROMAN
      • ROUND
      • ROUNDDOWN
      • ROUNDUP
      • SEQUENCE
      • SERIESSUM
      • SIGN
      • SQRT
      • SQRTPI
      • SUBTOTAL
      • SUM
      • SUMIF
      • SUMIFS
      • SUMPRODUCT
      • SUMSQ
      • SUMX2MY2
      • SUMX2PY2
      • SUMXMY2
      • TRUNC
      • ADDRESS
      • AREAS
      • CHOOSE
      • CHOOSECOLS
      • CHOOSEROWS
      • COLUMN
      • COLUMNS
      • DROP
      • EXPAND
      • FILTER
      • FORMULATEXT
      • GETPIVOTDATA
      • HLOOKUP
      • HSTACK
      • HYPERLINK
      • INDEX
      • INDIRECT
      • INTERSECT.RANGES
      • LOOKUP
      • MATCH
      • OFFSET
      • REFERENCE.NAME
      • ROW
      • ROWS
      • SORT
      • SORTBY
      • TAKE
      • TOCOL
      • TOROW
      • TRANSPOSE
      • UNION.RANGES
      • UNIQUE
      • VLOOKUP
      • VSTACK
      • WRAPCOLS
      • WRAPROWS
      • XLOOKUP
      • XMATCH
      • 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
      • ARRAYTOTEXT
      • 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
      • TEXTSPLIT
      • TRIM
      • UPPER
      • VALUE
      • ACOS
      • ACOSH
      • ASIN
      • ASINH
      • ATAN
      • ATAN2
      • ATANH
      • COS
      • COSH
      • DEGREES
      • RADIANS
      • SIN
      • SINH
      • TAN
      • TANH
    • Copyright

    Apple Footer

    ๏ฃฟ Apple
    1. Support
    2. Formulas and Functions Help
    3. Formulas and Functions Help
    UK
    Copyright ยฉ 2025 Apple Inc. All rights reserved.
    Privacy Policy Terms of Use Sales and Refunds Site Map Use of Cookies