Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Pivot Grid
  [Collapse]Spreadsheet
   [Expand]Product Information
    Getting Started
   [Collapse]Concepts
    [Expand]Spreadsheet Document
     Supported Formats
     Import and Export
    [Expand]Cell Basics
    [Collapse]Spreadsheet Formulas
     [Collapse]Functions
       Mathematical Functions
       Statistical Functions
       Date and Time Functions
       Text Functions
       Financial Functions
       Logical Functions
       Lookup and Reference Functions
       Engineering Functions
       Information Functions
       Compatibility Functions
       Database Functions
       Web Functions
       User-Defined Functions (UDF)
      Operators
      Array Formulas
     Defined Names
     Data Validation
    [Expand]Data Presentation
    [Expand]Charting
     Printing
    [Expand]Mail Merge
     Protection
     Adaptivity
     Keyboard Shortcuts
   [Expand]Visual Elements
  [Expand]Rich Text Editor
  [Expand]Scheduler
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Gauges
  [Expand]Vertical Grid
  [Expand]Data Editors
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Controls
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[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

Logical Functions

This document briefly describes logical functions implemented in the ASPxSpreadsheet.

Name

Description

Syntax

ANDReturns TRUE if all of its arguments are TRUE; returns FALSE if one or more arguments evaluate to FALSE.AND(logical1, [logical2], ...)
FALSEReturns the logical value FALSE.FALSE()
IFChecks a condition and returns one result if the condition is TRUE, and another result if the condition is FALSE.IF(logical_test, [value_if_true], [value_if_false])
IFERRORChecks whether or not a value (or expression) returns an error, and if so, the function returns a specified value; otherwise, the function returns the initial value.IFERROR(value, value_if_error)
IFNAChecks whether a value (or expression) resolves to #N/A, and if so the function returns a specified value; otherwise the function returns the initial value.IFNA(value, value_if_na)
NOTReverses the logical value of its argument.NOT(logical)
ORReturns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.OR(logical1, [logical2], ...)
TRUEReturns the logical value TRUE.TRUE()
XORReturns a logical exclusive OR of all arguments.XOR(logical1, [logical2],…)

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