<< Click to Display Table of Contents >> Current:  Appendix  Excel function

In addition to the above common functions, various calculation functions in Excel are also supported, as follows:

 

•Mathematical Functions

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 Functions

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)

 

•Financial Functions

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)

 

•Logical Functions

and(Object, Object, Object, Object) 

iif(Object, Object, Object) 

not(Object)

or(Object, Object, Object, Object)

 

•Statistical Functions

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)

 

•Text Functions

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)