# PSC HELPER

Public Service Commission Preparation & Blogging

Practical Guides

Practice Sets

Tips & Tricks

Practical Guides

Practice Sets

Tips & Tricks

Practical Guides

Practice Sets

Tips & Tricks

Practical Guides

Practice Sets

Tips & Tricks

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

## Interviews Preparations

### Tips & Tricks

Based on Experience

Modal Sets

Modal Sets

Modal Sets

Modal Sets

Modal Sets

Tutorials

Tutorials

Tutorials

Tutorials

Tutorials

Tutorials

## Blogging & Wordpress Tutorials, Courses

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

### Wordpress

Intermediate

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