| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I add a similar amount to a full column of prices
I have a price list with varying percentage profits according to amounts
purchased. I have a set 10p/ltr increase to me and want to make a 10p increase in every row. How can I get this +10p to repeat down the list |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I add a similar amount to a full column of prices
Just describe what you have at the moment in a bit more detail.
Pete On Apr 16, 7:01*pm, Colbirds wrote: I have a price list with varying percentage profits according to amounts purchased. I have a set 10p/ltr increase to me and want to make a 10p increase in every row. *How can I get this +10p to repeat down the list |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I add a similar amount to a full column of prices
If you loking for increase all prices in 10%
type 1.1 in one cell, copy it select the price range right click past special select value and multiply hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Colbirds" escreveu: I have a price list with varying percentage profits according to amounts purchased. I have a set 10p/ltr increase to me and want to make a 10p increase in every row. How can I get this +10p to repeat down the list |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I add a similar amount to a full column of prices
A way to do this and give yourself the option of still using Goal Seek and
other tools is to put 110% in a cell with the cell left of it labeled increase. Then in the first cell that you want to increase, multiply the results of the current formula by the cell containing 110% and hit the F4 key on your keyboard to make the reference absolute (ie. $B$10). After doing that to the first cell, fill that formula down through the range and you are done. Cool thing about this method is that if you want to change to 105%, just select that cell, type 105 and hit enter. "Colbirds" wrote: I have a price list with varying percentage profits according to amounts purchased. I have a set 10p/ltr increase to me and want to make a 10p increase in every row. How can I get this +10p to repeat down the list |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I add a similar amount to a full column of prices
If not percentage but straight addition of 10p just nter 10 in a cell.
Copy then select the range to change and Paste SpeciaAddOKEsc Gord Dibben MS Excel MVP On Wed, 16 Apr 2008 11:01:00 -0700, Colbirds wrote: I have a price list with varying percentage profits according to amounts purchased. I have a set 10p/ltr increase to me and want to make a 10p increase in every row. How can I get this +10p to repeat down the list |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I subtract 20% from a column of prices? | Excel Worksheet Functions | |||
| How do I convert number into full text amount | Excel Discussion (Misc queries) | |||
| How do I convert number into full text amount | Excel Discussion (Misc queries) | |||
| Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions | |||
| Need to add a certain percentage to a column of prices | Excel Worksheet Functions | |||
Linear Mode
