附录 > Excel函数

除了以上常见的函数 , 还支持 Excel 中的各种计算函数 , 具体如下 :

•数学函数

abs(double)

acos(double)

acosh(double)

asin(double)

asinh(double)

atan(double)

atan2(double, double)

atanh(double)

ceiling(double, double)

combin(double, double)

cos(double)

cosh(double)

degrees(double)

even(double)

exp(double)

fact(double)

factdouble(double)

floor(double, double)

gcd(Object)

integer(double)

lcm(Object)

ln(double)

log(double, double)

log10(double)

mathProduct(Object)

mathSum(Object)

mathSumsq(Object)

mdeterm(Object)

mod(double, double)

mround(double, double)

multinomial(Object)

odd(double)

pi()

power(double, double)

quotient(double, double)

radians(double)

rand()

randbetween(int, int)

round(double, int)

rounddown(double, int)

roundup(double, int)

seriessum(double, double, double, Object)

sign(double)

sin(double)

sinh(double)

sqrt(double)

sqrtpi(double)

subtotal(int, Object)

sumif(Object, String, Object)

sumproduct(Object)

sumx2my2(Object, Object)

sumx2py2(Object, Object)

sumxmy2(Object, Object)

tan(double)

tanh(double)

trunc(double, int)

•日期函数

date(int, int, int)

datevalue(Object)

day(Object)

dayofyear(Object)

days360(Object, Object, Object)

edate(Object, int)

eomonth(Object, int)

hour(Object)

minute(Object)

month(Object)

monthname(Object)

networkdays(Object, Object, Object)

now()

quarter(Object)

second(Object)

time(int, int, int)

timevalue(Object)

today()

weekday(Object, Object)

weekdayname(Object)

weeknum(Object, Object)

workday(Object, int, Object)

year(Object)

yearfrac(Object, Object, Object)

•财务函数

accrint(Object, Object, Object, double, double, double, double)

accrintm(Object, Object, double, double, double)

amordegrc(double, Object, Object, double, int, double, int)

amorlinc(double, Object, Object, double, int, double, int)

coupdaybs(Object, Object, double, int)

coupdays(Object, Object, double, double)

coupdaysnc(Object, Object, double, double)

coupncd(Object, Object, double, double)

coupnum(Object, Object, double, double)

couppcd(Object, Object, double, double)

cumipmt(double, int, double, double, double, int)

cumprinc(double, int, double, double, double, int)

ddb(double, double, double, double, double)

disc(Object, Object, double, double, double)

duration(Object, Object, double, double, double, double)

effect(double, double)

financialDb(double, double, double, double, double)

fv(double, int, double, double, int)

fvschedule(double, Object)

intrate(Object, Object, double, double, double)

ipmt(double, int, int, double, double, int)

ispmt(double, int, int, double)

mduration(Object, Object, double, double, double, double)

mirr(Object, double, double)

nominal(double, double)

nper(double, double, double, double, int)

npv(double, Object)

pmt(double, int, double, double, int)

ppmt(double, int, int, double, double, int)

price(Object, Object, double, double, double, double, int)

pricedisc(Object, Object, double, double, double)

pricemat(Object, Object, Object, double, double, double)

pv(double, int, double, double, int)

received(Object, Object, double, double, double)

sln(double, double, int)

syd(double, double, double, double)

tbilleq(Object, Object, double)

tbillprice(Object, Object, double)

tbillyield(Object, Object, double)

vdb(double, double, double, double, double, double, boolean)

xnpv(double, Object, Object)

yielddisc(Object, Object, double, double, double)

yieldmat(Object, Object, Object, double, double, double)

•逻辑函数

and(Object, Object, Object, Object)

iif(Object, Object, Object)

not(Object)

or(Object, Object, Object, Object)

•统计函数

avedev(Object)

average(Object)

averagea(Object)

averageif(Object, String, Object)

binomdist(double, double, double, boolean)

correl(Object, Object)

counta(Object)

countblank(Object)

countdistinct(Object)

countif(Object, String)

countn(Object)

covariance(Object, Object)

devsq(Object)

expondist(double, double, boolean)

fisher(double)

fisherinv(double)

forecast(double, Object, Object)

frequency(Object, Object)

geomean(Object)

harmean(Object)

hypgeomdist(double, double, double, double, boolean)

intercept(Object, Object)

kurt(Object)

large(Object, int)

maxa(Object)

mina(Object)

negbinomdist(double, double, double)

pearson(Object, Object)

percentile(Object, double)

percentrank(Object, double, double)

permut(double, double)

poisson(double, double, boolean)

prob(Object, Object, double, double)

rank(double, Object, double)

rsq(Object, Object)

skew(Object)

slope(Object, Object)

small(Object, int)

standardize(double, double, double)

statisticCount(Object)

statisticMax(Object)

statisticMedian(Object)

statisticMin(Object)

statisticMode(Object)

statisticQuartile(Object, double)

stdev(Object)

stdeva(Object)

stdevp(Object)

stdevpa(Object)

steyx(Object, Object)

trimmean(Object, double)

vara(Object)

varn(Object)

varp(Object)

varpa(Object)

weibull(double, double, double, boolean)

weightedavg(Object, Object)

•文本函数

character(int)

code(String)

concatenate(Object)

currency(double, int)

dollar(double, int)

exact(String, String)

find(String, String, int)

fixed(double, int, boolean)

left(String, int)

len(String)

lower(String)

mid(String, int, int)

proper(String)

replace(String, int, int, String)

rept(String, int)

right(String, int)

search(String, String, int)