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.
