Gnumeric Sheet Functions

Gnumeric currently has 621 functions for use in spreadsheets. 221 of these are unique to Gnumeric.

Bitwise Operations

Complex

Database

Date/Time

Engineering

Erlang

Finance

FunctionImplementationTesting
accrint Complete Basic
accrintm Complete Basic
amordegrc Complete Basic
amorlinc Complete Basic
coupdaybs Complete Basic
coupdays Complete Basic
coupdaysnc Complete Basic
coupncd Complete Basic
coupnum Complete Basic
couppcd Complete Basic
cum_biv_norm_dist Unique to Gnumeric No Testsuite
cumipmt Complete Basic
cumprinc Complete Basic
db Complete Basic
ddb Complete Basic
disc Complete Basic
dollarde Complete Basic
dollarfr Complete Basic
duration Complete Basic
effect Complete Basic
euro Unique to Gnumeric Basic
euroconvert Complete Basic
fv Complete Basic
fvschedule Complete Basic
g_duration Unique to Gnumeric Basic
intrate Complete Basic
ipmt Complete Basic
irr Complete Basic
ispmt Complete Basic
mduration Complete Basic
mirr Complete Basic
nominal Complete Basic
nper Complete Basic
npv Complete Basic
oddfprice Complete Basic
oddfyield Complete Basic
oddlprice Complete Basic
oddlyield Complete Basic
opt_2_asset_correlation Unique to Gnumeric Basic
opt_amer_exchange Unique to Gnumeric Basic
opt_baw_amer Unique to Gnumeric Basic
opt_binomial Unique to Gnumeric Basic
opt_bjer_stens Unique to Gnumeric Basic
opt_bs Unique to Gnumeric Basic
opt_bs_carrycost Unique to Gnumeric Basic
opt_bs_delta Unique to Gnumeric Basic
opt_bs_gamma Unique to Gnumeric Basic
opt_bs_rho Unique to Gnumeric Basic
opt_bs_theta Unique to Gnumeric Basic
opt_bs_vega Unique to Gnumeric Basic
opt_complex_chooser Unique to Gnumeric Basic
opt_euro_exchange Unique to Gnumeric Basic
opt_exec Unique to Gnumeric Basic
opt_extendible_writer Unique to Gnumeric Basic
opt_fixed_strk_lkbk Unique to Gnumeric Basic
opt_float_strk_lkbk Unique to Gnumeric Basic
opt_forward_start Unique to Gnumeric Basic
opt_french Unique to Gnumeric Basic
opt_garman_kohlhagen Unique to Gnumeric Basic
opt_jump_diff Unique to Gnumeric Basic
opt_miltersen_schwartz Unique to Gnumeric Basic
opt_on_options Unique to Gnumeric Basic
opt_rgw Unique to Gnumeric Basic
opt_simple_chooser Unique to Gnumeric Basic
opt_spread_approx Unique to Gnumeric Basic
opt_time_switch Unique to Gnumeric Basic
pmt Complete Basic
ppmt Complete Basic
price Complete Basic
pricedisc Complete Basic
pricemat Complete Basic
pv Complete Basic
rate Complete Basic
received Complete Basic
rri Complete No Testsuite
sln Complete Basic
syd Complete Basic
tbilleq Complete Basic
tbillprice Complete Basic
tbillyield Complete Basic
vdb Complete Basic
xirr Complete Basic
xnpv Complete Basic
yield Complete Basic
yielddisc Complete Basic
yieldmat Complete Basic

Gnumeric

FunctionImplementationTesting
gnumeric_version Unique to Gnumeric Exhaustive

Information

Logic

Lookup

Mathematics

