how can I calculate VAT for selective data in the same column of a

P

Pathma

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?
 
B

Bruno Campanini

Pathma said:
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?
Click to expand...

Nobody can answer unless you give criteria to select
data VAT must be calculated on.

Bruno
 
R

Roger Govier

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
 
Top