Using ROUND formula to calculate tax

[Saskia]

Using the round formula, how can I calculate, 20%VAT on a particula
item

 

[Jack Schitt]

Using the round formula, how can I calculate, 20%VAT on a particular
item?

Assuming you want it to 2 decimal places, and fractions of third+ decimal to
be rounded down,
=ROUNDDOWN(A1/5,2)
Where A1 contains the VAT-exclusive amount, or
=ROUNDDOWN(A1/6,2)
Where A1 contains the VAT-inclusive amount.
You could just use =ROUND() instead of =ROUNDDOWN() as above, which would
result in rounding to the nearest 2nd decimal place. Most regimes require
rounding down.

 

[Govind]

Hi,

Why do you want to use round formula only for this?

Cant you use the formula of =20%*item value

Regards

Govind.

 

[Frank Kabel]

Hi
do you mean
=ROUND(A1*0.2,2)