If you want to check that multiple conditions in your spreadsheet are TRUE, then we can use the AND formula.

For example, if you wanted to check if a number is greater than 10 but less than 50 we could use an AND formula. The formula in this example would be =AND(A5>10,A5<50)

Another example that you could use the AND formula is to compare two cells to check that they are the same. The formula for this example would be =AND(A5=10,B5=10)

This content is aimed at the

**Advanced**level.

**Click here**to view our course overview.