Microsoft Excel functions banner image.

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
CountryUrbanRuralMotorwaySpeeds higher than SA
Australia5090100
Germany70110140
France50110110
Italy5090110
Sample data to be used in Excel exercise

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!

An example of the AND function in Microsoft Excel.The result of the example of the AND function in Microsoft Excel.

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","")

The result of the example of the AND function combined with the IF function in Microsoft Excel.An example of the AND function combined with the IF function in Microsoft Excel.

For more info on using a function as an argument to another function, see: Using an Excel function as part of another function.

By MisterFoxOnline

CAT Educator

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.