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]Document Server
  Product Information
 [Expand]Redistribution and Deployment
 [Collapse]Spreadsheet Document Server
   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]XL Export Library
 [Expand]Rich Edit Document Server
 [Expand]Snap Document Server
 [Expand]PDF Document Processor
 [Expand]Compression Library
 [Expand]Bar Code Library
 [Expand]Unit Conversion Library
 [Expand]API Reference
[Expand]Reporting
[Expand]Report 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?​​​​​​​