FunctionImplementationTesting
abs Complete Exhaustive
acos Complete Exhaustive
acosh Complete Exhaustive
acot Complete No Testsuite
acoth Complete No Testsuite
agm Unique to Gnumeric Exhaustive
arabic Complete No Testsuite
asin Complete Exhaustive
asinh Complete Exhaustive
atan Complete Exhaustive
atan2 Complete Exhaustive
atanh Complete Exhaustive
averageif Complete No Testsuite
beta Unique to Gnumeric Exhaustive
betaln Unique to Gnumeric No Testsuite
ceil Unique to Gnumeric No Testsuite
ceiling Complete Basic
cholesky Unique to Gnumeric No Testsuite
combin Complete Exhaustive
combina Complete No Testsuite
cos Complete Exhaustive
cosh Complete Exhaustive
cospi Unique to Gnumeric Exhaustive
cot Complete No Testsuite
coth Complete No Testsuite
cotpi Complete No Testsuite
countif Complete Basic
csc Unique to Gnumeric No Testsuite
csch Unique to Gnumeric No Testsuite
degrees Complete Exhaustive
eigen Unique to Gnumeric No Testsuite
even Complete Basic
exp Complete Exhaustive
expm1 Unique to Gnumeric Exhaustive
fact Superset Exhaustive
factdouble Complete Exhaustive
fib Complete Basic
floor Complete Basic
g_product Complete Basic
gamma Unique to Gnumeric Exhaustive
gammaln Complete Basic
gcd Complete Basic
gd Complete Basic
hypot Unique to Gnumeric No Testsuite
igamma Unique to Gnumeric No Testsuite
int Complete Basic
lcm Complete Basic
linsolve Unique to Gnumeric No Testsuite
ln Complete Exhaustive
ln1p Unique to Gnumeric Exhaustive
log Complete Exhaustive
log10 Complete Exhaustive
log2 Complete Exhaustive
mdeterm Complete Basic
minverse Complete Basic
mmult Complete Basic
mod Complete Basic
mpseudoinverse Unique to Gnumeric No Testsuite
mround Complete Basic
multinomial Complete Basic
munit Complete No Testsuite
odd Complete Basic
odf.sumproduct Complete No Testsuite
pi Complete Exhaustive
pochhammer Unique to Gnumeric Exhaustive
power Superset Exhaustive
product Complete Basic
quotient Complete Basic
radians Complete Exhaustive
roman Complete Basic
round Complete Basic
rounddown Complete Basic
roundup Complete Basic
sec Unique to Gnumeric No Testsuite
sech Unique to Gnumeric No Testsuite
seriessum Complete Basic
sign Complete Basic
sin Complete Exhaustive
sinh Complete Exhaustive
sinpi Unique to Gnumeric Exhaustive
sqrt Complete Exhaustive
sqrtpi Complete Basic
sum Complete Basic
suma Complete Basic
sumif Complete Basic
sumproduct Complete Basic
sumsq Complete Basic
sumx2my2 Complete Basic
sumx2py2 Complete Basic
sumxmy2 Complete Basic
tan Complete Exhaustive
tanh Complete Exhaustive
tanpi Complete Exhaustive
trunc Complete Basic

Number Theory

Random Numbers

Statistics

