Formula Constant

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Let's assume your constant is stored in cell A1. In your formula, refer to
A1 as $A$1. This will prevent Excel from adjusting that reference when you
copy & paste.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

use the number in one cell for different formulas 2
help needed in excel 07 0
Simplifying array formula which evaluates as error. 5
Mapping integers to strings 5
Percentage of Multiple Rows 2
Formula constants? 2
Excel Excel Formula OFFSET maybe? 1
How do I keep the divisor constant in calculating percentage remai 3

Back
Top