This function takes multiple arguments and all the arguments must return TRUE for the function to return TRUE. You will most likely find this function combined with another function, as in the example below.
In the following example, we are going to identify which countries have Country, Urban and Motorway speed limits that are ALL higher than the relevant speeds in South Africa. The South African speed limits are:
- Country: 60
- Urban: 100
- Motorway: 120
| Country | Urban | Rural | Motorway | Speeds higher than SA |
|---|---|---|---|---|
| Australia | 50 | 90 | 100 | |
| Germany | 70 | 110 | 140 | |
| France | 50 | 110 | 110 | |
| Italy | 50 | 90 | 110 |
Step 1
Starting with the AND function in cell E2:
=AND(B2>60, C2>100, D2>120)
If all three of the conditions are met the function returns TRUE; if one or more of the conditions returns FALSE, the function returns FALSE. All or nothing!
Step 2
Combine the AND function with the IF function where the AND function serves as the condition for the IF function in E2:
=IF(AND(B2>60, C2>100, D2>120),"Higher","")
For more info on using a function as an argument to another function, see: Using an Excel function as part of another function.