# Multiplication formula

1. ## Multiplication formula

Howdy, im looking for a single formula that will do

1 2 3 4 5 6 7 8
2 4
3..9
4....16
5........25
6........... 36
7
8

so on and so fourth, except with 10s  Register To Reply

2. Assuming your values are in A1:A8, and across the top through H1 (as your example shows), in B2 put the formula exactly as shown:

=B\$1*\$A2

You can then fill this down as many rows as you need using the fill handle. Once that column is filled, and with those cells still selected, you can easily fill all columns to the right by dragging that direction with the fill handle.  Register To Reply

3. You want a formula that will build the table by multiplying the heading to each row by the heading to each column?? That's pretty easy, though I apologize for using R1C1 notation; I've grown quite accustomed to it. =rc1*r1c copied through the table. What's the equivalent A1 notation: B\$1*\$A2??

If that's not what you want, then can you explain better what you want?  Register To Reply

4. My teacher has set a little task to make a multiplication table using just 1 formula, the above posts arnt it, thanks anyway though. any ideas for different ways to do it ?  Register To Reply

5. If you want ONE formula that will cover every cell, this might work:

=COLUMN()*ROW()*100

This assumes that down column A you have

A1=10
A2=20
A3=30
...

And across the columns you have

A1=10
B1=20
C1=30
...

Put the formula in B2 and fill down and across. This will create your multiplication table by 10's.  Register To Reply

6. thanks alot.  Register To Reply