In this exercise we will see how to use the AND and OR operators to do complex logic tests in an IF function. This exercise is not easy. It is essential to have successfully completed the previous exercises:
- Exercise on Logic Testing in Excel
- Exercise IS Function – Message in the event of an employee’s absence
- Merchandise stock exercise with the SI function
Don’t skip steps. If you are not very familiar with the IS function, this case study will seem too difficult for you to solve.
Structure of the exercise with the functions IF, AND, OR
Here, we will help a seller to redefine the selling price of his shoe models based on unsold stock.
The selection criteria are multiple
- Shoe colors
- Size
- Genre
- Model type (sport, city, etc.)
Click on the following button to start the exercise.
Related exercises
Find other examples of the IF, IFERROR, AND, OR, COUNTIF, SUMIF functions in the following links.
- Use the IF, AND and OR functions – Product selection
- Evaluation of IF, IF.CONDITIONS and IFERROR functions
- Evaluation of the NB.SI and NB.SI.ENS functions
- SUMIF and SUMIFENT Exercises
Excel-Exercice.com, your educational partner.
Our team of certified experts has developed detailed training programs, suitable for all skill levels. From basic data processing to advanced analysis, our courses cover a wide range of Excel topics.
What sets excel-exercise.com, this is our interactive and practical teaching approach. Our training sheets are accompanied practical exercises and real-world use cases. So you can immediately apply your new skills in your daily work.
