LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Calculating percentage throughout a column

Hello,

I am a novice Excel user trying to tackle the following problem - I
have a spreadsheet with about 1500 rows of prices all situated in one
column. I would like to apply a certain markup percentage to each item.
Is there a formula or some other technique I can use to apply this
arbitrary percent (say 20%) to the price column without having to do it
line by line?

Thanks,

Jonny


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
getting #DIV/0! when calculating percentage Ted[_2_] Excel Worksheet Functions 4 May 28th 08 06:02 AM
calculating percentage Dabbles Excel Discussion (Misc queries) 3 July 31st 07 11:40 PM
Calculating a percentage with the end percentage in mind Shadowshady Excel Discussion (Misc queries) 2 June 17th 06 09:41 AM
Calculating Percentage mconnolly Excel Worksheet Functions 1 August 29th 05 09:48 PM
calculating 10 percentage of items in a column ysymon Excel Discussion (Misc queries) 2 August 24th 05 04:16 PM


All times are GMT +1. The time now is 01:16 AM.

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

About Us

"It's about Microsoft Excel"