| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 column multiplied by 1 row throughout sheet
I want to copy a formula from 1 cell or a group of cells in which the column
and row values will not change. Ex: Cell D6 = C6*D5 Cell H11 = C11*H5 Cell J15 = C15*J5 I want to be able to copy this formula into several cells without the C or the 5 changing. How can this be achieved? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I input a number it is being multiplied 10,000 | Excel Discussion (Misc queries) | |||
| Column multiplied by single cell | Excel Worksheet Functions | |||
| pounds multiplied by hours | Excel Worksheet Functions | |||
| same cell multiplied by set value | Excel Discussion (Misc queries) | |||
| Multiplied Values | Excel Discussion (Misc queries) | |||
Threaded Mode
