XOR
Returns the logical - Exclusive Or value of all arguments. The function returns - true when the number of - true inputs is odd and - false when the number of - true inputs is even.
Syntax
expression.XOR(args);
expression - A variable that represents a ApiWorksheetFunction class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| args | Required | ApiRange | ApiName | boolean | boolean[] | The conditions to check. |
Returns
boolean
Example
Perform an exclusive OR operation on multiple logical values in a spreadsheet.
// How do I test whether an odd number of conditions are true in a spreadsheet?
// Determine if exactly one or an odd number of values are true in a spreadsheet.
const worksheet = Api.GetActiveSheet();
let func = Api.WorksheetFunction;
let ans = func.TRUE(); //returns TRUE, doesnt require arguments
worksheet.GetRange("A1").SetValue(ans);