Skip to content

Supported Formulas

The following 389 formulas are supported.

ABSACCRINTACOSACOSH
ACOTACOTHADDAGGREGATE
ANDARABICARGS2ARRAYASIN
ASINHATANATAN2ATANH
AVEDEVAVERAGEAVERAGEAAVERAGEIF
AVERAGEIFSBASEBESSELIBESSELJ
BESSELYBETA.DISTBETA.INVBETADIST
BETAINVBIN2DECBIN2HEXBIN2OCT
BINOM.DISTBINOM.DIST.RANGEBINOM.INVBINOMDIST
BITANDBITLSHIFTBITORBITRSHIFT
BITXORCEILINGCEILINGMATHCEILINGPRECISE
CHARCHISQ.DISTCHISQ.DIST.RTCHISQ.INV
CHISQ.INV.RTCHOOSECLEANCODE
COLUMNCOLUMNSCOMBINCOMBINA
COMPLEXCONCATENATECONFIDENCECONFIDENCE.NORM
CONFIDENCE.TCONVERTCORRELCOS
COSHCOTCOTHCOUNT
COUNTACOUNTBLANKCOUNTIFCOUNTIFS
COUNTINCOUNTUNIQUECOVARIANCE.PCOVARIANCE.S
CSCCSCHCUMIPMTCUMPRINC
DATEDATEVALUEDAYDAYS
DAYS360DBDDBDEC2BIN
DEC2HEXDEC2OCTDECIMALDEGREES
DELTADEVSQDIVIDEDOLLAR
DOLLARDEDOLLARFREEDATE
EFFECTEOMONTHEQERF
ERFCEVENEXACTEXPON.DIST
EXPONDISTF.DISTF.DIST.RTF.INV
F.INV.RTFACTFACTDOUBLEFALSE
FDISTFDISTRTFINDFINV
FINVRTFISHERFISHERINVFIXED
FLATTENFLOORFORECASTFREQUENCY
FVFVSCHEDULEGAMMAGAMMA.DIST
GAMMA.INVGAMMADISTGAMMAINVGAMMALN
GAMMALN.PRECISEGAUSSGCDGEOMEAN
GESTEPGROWTHGTEHARMEAN
HEX2BINHEX2DECHEX2OCTHOUR
HTML2TEXTHYPGEOM.DISTHYPGEOMDISTIF
IMABSIMAGINARYIMARGUMENTIMCONJUGATE
IMCOSIMCOSHIMCOTIMCSC
IMCSCHIMDIVIMEXPIMLN
IMLOG10IMLOG2IMPOWERIMPRODUCT
IMREALIMSECIMSECHIMSIN
IMSINHIMSQRTIMSUBIMSUM
IMTANINTINTERCEPTINTERVAL
IPMTIRRISBINARYISBLANK
ISEVENISLOGICALISNONTEXTISNUMBER
ISODDISOWEEKNUMISPMTISTEXT
JOINKURTLARGELCM
LEFTLENLINESTLN
LOGLOG10LOGESTLOGNORM.DIST
LOGNORM.INVLOGNORMDISTLOGNORMINVLOWER
LTLTEMATCHMAX
MAXAMEDIANMIDMIN
MINAMINUSMINUTEMIRR
MODMODE.MULTMODE.SNGLMODEMULT
MODESNGLMONTHMROUNDMULTINOMIAL
MULTIPLYNENEGBINOM.DISTNEGBINOMDIST
NETWORKDAYSNOMINALNORM.DISTNORM.INV
NORM.S.DISTNORM.S.INVNORMDISTNORMINV
NORMSDISTNORMSINVNOTNOW
NPERNPVNUMBERSNUMERAL
OCT2BINOCT2DECOCT2HEXODD
ORPDURATIONPEARSONPERCENTILEEXC
PERCENTILEINCPERCENTRANKEXCPERCENTRANKINCPERMUT
PERMUTATIONAPHIPIPMT
POISSON.DISTPOISSONDISTPOWPOWER
PPMTPROBPRODUCTPROPER
PVQUARTILE.EXCQUARTILE.INCQUARTILEEXC
QUARTILEINCQUOTIENTRADIANSRAND
RANDBETWEENRANK.AVGRANK.EQRANKAVG
RANKEQRATEREFERENCEREGEXEXTRACT
REGEXMATCHREGEXREPLACEREPLACEREPT
RIGHTROMANROUNDROUNDDOWN
ROUNDUPROWROWSRRI
RSQSEARCHSECSECH
SECONDSERIESSUMSIGNSIN
SINHSKEWSKEW.PSKEWP
SLNSLOPESMALLSPLIT
SQRTSQRTPISTANDARDIZESTDEV.P
STDEV.SSTDEVASTDEVPSTDEVPA
STDEVSSTEYXSUBSTITUTESUBTOTAL
SUMSUMIFSUMIFSSUMPRODUCT
SUMSQSUMX2MY2SUMX2PY2SUMXMY2
SWITCHSYDTT.DIST
T.DIST.2TT.DIST.RTT.INVT.INV.2T
TANTANHTBILLEQTBILLPRICE
TBILLYIELDTDISTTDIST2TTDISTRT
TEXTTIMETIMEVALUETINV
TINV2TTODAYTRANSPOSETREND
TRIMTRIMMEANTRUETRUNC
UNICHARUNICODEUNIQUEUPPER
VALUEVAR.PVAR.SVARA
VARPVARPAVARSWEEKDAY
WEEKNUMWEIBULL.DISTWEIBULLDISTWORKDAY
XIRRXNPVXORYEAR
YEARFRAC