Functions

Functions Overview

• Spreadsheet.com Function List
• Introduction to Hierarchy Functions
• Introduction to Math Functions
• Introduction to Text Functions
• Introduction to Date and Time Functions
• Introduction to Logical Functions

See all 11 articles

Hierarchy functions

• ANCESTORCELLS
• CHILDCELLS
• DESCENDANTCELLS
• PARENTCELL

Math functions

• ABS
• ACOS
• ACOSH
• ACOT
• ACOTH
• ADD

See all 88 articles

Text functions

• ARABIC
• CHAR
• CLEAN
• CODE
• CONCAT
• CONCATENATE

See all 35 articles

Date and time functions

• DATE
• DATEDIF
• DATEVALUE
• DAY
• DAYS
• DAYS360

See all 26 articles

Logical functions

• AND
• FALSE
• IF
• IFERROR
• IFNA
• IFS

See all 11 articles

Information functions

• ISBINARY
• ISBLANK
• ISERR
• ISERROR
• ISEVEN
• ISFORMULA

See all 14 articles

Lookup functions

• CHOOSE
• COLUMN
• COLUMNS
• HLOOKUP
• HYPERLINK
• INDEX

See all 14 articles

Statistical functions

• AVEDEV
• AVERAGE
• AVERAGEA
• AVERAGEIF
• AVERAGEIFS
• BETA.DIST

See all 137 articles

Financial functions

• ACCRINT
• CUMIPMT
• CUMPRINC
• DB
• DDB
• DOLLARDE

See all 30 articles

Array functions

• ARGS2ARRAY
• ARRAYFORMULA
• ARRAY_CONSTRAIN
• FLATTEN
• FREQUENCY
• GROWTH

See all 14 articles

Engineering functions

• BESSELI
• BESSELJ
• BESSELK
• BESSELY
• BIN2DEC
• BIN2HEX

See all 52 articles