**Question description:**

*This user has given permission to use the problem statement for this blog.*

In my spread sheet I want to create a column where I can take a % off a number and all the numbers in a column will change by that %. I want to be able to change the % to see different results

Solved by V. U. in 36 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
15/03/2018 - 05:10

Hi, welcome to Got It

Excelchat Expert
15/03/2018 - 05:10

Let me assume the values in column A as multipled of 100

Excelchat Expert
15/03/2018 - 05:12

Do you want to find a% of a number ??

Excelchat Expert
15/03/2018 - 05:13

Hello!!!

Excelchat Expert
15/03/2018 - 05:17

Let us take 'a' as 20 %

Excelchat Expert
15/03/2018 - 05:17

So, we need to find 20% of values which are in column A

User
15/03/2018 - 05:18

In column A is a large group of retail prices and I want to run a promo 10% off I want to create another column that will show the 10% off and be able to change that % to see different results

User
15/03/2018 - 05:18

Yes

Excelchat Expert
15/03/2018 - 05:19

Do you want to find the discounted price?

User
15/03/2018 - 05:19

Yes

Excelchat Expert
15/03/2018 - 05:19

Okay

Excelchat Expert
15/03/2018 - 05:19

In column A we took values as multiples of 100

Excelchat Expert
15/03/2018 - 05:20

Let discount be 20%

Excelchat Expert
15/03/2018 - 05:20

So, discounted price is 80% of actual price

Excelchat Expert
15/03/2018 - 05:21

We will write a formula to multiply Actual price by (100-discount %)

Excelchat Expert
15/03/2018 - 05:22

Did you get it?

Excelchat Expert
15/03/2018 - 05:22

e used this formula:

Excelchat Expert
15/03/2018 - 05:23

=A3*(100-$B$1)/100

Excelchat Expert
15/03/2018 - 05:23

We used $B$1, because, we don't want to change the reference when we copy the formula

User
15/03/2018 - 05:24

I did it that way and it work in the first space but when I copied it down I lost my forumula

Excelchat Expert
15/03/2018 - 05:24

So all the cells will be multiplied by same value

Excelchat Expert
15/03/2018 - 05:24

We need to use $B$1

Excelchat Expert
15/03/2018 - 05:24

For fixing refernce

Excelchat Expert
15/03/2018 - 05:25

If we don't use fixed reference, the multiplied value will change when you copy the formula

Excelchat Expert
15/03/2018 - 05:25

So, when we use $ symbol, the reference is fixed

Excelchat Expert
15/03/2018 - 05:25

Did you get it

Excelchat Expert
15/03/2018 - 05:25

?

User
15/03/2018 - 05:26

I will give it a try Appreciate your help

Excelchat Expert
15/03/2018 - 05:26

Please try it now and confirm

Excelchat Expert
15/03/2018 - 05:27

You can try it on the excel sheet so that I can see

Excelchat Expert
15/03/2018 - 05:44

Did you get how to do it??

Excelchat Expert
15/03/2018 - 05:45

Hello!

Excelchat Expert
15/03/2018 - 05:45

Awesome

Excelchat Expert
15/03/2018 - 05:45

Do you need any further explanation?

Excelchat Expert
15/03/2018 - 05:46

Welcome.

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*