Menu
Gnumeric
LibreOffice
OpenOffice
🌙
LibreOffice Calc Functions
Browse 49 functions with syntax, examples, and troubleshooting.
Browse by Category
Math
Text
Date & Time
Logical
Lookup
Statistical
Financial
Database
Array
Information
Engineering
Conversion
Show all
Browse A–Z
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
A
AGGREGATE
AVERAGE
AVERAGEIF
AVERAGEIFS
C
CHISQ.TEST
CONFIDENCE.NORM
CONFIDENCE.T
CORREL
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
COVAR
COVARIANCE.P
COVARIANCE.S
F
F.TEST
FORECAST
FORECAST.LINEAR
FREQUENCY
G
GROWTH
I
INTERCEPT
L
LARGE
LINEST
LOGEST
M
MEDIAN
MODE
P
PEARSON
PERCENTILE.EXC
PERCENTILE.INC
PERCENTRANK.EXC
PERCENTRANK.INC
Q
QUARTILE.EXC
QUARTILE.INC
R
RANK
RANK.AVG
RANK.EQ
RSQ
S
SLOPE
SMALL
STANDARDIZE
STEYX
SUBTOTAL
SUM
SUMIF
SUMIFS
T
T.TEST
TREND
Z
Z.TEST
Copyright 2026. All rights reserved.