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). |
| @false | FALSE( ) | 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). |
| @true | TRUE( ) | 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