[mso] Re: Excel AND/OR Function (Jim Hickey)

Jim,

The function you want (which doesn't exist in Excel) is XOR - Exclusive Or.
You could achieve this, I think, without an IF as follows:

=AND(OR(I1,J1),NOT(AND(I1,J1)))

This works because Excel treats a zero as FALSE and any other numerical
value as TRUE.  It won't work if the cells contain text.

Here's the truth table which illustrates it:

A|            |TRUE  |TRUE  |FALSE |FALSE
B|            |TRUE  |FALSE |TRUE  |FALSE
C|A AND B     |TRUE  |FALSE |FALSE |FALSE
D|NOT(A AND B)|FALSE |TRUE  |TRUE  |TRUE
E|A OR B      |TRUE  |TRUE  |TRUE  |FALSE
 |D AND E     |FALSE |TRUE  |TRUE  |FALSE

HTH,

Andrew

________________________________________________
Hi everyone,

I need to produce a nested "AND" "OR" Function.

I need to check Columns I1:I36 AND Columns J1:J:36

If there is a value in both I want it to show False
If there is no value in both I want to show False
If there is a value in only one (either Column I or J) I want to show True.

Simple i am sure but i have spent hours and have got very frustrated.

Thanks to anyone that can help
__________________________________________________


                
___________________________________________________________ 
How much free photo storage do you get? Store your holiday 
snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: