| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting multiple cells into a single cell | New Users to Excel | |||
| Concatenate Multiple Cells into A Single Cell | Excel Discussion (Misc queries) | |||
| How to Copy single Cell into Multiple cells | Excel Worksheet Functions | |||
| Using a single cell value to repopulate multiple cells | Excel Worksheet Functions | |||
| Using a single cell value to repopulate multiple cells | Excel Discussion (Misc queries) | |||
![Fred Smith[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
