Creating Utililty Bill in Microsoft Excel 2019
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=mWo6oAI08Ic
Hi viewers in this tutorial you will learn how to create a any Utility Bill in Microsoft Excel 2019, also you will learn the formulas that use in this this bill. • SUBSCRIBE MY CHANNEL For more professional Video tutorials. • / yadonlinetrainingacademy • Formulas • Payabill bill • =SUM(E4:F4) • Electricity charges • =IF(units are greater than 200 then unit*15,if(units are greater than from 100 then unit*12,otherwise units*10)) • Surcharge • =IF (electricity bill is greater than from 5000 then surcharge will be 5%, if electricity bill is greater than from 1000 then surcharge will be 3%,otherwise it will be 0) • #billinexcel #utilitybillinexcel #createbillinexcel
#############################
