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:

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

Units Consumed Formula=D5-C5
Electricity Charges Formula=IF(E5>200, E515,IF(E5>100, 1000+(E5-100)12, E5*10))
SURCHARGE FORMULA = IF(F5>5000, F55%,IF(F5>1000, F53%, 0))
BILL PAYABLE FORMULA = SUM(F5:G5)

Download Excel Electricity Bill Calculation Worksheet Free

Image for Electricity Bill Calculator Formulas in Excel Software

Solution:

Create a new workbook in MS Excel and save as with the name Electricity Bill Calculator Formulas in Excel

Enter sample data for at least three customers
Enter formula for Units Consumed= D5 - C5 in cell with cell reference E5.
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.
Enter formula for Surcharge = IF(F5>5000, F5*5%,IF(F5>1000, F5*3%, 0)) in cell with cell reference G5.
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

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

What are Dual Devices or Both Input/ Output Devices

The devices that can be used to perform both functions -input and output- are called Dual Devices. These devices are also called Dual Purpose Devices or Both Input/Output Devices. With the help of a dual purpose device, we can enter data into computer as well as we can output data from the computer to outside world. For example, Dual devices include: Touch Screen Monitor, Modem, Network Interface Card, Sound card, Hard disk drive, Floppy disk Drive, Magnetic Tape Drive CD-Writer and DVD-Writer etc. These are also called Input/output devices, because they perform both functions. Touch Screen Monitor Dual Devices or Both Input / Output Devices - Touch screens Touch Screen Monitor is an input/output device. It uses a special touch sensitive screen. The User can enter data by touching icons or menus on the screen. As soon as the user selects a command from menu, output is displayed on screen. Commonly touch screen monitors use sensors to detect touch of finger. ...

Explain Different Types Of Data

DATA Data is the collection of raw facts and figures. It is without any proper meaning. Data may be collection of words, numbers, graphics or sounds. What is data? Explain different types of data Examples of Data 1) Student Data on Admission Forms When students get admission in a college. They fill admission form. This form contains raw facts (data of student) like name, father’s name, address of student etc. 2) Data of Citizens During census, data of all citizens is collected. 3) Survey Data Different companies collect data by survey to know the opinion of people about their product. 4) Students Examination data In examination data about obtained marks of different subjects for all students is collected. Different Types Of Data There are following main types of Data. 1) NUMERIC DATA Numeric data consists of 0 to 9 digits, + and – sign and dec...

Explain Star Network Topology With Advantages and Disadvantages

Topic: Explain the Working Star Network Topology With Advantages and Disadvantages Star Topology Star Topology is the most popular and widely used network topology in local area networks . In star topology , all computers are connected with a central device known as HUB or Switch. Now-a-days Hubs are often replaced by Fast Network Switches. The working of Star Topology The sender computer sends data to the hub. The hub sends it to the destination computer. So, all data communication is managed through HUB or Switch. In a star network, each node (file server, workstations, and peripherals) is connected to a central device called a hub. The hub takes a signal that comes from any node and passes it along to all the other nodes in the network. The star topology reduces the chance of network failure by connecting all of the systems to a central node. What is Star topology? Advantages and Disadvantages of star topology Note: The major difference between ...

Perfect Computer Notes

Search This Blog