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?