Skip to main content

Electricity Bill Calculator Formulas in Excel

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:

Q: Prepare a worksheet according to the following instructions:

  1. Create a worksheet in MS Excel according to the requirements
  2. Enter sample data of Electricity units consumed by customers in a city
  3. Apply formula to calculate Units Consumed
  4. Apply formula to calculate Electricity Charges
  5. Apply formula to calculate Surcharge
  6. Apply formula to calculate Bill Payable
  7. Note: Every formula will start from  = 

Units Consumed Formula=D5-C5
Electricity Charges Formula=IF(E5>200, E5*15,IF(E5>100, 1000+(E5-100)*12, E5*10))
SURCHARGE FORMULA = IF(F5>5000, F5*5%,IF(F5>1000, F5*3%, 0))
BILL PAYABLE FORMULA = SUM(F5:G5)
Download Excel Electricity Bill Calculation Worksheet Free
Download Excel Electricity Bill Calculation Worksheet Free

 Image for Electricity Bill Calculator Formulas in Excel Software



Solution:
  1. Create a new workbook in MS Excel and save as with the name Electricity Bill Calculator Formulas in Excel
  2. Enter sample data for at least three customers
  3. Enter formula for Units Consumed= D5 - C5 in cell with cell reference E5.
  4. Enter formula for Electricity Charges =IF(E5>200, E5*15,IF(E5>100, 1000+(E5-100)*12, E5*10)) in cell with cell reference F5.
  5. Enter formula for Surcharge = IF(F5>5000, F5*5%,IF(F5>1000, F5*3%, 0)) in cell with cell reference G5.
  6. Enter formula for Bill Payable =SUM(F5:G5) in cell with cell reference H5.
So, the worksheet with Electricity Bill Calculator Formulas in Excel Worksheet has been prepared successfully.

Download the Original Workbook File Prepared For Electricity Bill Calculator Formulas in Excel

Sponsored Links

Click to Download Excel Workbook For Electricity Bill Calculator Formulas in Excel Worksheet
Electricity Bill Calculator Worksheet with Formulas in Excel is normally required to be prepared by the students of a Basic Microsoft Office Training. There are very simple formulas used to calculate monthly electricity bill of the customers living in a town. Although, the electric supply company may use a customized software for preparing electricity bills, the students of Microsoft Excel will learn the use of different formulas and built-in functions to prepare Electricity Bill Calculator Worksheet with Formulas. Microsoft Excel can be very helpful to prepare such worksheets.



Microsoft Excel Practical Worksheet Preparation With  Predefined Functions and Formulas

Microsoft Excel Formulas and Functions Fast and Easy Way -1

Using Simple Formulas in Excel With Arithmetic Operators 2

How Functions are Used in Excel Fast and Easy Way 3

Create Bar Chart in Excel Easily by Example

Employee Pay sheet Formulas in Microsoft Excel 
Students Test Score Grades Result Sheet in Excel

Electricity Bill Calculator Formulas in Excel 
 
Microsoft Office Word Processing Practicals

Popular Networking Theory

8.1 Explain Advantages Of Networks8.2 Types Of Computer Networks8.3 Differences between LAN and WAN8.4 Bus Topology Advantages Disadvantages8.5 Advantages and Disadvantages of Star Topology8.6 Advantages and Disadvantages of Ring Network Topology8.7 Advantages and Disadvantages of Tree Topology8.8 Advantages and Disadvantages of Mesh Topology8.9 Advantages and Disadvantages of LAN Local Area Network

 



Comments

Popular posts from this blog

Convert Centimeters to Inches Python Programming | Python Program Conver...

YouTube Video Tutorial How to write a Python program to convert centimetres to inches Formula to convert centimetres to inches   Explanation of this Python Program This Python program prompts the user to enter a height in inches, converts it to centimeters, and then prints the converted value. It uses the conversion factor of 2.54 to perform the conversion and rounds the result to two decimal places before displaying it to the user. Here's an explanation of the provided Python program line by line: python inches = float ( input ( 'Enter the Height in inches to convert into centimeters:' )) This line prompts the user to enter a height in inches and assigns the entered value to the variable inches . The input() function is used to receive input from the user, and float() is used to convert the input into a floating-point number. python centimeters = inches * 2.54 This line calculates the equivalent value in centimeters by multiplying the inches variable by the conver...

Converting Decimal Number system to Binary, Octal and Hexa Decimal with Examples and Vice Versa

Topics covered with examples: Converting Decimal Number system to Binary, Octal and Hexa Decimal with Examples and Vice Versa Number Systems in Computer Science and Conversion Method Conversion of Decimal number system to other  number systems Conversion of Decimal number system to binary number systems Conversion of Decimal number system to octal number systems Conversion of Decimal number system to hexadecimal number systems Conversion of    non-decimal Number system to Other non-decimal number system Conversion of other number systems to Decimal number system Conversion of binary number systems to Decimal number system Conversion of octal number systems to Decimal number system Conversion of  hexadecimal number systems to Decimal number system Q1. What is a Number System? What are different types of number system? Number system A number system is a set of digits, symbols and rules to express quantities in counting and c...

Find Your Correct Age From Date of Birth

First of all click on First two digits to type Month number from keyboard like any number from 1 to 12. . Now click on next two digits and type day number of month that is date from 1 to 31. In the last step type the year of your birth in four digits like 1995.  Now click on the blue button with text "Calculate Age". Your accurate age will be displayed below the button. For example. If today is 09-16-2023 that is September 16, 2023 and you type birth date as 11-01-2000 that is November 1, 2000, your accurate age will be displayed as:Your age is 22 years, 10 months, and 15 days. Age Calculator Age Calculator Calculate Your Age Now! Enter your date of birth: Calculate Age As shown in the image below: