Dynamic Sales Commission Calculator

Ecologic , Baddi pays variable commissions based on tiered performance.
Create a dynamic commission calculator that automatically computes bonuses using modern array functions

Using Functions such as LET, MAP, LAMBDA, Solve this Case

Scenario:

A company pays variable commissions based on tiered performance.
Create a dynamic commission calculator that automatically computes bonuses using modern array functions.

Dataset Structure:

• Employee_ID, Name, Region, Monthly_Sales, Target_Achievement (%)
• Commission Tiers: 0-80%: 2%, 80-100%: 5%, 100-120%: 8%, 120%+: 12%

Tasks:

1.Use LET() to define variables for tier thresholds and rates
2.Build a LAMBDA() function that calculates commission based on achievement percentage
3.Apply MAP() to process the entire sales team array without manual dragging
4.Create a spill-range formula that auto-expands when new employees are added

Expected Output:

Dynamic commission table with automatic recalculation and expandable ranges.
Evaluation Criteria: Correct use of LET variables, proper LAMBDA syntax, MAP array processing