REALLY long - want to pick a random value from a table, and random symbol

Hi,

I have a long winded problem, attached. I have included what I need eventually in each column.

Questions.xlsx

I need to Create a 1000+ questions of this type.

Anyone have any ideas how to randomly select a value from the table I2:1000,L2:1000.

Also how do I make it randomly select a symbol? I want either plus, minus, multiply or divide in C2:1000 and E2:000.

Thanks in advance

Try:

=INDEX($I$2:$L$1000,RANDBETWEEN(1,1000),RANDBETWEEN(1,4))

for the symbols... list them in another column separately, say M2:M6

then

=INDEX($M$2:$M$6,RANDBETWEEN(1,6))

for symbol id use
=CHOOSE(RANDBETWEEN(1,4),"+","-","/","*")
for
sum use
=MROUND((EVAL(B3&C3&D3&E3&F3)),10)
mround needs analysis toolpak activated and eval needs morefunc addin
http://xcell05.free.fr/morefunc/english/#Functions

Originally Posted by Geomarsh

Hi,
The INDEX function worked fantastically, so did the CHOOSE for the symbols.
When it comes to the answer, I need each number in the question rounded to the nearest integer,10,100 or 1000, not the actual answer itself (I've only just realised this). So I need a function that can count how many digits in the number, then round it to 1000.

eg.
323 x 22 / 2.9 = 300 x 20 / 3

so 3 digit numbers are rounded to nearest 100, 2 digits to nearest 10, decimals to nearest integer.
Maybe a count function or something?

Thanks for your help!

Try:

=MROUND(B3,CHOOSE(LEN(INT(B3)),1,10,100,1000))*MROUND(D3,CHOOSE(LEN(INT(D3)),1,10,100,1000))/MROUND(F3,CHOOSE(LEN(INT(F3)),1,10,100,1000))