# PSC HELPER

Public Service Commission Preparation & Blogging

Practical Guides

Asked Papers

Practice Sets

Tips & Tricks

Practical Guides

Asked Papers

Practice Sets

Tips & Tricks

Practical Guides

Asked Papers

Practice Sets

Tips & Tricks

Practical Guides

Asked Papers

Practice Sets

Tips & Tricks

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

## Interviews Preparations

Asked Before

### Tips & Tricks

Based on Experience

Asked Before

Asked Papers

Asked Papers

Asked Papers

Asked Papers

Asked Papers

Modal Sets

Asked Papers

Modal Sets

Modal Sets

Modal Sets

Modal Sets

Tutorials

Tutorials

Tutorials

Tutorials

Tutorials

Tutorials

Tips

Tips

New Strategies

New Strategies

Make Money

Make money

Guide

Guide

For Beginners

For Beginners

Tutorials

Tutorials

How to start?

How to start?

Intermediate

Intermediate

## Post Top Ad

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.

#### 1 comment:

1. Thank you so much for this information. You have given my brain a real workout and I am grateful. I love intelligent content that is so well written. Good job. electricians gulfport ms