Home |
Search |
Today's Posts |
#1
|
|||
|
|||
one formula to make a multiplication table work
I am looking for the one formula in the upper left hand box that can be
copied thru the worksheet to make a multiplacation table work. |
#2
|
|||
|
|||
Hi
With numbers from 1 to 10 in both ranges B1:K1 and A2:A11, into cell B2 enter the formula =$A2*B$1 , and copy to range A2:K12 -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "Paige" wrote in message ... I am looking for the one formula in the upper left hand box that can be copied thru the worksheet to make a multiplacation table work. |
#3
|
|||
|
|||
Hi!
I assume you have 1,2,3,4 etc going down a column and across a row. Try this: =ROW(A1)*COLUMN(A1) Copy across then down or down then across. Biff "Paige" wrote in message ... I am looking for the one formula in the upper left hand box that can be copied thru the worksheet to make a multiplacation table work. |
#4
|
|||
|
|||
Thank you very much, that worked.
"Arvi Laanemets" wrote: Hi With numbers from 1 to 10 in both ranges B1:K1 and A2:A11, into cell B2 enter the formula =$A2*B$1 , and copy to range A2:K12 -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "Paige" wrote in message ... I am looking for the one formula in the upper left hand box that can be copied thru the worksheet to make a multiplacation table work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Pivot Table Data Formula | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Sumproduct help needed! | Excel Worksheet Functions | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) |