| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying one cell by a column
I'm trying to multiply column B3:12 by cell W5. B3:12 contains a set number
and I'm trying to multiply that number by the formula result in W5. I've tried every special paste option and combo. Also W5 is connected to a spinner. I need B3:12 to adjust as W5 does. So far I've had to manually link all the cells to W5. Uggh. Any help appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiplying one cell by a column
In C3 enter =B3 * W5
Drag/copy down to B12 Gord Dibben MS Excel MVP On Mon, 4 Feb 2008 20:13:01 -0800, Chrj15 wrote: I'm trying to multiply column B3:12 by cell W5. B3:12 contains a set number and I'm trying to multiply that number by the formula result in W5. I've tried every special paste option and combo. Also W5 is connected to a spinner. I need B3:12 to adjust as W5 does. So far I've had to manually link all the cells to W5. Uggh. Any help appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiplying one cell by a column
Doing this causes the next cell to multiply by W6, and the next by W7...so
on..... "Gord Dibben" wrote: In C3 enter =B3 * W5 Drag/copy down to B12 Gord Dibben MS Excel MVP On Mon, 4 Feb 2008 20:13:01 -0800, Chrj15 wrote: I'm trying to multiply column B3:12 by cell W5. B3:12 contains a set number and I'm trying to multiply that number by the formula result in W5. I've tried every special paste option and combo. Also W5 is connected to a spinner. I need B3:12 to adjust as W5 does. So far I've had to manually link all the cells to W5. Uggh. Any help appreciated. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiplying one cell by a column
=B3 * $W$5
Tyro "Chrj15" wrote in message ... Doing this causes the next cell to multiply by W6, and the next by W7...so on..... "Gord Dibben" wrote: In C3 enter =B3 * W5 Drag/copy down to B12 Gord Dibben MS Excel MVP On Mon, 4 Feb 2008 20:13:01 -0800, Chrj15 wrote: I'm trying to multiply column B3:12 by cell W5. B3:12 contains a set number and I'm trying to multiply that number by the formula result in W5. I've tried every special paste option and combo. Also W5 is connected to a spinner. I need B3:12 to adjust as W5 does. So far I've had to manually link all the cells to W5. Uggh. Any help appreciated. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiplying one cell by a column
you just saved me so much time.....thanks a bunch....wont forget that trick
"Tyro" wrote: =B3 * $W$5 Tyro "Chrj15" wrote in message ... Doing this causes the next cell to multiply by W6, and the next by W7...so on..... "Gord Dibben" wrote: In C3 enter =B3 * W5 Drag/copy down to B12 Gord Dibben MS Excel MVP On Mon, 4 Feb 2008 20:13:01 -0800, Chrj15 wrote: I'm trying to multiply column B3:12 by cell W5. B3:12 contains a set number and I'm trying to multiply that number by the formula result in W5. I've tried every special paste option and combo. Also W5 is connected to a spinner. I need B3:12 to adjust as W5 does. So far I've had to manually link all the cells to W5. Uggh. Any help appreciated. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiplying one cell by a column
Apologies for not adding the $ signs to W5.
I see Tyro has made the correction. Gord On Mon, 4 Feb 2008 21:03:05 -0800, Chrj15 wrote: Doing this causes the next cell to multiply by W6, and the next by W7...so on..... "Gord Dibben" wrote: In C3 enter =B3 * W5 Drag/copy down to B12 Gord Dibben MS Excel MVP On Mon, 4 Feb 2008 20:13:01 -0800, Chrj15 wrote: I'm trying to multiply column B3:12 by cell W5. B3:12 contains a set number and I'm trying to multiply that number by the formula result in W5. I've tried every special paste option and combo. Also W5 is connected to a spinner. I need B3:12 to adjust as W5 does. So far I've had to manually link all the cells to W5. Uggh. Any help appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiplying specific data within a range to get column totals | Excel Worksheet Functions | |||
| Multiplying a column of data by a constant | Excel Discussion (Misc queries) | |||
| Multiplying A Whole Column By 2 ??? Help | Excel Discussion (Misc queries) | |||
| multiplying a cell by a set number | Excel Discussion (Misc queries) | |||
| multiplying an enitre column. | Excel Discussion (Misc queries) | |||
Linear Mode
