How to Calculate Electricity Bill in Excel | Updated | Digital Edu

Описание: #Please_Subscribe: https://bit.ly/2RKXkHv
It is very easy to calculate the electricity bill and tariff for Electrical Engineering Students but, it makes confusion for non-technical people that concern about their electric charges from the electricity service providers.

How to Calculate Electricity Bill in Excel | Updated | Digital Edu

Conditions of The Project.
a) If the meter unit is less than equal 75, per unit price will be 3.80

b) If the meter unit is less than equal 200, per unit price will be 5.14.

c) If the meter unit is less than equal 300, per unit price will be 5.36

d) If the meter unit is less than equal 400, per unit price will be 5.63.

e) If the meter unit is less than equal 600, per unit price will be 8.70

d) If the meter unit is more than equal 600, per unit price will be 9.98

Electricity Charges Formula=IF(E5 greater than symbol 200, E5*15,IF(E5 greater than symbol 100, 1000+(E5-100)*12, E5*10))
SURCHARGE FORMULA = IF(F5 greater than symbol 5000, F5*5%,IF(F5 greater than symbol 1000, F5*3%, 0))
BILL PAYABLE FORMULA = SUM(F5:G5)


Visit Our Web Site : https://bit.ly/2RyM8yo

************************************-Disclaimer -***************************

This video is for educational purpose only.Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use.