• Apple
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
    • MUNIT
    • MOD
    • MROUND
    • MULTINOMIAL
    • 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
Vietnam
Copyright © 2025 Apple Inc. All rights reserved.
Privacy Policy Terms of Use Site Map