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

Uses Of Computer In Education Field

Computer can be used in education in the following ways: Computers In Teaching and Learning Process ( Computer Aided Learning - CAL ) Computers are being used actively in educational institutes to improve the learning process. Teachers can use audio video aids through computer to prepare lesson plans. They can use Microsoft Power Point to prepare electronic presentations about their lectures. These electronic presentations will be displayed on multimedia projectors in class rooms. This will be interesting and easy to learn for students. Multimedia presentations are easy to deliver for teachers too, These presentations save a lot of effort and time. Moreover multimedia presentations are interesting to view and hear sound and visual effects. Computers will be helpful for: Instructing the students using PowerPoint slides, Word documents or Web pages and using hyperlinks for be...

Types Of e-Commerce

Types/Categories/Modes of e-commerce. There are three main types of e-commerce as follows: 1) Business To Consumer (B2C) B2C ecommerce consists of selling goods and services to individual consumers. In this type, consumers or customers can visit the website and purchase goods online. The website will have a StoreFront. This storefront will show product details, pictures and a shopping cart. Shopping cart is used to collect items to purchase. Advantages of B2C e-commerce B2C e-commerce has the following advantages: * Shopping can be faster and more convenient. * Offerings and prices can change instantaneously. * Broadband telecommunications will enhance the buying experience. 2) Business To Business (B2B) B2B e-commerce takes place between two businesses. One business provides services to other business. Examples of B2B include: Online Advertisement, recruiting, sales, marketing, technical support and training. For eample, some companies provide online purchasing...

Explain Different Types Of Computer Networks - LAN, MAN, WAN

Explain different types of computer networks:(LAN,WAN,MAN) Today, we will discuss the main types of computer networks on the basis of the maximum distance covered where they can be accessed and operate. The main types of computer networks are: LAN, WAN, MAN Explain different types of computer networks 1. LAN - Local-Area Network 2. WAN - Wide-Area Network 3. MAN - Metropolitan-Area Network 1)LAN (Local Area Network) What is LAN or Local Area Network LAN stands for Local Area Network . It covers a small area. Most LANs are used to connect computers in a single building or group of near buildings. A network contained within a relatively small area, such as a classroom, school, or single building, is commonly referred to as a local area network. Hundreds or thousands of computers may be connected through LAN . LANs are used in office buildings, college or university campus etc. Local Area Networks can t...

Perfect Computer Notes

Search This Blog