Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Collapse]Spreadsheet
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [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)
      Real Time Data (RTD) function
     Operators
     Array Formulas
     Calculation
     Formula Engine
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
    Printing
    Events
   [Expand]Mail Merge Overview
    Protection
    Find and Replace
   [Expand]Visual Elements
    Services
   [Expand]Shortcuts
   [Expand]Examples
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Logical Functions

This document briefly describes logical functions implemented in the XtraSpreadsheet.

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],…)

How would you rate this topic?​​​​​​​