Multiple critera

D

Donna

Hi, I need help with a formula for the following:

If Column E =7 and Column F = 7 and column G = F it can return a value of
True if not False

Thanks Donna
 
S

smartin

Donna said:
Hi, I need help with a formula for the following:

If Column E =7 and Column F = 7 and column G = F it can return a value of
True if not False

Thanks Donna
Click to expand...

Here are a few options that demonstrate different ways to check multiple
conditions...

Straightforward, with clear intentions:
=IF(AND(E2=7,F2=7,G2="F"),TRUE)

Slightly more sophisticated, uses fewer functions:
=IF((E2=7)*(F2=7)*(G2="F"),TRUE)

Bending toward the absurd for this example:
=SUMPRODUCT((E2=7)*(F2=7)*(G2="F"))=--TRUE
 
Top