Export (0) Print
Expand All
Expand Minimize

WorksheetFunction.Xor Method (Excel)

Office 2013

Returns a logical exclusive OR of all arguments.

Version Added: Excel 2013

expression .Xor(Arg1,Arg2,Arg3,Arg4,Arg5,Arg6,Arg7,Arg8,Arg9,Arg10,Arg11,Arg12,Arg13,Arg14,Arg15,Arg16,Arg17,Arg18,Arg19,Arg20,Arg21,Arg22,Arg23,Arg24,Arg25,Arg26,Arg27,Arg28,Arg29,Arg30)

expression A variable that represents a WorksheetFunction Object (Excel) object.

Parameters

Name

Required/Optional

Data type

Description

Arg1

Required

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg2

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg3

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg4

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg5

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg6

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg7

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg8

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg9

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg10

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg11

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg12

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg13

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg14

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg15

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg16

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg17

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg18

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg19

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg20

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg21

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg22

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg23

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg24

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg25

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg26

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg27

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg28

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg29

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Arg30

Optional

VARIANT

1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

Return value

BOOL

Show:
© 2014 Microsoft