\PhpOffice\PhpSpreadsheet\Calculation\LogicalOperations

Summary

Methods
Properties
Constants
logicalAnd()
logicalOr()
logicalXor()
NOT()
No public properties found
No constants found
No protected methods found
No protected properties found
N/A
countTrueValues()
No private properties found
N/A

Methods

logicalAnd()

logicalAnd(mixed  ...$args) : bool|string

LOGICAL_AND.

Returns boolean TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE.

Excel Function: =AND(logical1[,logical2[, ...]])

   The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be arrays
       or references that contain logical values.

   Boolean arguments are treated as True or False as appropriate
   Integer or floating point arguments are treated as True, except for 0 or 0.0 which are False
   If any argument value is a string, or a Null, the function returns a #VALUE! error, unless the string
       holds the value TRUE or FALSE, in which case it is evaluated as the corresponding boolean value

Parameters

mixed $args variadic

Data values

Returns

bool|string —

the logical AND of the arguments

logicalOr()

logicalOr(mixed  ...$args) : bool|string

LOGICAL_OR.

Returns boolean TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.

Excel Function: =OR(logical1[,logical2[, ...]])

   The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be arrays
       or references that contain logical values.

   Boolean arguments are treated as True or False as appropriate
   Integer or floating point arguments are treated as True, except for 0 or 0.0 which are False
   If any argument value is a string, or a Null, the function returns a #VALUE! error, unless the string
       holds the value TRUE or FALSE, in which case it is evaluated as the corresponding boolean value

Parameters

mixed $args variadic

Data values

Returns

bool|string —

the logical OR of the arguments

logicalXor()

logicalXor(mixed  ...$args) : bool|string

LOGICAL_XOR.

Returns the Exclusive Or logical operation for one or more supplied conditions. i.e. the Xor function returns TRUE if an odd number of the supplied conditions evaluate to TRUE, and FALSE otherwise.

Excel Function: =XOR(logical1[,logical2[, ...]])

   The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be arrays
       or references that contain logical values.

   Boolean arguments are treated as True or False as appropriate
   Integer or floating point arguments are treated as True, except for 0 or 0.0 which are False
   If any argument value is a string, or a Null, the function returns a #VALUE! error, unless the string
       holds the value TRUE or FALSE, in which case it is evaluated as the corresponding boolean value

Parameters

mixed $args variadic

Data values

Returns

bool|string —

the logical XOR of the arguments

NOT()

NOT(mixed  $logical = false) : bool|string

NOT.

Returns the boolean inverse of the argument.

Excel Function: =NOT(logical)

   The argument must evaluate to a logical value such as TRUE or FALSE

   Boolean arguments are treated as True or False as appropriate
   Integer or floating point arguments are treated as True, except for 0 or 0.0 which are False
   If any argument value is a string, or a Null, the function returns a #VALUE! error, unless the string
       holds the value TRUE or FALSE, in which case it is evaluated as the corresponding boolean value

Parameters

mixed $logical

A value or expression that can be evaluated to TRUE or FALSE

Returns

bool|string —

the boolean inverse of the argument

countTrueValues()

countTrueValues(array  $args) : int|string

Parameters

array $args

Returns

int|string —