Logical Functions

A function that results in TRUE or FALSE is called a logical function.

In Excel, you can use logical expressions:

• > (greater than);
• < (less than);
• = (equals);
• <> (not equal to);
• >= (greater than or equal to);
• <= (less than or equal to).

Examples of use:

Logical functions in Excel include IF, AND, OR, NOT. The general form of the IF function is: IF(logical_expression;value_if_TRUE;value_if_FALSE)

These functions are most often used as arguments in the IF function, and very rarely on their own.

Task: Calculating Tax Coefficients Based on Employee Count

Background:

You are provided with a dataset of 5 companies. Each company has a different number of employees. The tax coefficient for each company is determined based on the number of employees they have. The tax rules are as follows:

• Companies with less than 20 employees have a tax coefficient of 0,15;
• Companies with 20 to 50 employees have a tax coefficient of 0,20;
• Companies with more than 50 employees have a tax coefficient of 0,25.

You can try it by yourself:

Task: Calculating Bonus Eligibility

Scenario:

You are tasked with determining employee bonus eligibility. Employees qualify for a bonus if they meet the following criteria:

• They must have been employed for at least one year;
• They must have exceeded their annual sales target.

Great job finishing Chapter 3! Now, let's dive into the next chapter and discover more exciting Excel skills!