Skip to main content
Spreadsheet.com Home
    ProductTemplatesCommunityPricingSign in
    Get started — it's free

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

OpenAI Integration functions

  • OPENAI_COMPLETE
Product
OverviewSheet ViewsGantt Chart ViewsKanban ViewsCalendar ViewsForm ViewsData TypesAttachmentsRelated RowsChartsReportsAutomationsIntegrationsPricingSign inSign up
Templates
All TemplatesProject ManagementSales & CRMProduct DevelopmentFinance & AccountingLists & ChecklistsHR & RecruitingSmall BusinessPersonalTeam CollaborationMarketingIT & SupportConstructionEducationReal EstateStartupsNonprofits
Resources
Help CenterVideosGuidesArticlesBlogProduct UpdatesCommunityDeveloper APINonprofit DiscountSchool DiscountFree for StudentsFree for TeachersSpreadsheet History
Compare
All Comparisonsvs Smartsheetvs Airtablevs Mondayvs Asanavs Wrikevs Microsoft Projectvs Microsoft Excelvs Google Sheetsvs Trellovs Jiravs Teamworkvs TeamGantt
Company
Customer StoriesAbout UsCareersTwitterFacebookYoutubeLinkedInContact Us
The spreadsheet you know with the power of a database, built-in project management, no-code automations, integrations, and real-time updates.

© 2023 Spreadsheet.com, Inc.

Security ⋅ Terms of use ⋅ Privacy policy
Monitored Badges