{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Worksheet","SYSTEM FORMULAE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Worksheet","index":0,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,0,1,1],[4,0,4,1],[0,2,0,9],[13,0,13,1]]}
[null,null,{"$f":"CONCATENATE(\"Use compound interest methods to find the \",IF(B6=1,\"balance \",IF(B6=2,\"amount of interest\",\"balance or amount of interest\")))","v":"Use compound interest methods to find the balance "}]
["Variables",null,1,5,6600,6,"balance","years","£6600 is invested for 5 years, at an interest rate of 6% per annum.  What is the balance at the end of the 5 years?",8832.2888121600026]
["SHOW ANSWERS",false,2,5,6000,5,"balance","months","£6000 is invested for 5 months, at an interest rate of 5% per month.  What is the balance at the end of the 5 months?",7657.6893750000008]
["Number of questions (minimum 6, maximum 20)",15,3,5,1200,5,"balance","years","£1200 is invested for 5 years, at an interest rate of 5% per annum.  What is the balance at the end of the 5 years?",1531.5378750000002]
["Types of questions",null,4,5,730,6,"balance","years","£730 is invested for 5 years, at an interest rate of 6% per annum.  What is the balance at the end of the 5 years?",976.90467164800032]
["Find the bank balance",1,5,5,900,1,"balance","years","£900 is invested for 5 years, at an interest rate of 1% per annum.  What is the balance at the end of the 5 years?",945.90904508999995]
["Find the interest",0,6,2,720,5,"balance","years","£720 is invested for 2 years, at an interest rate of 5% per annum.  What is the balance at the end of the 2 years?",793.80000000000007]
["Mixture of both",0,7,5,2100,5,"balance","months","£2100 is invested for 5 months, at an interest rate of 5% per month.  What is the balance at the end of the 5 months?",2680.1912812500004]
["Level of Difficulty",null,8,3,100,4,"balance","years","£100 is invested for 3 years, at an interest rate of 4% per annum.  What is the balance at the end of the 3 years?",112.4864]
["Maximum number of years",5,9,2,130,2,"balance","months","£130 is invested for 2 months, at an interest rate of 2% per month.  What is the balance at the end of the 2 months?",135.25200000000001]
["Maximum initial amount",{"$f":"10^(A14+1)","v":10000},10,3,670,2,"balance","years","£670 is invested for 3 years, at an interest rate of 2% per annum.  What is the balance at the end of the 3 years?",711.0093599999999]
["Whole number percentages only",true,11,3,700,1,"balance","months","£700 is invested for 3 months, at an interest rate of 1% per month.  What is the balance at the end of the 3 months?",721.21069999999997]
["Allow months as a unit of time?",true,12,3,600,7,"balance","months","£600 is invested for 3 months, at an interest rate of 7% per month.  What is the balance at the end of the 3 months?",735.02580000000012]
[3,null,13,2,480,2,"balance","years","£480 is invested for 2 years, at an interest rate of 2% per annum.  What is the balance at the end of the 2 years?",499.392]
[null,null,14,3,330,2,"balance","years","£330 is invested for 3 years, at an interest rate of 2% per annum.  What is the balance at the end of the 3 years?",350.19863999999995]
[null,null,15,3,910,6,"balance","months","£910 is invested for 3 months, at an interest rate of 6% per month.  What is the balance at the end of the 3 months?",1083.8245600000002]
[null,null,"",2,60,4,"balance","years","£60 is invested for 2 years, at an interest rate of 4% per annum.  What is the balance at the end of the 2 years?",64.896000000000001]
[null,null,"",2,370,2,"balance","months","£370 is invested for 2 months, at an interest rate of 2% per month.  What is the balance at the end of the 2 months?",384.94799999999998]
[null,null,"",2,1700,7,"balance","years","£1700 is invested for 2 years, at an interest rate of 7% per annum.  What is the balance at the end of the 2 years?",1946.3300000000002]
[null,null,"",4,380,4,"balance","months","£380 is invested for 4 months, at an interest rate of 4% per month.  What is the balance at the end of the 4 months?",444.5462528000001]
[null,null,"",2,730,1,"balance","months","£730 is invested for 2 months, at an interest rate of 1% per month.  What is the balance at the end of the 2 months?",744.673]

{"sheet":"SYSTEM FORMULAE","index":1,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":1},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":3},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":7500},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":7},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"years"},{"$f":"CONCATENATE(\"£\",C1,\" is invested for \",B1,\" \",F1,\", at an interest rate of \",D1,\"%\",IF(F1=\"years\",\" per annum.  \",\" per month.  \"),IF(E1=\"balance\",\"What is the balance at the end of the \",IF(E2=\"interest\",\"How much interest is there at the end of the \",CHOOSE(RANDBETWEEN(1,2),\"How much interest is there at the end of the \",\"What is the balance at the end of the \"))),B1,\" \",F1,\"?\")","v":"£7500 is invested for 3 years, at an interest rate of 7% per annum.  What is the balance at the end of the 3 years?"},{"$f":"IF(E1=\"interest\",(C1*((100+D1)/100)^B1)-C1,C1*((100+D1)/100)^B1)","v":9187.8225000000002}]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":2},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":4},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":690},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":1},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"years"},{"$f":"CONCATENATE(\"£\",C2,\" is invested for \",B2,\" \",F2,\", at an interest rate of \",D2,\"%\",IF(F2=\"years\",\" per annum.  \",\" per month.  \"),IF(E2=\"balance\",\"What is the balance at the end of the \",IF(E3=\"interest\",\"How much interest is there at the end of the \",CHOOSE(RANDBETWEEN(1,2),\"How much interest is there at the end of the \",\"What is the balance at the end of the \"))),B2,\" \",F2,\"?\")","v":"£690 is invested for 4 years, at an interest rate of 1% per annum.  What is the balance at the end of the 4 years?"},{"$f":"IF(E2=\"interest\",(C2*((100+D2)/100)^B2)-C2,C2*((100+D2)/100)^B2)","v":718.01676689999999}]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":3},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":2},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":100},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":7},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"years"},"£100 is invested for 2 years, at an interest rate of 7% per annum.  What is the balance at the end of the 2 years?",114.49000000000001]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":4},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":4},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":320},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":1},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"months"},"£320 is invested for 4 months, at an interest rate of 1% per month.  What is the balance at the end of the 4 months?",332.99328320000001]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":5},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":3},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":3700},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":1},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"years"},"£3700 is invested for 3 years, at an interest rate of 1% per annum.  What is the balance at the end of the 3 years?",3812.1136999999999]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":6},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":3},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":930.00000000000011},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":7},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"years"},"£930 is invested for 3 years, at an interest rate of 7% per annum.  What is the balance at the end of the 3 years?",1139.2899900000002]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":7},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":4},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":1900},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":6},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"months"},"£1900 is invested for 4 months, at an interest rate of 6% per month.  What is the balance at the end of the 4 months?",2398.7062240000005]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":8},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":4},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":1400},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":6},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"years"},"£1400 is invested for 4 years, at an interest rate of 6% per annum.  What is the balance at the end of the 4 years?",1767.4677440000005]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":9},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":2},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":340},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":3},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"months"},"£340 is invested for 2 months, at an interest rate of 3% per month.  What is the balance at the end of the 2 months?",360.70599999999996]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":10},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":4},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":350},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":6},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"months"},"£350 is invested for 4 months, at an interest rate of 6% per month.  What is the balance at the end of the 4 months?",441.86693600000012]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":11},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":5},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":490.00000000000006},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":5},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"years"},"£490 is invested for 5 years, at an interest rate of 5% per annum.  What is the balance at the end of the 5 years?",625.37796562500012]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":12},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":5},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":5900},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":2},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"months"},"£5900 is invested for 5 months, at an interest rate of 2% per month.  What is the balance at the end of the 5 months?",6514.0767388800004]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":13},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":3},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":120},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":5},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"months"},"£120 is invested for 3 months, at an interest rate of 5% per month.  What is the balance at the end of the 3 months?",138.91500000000002]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":14},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":2},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":5000},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":3},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"years"},"£5000 is invested for 2 years, at an interest rate of 3% per annum.  What is the balance at the end of the 2 years?",5304.5]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":15},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":3},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":6500},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":1},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"years"},"£6500 is invested for 3 years, at an interest rate of 1% per annum.  What is the balance at the end of the 3 years?",6696.9564999999993]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":""},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":4},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":740},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":1},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"months"},"£740 is invested for 4 months, at an interest rate of 1% per month.  What is the balance at the end of the 4 months?",770.04696739999997]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":""},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":4},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":520},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":1},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"months"},"£520 is invested for 4 months, at an interest rate of 1% per month.  What is the balance at the end of the 4 months?",541.11408519999998]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":""},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":4},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":7800},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":5},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"years"},"£7800 is invested for 4 years, at an interest rate of 5% per annum.  What is the balance at the end of the 4 years?",9480.9487499999996]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":""},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":5},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":740},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":3},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"months"},"£740 is invested for 5 months, at an interest rate of 3% per month.  What is the balance at the end of the 5 months?",857.86281498199992]
[{"$f":"IF(ROW()<=Worksheet!$B$4,ROW(),\"\")","v":""},{"$f":"RANDBETWEEN(2,Worksheet!$B$10)","v":3},{"$f":"(RANDBETWEEN(1,99)/10)*10^RANDBETWEEN(2,Worksheet!$A$14)","v":530},{"$f":"IF(Worksheet!$B$12,RANDBETWEEN(1,7),RANDBETWEEN(11,69)/10)","v":7},{"$f":"IF(Worksheet!$B$6=1,\"balance\",IF(Worksheet!$B$6=2,\"interest\",CHOOSE(RANDBETWEEN(1,2),\"balance\",\"interest\")))","v":"balance"},{"$f":"IF(Worksheet!$B$13,CHOOSE(RANDBETWEEN(1,2),\"months\",\"years\"),\"years\")","v":"months"},"£530 is invested for 3 months, at an interest rate of 7% per month.  What is the balance at the end of the 3 months?",649.2727900000001]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,#REF!+1,\"\")","v":""}]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,H21+1,\"\")","v":""}]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,H22+1,\"\")","v":""}]