Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Constant
I'm using Excel 2003 to develop a 2006 P&L budget. If Total Sales equals
100%, then, I want to use number in this cell as a constant divisor. I want each cell in the column to be divided by this constant. There are over 100 expense lines, so manually entering the formula would be a pain. I tried copy/paste special and the divisor moves to the next row down. Can you help? Thanks! Dale |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy a formula maintaining a constant cell | Excel Worksheet Functions | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
keep a cell used in a formula constant when pasteing into another. | Excel Worksheet Functions | |||
keep a cell used in a formula constant when pasteing into another. | Excel Worksheet Functions |