one formula to make a multiplication table work

P

Paige

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.
 
A

Arvi Laanemets

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
 
B

Biff

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
 
P

Paige

Thank you very much, that worked.

Arvi Laanemets said:
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
Click to expand...
 
Top