Array Formula using MAX()/MIN() and IF() - 2 criteria

• Beginner
• 250
• 250 points

 Building MAX + IF and MIN + IF with one condition - Example 2

• Beginner
• 250
• 250 points

 Building MAX + IF and MIN + IF with one condition - Example 2

• Beginner
• 250
• 250 points

 Find the four earliest dates using SMALL() and IF()

• Beginner
• 250
• 250 points

Body Mass Index Calculation

• Intermediate
• 1800
• 1.800 points

Create a body mass index calculator using height and weight of a person

Error Handling

• Advanced
• 1800
• 1.800 points

Correcting value errors.

Error Handling

• Advanced
• 1800
• 1.800 points

Correcting value errors.

Expense Sheet

• Unknown
• 1500
• 1.500 points

Using Nested IF.

Expense Sheet

• Unknown
• 1500
• 1.500 points

Using Nested IF.

GYM Complaints Sheet

• Unknown
• 900
• 900 points

Master date functions using the complaints data for a gym.

Highest Paid Celebrities

• Intermediate
• 1300
• 1.300 points

Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...

Highest Paid Celebrities

• Intermediate
• 1300
• 1.300 points

Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...

International Tourist Data

• Advanced
• 1300
• 1.300 points

Calculate which country recieves the most tourists in each continent.

iPhone vs Samsung

• Advanced
• 1200
• 1.200 points

Checking formulas results with Iphone-Samsung sales.

iPhone vs Samsung

• Advanced
• 1200
• 1.200 points

Checking formulas results with Iphone-Samsung sales.

Logical formulas: Basics of IF() and Nested IF()

• Beginner
• 250
• 250 points

Logical formulas: Combining IF() w. AND() & OR()

• Beginner
• 250
• 250 points

Most Popular Movies

• Intermediate
• 2300
• 2.300 points

Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...

Most Popular Movies

• Intermediate
• 2300
• 2.300 points

Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...

My First Invoice

• Unknown
• 1600
• 1.600 points

Creating an invoice with base functions.

My First Invoice

• Unknown
• 1600
• 1.600 points

Creating an invoice with base functions.

New Employee ID Badge

• Intermediate
• 1300
• 1.300 points

Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...

New Employee ID Badge

• Intermediate
• 1300
• 1.300 points

Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...

Practice: IF Functions 1 - Numbers

• Advanced
• 1000
• 1.000 points

Making more practice by using IF() function.

Practice: IF Functions 2 - Text

• Advanced
• 800
• 800 points

Making more practice by using IF() function.

Practice: IF Functions 3 - Other Functions and If

• Advanced
• 1000
• 1.000 points

Making more practice by using IF() function.

Practice: IF Functions 4 - Bets

• Advanced
• 1000
• 1.000 points

Making more practice by using IF() function.

Practice: IF Functions 5 - Items

• Advanced
• 1400
• 1.400 points

Making more practice by using IF() function.

Practice: IF Functions 6 - Students

• Advanced
• 1000
• 1.000 points

Making more practice by using IF() function.

Practice: IF Functions 7 - Customers

• Advanced
• 1000
• 1.000 points

Making more practice by using IF() and AND() functions.

Practice: IF Functions 8 - Sale Rent

• Advanced
• 1200
• 1.200 points

Making more practice by using IF() and OR() functions.

Privileged Customers

• Intermediate
• 1200
• 1.200 points

Matching nested IF() and IFS() functions.

Privileged Customers

• Intermediate
• 1200
• 1.200 points

Matching nested IF() and IFS() functions.

Salesperson Ratings

• Unknown
• 1700
• 1.700 points

Create a summary of salesperson sales stats with the help of range lookup.

Salesperson Ratings

• Unknown
• 1700
• 1.700 points

Create a summary of salesperson sales stats with the help of range lookup.

Social Security Numbers

• Intermediate
• 1100
• 1.100 points

Working on Social Security.

Special Use of Lookups

• Intermediate
• 2400
• 2.400 points

Try using vertical lookup instead of if statements

Stoner

• Intermediate
• 1300
• 1.300 points

Getting values with VLOOKUP:

Top Models

• Intermediate
• 1500
• 1.500 points

Calculate the earnings of top models based on scenarios

Top Models

• Intermediate
• 1500
• 1.500 points

Calculate the earnings of top models based on scenarios

Vacation Day Calculator

• Intermediate
• 1000
• 1.000 points

Calculate vacation days based on years worked and other conditions

Vacation Day Calculator

• Intermediate
• 1000
• 1.000 points

Calculate vacation days based on years worked and other conditions

Weekly Timesheet

• Intermediate
• 700
• 700 points

Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...

Win a lottary ticket

• Advanced
• 1900
• 1.900 points

Working with advanced functions.