Classifying Sales Performance Using Logical Conditions

Your reporting manager from the Retail Insights Team has now asked you to go beyond basic data structuring and start applying business logic to the dataset.

Welcome to your next phase as a Junior Data Analyst at DMart…

The dataset contains important fields such as Sales, Profit, Discount, Quantity, and Customer Type. However, raw numbers alone are not enough for decision-making.

Before this dataset is used in performance dashboards, your manager wants you to classify and evaluate business performance using logical formulas.

Your task is to apply IF conditions, nested logic, and error handling techniques to make the dataset more intelligent and decision-ready.

Module: Logical Functions and Error Handling in Excel

1) IF Function

2) Nested IF conditions

3) Logical Operators(AND, OR, NOT)

4) IFERROR Functio

Click to download Dataset: Dmart_RetailBusiness.xlsx

Your first goal is to categorize sales data into meaningful performance labels so that management can quickly understand which products are performing well and which are not.

Instead of analyzing raw sales numbers, you will convert them into business-friendly categories like High Sales Low Sales.

Add a new empty column next to the Sales column to display the classification.

Enter an IF formula to classify sales values based on a condition.

Press Enter and apply the formula to all rows using AutoFill.  

Is one condition enough to classify all sales data ?

Choose an empty column next to the Sales column where you want to display the classification.

In this task, we used a simple IF condition to divide sales into High and Low categories.

However, real-world business scenarios often require more detailed classification, such as adding a Medium category.

That’s why we use Nested IF, which allows us to apply multiple conditions in a single formula.

Enter the Nested IF Formula

Press Enter and apply the formula to all rows using AutoFill.

Now your manager wants to analyze performance based on multiple conditions at the same time.

This is where logical operators like AND, OR, and NOT are used.

Using AND Function

Use the AND function to check multiple conditions together.

Select an empty cell .

Enter the formula

Press Enter.

Drag the fill handle down to apply it to all rows.

Using OR Function

Use the OR function to check if at least one condition is true.

 Select another empty cell

Enter the formula:

Press Enter.

Drag to apply to all rows.

Using NOT Function

Use the NOT function to reverse a condition.

Select another empty cell

Enter the formula:

Press Enter

Drag the fill handle down to apply it to all rows.

How Can we handle errors ?

This question smoothly leads to using  the IFERROR Function.

Our task is to handle such errors using the IFERROR function.

Choose a cell where your formula result will appear 

Wrap your original formula inside IFERROR:

Press Enter to get the result.

Drag the fill handle down to apply the formula to all rows.

Great job!

You have successfully completed the Logical Functions and Decision-Making Lab.

In this lab, you have:

1) Classified sales performance using IF conditions

2) Applied nested IF for detailed categorization

3) Used logical operators (AND, OR, NOT) for advanced decision-making

4) Handled missing and error values using IFERROR

You have now transformed raw data into intelligent, decision-ready information, which is a critical step in real-world business analytics.

Hey! Don't forget to prepare for  next lab

1) SUMIF Function

2) AGGREGATE Function