The SWITCH function – Another alternative to complex nested IFs

Excel Skills Boost

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

The IFS function – No more nested IFs

Excel Skills Boost

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

AND / OR functions for testing multiple conditions

Excel Skills Boost

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

Using multiple IF functions – Nested IFs

Excel Skills Boost

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

IF Function #3 – Testing dates

Excel Skills Boost

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

IF Function #2 – Testing text

Excel Skills Boost

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

IF Function #1 – Testing numeric values

Excel Skills Boost

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

Example 4: Calculating percentage increase / decrease

Excel Skills Boost

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

Exercise 3: Using functions

Excel Skills Boost

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

Exercise 2: Absolute references

Excel Skills Boost

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.