homepage Welcome to WebmasterWorld Guest from 54.237.99.131
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
webwit

10+ Year Member



 
Msg#: 3236349 posted 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.

 

coopster

WebmasterWorld Administrator coopster us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 3236349 posted 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
=A1*1.35

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.

curlykarl

10+ Year Member



 
Msg#: 3236349 posted 8:53 pm on Jan 29, 2007 (gmt 0)

=SUM(A1*35%+A1)

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

webwit

10+ Year Member



 
Msg#: 3236349 posted 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