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!

Good work. The if function is a really important one in Excel. Knowing how to combine it with the other logical functions can really help increase the number of different things you can make in Excel.

**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.

## Related functions

IF