Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[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
  [Expand]Spreadsheet Formulas
   Defined Names
   Data Binding
  [Expand]Pivot Tables
  [Expand]Mail Merge
  [Collapse]Examples
   [Expand]Files
   [Expand]Workbooks
   [Expand]Worksheets
   [Expand]Rows and Columns
   [Expand]Cells
   [Collapse]Formulas
     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
    Sorting
   [Expand]Mail Merge
    Search
   [Expand]Charts
   [Expand]Sparklines
   [Expand]Formatting Cells
   [Expand]Conditional Formatting
   [Expand]Grouping
   [Expand]Filtering
   [Expand]Tables
   [Expand]Pivot Tables
   [Expand]Printing
   [Expand]Pictures
   [Expand]Protection
 [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]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

How to: Use Functions and Nested Functions in Formulas

Show Me

A complete sample project is available in the DevExpress Code Examples database at http://www.devexpress.com/example=E4339.

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?​​​​​​​