Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I calculate VAT for selective data in the same column of a
I can calculate VAT in a standard way. If i have mixed data in the same
column where some va,ues do not need VAT but the others do... How can I calculate? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I calculate VAT for selective data in the same column of a
"Pathma" wrote in message
... I can calculate VAT in a standard way. If i have mixed data in the same column where some va,ues do not need VAT but the others do... How can I calculate? Nobody can answer unless you give criteria to select data VAT must be calculated on. Bruno |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I calculate VAT for selective data in the same columnof a
Hi
Presumably you have a column with Vat code, lets say column C, and a column with the Net amount, say column D. Assuming your values are in rows 2:20 then =SUMIF($C$2:C$C20,"S",$D$2:D$D20)*17.5% If you needed it for Lower rate, then =SUMIF($C$2:C$C20,"L",$D$2:D$D20)*5% If you had both S and L and wanted a single Total VAT figure than add the 2 formulae together in the same cell =SUMIF($C$2:C$C20,"S",$D$2:D$D20)*17.5%+=SUMIF($C$ 2:C$C20,"L",$D$2:D$D20)*5% All other codes would be 0% VAT and would not need to be added to the total. Change ranges to suit. Regards Roger Govier Pathma wrote: I can calculate VAT in a standard way. If i have mixed data in the same column where some va,ues do not need VAT but the others do... How can I calculate? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
how to put data in the column A to the next row of the column B | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |