What is the Formula in microsoft XL IF the logical test of an AND Statement that consists of a zero, one,&...?

Question

This question is in reference to Microsoft Excel's Boolean Logic and AND Functions: IF I am interested in knowing What is the Formula in microsoft XL for IF the logical test of an AND Statement that consists of a zero, one,& another one (using the ordinal number value:, is true or false.

Answer 1

it will be
IF(AND(A1=0,A1=1,A1=****),"True","False")

I dont understand the part where you say statement consists of a zero? please explain better what exactly it is you want..
replace the **** with your logical tests as required.

This test will check to see if the number in cell a1 is zero, one and ****.

Let me know exactly what you want. Email me on the email link

Yah my answer is wrong.. forget it.. read the one below..

Answer 2

paka: this will always be a false result, as you cannot have one cell (A1) be different values. AND is logical based, not numeric.

branka: understand the AND function: Its a logical test, the same as the IF function, but only giving a true or false result.
Assume A1=0 A2=1
So, in A4 you type =AND(a1=0,a2=1)
Your result will be 'TRUE', since BOTH A1=0 and A2=1. At this point, you could continue this for as many logical tests that you want.

Now, if you want to display 'Yes' if the result of the AND statement in A4 was TRUE, you could type the following in A5:
=IF(A4,"Yes","No")

Notice that I embedded the result of A4 into my IF test. This first input is a logical: True or False. You can reference it like above, or test it directly like =IF(AND(a1=0,a2=1),"Yes","No")

The inverse is also true: You could do something like
=AND(If(a1=0,1,0),if(a2=1,1,0))
The result here will be TRUE or FALSE because you are leading with the AND function. If you lead with the IF function, you could get real data out of it.

Strange: You have to hover your mouse over the above formula to see the proper use of the parens. Yahoo has a bug!