Assignment: Problem$-$Solving with IF and VLOOKUP Functions in Excel

Scenario: You are an analyst at a local retail company called "ABC Retail." Your task is to evaluate sales data from the past quarter to determine sales bonuses for your sales team and categorize the products based on sales performance. Your data includes a sales report with the following fields:

Employee ID

Employee Name

Total Sales Amount

Region

Product Sold

Product Category

Sales Target $($provided for each employee$)$

The company has the following bonus criteria: If an employee's Total Sales Amount is equal to or greater than their Sales Target, they will receive a bonus of $$500.$ If their sales are below the target, they do not receive a bonus. Additionally, you are tasked with categorizing the products into three performance tiers based on their sales amount:

Tier $1($High Performance$)$: Sales above $$5,000$

Tier $2($Medium Performance$)$: Sales between $$2,000$ and $$5,000$

Tier $3($Low Performance$)$: Sales below $$2,000$

Sales Data

$\backslash$table$[[\backslash$table$[[$Employee$],[$ID$]],\backslash$table$[[$Employee$],[$Name$]],$Region,$\backslash$table$[[$Product$],[$Code$]],\backslash$table$[[$Product$],[$Sold$]],\backslash$table$[[$Total Sales$],[$Amount$]],\backslash$table$[[$Sales$],[$Target$]]],[1001,$John Doe,West,P$001,$Laptop,$$6,500,$$$6,000$