Method 1 – Electricity Bill Calculation for Fixed Unit Price Steps: Add theUnit PriceandTotal Billcolumns (G and H) to the right. Fill in thecolumn Gwith desired values. Go to cellH5and type the following formula: =F5*G5 PressENTERto get the result. ...