Increase all numbers on excel

October 21, 2010 at 07:50:21
Specs: Windows XP
Is it possible to increase let's say by 5% all the numbers on one page?

See More: Increase all numbers on excel

October 21, 2010 at 08:23:33
You might want to be more specific as to what you are actually trying to do.

PasteSpecial allows you perform some basic mathematical operations on values in cells, but "increase by a specific percentage" isn't one if them.

However, there may be a workaround.

You could calculate 5% of each number on another sheet, perform a PasteSpecial...Values to eliminate the formulas on that sheet and then PasteSpecial...Add those values to the values on the original sheet.

This should work for actual numbers on the original sheet, but might be problematic if the numbers are the result of a formula.

Again, telling us what you really want to do might help us come up with a more specific solution.

Report •

October 21, 2010 at 10:50:57

To be more specific, the page I use is: unit prices for spécific items and total.

unit price installation conextion total unit

100 35 35 170

I hope it help

Report •

October 21, 2010 at 11:18:00
You've given us a hint of what your data looks like, but I'm still not sure what you are trying to do.

If that's the "input" data, what should the "output" look like?

Report •

Related Solutions

October 21, 2010 at 11:30:47
All numbers are increased by 5%

Unit price from 100 to 105
installation fron 35 to36.75
conecxion from 35 to36.75
total from 170to178.50

Report •

October 21, 2010 at 11:51:28
I'm going to assume that your data looks like this. A1:C1 contain actual values, D1 contains a formula:

     A     B     C        D    
1   100    35    35  =SUM(A1:C1) 

If that's the case, try this:

      A    B     C        D          E         F        G  
1   100   35     35  =SUM(A1:C1)  =A1*.05   =B1*.05  =C1*.05

That will give you 5% of each figure in A1:C1

- Select E1:G1
- Edit...Copy
- Edit...PasteSpecial...Values
- Select A1:C1
- Edit...PasteSpecial...Add
- Delete E1:G1

The result should be:

     A      B      C        D
1   105   36.75  36.75   =SUM(A1:C1)

Report •

October 21, 2010 at 21:04:28
It is exactly what I needed.
Thank's so mutch

Report •

Ask Question