Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i add percentage to a spreadsheet
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i add percentage to a spreadsheet
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "JCS" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i add percentage to a spreadsheet
Tell us what formula you are trying to use, and what error message you are
getting, then we can help. -- David Biddulph "JCS" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage formula in Excel spreadsheet | New Users to Excel | |||
Increasing all values in spreadsheet by same percentage. | Excel Discussion (Misc queries) | |||
How to reduce all numbers in spreadsheet by a percentage | New Users to Excel | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel |