formula - random numbers

[hoffies]

can i use excel to help my daughter learn time tables ?

i want the numbers to change based on the table she is learning on the day, e.g. 3 time tables.

thanks!!

 

[SteveO59L]

Ok, in a1:a12 numbers from 1 - 12

in b1

=a1*$d$1

and copy to cells b2:b12

then hide col B

in e1 =if(c1="","",if(b1=c1,"Correct","Try Again"))

and copy to e2:e12.

Always Clear C1:C12, and enter the table number in d1

 

[Scott Huish]

See here:
http://www.mrexcel.com/forum/showthread.php?t=381051

 

[hoffies]

Thank you very much guys!!