Yes. Let's say your original numbers are in column A and we want the
adjusted numbers to appear in column B.

We will use cell C1 as a helper cell and put 5 in it.

In B1 enter:
=A1*(1-$C$1/100) and copy this formula down the column. You will see:

100 95
200 190
400 380
600 570
500 475


If you change the values in column A, the values in column B will also change.
If the change the value in C1, the values in column B will change.

You can even make C1 a negative value to get column B to increase.

Have a pleasant weekend !
--
Gary's Student


"brawny_javo" wrote:

Hello--
I have a spreadsheet that has numerical values in one column, and then
I want to have a column next to it that shows the equivalent of each
value from the first column minus X%, where X is a value that I can
change from time to time. For instance, if the first column lists 100,
200, 400, 600, & 500, and I choose 5 to be the value of X, then the
second column will list 95, 190, 380, 570, & 475. If I change the
value of X to 9 (and don't change any of the values in the first
column), the second column will then list 91, 182, 364, 546, & 455.
Is there a function or a macro that can do this?

Thanks,
Stephen