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
|
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.
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.
No comments:
Post a Comment