How To Make Electricity Bill Calculation in Ms-Excel with solutions?

Below are the conditions for the Electric Electricity Bill Calculations and Fillable Table to calculate. 

Electricity Bill
Cust.No	Name	Current Meter Reading	Previous Meter Reading	Consumed Unit	Bill Amount
A1001	RajKumar Sharma	1250	1130	120	810
A1002	Hari Shankar	1320	1305	15	80
A1003	Anita K.C.	768	599	169	1167.7
A1004	Sarita Thapa	1380	1125	255	1816.5

Condition:-                                                                            

Unit consume=Current unit-previous unit                               

Calculate Amount as if unit consume following criteria meets:-   

• If unit consumes is less than or equal 20 unit, amount = Rs. 8
• if unit consumes is greater than 20 and below than 250 units, the amount is Rs. 7.3 per unit for the extra unit.
• if unit consumes is greater than 250 units, the amount is Rs. 11.5 per unit for extra unit.            

Solution:

Today, we will discuss How to create an Electricity Bill Calculator Worksheet by using Electricity Bill Calculator Formulas in Excel. The following formulas will be used in Electricity Bill Calculator Worksheet:

• Enter sample data for at least four customers.
• Enter the formula for Units Consumed= D5-E5 in the cell with cell reference F5.
• Enter formula for Electricity Charges =IF(F5<=20,80,IF(AND(F5>20,F5<=250),80+(F5-20)*7.3,IF(F5>250,80+(250-20)*7.3+(F5-250)*11.5)))

In above formula, 

• If units less than 20, first conditions 80 executes.
• If units >20 and <=250, executes the 2nd condition, 80+(F5-20)*7.3
• If units>250, executes the 3rd conditions, 80+(250-20)*7.3+(F5-250)*11.5.

If you have any queries, ask me in the comments section without any hesitation. I would like to thanks you for sharing, viewing a post that solves your problems.