P
Peter Barrett
Hello
I have been fiddling about trying to construct a fairly simple spreadsheet -
but have so far been unable to find an elegant function to carry out a fairly
simple task.
Basically, I am trying to build a "Flash Card" type worksheet for maths
problems (multiplication, addition, subtraction etc.). The idea is that the
spreadsheet will create random maths problems (e.g. 4 x 7, 6 x 8 etc.) This
is meant to be some fun for my daughter as she practices her times tables.
The complication / refinement that I want to add is that I want to be able
to identify which times tables ( 1 - 12) are to be included in the test (for
instance, we have not done the 7 and 8 times tables yet and so I do not want
to include these tables in the list of randomly generated questions yet). So
far I have just listed the digits 1 - 12 is separate rows and put a "Y"
character in the adjacent box next to each digit to indicate whether I want
that number included in the list of values to used to generate questions -
i.e. to create a shortlist.
The problem is - how do I create a function that randomly selects from this
shortlist of values?
I tried using the CHOOSE function, but to no joy?
Any thoughts anyone?
Thanks in advance.
I have been fiddling about trying to construct a fairly simple spreadsheet -
but have so far been unable to find an elegant function to carry out a fairly
simple task.
Basically, I am trying to build a "Flash Card" type worksheet for maths
problems (multiplication, addition, subtraction etc.). The idea is that the
spreadsheet will create random maths problems (e.g. 4 x 7, 6 x 8 etc.) This
is meant to be some fun for my daughter as she practices her times tables.
The complication / refinement that I want to add is that I want to be able
to identify which times tables ( 1 - 12) are to be included in the test (for
instance, we have not done the 7 and 8 times tables yet and so I do not want
to include these tables in the list of randomly generated questions yet). So
far I have just listed the digits 1 - 12 is separate rows and put a "Y"
character in the adjacent box next to each digit to indicate whether I want
that number included in the list of values to used to generate questions -
i.e. to create a shortlist.
The problem is - how do I create a function that randomly selects from this
shortlist of values?
I tried using the CHOOSE function, but to no joy?
Any thoughts anyone?
Thanks in advance.