Is it possible to increase let's say by 5% all the numbers on one page?

Thanks

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

numberson the original sheet, but might be problematic if the numbers are the result of a formula.Again, telling us what you

reallywant to do might help us come up with a more specific solution.

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

Example:unit price installation conextion total unit

100 35 35 170

I hope it help

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?

Ok

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

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*.05That 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:G1The result should be:

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

It is exactly what I needed.

Thank's so mutch

Norm

Ask Your Question

Weekly Poll