You are about to test the values of several cells by using the following types of formulas: AND, OR, and IFs.

Input this formula into I40:

You are interested in knowing IF the logical test of an AND statement that cosists of a zero,one, and another one(use the ordinal number value) , is true or false.

The result of this And statement, if true is another IF statement that has B10 as the logical test, the word true for the true argument and false for the false argument.

The false argument is another IF statement that has B11 as the logical test, then 1 followed by a 0 for the true and false arguments respectively. The answer o that If statement is one of three argument in an OR statement. The other two arguments are the words True or False .

Now the result of this Or is the logical test of an IF that has "CGS2531 is Great!" as its true argument and "CGS2531 is the Best!" as its false argument.

Tried to clear that up a bit. I need the formula for I40. Where I am running into a problem is testing to see if three values are true or false. I can't make IF(0 AND 1 AND 1, x,y), or even IF(0 AND 1,x,y) for that matter. I don't know how to test this. Any help would be appreciated, ASAP. Thanks all.

Input this formula into I40:

You are interested in knowing IF the logical test of an AND statement that cosists of a zero,one, and another one(use the ordinal number value) , is true or false.

The result of this And statement, if true is another IF statement that has B10 as the logical test, the word true for the true argument and false for the false argument.

The false argument is another IF statement that has B11 as the logical test, then 1 followed by a 0 for the true and false arguments respectively. The answer o that If statement is one of three argument in an OR statement. The other two arguments are the words True or False .

Now the result of this Or is the logical test of an IF that has "CGS2531 is Great!" as its true argument and "CGS2531 is the Best!" as its false argument.

Tried to clear that up a bit. I need the formula for I40. Where I am running into a problem is testing to see if three values are true or false. I can't make IF(0 AND 1 AND 1, x,y), or even IF(0 AND 1,x,y) for that matter. I don't know how to test this. Any help would be appreciated, ASAP. Thanks all.

## Comment