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
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 3, 2009 at 05:08 AM
Related:
- Percentage formula
- Excel marksheet percentage formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
Jun 3, 2009 at 05:08 AM
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 ......
