Thunder

Steph was working in a school today where they were looking at using ICT to support addition. Among a variety of other resources, she was planning to use Excel to produce addition questions similar to this:

I thought I would try and be smart and use the ‘=randbetween()’ function to generate the numbers and use the ‘=if()’ function to check the number entered by the student is correct. Unfortunately when you press enter to get the ‘=if()’ function to check the number is correct it randomises the original numbers again. I was wondering if anyone (Tim?) knew of a way to keep both bits of functionality i.e. random numbers and checking of answers. My working progress can be downloaded from here.