Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LRM LRM is offline
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default 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

  #4   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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 am not human. I am an Excel Wizard
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting multiple cells into a single cell David New Users to Excel 2 January 29th 09 01:04 AM
Concatenate Multiple Cells into A Single Cell [email protected] Excel Discussion (Misc queries) 2 May 6th 08 09:14 PM
How to Copy single Cell into Multiple cells Nitesh Mathur Excel Worksheet Functions 3 December 12th 07 09:35 AM
Using a single cell value to repopulate multiple cells Chris_NetworkRail Excel Worksheet Functions 2 March 28th 07 02:19 AM
Using a single cell value to repopulate multiple cells Chris_NetworkRail Excel Discussion (Misc queries) 8 March 28th 07 12:12 AM


All times are GMT +1. The time now is 03:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"