These functions are often attached to the IF function but can also be used with tools of data validation or conditional formatting updates.
A condition AND returns TRUE if and only if all tests in parenthesis are true.
A condition OR returns TRUE if one (or more) tests of the function is true.
Excel 2010 allows up to 255 arguments in functions AND & OR 😉
In the following file, you have various informations about your customers. You want to extract of this file a part of your customers on certain criteria.
If the criteria match your expectations, you will enter in column G 1 if you rest is True and 0 if test is not conclusive. Then, you make a SUM of the column G to see how many customers match your criteria.
Try to solve all these issues in the Excel workbook below.
- Question 1: How many clients are married with one child
- Question 2: How many clients are single or divorced
- Question 3: How many clients are married with an income above 75,000
- Question 4: How many clients are male, unmarried and without children
- Question 5: How many clients are women with 1 or 2 children.
- Question 6: How many clients are married or in relationship, with an income greater than or equal to 50,000 and have at least two children.
If your logical test is based on a string you must write your string between double-quotes, if it’s a numeric, leave it like it is
The answer for the question 1 is:
The answer for the question 2 is:
The answer for the question 3 is:
The answer for the question 4 is:
The answer for the question 5 is:
The answer for the question 6 is: