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

[@Bubai200]

❤❤❤

[@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 ❤

[@Kulwant-ce7js]

nicely explained

[@abhilipsabehera813]

Thank you sir ❤

[@nileshpandey9567]

Nyc

[@devarajkakhandaki694]

Nice class sir

[@Ananymous_1081]

Nice session ❤🎉

[@StudySpan]

Thank you so much. Stay tuned for latest videos

[@TimeToExplore]

New subscriber ❤

[@vinohjp]

👍

[@user-ol7gc3fy8s]

TQ sir ❤se

[@llm6010]

Thank you

[@StudySpan]

You are mostly welcome. Stay tuned for latest videos

[@user-ut6yw3gn9o]

Thanks you so much sir

[@Naseerkhankhel]

Very nice

[@rajdeepbanerjee8339]

excellent sir

[@roshankumar1351]

Thanks A lot

[@sanchaysahu9011]

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

[@AshishKumar-xv4sq]

Other Charges Lagaiye Bhai

[@StudySpan]

Thank you for your valuable feedback. But yahan per Maine ek demo sheet banaya hai, aap apne hisab se table ko banaa sakte ho...

[@shahaaqib6904]

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

[@nitishkumarjha5496]

Formula hai apply toh Karna hi padega 😂

[@user-te3ng7wh8c]

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

[@StudySpan]

Yah actually depend karta hai ke kitne conditions hai, uske anusar aapko calculation karna padega.

[@sanjaygirgoswami-fi3ex]

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

[@bhavya_jangra]

Iska download link provide kar wa do

[@DilipsinhGohil9009]

सरजी हमारे यहां गुजरात के ग्रामीण इलाकों में दो महीनो का बिल साथ में बनता है..! लेकिन बिल के पीछे गिनती करने का जो फार्मूला लिखते है वो एक महीने के हिसाबसे होता है जो मैं नीचे लिख रहा हु। 1 प्रथम 100 यूनिट के लिए Rs2.65 2 प्रथम सौ यूनिट के बाद दुसरे 100यूनिट का चार्ज Rs3.10 3 उसके बाद 150यूनिट का चार्ज Rs 3.75 4आखिर में 250 के उपर जितने भी यूनिट चले उसका चार्ज Rs 4.90 तो सर जी अब इसका फॉर्मेट कैसे बनाए ये समजाने के लिए बिनती है।

[@PraveenSharma-tv7ww]

sir agr sari slab lagni h to kse hoga

[@StudySpan]

Same process follow karke apply kijiye

[@PraveenSharma-tv7ww]

nhi ho rha sir q ki mujhe sabhi untis pr sare rate apply krne hai

[@PraveenSharma-tv7ww]

for exp. totl units 487 hai to slab rate hai 150 tkk 2.65 150 se 250 tkk 5.46 250 se 500 tkk 6.53 isse upr 7.34 lagta hai to 487 units ka hua 150×2.65 = 398 100 × 5.46 = 546 237× 6.53 = 1547 totel hua = 398+546+1547= 2491