| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ?
I HAVE A COLUMN OF 200 CELLS THAT I WANT TO MULTIPLY BY A CONSTANT CELL.
HOW DO I LOCK THE CONSTANT CELL IN THE FORMULA SO WHEN I COPY IT DOWN THE COLUMN THAT CELL STAYS THE SAME ? EXAMPLE: THE CONSTANT CELL IS H7, WHEN I COPY THE FORMULA FROM THE FIRST CELL (A1*H7), I WANT THE 200 CELLS TO FOLLOW HAVING THE SAME CONSTANT CELL - B1*H7, C1*H7, D1*H7, E1*H7, ...... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to multiply whole of excel table by some constant | Excel Discussion (Misc queries) | |||
| formula for multiply one cell to one of two other cells? | Excel Discussion (Misc queries) | |||
| Need Help Creating a Macro to Multiply Cells by a Constant Number | Excel Discussion (Misc queries) | |||
| can i multiply digits of a number by a constant in excel? | Excel Discussion (Misc queries) | |||
| Multiply by a constant | Excel Discussion (Misc queries) | |||
Threaded Mode
