On Friday, January 4, 2013 12:54:46 PM UTC-8, tb wrote:
On 1/4/2013 at 1:51:56 PM wrote:





Hi tb,



From a google search:

(adjust the ranges and percentage amount to your needs)



Increase Selected Numbers by a Percentage.

You may want to increase all the numbers in a range by a set

percentage. For example, in this price list, all the prices should be

increased by 5%. The following technique makes it easy to increase

the prices, all at once. In a blank cell, enter the amount of the

increase. In this example, 1.05 was entered in cell D8 Copy the cell

which contains the increase amount. Select the cells which contain

the amounts that you want to increase. Here, cells B8:B11 are

selected. On the menu bar, click Edit | Paste Special Click Values,

and click Multiply, then click OK. Each of the selected numbers is

automatically increased by 5%



Regards,

Howard



Thanks, Howard!



A follow-up question: Is there a way to round/truncate the results to

two decimals?



Best regards.

--

tb

After you have... "Paste Special Values Multiply OK" your field of prices that you have just increased should still be selected. Click Home Number 'click decrease (or increase) decimal points icon' until two.

Should get you there.

Regards,
Howard