How to apply a 25% price increase to a column of rates.
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. |
How to apply a 25% price increase to a column of rates.
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 |
How to apply a 25% price increase to a column of rates.
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 |
How to apply a 25% price increase to a column of rates.
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 |
All times are GMT +1. The time now is 12:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com