Sir,
I am going to a creat sheet for invoice. I want a formula that can calculate
taxes with two different rates based on item name.

means - when it found in the particular range "F&B" it should be calculate
14% tax on Amount and if it found "Alchoholic Beverage" then it should
calculate 20% on amount

Format is

S.No. Descption Qty Rate Amount
01 F&B 2 150 300
02 Alch Bevrg 6 300 1800


SubTotal 2100
Tax =
Grand Total =