table


Posted by jonathan on October 21, 2001 8:47 PM

how do u create a multiplication table with formulas in a spreadsheet?



Posted by Jonathan on October 21, 2001 9:37 PM

Let's say you have B1:J1 filled with 1,2,3,4,...9 and that you have A2:A10 filled with 1,2,3,4,...9. In cell B2 put =B$1*$A2. Then fill down and across (or across and down :). The idea is that you want the formulas filling across to have relative Column names - so they'll change appropriately - but the same row number: thus, B$1. On the other hand, you want the formulas filling down to have relative row numbers - so they'll change accordingly - but to refer to the same number up top: so, Absolute column name: thus, $A2. Together the formula can be extended to as far as you want your multiplication table to go, just so that you fill in the top row and the leftmost column first.

HTH

P.S. Where'd you get a name like that? ;)