Percentage formula

[Closed]
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,

Please help me for percentage formula, i want to have a price increse thru percentage, how can i do this in one formula only.As in i can just highlight all the existing price of all the items and there will be an answer in column of 10% as well as in 14% column.

Item Existing Price Increase Increase
10% 14%

q1 10
q2 20
q3 30
q4 40
q5 50
q6 60
q7 70
q8 80
q9 90
q10 100

1 reply

Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
Let's say you have a list of values in A1:A10 and you need to increase these values all by 10%. Here is how;

1. Enter the number 1.10 into any blank cell and then Copy it
2. Now select the range A1:A100 and go to Edit>Paste Special
3. Choose Values from under Paste and then Multiply under Operation and click OK.

All value will now have increased by 10%

To decrease the values by 10% you would simply Enter =.901 in any blank cell and repeat the above steps ......

7
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month