We resell international telephone service and need to be able to replace the values we get from our supplier in a column with a value that is 25% greater. I think there must be a way to use a formula to do this. We should be able to apply the formula and it re-populate the cells with the new value.
Thanks.

Hi Woolfie:

There is no direct way to update a series of cells by a percetage.

Here are some options:

You can use the copy paste special:

Enter 1.25 in an empty cell somewhere copy it, then select the cells you
want to update and do paste special values and select mutilply.

You could enter a formula in another column and enter =B2*(1+$C$1) and copy
it down where b2 is the first value to increment and $C$1 is the rate (ie
0.25).

You could write a macro to do it:

sub IncreaseValues

const dRate as double = 1.25
dim rCell as range

on error resume next

for each rCell in selection
rCell.value = rCell.value *1.25
next rCell

end sub

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"woolfie" wrote:


We resell international telephone service and need to be able to replace
the values we get from our supplier in a column with a value that is 25%
greater. I think there must be a way to use a formula to do this. We
should be able to apply the formula and it re-populate the cells with
the new value.
Thanks.




--
woolfie

Copy Paste Special is fine

Percentage is only a number
Adding 25% is the same as Multiplying by 1.25


Steve

On Thu, 25 Jan 2007 07:06:03 -0000, Martin Fishlock
wrote:

Hi Woolfie:

There is no direct way to update a series of cells by a percetage.

Here are some options:

You can use the copy paste special:

Enter 1.25 in an empty cell somewhere copy it, then select the cells you
want to update and do paste special values and select mutilply.

You could enter a formula in another column and enter =B2*(1+$C$1) and
copy
it down where b2 is the first value to increment and $C$1 is the rate (ie
0.25).

You could write a macro to do it:

sub IncreaseValues

const dRate as double = 1.25
dim rCell as range

on error resume next

for each rCell in selection
rCell.value = rCell.value *1.25
next rCell

end sub

Yes, but don't fall into the trap of putting 25% into a cell, copying that,
and using Paste Special/ Add.
--
David Biddulph

"SteveW" wrote in message
news:op.tmpay6pjevjsnp@enigma03...
Copy Paste Special is fine

Percentage is only a number
Adding 25% is the same as Multiplying by 1.25


Steve

On Thu, 25 Jan 2007 07:06:03 -0000, Martin Fishlock
wrote:

Hi Woolfie:

There is no direct way to update a series of cells by a percetage.

Here are some options:

You can use the copy paste special:

Enter 1.25 in an empty cell somewhere copy it, then select the cells you
want to update and do paste special values and select mutilply.

You could enter a formula in another column and enter =B2*(1+$C$1) and
copy
it down where b2 is the first value to increment and $C$1 is the rate (ie
0.25).

You could write a macro to do it:

sub IncreaseValues

const dRate as double = 1.25
dim rCell as range

on error resume next

for each rCell in selection
rCell.value = rCell.value *1.25
next rCell

end sub