Bill/ invoice बनाना सीखें /Discount, Shipping Charge, Sale Tax in Excel//

Описание: in excel we create many types of Bill/Invoice. we can add sales Tax, shipping charges, and discount. we can do more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow to pick an item form a list that you create.
Sales Tax =if(select drop down cell="Yes",select total amount*salestax,0)
Shipping Charges =if(Select drop down cell="Yes",select total qty*1.50,0)
Discount =if(Select drop down cell="Yes",Total*5%,0)