Share this article:

What it does: The AND() checks if all conditions that you list are TRUE.

Plain English: The AND() formula is often used in conjunction with IF() statements. The AND statement allows you test whether two or more criteria are TRUE, not just one.

Say you’re building a fantasy football team full of offensive players. If you want to check whether or not a receiver’s touchdowns average more than 1 per game AND they’ve played at least 3 seasons in the league, you could use the AND() formula along with your data to test this.

Arguments: AND(TEST1, TEST2, etc..)

  • TEST 1 – The first thing you want to test, i.e. Average touchdowns per game greater than 1? TRUE
  • TEST 2 –  The second thing you want to test, i.e. Seasons greater than 3? TRUE

NOTE: If any condition within the AND() statement equates to FALSE, the entire statement will equate to FALSE.