% formula


S

scr

Is there a way to take an excel spreadsheet full of numbers and have all
those numbers change if you asked for a different % of the original.

For example: if at 100% my numbers read across the top
10.00, 20.00, 30.00, 40.00
but if I changed the % to 90% my numbers would change to
9.00, 18.00, 27.00, 36.00
and if I changed the % to 50% my numbers would change to
5.00, 10.00, 15.00, 20.00

I know I could put the % into a cell and formula and have that change, but
how do I keep my original value & have it update in that same cell. Is that
even possible?
 
Ad

Advertisements

G

Gord Dibben

If you do operations on the original numbers, they will not be retained in the
same cell.

To change a range at one whack without formulas.............

Enter 90% in an empty cell. Copy that cell.

Select the range to change and Edit>Paste Special>Multiply>OK>Esc.

Assuming range of original numbers is A1:E100

To retain the originals, enter a formula in G1 such as =A1*$F$1 where F1
contains 90% or whatever you wish.

Copy that formula across 5 columns and down 100 rows.

When you change the 90% to 50% the result cells will change but originals will
not.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top