ISDEFINED function

  • 21 December 2021
  • 0 replies
  • 1072 views

​​​Description

Returns TRUE if the given Value is defined, BLANK otherwise.
 

Note: This function is similar to the function ISNOTBLANK. However it returns BLANK values instead of FALSE, which means that any cells equal to FALSE remain unpopulated. The result is sparse, which means less data, and also less time required to write the result in the database. This prevents max cardinality and timeout errors.

 

Syntax

 

ISDEFINED(Value)

 

Arguments

Argument Type Dimensions Description

Value

(required)

Any Any  

 

Returns

Type Dimensions
Boolean Dimensions of argument Value

 

Examples

Formula Result Description
ISDEFINED(1) TRUE 1 is not BLANK
ISDEFINED(BLANK) BLANK  

 

See also

Excel: IS

Related articles: ISBLANK, IFBLANK, IF, ISNOTBLANK

 

More of a hands-on learner? 

Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace.  It includes examples of every formula and modifier in Pigment!

 

 


This topic has been closed for comments