Percentage increase

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lynne Mawson - 29 Mar 2007 11:46 GMT

I have a spreadsheet with 3 columns of figures. There is a price increase of
6% this year but I don't know how to use the existing spreadsheet and add the
6% to all 3 columns.

Signature

Lynne Mawson
Manchester

Reply to this Message

JE McGimpsey - 29 Mar 2007 12:48 GMT

One way:

Put 1.06 in an empty cell. Copy the cell. Select the values in the three
columns. Choose Edit/Paste Special, selecting the Values and Multiply
radio buttons. Click OK.

> I have a spreadsheet with 3 columns of figures. There is a price increase of
> 6% this year but I don't know how to use the existing spreadsheet and add the
> 6% to all 3 columns.

Reply to this Message

Lynne Mawson - 29 Mar 2007 14:02 GMT

GE McGimpsey - you are a star! Saved me hours of messing around. Thanks.

Signature

Lynne Mawson
Manchester

> One way:
>
[quoted text clipped - 5 lines]
> > 6% this year but I don't know how to use the existing spreadsheet and add the
> > 6% to all 3 columns.

Reply to this Message