Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to control updating of random numbers
I have created a simple worksheet to help my kids practice math facts using
the "randbetween" function, but I also have an IF-THEN-ELSE to show them if they are right. The problem is that as soon as they enter their values, new values are generated and their answer is no longer correct. I went into the options and made calculations manual, but then the answer is not updated either. Is there an easy way to select cells to update automatically (or after pressing a button with a macro) while leaving the others with their original values? =randbetween(-12,12) x =randbetween(-12,12) =IF(B3=B1*B2,"Great!","Try Again") I would like cells B1 and B2 to only be updated manually, but I would like B4 to be updated either automatically or when they are finished with a sheet and hit a button that says "Check answers" or something like that. Thanks! -- Jeff Ciaccio Sprayberry High School Physics & AP Physics Teacher 770-578-3200 AP Physics Site: http://home.bellsouth.net/p/PWP-shsphysics |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
(djn) Excel Not Updating Random Cells | Excel Discussion (Misc queries) | |||
Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) |