Expression Language Reference
    Preparing search index...

    Namespace FormulaJs

    Namespaces

    BETA
    BINOM
    CEILING
    CHISQ
    CONFIDENCE
    COVARIANCE
    ERF
    ERFC
    ERROR
    EXPON
    F
    FLOOR
    GAMMA
    GAMMALN
    HYPGEOM
    ISO
    LOGNORM
    MODE
    NEGBINOM
    NETWORKDAYS
    NORM
    PERCENTILE
    PERCENTRANK
    POISSON
    QUARTILE
    RANK
    SKEW
    STDEV
    VAR
    WEIBULL
    WORKDAY
    Z

    Variables

    BETADIST
    BETAINV
    BINOMDIST
    CEILINGMATH
    CEILINGPRECISE
    CHIDIST
    CHIDISTRT
    CHIINV
    CHIINVRT
    CHITEST
    COVAR
    COVARIANCEP
    COVARIANCES
    CRITBINOM
    ERFCPRECISE
    ERFPRECISE
    EXPONDIST
    FDIST
    FDISTRT
    FINV
    FINVRT
    FLATTEN
    FLOORMATH
    FLOORPRECISE
    FTEST
    GAMMADIST
    GAMMAINV
    GAMMALNPRECISE
    HYPGEOMDIST
    LOGINV
    LOGNORMDIST
    LOGNORMINV
    MODEMULT
    MODESNGL
    NEGBINOMDIST
    NETWORKDAYSINTL
    NORMDIST
    NORMINV
    NORMSDIST
    NORMSINV
    PERCENTILEEXC
    PERCENTILEINC
    PERCENTRANKEXC
    PERCENTRANKINC
    POISSONDIST
    QUARTILEEXC
    QUARTILEINC
    RANKAVG
    RANKEQ
    SKEWP
    STDEVP
    STDEVS
    TDIST
    TDISTRT
    TINV
    TTEST
    VARP
    VARS
    WEIBULLDIST
    WORKDAYINTL
    ZTEST

    Functions

    ABS
    ACCRINT
    ACCRINTM
    ACOS
    ACOSH
    ACOT
    ACOTH
    ADD
    AGGREGATE
    AMORDEGRC
    AMORLINC
    AND
    ARABIC
    ARGS2ARRAY
    ASC
    ASIN
    ASINH
    ATAN
    ATAN2
    ATANH
    AVEDEV
    AVERAGE
    AVERAGEA
    AVERAGEIF
    AVERAGEIFS
    BAHTTEXT
    BASE
    BESSELI
    BESSELJ
    BESSELK
    BESSELY
    BIN2DEC
    BIN2HEX
    BIN2OCT
    BITAND
    BITLSHIFT
    BITOR
    BITRSHIFT
    BITXOR
    CEILING
    CELL
    CHAR
    CHOOSE
    CLEAN
    CODE
    COLUMN
    COLUMNS
    COMBIN
    COMBINA
    COMPLEX
    CONCAT
    CONCATENATE
    CONVERT
    CORREL
    COS
    COSH
    COT
    COTH
    COUNT
    COUNTA
    COUNTBLANK
    COUNTIF
    COUNTIFS
    COUNTIN
    COUNTUNIQUE
    COUPDAYBS
    COUPDAYS
    COUPDAYSNC
    COUPNCD
    COUPNUM
    COUPPCD
    CSC
    CSCH
    CUMIPMT
    CUMPRINC
    DATE
    DATEDIF
    DATEVALUE
    DAVERAGE
    DAY
    DAYS
    DAYS360
    DB
    DBCS
    DCOUNT
    DCOUNTA
    DDB
    DEC2BIN
    DEC2HEX
    DEC2OCT
    DECIMAL
    DEGREES
    DELTA
    DEVSQ
    DGET
    DISC
    DIVIDE
    DMAX
    DMIN
    DOLLAR
    DOLLARDE
    DOLLARFR
    DPRODUCT
    DSTDEV
    DSTDEVP
    DSUM
    DURATION
    DVAR
    DVARP
    E
    EDATE
    EFFECT
    EOMONTH
    EQ
    ERF
    ERFC
    EVEN
    EXACT
    EXP
    FACT
    FACTDOUBLE
    FALSE
    FIND
    FINDFIELD
    FISHER
    FISHERINV
    FIXED
    FLOOR
    FORECAST
    FREQUENCY
    FV
    FVSCHEDULE
    GAMMA
    GAMMALN
    GAUSS
    GCD
    GEOMEAN
    GESTEP
    GROWTH
    GT
    GTE
    HARMEAN
    HEX2BIN
    HEX2DEC
    HEX2OCT
    HLOOKUP
    HOUR
    HTML2TEXT
    IF
    IFERROR
    IFNA
    IFS
    IMABS
    IMAGINARY
    IMARGUMENT
    IMCONJUGATE
    IMCOS
    IMCOSH
    IMCOT
    IMCSC
    IMCSCH
    IMDIV
    IMEXP
    IMLN
    IMLOG10
    IMLOG2
    IMPOWER
    IMPRODUCT
    IMREAL
    IMSEC
    IMSECH
    IMSIN
    IMSINH
    IMSQRT
    IMSUB
    IMSUM
    IMTAN
    INDEX
    INFO
    INT
    INTERCEPT
    INTERVAL
    INTRATE
    IPMT
    IRR
    ISBINARY
    ISBLANK
    ISERR
    ISERROR
    ISEVEN
    ISFORMULA
    ISLOGICAL
    ISNA
    ISNONTEXT
    ISNUMBER
    ISODD
    ISOWEEKNUM
    ISPMT
    ISREF
    ISTEXT
    JOIN
    KURT
    LARGE
    LCM
    LEFT
    LEN
    LINEST
    LN
    LN10
    LN2
    LOG
    LOG10
    LOG10E
    LOG2E
    LOGEST
    LOOKUP
    LOWER
    LT
    LTE
    MATCH
    MAX
    MAXA
    MDURATION
    MEDIAN
    MID
    MIN
    MINA
    MINUS
    MINUTE
    MIRR
    MOD
    MONTH
    MROUND
    MULTINOMIAL
    MULTIPLY
    N
    NA
    NE
    NETWORKDAYS
    NOMINAL
    NOT
    NOW
    NPER
    NPV
    NUMBERS
    NUMBERVALUE
    OCT2BIN
    OCT2DEC
    OCT2HEX
    ODD
    ODDFPRICE
    ODDFYIELD
    ODDLPRICE
    ODDLYIELD
    OR
    PDURATION
    PEARSON
    PERMUT
    PERMUTATIONA
    PHI
    PI
    PMT
    POW
    POWER
    PPMT
    PRICE
    PRICEDISC
    PRICEMAT
    PROB
    PRODUCT
    PRONETIC
    PROPER
    PV
    QUOTIENT
    RADIANS
    RAND
    RANDBETWEEN
    RATE
    RECEIVED
    REFERENCE
    REGEXEXTRACT
    REGEXMATCH
    REGEXREPLACE
    REPLACE
    REPT
    ROMAN
    ROUND
    ROUNDDOWN
    ROUNDUP
    ROW
    ROWS
    RRI
    RSQ
    SEC
    SECH
    SECOND
    SERIESSUM
    SHEET
    SHEETS
    SIGN
    SIN
    SINH
    SKEW
    SLN
    SLOPE
    SMALL
    SPLIT
    SQRT
    SQRT1_2
    SQRT2
    SQRTPI
    STANDARDIZE
    STDEVA
    STDEVPA
    STEYX
    SUBSTITUTE
    SUBTOTAL
    SUM
    SUMIF
    SUMIFS
    SUMPRODUCT
    SUMSQ
    SUMX2MY2
    SUMX2PY2
    SUMXMY2
    SWITCH
    SYD
    T
    TAN
    TANH
    TBILLEQ
    TBILLPRICE
    TBILLYIELD
    TEXT
    TEXTJOIN
    TIME
    TIMEVALUE
    TODAY
    TRANSPOSE
    TREND
    TRIM
    TRIMMEAN
    TRUE
    TRUNC
    TYPE
    UNICHAR
    UNICODE
    UNIQUE
    UPPER
    VALUE
    VARA
    VARPA
    VDB
    VLOOKUP
    WEEKDAY
    WEEKNUM
    WORKDAY
    XIRR
    XNPV
    XOR
    YEAR
    YEARFRAC
    YIELD
    YIELDDISC
    YIELDMAT

    Settings

    Member Visibility

    On This Page

    Namespaces
    Variables
    Functions
    ABSACCRINTACCRINTMACOSACOSHACOTACOTHADDAGGREGATEAMORDEGRCAMORLINCANDARABICARGS2ARRAYASCASINASINHATANATAN2ATANHAVEDEVAVERAGEAVERAGEAAVERAGEIFAVERAGEIFSBAHTTEXTBASEBESSELIBESSELJBESSELKBESSELYBIN2DECBIN2HEXBIN2OCTBITANDBITLSHIFTBITORBITRSHIFTBITXORCEILINGCELLCHARCHOOSECLEANCODECOLUMNCOLUMNSCOMBINCOMBINACOMPLEXCONCATCONCATENATECONVERTCORRELCOSCOSHCOTCOTHCOUNTCOUNTACOUNTBLANKCOUNTIFCOUNTIFSCOUNTINCOUNTUNIQUECOUPDAYBSCOUPDAYSCOUPDAYSNCCOUPNCDCOUPNUMCOUPPCDCSCCSCHCUMIPMTCUMPRINCDATEDATEDIFDATEVALUEDAVERAGEDAYDAYSDAYS360DBDBCSDCOUNTDCOUNTADDBDEC2BINDEC2HEXDEC2OCTDECIMALDEGREESDELTADEVSQDGETDISCDIVIDEDMAXDMINDOLLARDOLLARDEDOLLARFRDPRODUCTDSTDEVDSTDEVPDSUMDURATIONDVARDVARPEEDATEEFFECTEOMONTHEQERFERFCEVENEXACTEXPFACTFACTDOUBLEFALSEFINDFINDFIELDFISHERFISHERINVFIXEDFLOORFORECASTFREQUENCYFVFVSCHEDULEGAMMAGAMMALNGAUSSGCDGEOMEANGESTEPGROWTHGTGTEHARMEANHEX2BINHEX2DECHEX2OCTHLOOKUPHOURHTML2TEXTIFIFERRORIFNAIFSIMABSIMAGINARYIMARGUMENTIMCONJUGATEIMCOSIMCOSHIMCOTIMCSCIMCSCHIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWERIMPRODUCTIMREALIMSECIMSECHIMSINIMSINHIMSQRTIMSUBIMSUMIMTANINDEXINFOINTINTERCEPTINTERVALINTRATEIPMTIRRISBINARYISBLANKISERRISERRORISEVENISFORMULAISLOGICALISNAISNONTEXTISNUMBERISODDISOWEEKNUMISPMTISREFISTEXTJOINKURTLARGELCMLEFTLENLINESTLNLN10LN2LOGLOG10LOG10ELOG2ELOGESTLOOKUPLOWERLTLTEMATCHMAXMAXAMDURATIONMEDIANMIDMINMINAMINUSMINUTEMIRRMODMONTHMROUNDMULTINOMIALMULTIPLYNNANENETWORKDAYSNOMINALNOTNOWNPERNPVNUMBERSNUMBERVALUEOCT2BINOCT2DECOCT2HEXODDODDFPRICEODDFYIELDODDLPRICEODDLYIELDORPDURATIONPEARSONPERMUTPERMUTATIONAPHIPIPMTPOWPOWERPPMTPRICEPRICEDISCPRICEMATPROBPRODUCTPRONETICPROPERPVQUOTIENTRADIANSRANDRANDBETWEENRATERECEIVEDREFERENCEREGEXEXTRACTREGEXMATCHREGEXREPLACEREPLACEREPTRIGHTROMANROUNDROUNDDOWNROUNDUPROWROWSRRIRSQSEARCHSECSECHSECONDSERIESSUMSHEETSHEETSSIGNSINSINHSKEWSLNSLOPESMALLSPLITSQRTSQRT1_2SQRT2SQRTPISTANDARDIZESTDEVASTDEVPASTEYXSUBSTITUTESUBTOTALSUMSUMIFSUMIFSSUMPRODUCTSUMSQSUMX2MY2SUMX2PY2SUMXMY2SWITCHSYDTTANTANHTBILLEQTBILLPRICETBILLYIELDTEXTTEXTJOINTIMETIMEVALUETODAYTRANSPOSETRENDTRIMTRIMMEANTRUETRUNCTYPEUNICHARUNICODEUNIQUEUPPERVALUEVARAVARPAVDBVLOOKUPWEEKDAYWEEKNUMWORKDAYXIRRXNPVXORYEARYEARFRACYIELDYIELDDISCYIELDMAT