Add percent to group of numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jwswaco@gmail.com - 28 Jun 2005 20:57 GMT

I have pricing sheets that have been created in Excel. We are
increasing our pricing and I need to increase all the prices in the
worksheet by 7 percent. Does anyone have a suggestion as to how to do
this to the entire sheet at once instead of individually? Thanks in
advance -James

Reply to this Message

Bernard Rey - 28 Jun 2005 21:29 GMT

jwswaco@gmail.com:

> I have pricing sheets that have been created in Excel. We are
> increasing our pricing and I need to increase all the prices in the
> worksheet by 7 percent. Does anyone have a suggestion as to how to do
> this to the entire sheet at once instead of individually?

In a free unused cell, type the value "1.07" (without the quotes). Copy the
cell. Then select the cells you want to modify, in the "Edit" menu "Paste
special" item check the "Multiply" button, click the "OK" button and you
should be through.

---------------------------------------------------------
Please reply to the newsgroup, and within the same thread.
Merci de répondre au groupe, et dans l'enfilade.

Signature

Bernard Rey - Toulouse / France
MVP - office:macintosh http://faq.office.macintosh.free.fr

Reply to this Message

jwswaco@gmail.com - 29 Jun 2005 21:32 GMT

Thank you so much for your assistance!
James

Reply to this Message

Mac Forum / Applications / Excel / June 2005

Add percent to group of numbers