| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calcution with two conditon
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 = |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How i count coulm by conditon | Excel Discussion (Misc queries) | |||
| If statement - can it stop once a conditon is reached? | Excel Worksheet Functions | |||
| copying conditon formats with $ | Excel Worksheet Functions | |||
| Get data with certain conditon | Excel Discussion (Misc queries) | |||
| How to determine the number from given conditon? | Excel Discussion (Misc queries) | |||
Threaded Mode
