For Making Bill

For Making Bill

S.N	Item/Particular	Rate	Quantity/Qty.		Amount
1	Copy	100	2		200
2	Pen	200	4		800
				Total	1000
				Disc.	100
				VAT	117
				G.T	1017

ÿ Amount

o   Multiply by rate & Qty.

o   Eg.=c2*d2 8

ÿ Total

o   Add all cells or

o   =Sum(e2:e3) 8

o   Or you can press the key in the same time Alt++= sign

ÿ Disc.  Discounts

o   Total * Percentage of the Discount

o   E.g. =E4*10% 8

ÿ VAT.  Value Added tax

o   Total – Discount and Multiply by Percentages of the VAT

o   E.G. =(E4-E5)*13% 8

ÿ G.T.   Grand Total

o   Total – Discount and Add the VAT.

o   =(E4-E5)+VAT 8