AppleWorks
J
__________________________________________________________________
AppleWorks 2.0 Spreadsheet @And and @Or
__________________________________________________________________
"@AND" and "@OR" test each value specified as an argument.  They 
require a list of 2 or more arguments.  They  are usually used 
with @IF.

Example:   @IF(@OR(A17>56,A18=0),.25,.333333).

 

@AND takes any number of arguments, each of which must be a 
logical value or a range of logical values.  Its value is 1 if all 
of the arguments are not 0; its value is 0 if any of the arguments 
are 0.

 

Syntax:  @AND(value:operand:value, value:operand:value)

 

Example:  @AND(A3>4,C5<4)

 

@OR takes any number of arguments, each of which must be a logical 
value or a range of logical values.  Its value is 1 if any of the 
values is not 0; its value is 0 if all of the values are 0.

 

Syntax:  @OR(value:operand:value, value:operand:value)

 

Example:  @OR(A3>4,C5<4)