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 |
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 |