Lab › Formulas & Functions › Electricity Bill (Slab Rates)

Electricity Bill (Slab Rates): Excel Lab

Lab 11 · IntermediateNested IFSlab calculation

The task: First 100 units cost 3 each, the next 100 cost 5 each, and every unit above 200 costs 7. Add a fixed charge of 50.

1 Watch how it is done

1. Step 1: Charge the slabs

   =IF(B4<=100,B4*3,IF(B4<=200,300+(B4-100)*5,800+(B4-200)*7))

   • Click C4.
   • Type =IF(B4<=100,B4*3,IF(B4<=200,300+(B4-100)*5,800+(B4-200)*7)) and press Enter.
   • 300 = first 100 units × 3. 800 = 300 + next 100 units × 5.
   • Drag the fill handle down.

2. Step 2: Add the fixed charge

   =C4+50

   • Click D4.
   • Type =C4+50 and press Enter.
   • Drag the fill handle down.

2 Your turn

3 Check your answers

Stuck? Download the solution file and compare it with yours.

Next lab: Orders and Sales by Region →
Want the theory? Read the Formulas & Functions lessons →
← More Formulas & Functions labs · All lab categories