FunctionImplementationTesting
adtest Unique to Gnumeric No Testsuite
avedev Complete Basic
average Complete Basic
averagea Complete Basic
bernoulli Complete Basic
beta.dist Complete Basic
betadist Complete Basic
betainv Complete Basic
binom.dist.range Unique to Gnumeric No Testsuite
binomdist Complete Basic
cauchy Complete Basic
chidist Complete Basic
chiinv Complete Basic
chitest Complete Basic
confidence Complete Basic
confidence.t Complete No Testsuite
correl Complete Basic
count Complete Basic
counta Complete Basic
covar Complete Basic
covariance.s Complete Basic
critbinom Complete Basic
cronbach Unique to Gnumeric No Testsuite
cvmtest Unique to Gnumeric No Testsuite
devsq Complete Basic
expondist Complete Basic
exppowdist Unique to Gnumeric No Testsuite
fdist Complete Basic
finv Complete Basic
fisher Complete Basic
fisherinv Complete Basic
forecast Complete Basic
frequency Complete Basic
ftest Complete Basic
gammadist Complete Basic
gammainv Complete Basic
geomdist Unique to Gnumeric No Testsuite
geomean Complete Basic
growth Complete Basic
harmean Complete Basic
hypgeomdist Complete Basic
intercept Complete Basic
kurt Complete Basic
kurtp Unique to Gnumeric No Testsuite
landau Unique to Gnumeric No Testsuite
laplace Unique to Gnumeric No Testsuite
large Complete Basic
leverage Unique to Gnumeric No Testsuite
linest Complete Basic
lkstest Unique to Gnumeric No Testsuite
logest Complete Basic
logfit Unique to Gnumeric No Testsuite
loginv Complete Basic
logistic Unique to Gnumeric No Testsuite
lognormdist Complete Basic
logreg Unique to Gnumeric No Testsuite
max Complete Basic
maxa Complete Basic
median Complete Basic
min Complete Basic
mina Complete Basic
mode Complete Basic
mode.mult Complete No Testsuite
negbinomdist Complete Basic
normdist Complete Basic
norminv Complete Basic
normsdist Complete Basic
normsinv Complete Basic
owent Unique to Gnumeric Exhaustive
pareto Unique to Gnumeric No Testsuite
pearson Complete Basic
percentile Complete Basic
percentile.exc Complete No Testsuite
percentrank Complete Basic
percentrank.exc Complete No Testsuite
permut Complete Basic
permutationa Complete No Testsuite
poisson Complete Basic
prob Complete Basic
quartile Complete Basic
quartile.exc Complete No Testsuite
r.dbeta Unique to Gnumeric Exhaustive
r.dbinom Unique to Gnumeric Exhaustive
r.dcauchy Unique to Gnumeric Exhaustive
r.dchisq Unique to Gnumeric Exhaustive
r.dexp Unique to Gnumeric Exhaustive
r.df Unique to Gnumeric Exhaustive
r.dgamma Unique to Gnumeric Exhaustive
r.dgeom Unique to Gnumeric No Testsuite
r.dgumbel Unique to Gnumeric No Testsuite
r.dhyper Unique to Gnumeric Exhaustive
r.dlnorm Unique to Gnumeric Exhaustive
r.dnbinom Unique to Gnumeric Exhaustive
r.dnorm Unique to Gnumeric Exhaustive
r.dpois Unique to Gnumeric Exhaustive
r.drayleigh Unique to Gnumeric No Testsuite
r.dsnorm Unique to Gnumeric No Testsuite
r.dst Unique to Gnumeric No Testsuite
r.dt Unique to Gnumeric Exhaustive
r.dweibull Unique to Gnumeric Exhaustive
r.pbeta Unique to Gnumeric Exhaustive
r.pbinom Unique to Gnumeric Exhaustive
r.pcauchy Unique to Gnumeric Exhaustive
r.pchisq Unique to Gnumeric Exhaustive
r.pexp Unique to Gnumeric Exhaustive
r.pf Unique to Gnumeric Exhaustive
r.pgamma Unique to Gnumeric Exhaustive
r.pgeom Unique to Gnumeric Exhaustive
r.pgumbel Unique to Gnumeric No Testsuite
r.phyper Unique to Gnumeric Exhaustive
r.plnorm Unique to Gnumeric Exhaustive
r.pnbinom Unique to Gnumeric Exhaustive
r.pnorm Unique to Gnumeric Exhaustive
r.ppois Unique to Gnumeric Exhaustive
r.prayleigh Unique to Gnumeric No Testsuite
r.psnorm Unique to Gnumeric No Testsuite
r.pst Unique to Gnumeric No Testsuite
r.pt Unique to Gnumeric Exhaustive
r.ptukey Unique to Gnumeric No Testsuite
r.pweibull Unique to Gnumeric Exhaustive
r.qbeta Unique to Gnumeric Exhaustive
r.qbinom Unique to Gnumeric No Testsuite
r.qcauchy Unique to Gnumeric Exhaustive
r.qchisq Unique to Gnumeric Exhaustive
r.qexp Unique to Gnumeric Exhaustive
r.qf Unique to Gnumeric Exhaustive
r.qgamma Unique to Gnumeric Exhaustive
r.qgeom Unique to Gnumeric No Testsuite
r.qgumbel Unique to Gnumeric No Testsuite
r.qhyper Unique to Gnumeric No Testsuite
r.qlnorm Unique to Gnumeric Exhaustive
r.qnbinom Unique to Gnumeric No Testsuite
r.qnorm Unique to Gnumeric Exhaustive
r.qpois Unique to Gnumeric No Testsuite
r.qrayleigh Unique to Gnumeric No Testsuite
r.qsnorm Unique to Gnumeric No Testsuite
r.qst Unique to Gnumeric No Testsuite
r.qt Unique to Gnumeric Exhaustive
r.qtukey Unique to Gnumeric No Testsuite
r.qweibull Unique to Gnumeric Exhaustive
rank Complete Basic
rank.avg Complete No Testsuite
rayleigh Unique to Gnumeric No Testsuite
rayleightail Unique to Gnumeric No Testsuite
rsq Complete Basic
sftest Unique to Gnumeric No Testsuite
skew Complete Basic
skewp Unique to Gnumeric No Testsuite
slope Complete Basic
small Complete Basic
snorm.dist.range Unique to Gnumeric No Testsuite
ssmedian Unique to Gnumeric No Testsuite
standardize Complete Basic
stdev Complete Basic
stdeva Complete Basic
stdevp Complete Basic
stdevpa Complete Basic
steyx Complete Basic
subtotal Complete Basic
tdist Complete Basic
tinv Complete Basic
trend Complete Basic
trimmean Complete Basic
ttest Complete Basic
var Complete Basic
vara Complete Basic
varp Complete Basic
varpa Complete Basic
weibull Complete Basic
ztest Complete Basic

String

Time Series Analysis