Multiplication Table

[Faehnfare]

I am a math teacher wanting to know the best way to make a multiplication
table. I tried one way but kept getting the "Inconsistent Formula" error.

 

[Paul B]

Faehnfare, here is one way

In A1 put =ROW()*COLUMN(), drag to the right, to column L for 12 and down to
row 12 or for how many rows you want
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Bob Phillips]

And if you change the formula style to R1C1 (Tools>Options>General tick the
R1C1 Reference Style box), the row and column headings will work for you.

--

HTH

RP
(remove nothere from the email address if mailing direct)