Practicing and, or, and if
BeginnerThis one's an opportunity to practice your IFs, ANDs and ORs. You may find yourself combining these functions when you require more complex conditions. This exercise mimics a case like that so you can see how you fare.
In the below exercise, there is a column filled with quantities. We want to create a formula that will return Yes when the quantity is between 16 (including 16 itself) and 29 (including 29 itself). It should also return Yes when the quantity is above 55 (excluding 55 itself). Any other value should make the formula return No.
Use the formula in cell range D2:D8. Good luck!
Answer
Exercise
Practicing and, or, and if
BeginnerThis one's an opportunity to practice your IFs, ANDs and ORs. You may find yourself combining these functions when you require more complex conditions. This exercise mimics a case like that so you can see how you fare.
In the below exercise, there is a column filled with quantities. We want to create a formula that will return Yes when the quantity is between 16 (including 16 itself) and 29 (including 29 itself). It should also return Yes when the quantity is above 55 (excluding 55 itself). Any other value should make the formula return No.
Use the formula in cell range D2:D8. Good luck!