| Multiply an Excel 2003 Spreedsheet
|
webwit
msg:3236351 | 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
msg:3236364 | 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
msg:3236365 | 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
msg:3236446 | 10:02 pm on Jan 29, 2007 (gmt 0) |
It works! Thank you both very much for your help.
|
|
|
