Thursday 20 April 2017

Excel - Microsoft Excel 2013 XOR Function

Description

Returns a logical Exclusive Or of all arguments.
Syntax
XOR(logical1, [logical2],…)

The XOR function syntax has the following arguments.
  • Logical1, logical2,…    Logical 1 is required, subsequent logical values are optional. 1 to 254 conditions you want to test that can be either TRUE or FALSE, and can be logical values, arrays, or references.

Remarks

Example
The workbook below shows examples of this function. Inspect them, change existing formulas, or enter your own formulas to learn how the function works.

No comments:

Post a Comment