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
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
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.
Last edited by Paul; 03-05-2007 at 01:03 AM.
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?
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 ?
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.
Last edited by Paul; 03-05-2007 at 01:26 AM.
thanks alot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks