homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / WebmasterWorld / Webmaster General
Forum Library, Charter, Moderators: phranque

Webmaster General Forum

Multiply an Excel 2003 Spreedsheet

 8:44 pm on Jan 29, 2007 (gmt 0)

I don't know much about Excel, because I never use it.
If this is a dumb question please don't get mad at me.

I have a spreadsheet of over 1,000 products my client wants me to markup 35 percent.

Is there an easy way to multiply a whole Excel spreadsheet of numbers times 1.35 or an additional 35% markup.

Thanks to anyone who knows the answer.



 8:53 pm on Jan 29, 2007 (gmt 0)

Insert a column right next to the existing price column. Create a formula in the new column at the very top next to the first price that looks something like this

where A1 happens to be the column that contains the current price. Now select that new cell. When you do, you will notice a little plus sign in the lower left corner of the cell when you hover your cursor there. Double-click it and it will copy the same formula all the way down the column to reflect the price to it's left marked up by 35 percent.


 8:53 pm on Jan 29, 2007 (gmt 0)


Just change A1 for you chosen cell name and the percentage to your required amount, then copy and paste.


 10:02 pm on Jan 29, 2007 (gmt 0)

It works!

Thank you both very much for your help.

Global Options:
 top home search open messages active posts  

Home / Forums Index / WebmasterWorld / Webmaster General
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved