Expression Editor Functions - Logical Category
|
Function |
Description of Returned Value |
|---|---|
|
And |
Returns True if all the arguments have a logical value of True and returns False if at least one argument is False. Format: And(argument1, argument2, ...) |
|
False |
Returns the logical value for False. Format: False() |
|
If |
Specifies a logical test to perform. Format: If(condition, true_clause, false_clause) |
|
IsBlank |
Tests for blank or null values. Format: IsBlank(value) |
|
IsDate |
Tests whether a value is a date. Format: IsDate(value) |
|
IsErr |
Tests whether the value is an error. Format: IsErr(value) |
|
IsError |
Tests whether the value is a string that starts with #. Format: IsError(value) |
|
IsLogical |
Tests whether a value is of a logical type. Format: IsLogical(value) |
|
IsNA |
Tests whether the value is an #NA error value. Format: IsNA(value) |
|
IsNonText |
Tests whether the value is not a string of text. Format: IsNonText(Text) |
|
IsNumber |
Tests whether a value is a number. Format: IsNumber(value) Example: IF(ISNUMBER(GetPriceSeriesValueQP("AA Cu",MOS(2,0), "USD", "mt")), GetPriceSeriesValueQP("AA Cu",MOS(2,0), "USD", "mt"), 100) |
|
IsText |
Tests whether a value is text. Format: IsText(value) |
|
Not |
Reverses the value of its argument. Format: Not(argument) |
|
Or |
Returns True if any argument is True and returns False if all arguments are False. Format: Or(argument1, argument2, ...) |
|
True |
Returns the logical value for True. Format: True() |
