how to add 17.5% vat formula
Hi Jeremy
Peo's answer is perfectly correct for the question you posed.
However, what is more useful and acceptable for the recipient of your
invoice is to show the VAT separately.
So maybe in J50 =J49*.175
and in J51 =J49+J50
Just a thought.
Regards
Roger Govier
Peo Sjoblom wrote:
=j49*1.175
|