View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.newusers
Shirley Shirley is offline
external usenet poster
 
Posts: 31
Default Want to Increase Prices by Percent

Gord and George:
Thanks so much for the help. I found exactly what I wanted on the Help file
in note titled: Examples of commonly used formulas.
It is almost same as what you both suggested, but works around the fact I
could not get the Paste Special full window with operations etc.
Here is what is working for me and it does full range of Cells selected:

In empty cell formatted as number I enter 1.10 (for 10 percent).
Than in another empy cell I enter formula: =C5*(1+$F$5) and copy it. (That
makes the F5 cell active with moving border). Copy my range of cells and
Paste Special with multiply and all my prices I selected are increased by 10
percent. I checked a few to make sure and they were perfect.

Thanks to all for sticking with me on this.
It is really a load off my mind.
--
ShirleyF


"Gord Dibben" wrote:

No problem.

Need a slap upside the head quite often.

Just managed this time to slap my ownself<g


Gord

On Sat, 29 Dec 2007 20:03:32 -0000, "George Gee" wrote:

Gord

Sorry, just seen your "update".

George Gee


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Make sure you are following AddOKEsc.

Do not hit the ENTER key after OK or the cells will go blank.


Gord

On Sat, 29 Dec 2007 05:04:01 -0800, Shirley

wrote:

But, in your instructions: Paste Special (in place)addokEsc - it leaves
the cells blank.