# 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

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.

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?

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 ?

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.

6. thanks alot.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1