Col A - Sl.No.
Col B - Item Name
Col C - Qty
Col D - Rate
Col E - Total
Col F - Helping Column ( New column for calculation )
Cell D5 - Subtotal
Cell D6 - VAT
Cell D7 - Total

in Cell F2 put this formula and drag it down
=INDEX({0,0.14,0.2},MATCH(B2,{"Room Charges";"Food & bev";"alcoholic"},
0))

in Cell F6 put this formula
=SUMIF(F2:F4,"<"&0,E2:E4)*SUM(F2:F4)



On Nov 29, 3:22*pm, Rao Ratan Singh <Rao Ratan
wrote:
Hi All,
I am preparing a Tax Invoice for our Hotel. But problem is
some items are Tax free and some are Taxable. How i can detect
exempted and taxable item from List.

my invoice Format is like

S.No. * Item Name * * * * * * * Qty * * Rate * *Total
01 * * *Food & Beverage * * * * * * 2 * * * 500.00 *1000.00
02 * * *Alchoholic Bvrg * * * * 2 * * * 300.00 *600..00
03 * * *Room Charges * * * * * *1 * * * 5000 * *5000.00

SubTotal

Vat

Total

VAT should be calculate only items which are taxable.

Room Charges * *- Exempte
Food & Bvrg - 14% Taxable
Alcholic Bvrg * - 20% Taxable

Help from anyone will be appreciated

Regards
RRS