need a help for random formula for kidmathPrev TopicNext Topic

• sysp34

  

  Heroic City
  Indonesia
  Member #31,688
  February 2, 2006
  1,153 Posts
  Offline
  Nov 21, 2008, 9:51 am

  ▲▼

  hi there excelsior.

  does anyone knew a formula to generate random formula because i need a help to make a spreasheet

  for my little rascal niece

  addition, it little bit easy to generate random formula, thank to Dough for =INDEX($A$9:$A$13;INT(RAND()*5)+1;1)

  subtraction, little bit hard using random formula because at some point it generate minus result while i like to have positive results

  multiplication, it similar with addition so it must be little bit easy although it will

  division, i think it similar with subtraction problems i like to have round number

  here are some sample

  start: ________  finish:  ________  name: ________ class:  ________

   

  	9	5				6	9				5	8				6	1				8	0				7	4				9	0				9	8
  	7	1	+			8	0	+			9	5	+			6	4	+			8	0	+			6	3	+			7	5	+			9	1	+
  	5	6				9	6				7	9				6	0				5	4				9	8				9	2				8	4
  	9	8	+			9	3	+			5	6	+			9	1	+			8	9	+			6	3	+			9	7	+			9	7	+

  a sample of kidmath only addition DOWNLOAD LINK

   

  thank for any helps and info

  Et erunt signa in sole.......Et luna et stellis.......Et presura gentium
  Prae confusione sonitus maris.