Excel Exercise

Medium

4 minutes

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

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"36c04":{"name":"Main Accent","parent":-1},"3a8fd":{"name":"Accent Light","parent":"36c04","lock":{"saturation":1,"lightness":1}}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"36c04":{"val":"rgb(255, 204, 102)","hsl":{"h":40,"s":1,"l":0.7}},"3a8fd":{"val":"rgb(241, 241, 241)","hsl_parent_dependency":{"h":0,"s":0,"l":0.94}}},"gradients":[]},"original":{"colors":{"36c04":{"val":"rgb(255, 204, 102)","hsl":{"h":40,"s":1,"l":0.7}},"3a8fd":{"val":"rgb(241, 241, 241)","hsl_parent_dependency":{"h":0,"s":0,"l":0.94}}},"gradients":[]}}]}__CONFIG_colors_palette__

​Get Good at Excel on Autopilot

Sign up to our newsletter and receive ​Excel articles, tips and tricks delivered straight to your inbox. All you have to do is read them! ​Plus, to get you started, you'll receive a PDF with 200+ Excel shortcuts.

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"2dd0d":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"2dd0d":{"val":"rgb(45, 164, 92)","hsl":{"h":143,"s":0.57,"l":0.41}}},"gradients":[]},"original":{"colors":{"2dd0d":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
Join List
>