雷鸟365目前支持哪些公式?


雷鸟365目前支持以下多达451种公式


ABSACCRINTACCRINTM
ACOSACOSHACOT
ACOTHADDRESSAMORDEGRC
AMORLINCANDARABIC
AREASASINASINH
ATANATAN2ATANH
AVEDEVAVERAGEAVERAGEA
AVERAGEIFAVERAGEIFSBAHTTEXT
BASEBESSELIBESSELJ
BESSELKBESSELYBETADIST
BETA.DISTBETAINVBETA.INV
BIN2DECBIN2HEXBIN2OCT
BINOMDISTBINOM.DISTBINOM.DIST.RANGE
BINOM.INVBITANDBITLSHIFT
BITORBITRSHIFTBITXOR
CEILINGCEILING.MATHCEILING.PRECISE
CHARCHIDISTCHIINV
CHISQ.DISTCHISQ.DIST.RTCHISQ.INV
CHISQ.INV.RTCHISQ.TESTCHITEST
CHOOSECLEANCODE
COLUMNCOLUMNSCOMBIN
COMBINACOMPLEXCONCAT
CONCATENATECONFIDENCECONFIDENCE.NORM
CONFIDENCE.TCONVERTCORREL
COSCOSHCOT
COTHCOUNT COUNTA
COUNTBLANKCOUNTIFCOUNTIFS
COUPDAYBSCOUPDAYSCOUPDAYSNC
COUPNCDCOUPNUMCOUPPCD
COVARCOVARIANCE.PCOVARIANCE.S
CRITBINOMCSCCSCH
CUMIPMTCUMPRINC



DATEDATEDIFDATEVALUE
DAVERAGEDAYDAYS
DAYS360DBDCOUNT
DCOUNTADDBDEC2BIN
DEC2HEXDEC2OCTDECIMAL
DEGREESDELTADEVSQ
DGETDISCDMAX
DMINDOLLARDOLLARDE
DOLLARFRDPRODUCTDSTDEV
DSTDEVPDSUMDURATION
DVARDVARPEDATE
EFFECTENCODEURLEOMONTH
ERFERF.PRECISEERFC
ERFC.PRECISEERROR.TYPEEURO
EUROCONVERTEVENEXACT
EXPEXPONDISTEXPON.DIST



FACTFACTDOUBLEFALSE
FDISTF.DISTF.DIST.RT
FINDFINDBFINV
F.INVF.INV.RTFISHER
FISHERINVFIXEDFLOOR
FLOOR.MATHFLOOR.PRECISEFORECAST
FORMULATEXTFREQUENCYFTEST
F.TESTFVFVSCHEDULE
GAMMAGAMMADISTGAMMA.DIST
GAMMAINVGAMMA.INVGAMMALN
GAMMALN.PRECISEGAUSSGCD
GEOMEANGESTEPGROWTH
HARMEANHEX2BINHEX2DEC
HEX2OCTHLOOKUPHOUR
HYPERLINKHYPGEOMDIST HYPGEOM.DIST



IFIFERRORIFS
IFNAIMABSIMAGINARY
IMARGUMENTIMCONJUGATEIMCOS
IMDIVIMEXPIMLN
IMLOG2IMLOG10IMPOWER
IMPRODUCTIMREALIMCOSH
IMCOTIMCSCIMCSCH
IMSECIMSECHIMSIN
IMSINHIMSQRTIMSUB
IMSUMIMTANINDEX
INDIRECTINTINTERCEPT
INTRATEIPMTIRR
ISBLANKISERRISERROR
ISEVENISFORMULAISLOGICAL
ISNAISNONTEXTISNUMBER
ISO.CEILINGISODDISOWEEKNUM
ISPMTISREFISTEXT
KURTLARGELCM
LEFTLEFTBLEN
LENBLINESTLN
LOGLOG10LOGEST
LOGINVLOGNORMDISTLOGNORM.DIST
LOGNORM.INVLOOKUPLOWER



MATCHMAXMAXA
MAXIFSMDETERMMDURATION
MEDIANMIDMIDB
MINMINAMINIFS
MINUTEMINVERSEMIRR
MMULTMODMODE
MODE.MULTMODE.SNGLMONTH
MROUNDMULTINOMIALNEGBINOMDIST
NEGBINOM.DISTNNA
NETWORKDAYSNETWORKDAYS.INTLNOMINAL
NORMDISTNORM.DISTNORMINV
NORM.INVNORMSDISTNORM.S.DIST
NORMSINVNORM.S.INVNOT
NOWNPERNPV
OCT2BINOCT2DECOCT2HEX
ODDODDFPRICEODDFYIELD
ODDLPRICEODDLYIELDOFFSET
OROFFSET



PDURATIONPEARSONPERCENTILE
PERCENTILE.EXCPERCENTILE.INCPERCENTRANK
PERCENTRANK.EXCPERCENTRANK.INCPERMUT
PERMUTATIONAPHIPI
PMTPOISSONPOISSON.DIST
POWERPPMTPRICE
PRICEDISCPRICEMATPROB
PRODUCTPROPERPV
QUARTILEQUARTILE.EXCQUARTILE.INC
QUOTIENTRADIANSRAND
RANDBETWEENRANKRANK.AVG
RANK.EQRATERECEIVED
REFRESHREPLACEREPLACEB
REPTRIGHTRIGHTB
ROMANROUNDROUNDDOWN
ROUNDUPROWROWS
RRIRSQ



SEARCHSEARCHBSEC
SECHSECONDSERIESSUM
SIGNSINSINH
SKEWSKEW.PSLN
SLOPESMALLSQRT
SQRTPISTANDARDIZESTDEV
STDEVASTDEVPSTDEV.P
STDEVPASTDEV.SSTEYX
SUBSTITUTESUBTOTALSUM
SUMIFSUMIFSSUMPRODUCT
SUMSQSUMX2MY2SUMX2PY2
SUMXMY2SYDSWITCH
TTANTANH
TBILLEQTBILLPRICETBILLYIELD
TDISTT.DISTT.DIST.2T
T.DIST.RTTEXTTEXTJOIN
TIMETIMEVALUETINV
T.INVT.INV.2TTODAY
TRANSPOSETRENDTRIM
TRIMMEANTRUETRUNC
TTESTT.TESTTYPE



UPPERUNICHARUNICODE
VALUEVARVARA
VARPVAR.PVARPA
VAR.SVDBVLOOKUP
WEEKDAYWEEKNUMWEIBULL
WEIBULL.DISTWORKDAYWORKDAY.INTL
XIRRXNPVXOR
YEARYEARFRACYIELD
YIELDDISCYIELDMATZTEST
Z.TEST


官方微信群