Welcome Guest
You last visited January 24, 2017, 2:35 am
All times shown are
Eastern Time (GMT-5:00)

need a help for random formula for kidmath

Topic closed. Posted 8 years ago. No replies.

 Page 1 of 1
Heroic City
Indonesia
Member #31689
February 2, 2006
1153 Posts
Offline
 Posted: November 21, 2008, 9:51 am - IP Logged

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 +