Logical Spreadsheet Functions

Logical Spreadsheet Functions

All of the arguments of these functions (x, y, z, s, and w) are expressions. Series and array subranges are allowed in any argument requiring a series or array (without subscripts).

DPL Excel Action
xland(x,y,z,...)AND(x,y,z,...) The logical value 1 if all arguments are true (not 0). The logical value 0 if one or more arguments is false (0).
@falseFALSE( ) The logical value 0. Does not take arguments or parentheses.
@if(z,x,y)IF(z,y,x) x if z is true (not 0), and y if z is false (0). If the first argument equals 0 exactly, the function equals y. Otherwise it equals x. For example, @if(0.0,x,y) and @if(5-5,x,y) both equal y, but @if(0.0000001,x,y) equals x. Usually the first argument of @if( ) is a number produced by the logical operators. The @if function is equivalent to the conditional operator (? :).
xlor(x,y,z,...)OR(x,y,z,...) The logical value 1 if one or more arguments is true (not 0). The logical value 0 if all arguments are false (0).
@trueTRUE( ) The logical value 1. Does not take arguments or parentheses.

Notes: This information is subject to change. New functions are added from time to time. Contact technical support for the latest compatibility information.

Versions: DPL Professional, DPL Enterprise, DPL Portfolio

See Also

Spreadsheet Functions