Difficulty 3 of 5 · about 4 min
Find a sales commission from a slab table with approximate match
The commission slabs are in A2:B6. Column A is the minimum monthly sales (INR) for the slab, sorted from lowest to highest, and column B is the commission rate for sales at or above that minimum (up to the next minimum). A rep's sales for the month are in E2. In F2, write a formula that returns the commission payable, which is the sales amount multiplied by the rate of the slab it falls in. Use VLOOKUP with approximate match.
Loading grid…