One play ..

Enter the numbers in A2 down, eg: 24, 20, 25, ...

Then put in B2:
=IF($A2="","",IF(MOD($A2,COLUMN(A1))=0,$A2/COLUMN(A1)&" x "&COLUMN(A1),""))

Copy B2 across by say 20 cols to U2,
then fill down as far as required to populate the table
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Excel Novice" wrote:
How do you use excel to calculate multiples of a number? I am creating a
multiplication table for my dtr. up to 12. Can I create the table in Excel
and overlay a function that would calculate the multiples for each number in
the table? Example: "24" (multiples a 24x1; 12x2; 6x4 and 4x3)

T. Scott