This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

 
Home
4D v19
4D View Pro Reference
4D View Pro Formulas
AND

AND 


 

AND ( logicalValue {, logicalValue2 , ... , logicalValueN} ) 
Parameter Type   Description
logicalValue  Boolean, Number, Expression in Value(s) to evaluate

The AND function returns TRUE if all arguments are true; otherwise, it returns FALSE if at least one argument is false.

It accepts boolean values as numeric (0 or 1) or logical expressions (TRUE or FALSE) for up to 255 arguments. You can also specify a single array instead of listing the values separately, or up to 255 arrays. You can also specify the logicalValue as an expression.

Example  

 

AND(D12,E12)  //True if D12 and E12 cell values are true or 1, False otherwise

AND(D2:D12)  //True if D12 to D12 cell values are true or 1, False otherwise

AND(5+3=8,5+1=6) //TRUE

AND(1,TRUE) //TRUE



See also 

NOT
OR

Previous page
Next page

 
PROPERTIES 

Product: 4D
Theme: 4D View Pro Formulas

 
PAGE CONTENTS 
Description
Example
 
HISTORY 

 
ARTICLE USAGE

4D View Pro Reference ( 4D v19)