[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Collapse]Office File API
  Demo Application
  Redistribution and Deployment
 [Collapse]Spreadsheet Document API
   Product Structure
   Getting Started
  [Expand]Spreadsheet Document
   Supported Formats
  [Expand]Cell Basics
   Defined Names
   Data Binding
  [Expand]Pivot Tables
  [Expand]Charts and Graphics
  [Expand]Mail Merge
   [Expand]Rows and Columns
     How to: Use Constants and Calculation Operators in Formulas
     How to: Use Cell and Worksheet References in Formulas
     How to: Use Names in Formulas
     How to: Create Named Formulas
     How to: Use Functions and Nested Functions in Formulas
     How to: Create Shared Formulas
     How to: Create Array Formulas
   [Expand]Import and Export Data
   [Expand]Data Binding
   [Expand]Mail Merge
   [Expand]Formatting Cells
   [Expand]Conditional Formatting
   [Expand]Group Data
   [Expand]Filter Data
   [Expand]Pivot Tables
 [Expand]Word Processing Document API
 [Expand]PDF Document API
 [Expand]Excel Export Library
 [Expand]Snap Report API
 [Expand]Zip Compression and Archive API
 [Expand]Barcode Generation API
 [Expand]Unit Conversion API
 [Expand]API Reference
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

How to: Use Functions and Nested Functions in Formulas

This example demonstrates how to use predefined Functions in Formulas to perform simple or complex calculations over arguments. Set the Range.Formula property to a formula. Follow the rules below to create a formula that uses a function.

  1. Start a formula with the "=" sign, as you usually do when creating a formula.
  2. Type the function name.
  3. Type the function arguments in parentheses. Arguments can be numbers, text and logical values, cell references and names, or other functions.

The image below shows cells with formulas using different functions (the workbook is opened in Microsoft® Excel®).

Expanded See Also

Is this topic helpful?​​​​​​​