How do I evaluate a pair of cells

Originally Posted by GaidenFocus

You're right, I've seen some pretty gnarly if statements before, and they can be a pain to understand/modify.

=if(a2+b2>60,"Pass","Fail")

hows that?

You need to make the condition a2+b2 > 60 evaluate to a specific number. If you use this: ((a2+b2)>60)*1+1, you will then have 2 cases: (False)*1+1 which evaluates to 1 or (True)*1+1 which evaluates to 2.

Then, you tell Choose what the function should return for the 1 and 2 case: "pass" for 1, and "fail" for 2.

Basically, statement like (B1>30) evaluate to TRUE or FALSE and when you use those statements in a multiplication statement, they are read as true=1 and false=0.