Microsoft Excel

2 minute read

Excel Challenge 19: Using Advanced Logic to Return Different Results

Claudia Buckley

Claudia Buckley

Join the Excel conversation on Slack

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

Download your free challenge data!

Start working on the Excel challenge with this data workbook.

For this Excel challenge, we have multiple options which could lead to different outcomes depending on which options appear together. To get started,

  1. Watch the challenge video. 
  2. Download the Excel worksheet. 
  3. Complete the challenge tasks.
  4. Share your solution, discuss, or ask for help in our Slack channel.

The Challenge

Here’s the scenario: 

We have some college applicants applying to get into our Arts, Business, or STEM program. How we treat their application will be based on last term’s performance and their exam average. 

Sample datasetCan you get the "Application Status" column to automatically update based on the rules in the following chart?

Logic conditions

 


The AND and OR functions are pretty useful for combination and decision-type formulas, and as usual, IF and IFS are go-to functions for controlling behavior.

Watch out! This could be tricky! Tell us how you would solve this. then tune in next week for my solution.

Download your free challenge data!

Start working on the Excel challenge with this data workbook.

We hope you'll enjoy working on this challenge!


The Solution


We hope you enjoyed 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.

If you enjoyed this challenge, you’ll love our Basic and Advanced Excel course, which will help you learn both essential and new Excel functions, as well as help you learn practical, real-world skills!

Ready to become a certified Excel ninja?

Start learning for free with GoSkills courses

Start free trial

Join the Excel conversation on Slack

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

Claudia Buckley

Claudia Buckley

Claudia is a certified Microsoft Office Expert (Excel Specialist), project manager, and business skills instructor at GoSkills who has spent over 20 years in employee professional development. Claudia has a Masters Degree in Business Administration and a Diploma in Educational Psychology. In her spare time, she listens to audiobooks and is an amateur genealogist. View her profile here.