% formula



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?



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

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