Multiplication Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Faehnfare - 14 Jan 2005 17:03 GMT

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.

Reply to this Message

Paul B - 14 Jan 2005 17:41 GMT

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

Signature

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

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

Reply to this Message

Bob Phillips - 16 Jan 2005 17:40 GMT

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.

Signature

HTH

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

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

Reply to this Message