Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove function
Hi everyone. Ok I have a little dilemma.
My company has a 36 page pricelist with a list of about 40 or more prices/page. In 2007 we are applying a 7% increase in all prices. With the use of a function I created an additional column that has the 7% increase. Now I want to cut and paste that column where the other price column was before, but when I try to do that all I get is ###### because the old price column is being used in the function that calculates the new price column. This is the only way I know how to increase by a percent. QUESTION: Is there a way to increase a given value by a percent without having to add columns? The way I been doing it is =C11*(1+F11) where C11 is the amount and F11 is 7% (the increase). Shayra |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove function
in an empty cell enter 1.07
copy that cell select all the cells you want to change paste special multiply "Shayra" wrote: Hi everyone. Ok I have a little dilemma. My company has a 36 page pricelist with a list of about 40 or more prices/page. In 2007 we are applying a 7% increase in all prices. With the use of a function I created an additional column that has the 7% increase. Now I want to cut and paste that column where the other price column was before, but when I try to do that all I get is ###### because the old price column is being used in the function that calculates the new price column. This is the only way I know how to increase by a percent. QUESTION: Is there a way to increase a given value by a percent without having to add columns? The way I been doing it is =C11*(1+F11) where C11 is the amount and F11 is 7% (the increase). Shayra |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove function
Hi bj.
Thank you. This works also BUT I'm sending this to our retailers and I don't want them to know the exact % of increase I just want them to see the new prices. Because I was just told some prices are increasing while others are not. Can I increase the entire price column by 7% without having to add an additional cell. I've tried doing =76.99*(1+0.07%) in the actual price cell (where 76.99 is the amount to be increased). But by doing it that way I have to do each price cell individually and Im trying to avoid that. Can you help me, please? "bj" wrote: in an empty cell enter 1.07 copy that cell select all the cells you want to change paste special multiply "Shayra" wrote: Hi everyone. Ok I have a little dilemma. My company has a 36 page pricelist with a list of about 40 or more prices/page. In 2007 we are applying a 7% increase in all prices. With the use of a function I created an additional column that has the 7% increase. Now I want to cut and paste that column where the other price column was before, but when I try to do that all I get is ###### because the old price column is being used in the function that calculates the new price column. This is the only way I know how to increase by a percent. QUESTION: Is there a way to increase a given value by a percent without having to add columns? The way I been doing it is =C11*(1+F11) where C11 is the amount and F11 is 7% (the increase). Shayra |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove function
Shayra
After the Paste SpecialMultiplyOKEsc just delete the cell with the 1.07 The prices will have all been changed by 7% increase but retailers won't know original prices. Gord Dibben MS Excel MVP On Fri, 8 Dec 2006 11:31:01 -0800, Shayra wrote: Hi bj. Thank you. This works also BUT I'm sending this to our retailers and I don't want them to know the exact % of increase I just want them to see the new prices. Because I was just told some prices are increasing while others are not. Can I increase the entire price column by 7% without having to add an additional cell. I've tried doing =76.99*(1+0.07%) in the actual price cell (where 76.99 is the amount to be increased). But by doing it that way I have to do each price cell individually and Im trying to avoid that. Can you help me, please? "bj" wrote: in an empty cell enter 1.07 copy that cell select all the cells you want to change paste special multiply "Shayra" wrote: Hi everyone. Ok I have a little dilemma. My company has a 36 page pricelist with a list of about 40 or more prices/page. In 2007 we are applying a 7% increase in all prices. With the use of a function I created an additional column that has the 7% increase. Now I want to cut and paste that column where the other price column was before, but when I try to do that all I get is ###### because the old price column is being used in the function that calculates the new price column. This is the only way I know how to increase by a percent. QUESTION: Is there a way to increase a given value by a percent without having to add columns? The way I been doing it is =C11*(1+F11) where C11 is the amount and F11 is 7% (the increase). Shayra |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I know which cell a function is called from? | Excel Worksheet Functions | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Remove the paste function in a worksheet | Excel Worksheet Functions | |||
how do I remove fx from the function line, can't enter data | New Users to Excel | |||
Conversion | Excel Worksheet Functions |