You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
352 lines
2.5 KiB
352 lines
2.5 KiB
4 years ago
|
ABS
|
||
|
ACCRINT
|
||
|
ACCRINTM
|
||
|
ACOS
|
||
|
ACOSH
|
||
|
ADDRESS
|
||
|
AMORDEGRC
|
||
|
AMORLINC
|
||
|
AND
|
||
|
AREAS
|
||
|
ASC
|
||
|
ASIN
|
||
|
ASINH
|
||
|
ATAN
|
||
|
ATAN2
|
||
|
ATANH
|
||
|
AVEDEV
|
||
|
AVERAGE
|
||
|
AVERAGEA
|
||
|
AVERAGEIF
|
||
|
AVERAGEIFS
|
||
|
BAHTTEXT
|
||
|
BESSELI
|
||
|
BESSELJ
|
||
|
BESSELK
|
||
|
BESSELY
|
||
|
BETADIST
|
||
|
BETAINV
|
||
|
BIN2DEC
|
||
|
BIN2HEX
|
||
|
BIN2OCT
|
||
|
BINOMDIST
|
||
|
CEILING
|
||
|
CELL
|
||
|
CHAR
|
||
|
CHIDIST
|
||
|
CHIINV
|
||
|
CHITEST
|
||
|
CHOOSE
|
||
|
CLEAN
|
||
|
CODE
|
||
|
COLUMN
|
||
|
COLUMNS
|
||
|
COMBIN
|
||
|
COMPLEX
|
||
|
CONCATENATE
|
||
|
CONFIDENCE
|
||
|
CONVERT
|
||
|
CORREL
|
||
|
COS
|
||
|
COSH
|
||
|
COUNT
|
||
|
COUNTA
|
||
|
COUNTBLANK
|
||
|
COUNTIF
|
||
|
COUNTIFS
|
||
|
COUPDAYBS
|
||
|
COUPDAYBS
|
||
|
COUPDAYSNC
|
||
|
COUPNCD
|
||
|
COUPNUM
|
||
|
COUPPCD
|
||
|
COVAR
|
||
|
CRITBINOM
|
||
|
CUBEKPIMEMBER
|
||
|
CUBEMEMBER
|
||
|
CUBEMEMBERPROPERTY
|
||
|
CUBERANKEDMEMBER
|
||
|
CUBESET
|
||
|
CUBESETCOUNT
|
||
|
CUBEVALUE
|
||
|
CUMIPMT
|
||
|
CUMPRINC
|
||
|
DATE
|
||
|
DATEDIF
|
||
|
DATEVALUE
|
||
|
DAVERAGE
|
||
|
DAY
|
||
|
DAYS360
|
||
|
DB
|
||
|
DCOUNT
|
||
|
DCOUNTA
|
||
|
DDB
|
||
|
DEC2BIN
|
||
|
DEC2HEX
|
||
|
DEC2OCT
|
||
|
DEGREES
|
||
|
DELTA
|
||
|
DEVSQ
|
||
|
DGET
|
||
|
DISC
|
||
|
DMAX
|
||
|
DMIN
|
||
|
DOLLAR
|
||
|
DOLLARDE
|
||
|
DOLLARFR
|
||
|
DPRODUCT
|
||
|
DSTDEV
|
||
|
DSTDEVP
|
||
|
DSUM
|
||
|
DURATION
|
||
|
DVAR
|
||
|
DVARP
|
||
|
EDATE
|
||
|
EFFECT
|
||
|
EOMONTH
|
||
|
ERF
|
||
|
ERFC
|
||
|
ERROR.TYPE
|
||
|
EVEN
|
||
|
EXACT
|
||
|
EXP
|
||
|
EXPONDIST
|
||
|
FACT
|
||
|
FACTDOUBLE
|
||
|
FALSE
|
||
|
FDIST
|
||
|
FIND
|
||
|
FINDB
|
||
|
FINV
|
||
|
FISHER
|
||
|
FISHERINV
|
||
|
FIXED
|
||
|
FLOOR
|
||
|
FORECAST
|
||
|
FREQUENCY
|
||
|
FTEST
|
||
|
FV
|
||
|
FVSCHEDULE
|
||
|
GAMAMDIST
|
||
|
GAMMAINV
|
||
|
GAMMALN
|
||
|
GCD
|
||
|
GEOMEAN
|
||
|
GESTEP
|
||
|
GETPIVOTDATA
|
||
|
GROWTH
|
||
|
HARMEAN
|
||
|
HEX2BIN
|
||
|
HEX2OCT
|
||
|
HLOOKUP
|
||
|
HOUR
|
||
|
HYPERLINK
|
||
|
HYPGEOMDIST
|
||
|
IF
|
||
|
IFERROR
|
||
|
IMABS
|
||
|
IMAGINARY
|
||
|
IMARGUMENT
|
||
|
IMCONJUGATE
|
||
|
IMCOS
|
||
|
IMEXP
|
||
|
IMLN
|
||
|
IMLOG10
|
||
|
IMLOG2
|
||
|
IMPOWER
|
||
|
IMPRODUCT
|
||
|
IMREAL
|
||
|
IMSIN
|
||
|
IMSQRT
|
||
|
IMSUB
|
||
|
IMSUM
|
||
|
INDEX
|
||
|
INDIRECT
|
||
|
INFO
|
||
|
INT
|
||
|
INTERCEPT
|
||
|
INTRATE
|
||
|
IPMT
|
||
|
IRR
|
||
|
ISBLANK
|
||
|
ISERR
|
||
|
ISERROR
|
||
|
ISEVEN
|
||
|
ISLOGICAL
|
||
|
ISNA
|
||
|
ISNONTEXT
|
||
|
ISNUMBER
|
||
|
ISODD
|
||
|
ISPMT
|
||
|
ISREF
|
||
|
ISTEXT
|
||
|
JIS
|
||
|
KURT
|
||
|
LARGE
|
||
|
LCM
|
||
|
LEFT
|
||
|
LEFTB
|
||
|
LEN
|
||
|
LENB
|
||
|
LINEST
|
||
|
LN
|
||
|
LOG
|
||
|
LOG10
|
||
|
LOGEST
|
||
|
LOGINV
|
||
|
LOGNORMDIST
|
||
|
LOOKUP
|
||
|
LOWER
|
||
|
MATCH
|
||
|
MAX
|
||
|
MAXA
|
||
|
MDETERM
|
||
|
MDURATION
|
||
|
MEDIAN
|
||
|
MID
|
||
|
MIDB
|
||
|
MIN
|
||
|
MINA
|
||
|
MINUTE
|
||
|
MINVERSE
|
||
|
MIRR
|
||
|
MMULT
|
||
|
MOD
|
||
|
MODE
|
||
|
MONTH
|
||
|
MROUND
|
||
|
MULTINOMIAL
|
||
|
N
|
||
|
NA
|
||
|
NEGBINOMDIST
|
||
|
NETWORKDAYS
|
||
|
NOMINAL
|
||
|
NORMDIST
|
||
|
NORMINV
|
||
|
NORMSDIST
|
||
|
NORMSINV
|
||
|
NOT
|
||
|
NOW
|
||
|
NPER
|
||
|
NPV
|
||
|
OCT2BIN
|
||
|
OCT2DEC
|
||
|
OCT2HEX
|
||
|
ODD
|
||
|
ODDFPRICE
|
||
|
ODDFYIELD
|
||
|
ODDLPRICE
|
||
|
ODDLYIELD
|
||
|
OFFSET
|
||
|
OR
|
||
|
PEARSON
|
||
|
PERCENTILE
|
||
|
PERCENTRANK
|
||
|
PERMUT
|
||
|
PHONETIC
|
||
|
PI
|
||
|
PMT
|
||
|
POISSON
|
||
|
POWER
|
||
|
PPMT
|
||
|
PRICE
|
||
|
PRICEDISC
|
||
|
PRICEMAT
|
||
|
PROB
|
||
|
PRODUCT
|
||
|
PROPER
|
||
|
PV
|
||
|
QUARTILE
|
||
|
QUOTIENT
|
||
|
RADIANS
|
||
|
RAND
|
||
|
RANDBETWEEN
|
||
|
RANK
|
||
|
RATE
|
||
|
RECEIVED
|
||
|
REPLACE
|
||
|
REPLACEB
|
||
|
REPT
|
||
|
RIGHT
|
||
|
RIGHTB
|
||
|
ROMAN
|
||
|
ROUND
|
||
|
ROUNDDOWN
|
||
|
ROUNDUP
|
||
|
ROW
|
||
|
ROWS
|
||
|
RSQ
|
||
|
RTD
|
||
|
SEARCH
|
||
|
SEARCHB
|
||
|
SECOND
|
||
|
SERIESSUM
|
||
|
SIGN
|
||
|
SIN
|
||
|
SINH
|
||
|
SKEW
|
||
|
SLN
|
||
|
SLOPE
|
||
|
SMALL
|
||
|
SQRT
|
||
|
SQRTPI
|
||
|
STANDARDIZE
|
||
|
STDEV
|
||
|
STDEVA
|
||
|
STDEVP
|
||
|
STDEVPA
|
||
|
STEYX
|
||
|
SUBSTITUTE
|
||
|
SUBTOTAL
|
||
|
SUM
|
||
|
SUMIF
|
||
|
SUMIFS
|
||
|
SUMPRODUCT
|
||
|
SUMSQ
|
||
|
SUMX2MY2
|
||
|
SUMX2PY2
|
||
|
SUMXMY2
|
||
|
SYD
|
||
|
T
|
||
|
TAN
|
||
|
TANH
|
||
|
TBILLEQ
|
||
|
TBILLPRICE
|
||
|
TBILLYIELD
|
||
|
TDIST
|
||
|
TEXT
|
||
|
TIME
|
||
|
TIMEVALUE
|
||
|
TINV
|
||
|
TODAY
|
||
|
TRANSPOSE
|
||
|
TREND
|
||
|
TRIM
|
||
|
TRIMMEAN
|
||
|
TRUE
|
||
|
TRUNC
|
||
|
TTEST
|
||
|
TYPE
|
||
|
UPPER
|
||
|
USDOLLAR
|
||
|
VALUE
|
||
|
VAR
|
||
|
VARA
|
||
|
VARP
|
||
|
VARPA
|
||
|
VDB
|
||
|
VERSION
|
||
|
VLOOKUP
|
||
|
WEEKDAY
|
||
|
WEEKNUM
|
||
|
WEIBULL
|
||
|
WORKDAY
|
||
|
XIRR
|
||
|
XNPV
|
||
|
YEAR
|
||
|
YEARFRAC
|
||
|
YIELD
|
||
|
YIELDDISC
|
||
|
YIELDMAT
|
||
|
ZTEST
|