Remember Me?

#1
July 21st 09, 07:01 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2009 Posts: 1
Looking for BOOLEAN ALGEBRA functions (specifically XOR)

I am looking for BOOLEAN Algebra Functions. Can't find any help in EXCEL.
While I can work around the OR, AND, and NOT, I need XOR.

#2
July 21st 09, 07:27 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 11,501
Looking for BOOLEAN ALGEBRA functions (specifically XOR)

Hi,

Excel doesn't have it but you can write your own quite simply

=IF(COUNTIF(A1:B1,"Some Value")=1,TRUE,FALSE)

Mike

"RL Jones" wrote:

I am looking for BOOLEAN Algebra Functions. Can't find any help in EXCEL.
While I can work around the OR, AND, and NOT, I need XOR.

#3
July 21st 09, 07:27 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Aug 2008 Posts: 5,934
Looking for BOOLEAN ALGEBRA functions (specifically XOR)

I'm pretty sure this is it...

=OR(AND(A1,NOT(B1)),AND(NOT(A1),B1))

--
Rick (MVP - Excel)

"RL Jones" <RL wrote in message
...
I am looking for BOOLEAN Algebra Functions. Can't find any help in EXCEL.
While I can work around the OR, AND, and NOT, I need XOR.

#4
July 21st 09, 08:08 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 11,501
Looking for BOOLEAN ALGEBRA functions (specifically XOR)

Rick,

Can be abbreviated to:-

=(A1<0)+(B1<0)=1

and it also works if both cells are blank.

Mike

"Rick Rothstein" wrote:

I'm pretty sure this is it...

=OR(AND(A1,NOT(B1)),AND(NOT(A1),B1))

--
Rick (MVP - Excel)

"RL Jones" <RL wrote in message
...
I am looking for BOOLEAN Algebra Functions. Can't find any help in EXCEL.
While I can work around the OR, AND, and NOT, I need XOR.

#5
July 21st 09, 08:20 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Aug 2008 Posts: 5,934
Looking for BOOLEAN ALGEBRA functions (specifically XOR)

Ah, yes... very good. And I guess that could be written this way as well...

=NOT(A1)+NOT(B1)=1

--
Rick (MVP - Excel)

"Mike H" wrote in message
...
Rick,

Can be abbreviated to:-

=(A1<0)+(B1<0)=1

and it also works if both cells are blank.

Mike

"Rick Rothstein" wrote:

I'm pretty sure this is it...

=OR(AND(A1,NOT(B1)),AND(NOT(A1),B1))

--
Rick (MVP - Excel)

"RL Jones" <RL wrote in message
...
I am looking for BOOLEAN Algebra Functions. Can't find any help in
EXCEL.
While I can work around the OR, AND, and NOT, I need XOR.

#6
July 21st 09, 08:33 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 11,501
Looking for BOOLEAN ALGEBRA functions (specifically XOR)

Yes it could and until Excel include

=XOR(A1,B1) then they are as short as it gets.

Mike

"Rick Rothstein" wrote:

Ah, yes... very good. And I guess that could be written this way as well...

=NOT(A1)+NOT(B1)=1

--
Rick (MVP - Excel)

"Mike H" wrote in message
...
Rick,

Can be abbreviated to:-

=(A1<0)+(B1<0)=1

and it also works if both cells are blank.

Mike

"Rick Rothstein" wrote:

I'm pretty sure this is it...

=OR(AND(A1,NOT(B1)),AND(NOT(A1),B1))

--
Rick (MVP - Excel)

"RL Jones" <RL wrote in message
...
I am looking for BOOLEAN Algebra Functions. Can't find any help in
EXCEL.
While I can work around the OR, AND, and NOT, I need XOR.

#7
July 21st 09, 10:47 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 1,230
Looking for BOOLEAN ALGEBRA functions (specifically XOR)

"Rick Rothstein" wrote...
Ah, yes... very good. And I guess that could be written this way as well...

=NOT(A1)+NOT(B1)=1

....

If A1 and B1 would always be 1s or 0s, even shorter:

=MOD(A1+B1,2)
#8
July 21st 09, 11:03 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Aug 2008 Posts: 5,934
Looking for BOOLEAN ALGEBRA functions (specifically XOR)

Ah, yes... very good. And I guess that could be written this way as
well...

=NOT(A1)+NOT(B1)=1

...

If A1 and B1 would always be 1s or 0s, even shorter:

=MOD(A1+B1,2)

Provided the user didn't need to see the result of the operation as
TRUE/FALSE, of course.

--
Rick (MVP - Excel)

#9
July 22nd 09, 12:16 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 1,180
Looking for BOOLEAN ALGEBRA functions (specifically XOR)

An XOR could operate on any number of binary bits.
An odd parity checker would XOR all given bits,
thus checking for an odd number of bits in a word:
=MOD(1+MOD(HEX2BIN("AE")-1,9),2)
I vote for Harlan's formulas, having lifted them from
his post dated Jun 16, 2003.
#10
July 22nd 09, 05:21 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2008 Posts: 690
Looking for BOOLEAN ALGEBRA functions (specifically XOR)

... until Excel include =XOR(A1,B1)

It's included as an Excel vba function.
I have no idea why it's not included as a Worksheet function.

b = a Xor b

= = = =
Dana DeLouis

Mike H wrote:
Yes it could and until Excel include

=XOR(A1,B1) then they are as short as it gets.

Mike

"Rick Rothstein" wrote:

Ah, yes... very good. And I guess that could be written this way as well...

=NOT(A1)+NOT(B1)=1

--
Rick (MVP - Excel)

"Mike H" wrote in message
...
Rick,

Can be abbreviated to:-

=(A1<0)+(B1<0)=1

and it also works if both cells are blank.

Mike

"Rick Rothstein" wrote:

I'm pretty sure this is it...

=OR(AND(A1,NOT(B1)),AND(NOT(A1),B1))

--
Rick (MVP - Excel)

"RL Jones" <RL wrote in message
...
I am looking for BOOLEAN Algebra Functions. Can't find any help in
EXCEL.
While I can work around the OR, AND, and NOT, I need XOR.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Gadgetgw Excel Discussion (Misc queries) 4 October 6th 08 08:43 PM edm Excel Discussion (Misc queries) 0 January 10th 07 11:57 PM Irish3538 Excel Worksheet Functions 2 October 16th 06 06:15 PM Zip code help Excel Worksheet Functions 4 October 14th 05 07:13 PM HT New Users to Excel 5 December 5th 04 06:56 PM

All times are GMT +1. The time now is 10:27 PM.