A simple logical expression that I can't figure out

Hi. This seems so simple, but I can't find the answer (I'm getting old!)

I have 3 columns A,B,C. Columns A & B contain values which are either zero or non-zero.

In C I want a logical expression which returns TRUE if A & B are both zero, or if they are both none-zero, but FALSE if one is zero and the other is non-zero.

Values of 1 or 0 rather than TRUE or FALSE would be ok if it makes the formula simpler.

It needs to be as simple as possible please, as it will form part of a longer expression later.

Many thanks

K

Hi, negative numbers yes, empty cells no.

Thx

try

Formula:

Please Login or Register  to view this content.

1 1 TRUE
0 0 TRUE
1 0 FALSE
0 1 FALSE
-1 -1 TRUE etc...

Originally Posted by sandy666

try

Formula:

Please Login or Register  to view this content.

1 1 TRUE
0 0 TRUE
1 0 FALSE
0 1 FALSE
-1 -1 TRUE etc...

Hi I'm getting #NAME? Very sorry I ought have mentioned I have excel 2007

Also I ought have mentioned my non-zero values are not necessarily numbers, some are text, sorry if this has caused confusion. K

Originally Posted by Tony Valko

This one is a few keystrokes shorter...

=MOD(COUNTIF(A1:B1,0),2)=0

This is working thanks. I wonder if I ought upgrade though, the xor is so elegant

@Trebor777
Sorry about that with Ex2007 and XOR() function

@Tony
Make footnote from this: MS-Off Ver PeeSee(64)=ROUND(4.831^4.831,0) . Will be funnier

No problem sandy, I have wondered many times about upgraging

btw. here is XOR() for Ex2007 for the case above

Formula:

Please Login or Register  to view this content.

but it doesn't accept the text values.

Originally Posted by sandy666

btw. here is XOR() for Ex2007 for the case above

Formula:

Please Login or Register  to view this content.

but it doesn't accept the text values.

I really need xor

I wish you all the best
Maybe you can try:
XOR function
Applies To: Excel 2016 Excel 2013 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad

This seems to work:

=(OR(N25+O25=0,AND(N25>0,O25>0)))

just replace with your cells. Good Luck!