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.
|