Increase cell range by percentage

[SpaceCamel]

I have a range of cells with values I need to increase by a percentage.

Is there a simple way to do that?

Thanks,

[Niek Otten]

If you want to increase by 5%:

Format an empty cell as Number. Enter the number 1.05. Edit>Copy.
Select your range. Edit>Paste Special, check Multiply.

Make a copy of your workbook before you try.

--
Kind regards,

Niek Otten

"SpaceCamel" <SpaceCamel@discussions.microsoft.com> wrote in message news:DC0214AA-D314-4F74-929B-4230166CF1B4@microsoft.com...
>I have a range of cells with values I need to increase by a percentage.
>
> Is there a simple way to do that?
>
> Thanks,

[SpaceCamel]

Never mind, found the answer on the General Questions board.

"SpaceCamel" wrote:

> I have a range of cells with values I need to increase by a percentage.
>
> Is there a simple way to do that?
>
> Thanks,