Absolute and Relative cell referencing


Posted by Brian Spurgin on December 09, 2000 6:57 AM

I'm trying to create a single formula in cell B2 which can be copied across and down to produce the times table.



Posted by Ivan Moala on December 09, 2000 11:29 AM

Place this formula in B2 =((ROW()-1)*B$1) and
copy down & across


Ivan