Multiply a range of numbers by a cell ?

**Table10sHotShot** · 11-26-2006, 03:27 PM

Is it possible to multiply an arrange of numbers by a cell?

For example:

A B
1 x
2
3
4
5

Is there a way to multiply A2:A6 by whatever value is in B2? I want to be able to change B2 and have the numbers in A2:A6 change.

Thanks,
Bob

**VBA Noob** · 11-26-2006, 03:31 PM

Try

=SUMPRODUCT(A2:A6)*B2

VBA Noob

**Carim** · 11-26-2006, 03:32 PM

Hi,

Do you mean =A2*$B$2 ... in cell C2 ...
and copied down ... ?

HTH
Carim

**Table10sHotShot** · 11-26-2006, 03:48 PM

That's not what I meant.

I want to multiply the numbers in the array by the cell, where the numbers in the array don't change but the number in the single cell can. If C2 = 2, then I would want A to look like...

A B
2 2
4
6
8
10

If I changed C2 to be 3, then I would want A to look like...

A B
6 3
9
12
15
18

I don't care if the results of the multiplication are in a new array of cells eg.

A B C
1 6 3
2 9
3 12
4 15
5 18

Here A2:A6 is multiplied by the value of C2, and the results are displayed in B2:B6 instead of replacing the values of A2:A6.

Thanks,
Bob

**Table10sHotShot** · 11-26-2006, 03:57 PM

Nevermind I got it working with the $'s... thanks guys.

Thanks,
Bob

**Carim** · 11-26-2006, 04:05 PM

Hi,

You can also get it done with an event macro

Please Login or Register  to view this content.

HTH
Carim

Multiply a range of numbers by a cell ?

LinkBack

Thread Tools

Rate This Thread

Display

Multiply a range of numbers by a cell ?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions