one formula to make a multiplication table work
 

I am looking for the one formula in the upper left hand box that can be
copied thru the worksheet to make a multiplacation table work.

Hi

With numbers from 1 to 10 in both ranges B1:K1 and A2:A11, into cell B2
enter the formula
=$A2*B$1
, and copy to range A2:K12


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"Paige" wrote in message
...
I am looking for the one formula in the upper left hand box that can be
copied thru the worksheet to make a multiplacation table work.

Hi!

I assume you have 1,2,3,4 etc going down a column and across a row.

Try this:

=ROW(A1)*COLUMN(A1)

Copy across then down or down then across.

Biff

"Paige" wrote in message
...
I am looking for the one formula in the upper left hand box that can be
copied thru the worksheet to make a multiplacation table work.

Thank you very much, that worked.

"Arvi Laanemets" wrote:

Hi

With numbers from 1 to 10 in both ranges B1:K1 and A2:A11, into cell B2
enter the formula
=$A2*B$1
, and copy to range A2:K12


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"Paige" wrote in message
...
I am looking for the one formula in the upper left hand box that can be
copied thru the worksheet to make a multiplacation table work.