This 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!
Note: The IF function works slightly different in our spreadsheet editor than it does in Excel. The difference being that the equals operator (=) should be replaced by a double equals sign (==) to work in the above spreadsheet editor. You can solve the exercise without using the equals operator though.