[pussar]

Hello !

I have some problems, of course.

first problem: english is not my main language so sorry for any typos.
second problem is a excel problem:

I have a table with say 300+ prices, I would like to increase all the
prices
with 2%, how would I do that

I have tried to make this work for a while now but I can't make it
work.
please help me.....

Thanks for beeing out there ... :)


--
pussar
------------------------------------------------------------------------
pussar's Profile: http://www.excelforum.com/member.php...o&userid=37492
View this thread: http://www.excelforum.com/showthread...hreadid=571469

[Niek Otten]

Format an empty cell as Number. Enter the number 1.02
EditCopy
Select your cells to be updated
EditPaste Special, check Multiply

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"pussar" wrote in message
...
|
| Hello !
|
| I have some problems, of course.
|
| first problem: english is not my main language so sorry for any typos.
| second problem is a excel problem:
|
| I have a table with say 300+ prices, I would like to increase all the
| prices
| with 2%, how would I do that
|
| I have tried to make this work for a while now but I can't make it
| work.
| please help me.....
|
| Thanks for beeing out there ... :)
|
|
| --
| pussar
| ------------------------------------------------------------------------
| pussar's Profile: http://www.excelforum.com/member.php...o&userid=37492
| View this thread: http://www.excelforum.com/showthread...hreadid=571469
|

[Dave Peterson]

Put 1.02 in an empty cell
select that cell
edit|Copy
select your range to adjust
edit|paste special|check multiply

clean up that cell with 1.02 in it.

pussar wrote:

Hello !

I have some problems, of course.

first problem: english is not my main language so sorry for any typos.
second problem is a excel problem:

I have a table with say 300+ prices, I would like to increase all the
prices
with 2%, how would I do that

I have tried to make this work for a while now but I can't make it
work.
please help me.....

Thanks for beeing out there ... :)

--
pussar
------------------------------------------------------------------------
pussar's Profile: http://www.excelforum.com/member.php...o&userid=37492
View this thread: http://www.excelforum.com/showthread...hreadid=571469

--

Dave Peterson