Number manipulation

  • Thread starter Thread starter westvilla
  • Start date Start date
W

westvilla

I have price sheet of factory prices in spreadsheet form. What I need t
do is update all of them by a certain percentage(which constantl
changes)

I there a way to change all of them by multiplying by a variable wit
out typing through every cell?

It's very tedious.

Please help.

Ryan:confused
 
Hi
note: you will loose your original data with the following procedure:
- enter your percentage in an empty cell
- copy this empty cell
- select all cells which should be changed
- goto 'Edit - Paste Special' and choose 'Multiply'
 
In a empty cell somewhere put in 1.03 for a 3% increase
copy
select cells to modify by using ctrl key and selecting each
edit>paste special >multiply

you may want to record a macro while you do this
 
Personally I would probably work with a helper sheet, leaving all the data on my
source sheet intact. This means that assuming your factory prices are all on a
sheet called Sheet1 and lets assume they are in the range B5:K100, then on
Sheet2 in cell A1 put 100%. Now in cell B5 on sheet 2 put the following
formula:-

=Sheet1!B5*$A$1

Then copy that cell, and paste it across B5:K100 on Sheet2

Now you can simply change the % in cell A2 and all the values in B5:K100 will
change to reflect the factory prices * %.

If you want to keep everything on the same sheet, then on your sheet1 in cell A1
put 100%. In any other blank cell put =$A$1, then copy that cell, select
B5:K100 and do Edit / Paste Special / Multiply. Every value in B5:K100 will now
look like the following:-

=25.50*($A$1)

So you can now alter all the values you see simply by changing the % in A1.
 
Back
Top