# Excel - COLUMN Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.