Logical Functions for Data Analytics
Learn how IF, AND, OR, NOT and nested logical formulas help analysts turn business rules into useful decisions.
Logical Toolkit
Practice Dataset
Sales Performance Data
Logical functions become useful when they are connected to real business rules such as targets, bonuses and performance classifications.
| Product | Region | Sales | Target | Units |
|---|---|---|---|---|
| Laptop | North | ₹60,000 | ₹50,000 | 6 |
| Mouse | South | ₹18,000 | ₹25,000 | 18 |
| Monitor | East | ₹42,000 | ₹40,000 | 7 |
| Keyboard | West | ₹15,000 | ₹15,000 | 10 |
Concept 1 • FOUNDATION
IF: Make a Decision
IF evaluates a condition and returns one result when the condition is TRUE and another result when it is FALSE.
Interactive Activity
Solve the logical problem
A sale of ₹60,000 has a target of ₹50,000. Which result should an IF formula return when Sales >= Target?
Logical Function Map
Start with the business rule
Logical Excel functions are most useful when the analyst first understands the decision that needs to be made.
Logical Functions in Excel for Data Analytics
Excel logical functions help data analysts turn conditions and business rules into useful classifications and decisions. IF, AND, OR and NOT can be combined to evaluate sales performance, targets, eligibility and other analytical conditions.
IF Function in Excel
The IF function checks a logical condition and returns one result when the condition is TRUE and another result when it is FALSE. This makes IF useful for creating business labels such as Target Achieved and Below Target.
AND and OR Functions
AND is useful when all requirements must be satisfied. OR is useful when at least one condition can satisfy the business rule. Combining these functions with IF creates more powerful analytical logic.
Nested IF for Data Classification
Nested IF formulas allow analysts to classify numerical results into multiple categories. The order of conditions matters because Excel evaluates the logical tests sequentially.
Excel Logical Functions for Business Questions
The key analytical skill is not memorizing formulas. It is translating a business rule into logical conditions and then selecting the Excel function that represents those conditions.
Final Analyst Challenge
Turn a business rule into Excel logic
A sales manager wants employees to receive a bonus only when they reach both the sales target and the minimum units target. This requires multiple conditions, not just a single IF test.
"Bonus","No Bonus")