If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I create an arithmetic test in Excel?
I tried using RAND but each time the answer is entered by the pupil the
numbers will change so it will be impossible to check the results. I then tried F9. This works well but produces just one version of the test. I need an in between stage that just changes the random numbers when the worksheet is opened. |
#2
|
|||
|
|||
Maybe you could have a macro that inserts static random numbers in your cells
each time the workbook opens? You want it to change each and every time??? If you share the cell addresses and worksheet names that need it, I'm sure you'll get a more specific suggestion. Helier wrote: I tried using RAND but each time the answer is entered by the pupil the numbers will change so it will be impossible to check the results. I then tried F9. This works well but produces just one version of the test. I need an in between stage that just changes the random numbers when the worksheet is opened. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
CREATE LIST OBJECT IN EXCEL | MIKE | Worksheet Functions | 0 | June 20th, 2005 08:13 AM |
Excel Range Value issue (Excel 97 Vs Excel 2003) | Keeno | General Discussion | 2 | June 13th, 2005 02:01 PM |
Create Excel through XSL including image | Snig | General Discussion | 0 | May 7th, 2005 08:49 AM |
Create Excel Form with Excel data | Scotts | General Discussion | 1 | July 10th, 2004 12:45 PM |
How to create transparent objects on images in Excel | Simon Lenn | Charts and Charting | 1 | December 23rd, 2003 05:12 AM |