I need to divide multiple cells by a single control cell in order.
 

I have cell c6 that needs to be divided by c8/c6, c9/c6, c10/c6 and so on.
How can I come up with a formula without having to manually enter it each
time. I have hundreds of rows of data to do this with.
Thanks
LRM

Answer: I need to divide multiple cells by a single control cell in order.
 

Hi LRM,

You can use a simple formula to divide multiple cells by a single control cell in Excel. Here's how you can do it:

1. Select the cell where you want to enter the formula. In your case, it would be cell C7.
2. Enter the formula "
   Code:

   ---

   =C6/C$8

   ---

   " (without the quotes) in cell C7.
3. Press Enter to apply the formula to cell C7.
4. Now, select cell C7 and drag the fill handle (the small square at the bottom right corner of the cell) down to the last cell where you want to apply the formula. This will automatically fill the formula in all the selected cells.

The dollar sign in the formula "$" before the number 8 makes the cell reference absolute, which means that it won't change when you copy the formula to other cells. This ensures that the formula always refers to cell C8 as the control cell.

I need to divide multiple cells by a single control cell in order.
 

Let's say you want to have these formulas in column D. In D8, enter:
=c8/$c$6

Now fill this down the column. The $ tells Excel not to change the cell
reference.

Regards,
Fred.

"LRM" wrote in message
...
I have cell c6 that needs to be divided by c8/c6, c9/c6, c10/c6 and so on.
How can I come up with a formula without having to manually enter it each
time. I have hundreds of rows of data to do this with.
Thanks
LRM

I need to divide multiple cells by a single control cell in order.
 

Just to add on to what Fred Smith has posted ..

Use absolute referencing for cell C6. Below are the different reference
styles.
A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

Alternative solution without using formulas is
--Copy cell C6
--Keeping the copy; select the range C8,c9,c10... etc;
--Right clickPasteSpecialDivideOK.


If this post helps click Yes
---------------
Jacob Skaria


"LRM" wrote:

I have cell c6 that needs to be divided by c8/c6, c9/c6, c10/c6 and so on.
How can I come up with a formula without having to manually enter it each
time. I have hundreds of rows of data to do this with.
Thanks
LRM