# Excel Challenge 6: Introduction to Logical Functions

Claudia Buckley

#### Join the Excel conversation on Slack

Ask a question or join the conversation regarding Excel challenges on our Slack channel.

Start working on the Excel challenge with this data workbook

How well have you been paying attention to our recent YouTube tutorials? If you’re comfortable with the SUMIF and OR functions, this challenge should be a breeze.

Everything you need to participate in the challenge can be found on this page. To take part:

• First, watch the challenge video and read the instructions below the video.
• Review the previously published video(s) and article(s) off of which the challenge is based.
• Put yourself to the test!

## The challenge

Start working on the Excel challenge with this data workbook

It’s coming up to the end of the year and there’s a scramble to take vacation days.

The HR Department wants to prioritize who gets to take vacation first by looking at employee tenure and the number of vacation days each employee has remaining.

If an employee has more than five vacation days remaining, or if they’ve been with the company for three years or more, they’ll get priority.

Write a formula where the cells in column E will say “Priority” if at least one of these two conditions is met. If neither condition is met, we want this column to display a blank.

HR also wants to query the number of vacation days remaining per department.

Write a formula in cell B17 which will calculate and display the number of vacation days based on the department selected from the B16 dropdown cell.

How quickly can you complete this challenge? Fifteen minutes? Ten? Less?

If you’re just getting started with Excel, all the knowledge you need to solve this challenge has been shown in the following videos:

If you’re already proficient with Excel, this should be quite easy. Maybe you can tell us a creative way to solve this problem in our Slack channel.

Have fun!

Start working on the Excel challenge with this data workbook

## The solution

We hope you'll enjoy taking part in this challenge!

Stay tuned to the GoSkills Excel Resource hub for more Excel challenges, and check out our range of expert-led Excel courses for all skill levels to further sharpen your skills.