A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

how do i add percentage to a spreadsheet



 
 
Thread Tools Display Modes
  #1  
Old November 6th 08, 12:19 PM posted to microsoft.public.excel.misc
JCS
external usenet poster
 
Posts: 93
Default 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.
Ads
  #2  
Old November 6th 08, 12:43 PM posted to microsoft.public.excel.misc
Bernard Liengme
external usenet poster
 
Posts: 4,393
Default 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  
Old November 6th 08, 12:47 PM posted to microsoft.public.excel.misc
David Biddulph[_2_]
external usenet poster
 
Posts: 8,651
Default 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.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Percentage formula in Excel spreadsheet Rick New Users to Excel 5 November 10th 08 04:30 AM
Increasing all values in spreadsheet by same percentage. Excels Alot Excel Discussion (Misc queries) 1 February 5th 08 12:39 AM
How to reduce all numbers in spreadsheet by a percentage stubarlow New Users to Excel 1 July 5th 07 05:34 PM
Calculating a percentage with the end percentage in mind Shadowshady Excel Discussion (Misc queries) 2 June 17th 06 09:41 AM
Bar Chart depicting the "percentage of another percentage(less than 100)" TEAM Charts and Charting in Excel 1 October 28th 05 05:06 AM


All times are GMT +1. The time now is 05:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.