Previous Topic Next Topic

Percentage formula

Closed
thess - Jun 3, 2009 at 03:57 AM
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
 - Jun 3, 2009 at 05:08 AM
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

Answer 1 / 1
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
 159
Jun 3, 2009 at 05:08 AM
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