How do I use BITXOR to flag when two warehouses have different inventory patterns?

Compare the on-hand values from two locations with BITXOR. If the result is 0, the quantities are identical in binary; any other result means they differ. Wrap it in IF() for readability: =IF(BITXOR(C2,C3)=0,"Match","Different") to mark mismatches in a summary column.

Why does BITXOR fail with negative numbers?

Bitwise operations are mathematically defined only for non-negative integers. Negative values trigger #NUM!. If your dataset includes negatives, use ABS() to convert them first, or filter them before applying BITXOR.

Can BITXOR work with prices like 29.99 or 45.67?

BITXOR truncates decimals to integers automatically; 29.99 becomes 29, losing precision. To preserve cents, multiply by 100 first (29.99 → 2999), apply BITXOR, then divide by 100: =BITXOR(E4*100,E5*100)/100.

What's the practical difference between BITXOR and XOR?

XOR() is a logical function that returns TRUE when inputs have different truth values (useful for boolean conditions). BITXOR() compares integers bit-by-bit and returns a numeric result (useful for encoded data). Choose XOR() for IF statements, BITXOR() for inventory or flag analysis.

BITXOR function

BITXOR compares the binary representations of two integers and returns a new integer whose bits show exactly where the inputs differ.

=BITXOR(number1, number2)

Generate a BITXOR formula

Describe what you need. The generator will reach for BITXOR where BITXOR is the right tool, and tell you when it is not.

Arguments

How BITXOR reads its arguments

Argument	Required	Description
number1	Required	A non-negative integer (or cell reference containing one); decimal values are silently truncated to whole numbers before the operation.
number2	Required	A non-negative integer (or cell reference containing one); decimal values are silently truncated to whole numbers before the operation.

Returns

Returns an integer representing the bitwise XOR (exclusive OR) of the two input numbers.

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Compare on-hand inventory between warehouse locations

SKU	Warehouse	On Hand	Reorder Point	Cost
P001	A	12	8	45
P001	B	15	8	45
P002	A	8	15	32
P002	B	8	15	29

=BITXOR(C2, C3)

Result: 7

Warehouse A holds 12 units of P001 (binary 1100), Warehouse B holds 15 (binary 1111). BITXOR returns 7 (binary 0111), showing which bit positions differ in inventory. This flags warehouses with significantly different stock levels at a glance.

2. Detect pricing discrepancies across warehouse locations

SKU	Warehouse	On Hand	Reorder Point	Cost
P001	A	12	8	45
P001	B	15	8	45
P002	A	8	15	32
P002	B	8	15	29

=BITXOR(E4, E5)

Result: 13

SKU P002 costs 32 at Warehouse A (binary 100000) and 29 at Warehouse B (binary 011101). BITXOR returns 13 (binary 001101), indicating which bits differ. A non-zero result signals a pricing mismatch requiring reconciliation between locations.

3. Compare reorder thresholds between SKUs to audit restocking policies

SKU	Warehouse	On Hand	Reorder Point	Cost
P001	A	12	8	45
P001	B	15	8	45
P002	A	8	15	32
P002	B	8	15	29

=BITXOR(D2, D4)

Result: 7

SKU P001 has reorder point 8 (binary 1000), SKU P002 has 15 (binary 1111). BITXOR yields 7 (binary 0111), showing policy variation. Use this to audit whether different product categories follow consistent restocking rules or if thresholds have drifted.

Common errors

Which BITXOR error are you seeing?

Error	Why it happens	How to fix it
#VALUE!	One or both arguments contain text, TRUE/FALSE values, or reference cells with non-numeric content instead of numbers.	Ensure both arguments are pure numbers or cell references containing only numeric values. Wrap text-as-numbers with VALUE(): =BITXOR(VALUE(A1), 15)
#NUM!	One or both arguments are negative integers or exceed the platform's supported range (typically –2,147,483,648 to 2,147,483,647); BITXOR does not support negatives.	Verify both numbers are non-negative integers. If you have negatives, convert with ABS(): =BITXOR(ABS(A1), ABS(B1)), or filter them out before calling BITXOR.
#NAME?	The function name is misspelled (e.g., BITXR, XORBIT) or BITXOR is not available in your spreadsheet version (older platforms lack bitwise functions).	Confirm the spelling is exactly BITXOR. If unavailable, check your platform's function library or use BITOR and BITAND in combination to simulate XOR behavior.

Tips and when to use something else

Decimal inputs are truncated silently; 32.99 becomes 32 before the XOR. Use ROUND() or INT() for explicit control if precision matters.
A BITXOR result of 0 means both numbers are identical in binary—a fast equality check for encoded flags or status codes.
Do not confuse BITXOR (bitwise operation returning a number) with XOR() (logical function returning TRUE/FALSE). Use XOR() for conditional statements, BITXOR() for bit-level data analysis.
BITXOR is specialized for technical and bit-flag scenarios; most business problems are solved faster with IF(), VLOOKUP, or XOR(). Reach for BITXOR only when working with encoded data or binary representations.

Related functions

BITANDBITAND returns the bitwise AND of two non-negative integers, useful for checking if both values share certain bits or permission flags.BITORReturns the bitwise OR of two numbers, combining all set bit positions from both values into a single numerical result.BITLSHIFTBITLSHIFT returns the bitwise left shift of a number by the specified amount, effectively multiplying by 2 raised to the shift amount.BITRSHIFTBITRSHIFT shifts a number's bits rightward by a specified amount, returning an integer and effectively dividing by powers of 2.DEC2BINConverts a decimal number to its binary representation, optionally padding the result with leading zeros to a specified width.

Frequently asked questions

How do I use BITXOR to flag when two warehouses have different inventory patterns?: Compare the on-hand values from two locations with BITXOR. If the result is 0, the quantities are identical in binary; any other result means they differ. Wrap it in IF() for readability: =IF(BITXOR(C2,C3)=0,"Match","Different") to mark mismatches in a summary column.
Why does BITXOR fail with negative numbers?: Bitwise operations are mathematically defined only for non-negative integers. Negative values trigger #NUM!. If your dataset includes negatives, use ABS() to convert them first, or filter them before applying BITXOR.
Can BITXOR work with prices like 29.99 or 45.67?: BITXOR truncates decimals to integers automatically; 29.99 becomes 29, losing precision. To preserve cents, multiply by 100 first (29.99 → 2999), apply BITXOR, then divide by 100: =BITXOR(E4*100,E5*100)/100.
What's the practical difference between BITXOR and XOR?: XOR() is a logical function that returns TRUE when inputs have different truth values (useful for boolean conditions). BITXOR() compares integers bit-by-bit and returns a numeric result (useful for encoded data). Choose XOR() for IF statements, BITXOR() for inventory or flag analysis.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17