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