LibreOffice Calc — Function Directory

Browse 530 published, source-reviewed guides with syntax, reproducible examples and troubleshooting. This is not a complete inventory of all functions supported by LibreOffice Calc.

Find a function

530 functions

Browse by category

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

ABSThe ABS function in LibreOffice Calc returns the absolute value of a number. It removes the sign and always returns a …
ABSDBABSDB is not a documented native Calc function in the checked release. Use ABS for the absolute value of a number.
ACCRINTThe ACCRINT function returns the accrued interest for a security that pays periodic interest. It supports multiple day-count …
ACCRINTMThe ACCRINTM function returns the accrued interest for a security that pays interest only at maturity. It supports multiple …
ACOSThe ACOS function returns the arccosine (inverse cosine) of a number. The result is an angle expressed in radians, commonly …
ACOSHThe ACOSH function returns the inverse hyperbolic cosine of a number. The result is expressed in radians and is used in …
ACOTThe ACOT function returns the inverse cotangent (arccotangent) of a number. The result is expressed in radians and is used in …
ACOTHThe ACOTH function returns the inverse hyperbolic cotangent of a number. The result is expressed in radians and is used in …
ADDRESSThe ADDRESS function returns a cell reference as text, based on a given row and column number. It supports absolute, …
AGGREGATEThe AGGREGATE function in LibreOffice Calc performs advanced calculations such as SUM, AVERAGE, COUNT, MAX, MIN, and more, …
AMORDEGRCThe AMORDEGRC function returns the prorated depreciation for each accounting period using the French accounting system. It …
AMORLINCThe AMORLINC function returns the linear depreciation for each accounting period using the French accounting system. It …
ANDThe AND function in LibreOffice Calc evaluates multiple logical conditions and returns TRUE only when all conditions are …
ARABICConvert Roman numerals with LibreOffice ARABIC, including lowercase and simplified forms, empty-string zero, invalid-text …
AREASThe AREAS function returns the number of ranges (areas) in a reference. It is primarily used with multi-area references …
ASCThe ASC function converts full-width (double-byte) characters to half-width (single-byte) characters. It is primarily used …
ASINThe ASIN function returns the arcsine (inverse sine) of a number. The result is an angle expressed in radians, commonly used …
ASINHThe ASINH function returns the inverse hyperbolic sine of a number. The result is expressed in radians and is used in …
ATANThe ATAN function returns the arctangent (inverse tangent) of a number. The result is an angle expressed in radians and is …
ATAN2The ATAN2 function returns the arctangent of the specified X and Y coordinates, producing an angle in radians with full …
ATANHThe ATANH function returns the inverse hyperbolic tangent of a number. The result is expressed in radians and is used in …
AVEDEVLearn the AVEDEV function in LibreOffice Calc: Returns the average of the absolute deviations of a sample from the mean.
AVERAGEThe AVERAGE function in LibreOffice Calc calculates the arithmetic mean of numbers, ranges, or mixed arguments. This guide …
AVERAGEALearn the AVERAGEA function in LibreOffice Calc: Returns the average value for a sample. Text is evaluated as zero.
AVERAGEIFThe AVERAGEIF function in LibreOffice Calc calculates the average of values that meet a single condition. This guide explains …
AVERAGEIFSThe AVERAGEIFS function in LibreOffice Calc calculates the average of values that meet multiple conditions across one or more …

B

C

D

E

F

G

H

I

J

JISConvert ASCII and half-width katakana with LibreOffice JIS. See mixed-script examples, voiced katakana and the limits of …

K

KURTLearn the KURT function in LibreOffice Calc: Returns the kurtosis of a distribution.

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z