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.

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


"Faehnfare" wrote in message
...
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.

And if you change the formula style to R1C1 (ToolsOptionsGeneral 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)


"Paul B" wrote in message
...
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


"Faehnfare" wrote in message
...
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.