Electricity Bill Calculation in Microsoft Excel | Electricity Bill Formula in MS Excel

In this video we will learn to Calculate Electricity Bill in Microsoft Excel step by step

#electricitybill
#electricity_bill
#electricbill
#electricity_bill_in_excel
#bill_in_excel
#excelformulas
#excelfunctions
#microsoftexcel
#exceltipsandtricks
#microsoft_excel_tutorial
#studyspan

Music: Outside
Musician: @iksonmusic

Thank you

[pujariabhishekh]

Electricity bill is not calculated in this way by Mahavitaran atleast, in 340, first 100 units are calculated as per the rates of (0-100 units category) the remaining units i.e 200 units is calculated as per (101-300 units category) now the last remaining 40 units are above 300, so (301-500 units Category) rates are applied to the rest 40 units.

The bill is calculated in such a way i.e Bill = (100 * 4.41 + 199 * 9.64 + 39 * 0.60) = 2382.76, I have taken 199 instead of 200 because the catogery is 101-300 which becomes 199

[TimeToExplore]

Your teaching way is very very easy 🙂 Anyone can learn by your video 🙂
You have put hard efforts ❤

[sanchaysahu]

One can use vlookup formula also for getting rates in the sheet from the another sheet

[shahaaqib]

Sir can we make below own format such as you typed here units and cost? please confirm me

[Alenqo]

सर क्या एक ही if से नहीं हो सकता या जितनी condition h utne ही if लगाने hoge

[राजानिषाद-भज]

सर जी 4 कंडीशन में ग्रेटर डेन ही आयेगा क्या सर जी

[sanjaygirgoswami-fiex]

Sir ji ye 2 shit me aap jo ye type kiya hai usee tarh kya hr bar krna hota hai

[DilipsinhGohil]

सरजी हमारे यहां गुजरात के ग्रामीण इलाकों में दो महीनो का बिल साथ में बनता है..!
लेकिन बिल के पीछे गिनती करने का जो फार्मूला लिखते है वो एक महीने के हिसाबसे होता है जो मैं नीचे लिख रहा हु।

1 प्रथम 100 यूनिट के लिए Rs2.65

2 प्रथम सौ यूनिट के बाद दुसरे 100यूनिट का चार्ज Rs3.10


3 उसके बाद 150यूनिट का चार्ज Rs 3.75

4आखिर में 250 के उपर जितने भी यूनिट चले उसका चार्ज Rs 4.90

तो सर जी अब इसका फॉर्मेट कैसे बनाए ये समजाने के लिए बिनती है।