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
Return 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 in a spreadsheet.
// How to return the logical Exclusive Or value of all arguments in a spreadsheet.
// Use a function to calculate Exclusive Or 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);