how do i add percentage to a spreadsheet

J

JCS

Hi

I am trying to add VAT to a column in my spreadsheet but it doesn't seem to
like the funcion i type in, can anyone help.
 
B

Bernard Liengme

If the pre-VAT price is in A1, then the VAT is computed with =A1*17%
(change 17% to your value)
To compute the with-VAT price use =A1*(1+17%)
best wishes
 
D

David Biddulph

Tell us what formula you are trying to use, and what error message you are
getting, then we can help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top