Hi Keeno
If you want to reduce by 15%, then you would multiply by 0.85 not by 1.15
Jim's suggestion of entering a value in a cell (0.85) copying it then
Selecting your range of data and paste SpecialMultiply will work.
If you are not getting the normal Paste Special options, it sounds as though
you have 2 instances of Excel loaded.
Close the instance that you are not using, and you should get the normal
Paste Special options.
--
Regards
Roger Govier
"Keeno" wrote in message
...
HI Jim.
Could you help me. I have a similar problem to the one you answered below
some time ago. Searched the web for answers you see.
I have a column of values say from b3:b23 and I need to reduce these by
15%.
Is there anyway I can get a formula that just updates the values all at
the
same time without using another column to show the values in. I tried to
use
the formula you gave below and I can update each cell using the formaula
for
example =b3*1.15 but that would be cumbersome to do that for over a
hundred
values. Unfortuantely for some reason I to dont have the multiply option
when
you go to paste special etc. It simply gives the option of pasting either
in
text or unicode.
Any help
"Jim Cone" wrote:
Enter 1.1 in a blank cell.
Copy the cell.
Select the column of prices.
Go to... Edit (menu) | Paste Special | Multiply (button) - click Ok.
Press the Escape key.
Delete 1.1 in the blank cell.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"Tom McLean"
wrote in message
Is it possible to update or change the values in a range of cells by a
certain percentage? What I'm trying to do is apply a 10% increase to a
column
of prices (several hundred cells long) without doing it manually one by
one
or creating a new column (B) that references the values in the first
column
(A) and then manipulates the values by X%.
Basically, I'm supposed to update the price list without changing it's
present format. I expect to need to do this again in the future several
times
and it would be wonderful if there was some way to do it quickly and
easily.
Thanks for any ideas!!
Tom
__________ Information from ESET Smart Security, version of virus
signature database 4830 (20100203) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus signature database 4830 (20100203) __________
The message was checked by ESET Smart Security.
http://www.eset.com