Logical Functions

Hi be165,

Try this in C2:

Please Login or Register  to view this content.

Cheers,

Originally Posted by be165

Hi, I'm fairly new to Excel and am struggeling with a formula that I think should be reasonably simple.

Based on some data I have two columns which each calculate either "TRUE" or "FALSE" based on the rules I have applied.

I now want to be able to have a third column that will display "CORRECT" if the first two columns display "TRUE", display "INCORRECT" if both display "FALSE" or "FUTHER EVALUATION" if the columns have one of each "TRUE" and "FALSE".

If it helps the first rule is based on an "IF" formula and the second on an "AND" forumla.

Any help with developing this formula would be greatly appreciated.

Thanks in advance.

=CHOOSE(A1+B1+1,"Incorrect","Further evaluation","Correct")

Just to explain the last approach - logicals can be coerced to their integer equivalents, in native XL TRUE = 1 and FALSE = 0 ... so A1+B1 will coerce and add the integer outputs, ie:

FALSE + FALSE -> 0 + 0 -> 0
FALSE + TRUE -> 0 + 1 -> 1
TRUE + FALSE -> 1 + 0 -> 1
TRUE + TRUE -> 1 + 1 -> 2

So in the prior example the numerical output was used in a CHOOSE, because CHOOSE works only from 1 onwards 1 was added to the result such that complete fail (0) = 1, partial pass (1) = 2 and pass (2) = 3.