関数式の作成 　 問題の左の数値を選択する、基準値の引数を求めます。 セルＣ32 =IF(V29<>"",INT(MOD(V29,100)/10),"")　　　　 セルＧ32 =IF(V29<>"",IF(MOD(V29,10)=0,10,MOD(V29,10)),"")　　　　 　 第一問の左の数値基準を求めます。 セルＬ32 =IF(V29<>"",HLOOKUP(C32,F5:S19,G32+1),"")　　　 　 問題の右の数値を選択する、基準値の引数を求めます。 セルＣ33 =IF(V29<>"",INT(MOD(V29,100)/10),"")　 セルＧ33 =IF(V29<>"",IF(MOD(V29,10)=0,10,MOD(V29,10)),"")　　　　 　 第一問の右の数値基準を求めます。 セルＬ33 =IF(V29<>"",VLOOKUP(G33,E6:S19,C32+1),"")　　 　 問題の左枠の数値を求めます。 セルＱ37 =IF(V29<>"",IF(R37="−",HLOOKUP($C$32,$F$5:$S$19,$G$32+1)+S37,　　→ 　 　　→　　IF(R37="÷",HLOOKUP($C$32,$F$5:$S$19,$G$32+1)*S37,HLOOKUP($C$32,$F$5:$S$19,$G$32+1))),"") セルＱ39 =IF(V29<>"",IF(R39="−",HLOOKUP($C$32,$F$5:$S$19,$G$32+2)+S39,　　→ 　 　　→　　IF(R39="÷",HLOOKUP($C$32,$F$5:$S$19,$G$32+2)*S39,HLOOKUP($C$32,$F$5:$S$19,$G$32+2))),"") セルＱ41 =IF(V29<>"",IF(R41="−",HLOOKUP($C$32,$F$5:$S$19,$G$32+3)+S41,　　→ 　 　　→　　IF(R41="÷",HLOOKUP($C$32,$F$5:$S$19,$G$32+3)*S41,HLOOKUP($C$32,$F$5:$S$19,$G$32+3))),"") セルＱ43 =IF(V29<>"",IF(R43="−",HLOOKUP($C$32,$F$5:$S$19,$G$32+4)+S43,　　→ 　 　 →　　IF(R43="÷",HLOOKUP($C$32,$F$5:$S$19,$G$32+4)*S43,HLOOKUP($C$32,$F$5:$S$19,$G$32+4))),"") セルＱ45 =IF(V29<>"",IF(R45="−",HLOOKUP($C$32,$F$5:$S$19,$G$32+5)+S45,　　→ 　 　　→　　IF(R45="÷",HLOOKUP($C$32,$F$5:$S$19,$G$32+5)*S45,HLOOKUP($C$32,$F$5:$S$19,$G$32+5))),"") 　 問題の右枠の数値を求めます。 セルＳ37 =IF(V29<>"",VLOOKUP($G$33,$E$6:$S$19,$C$32+1),"")　　　　 セルＳ39 =IF(V29<>"",VLOOKUP($G$33,$E$6:$S$19,$C$32+2),"")　　　 セルＳ41 =IF(V29<>"",VLOOKUP($G$33,$E$6:$S$19,$C$32+3),"")　　 セルＳ43 =IF(V29<>"",VLOOKUP($G$33,$E$6:$S$19,$C$32+4),"")　 セルＳ45 =IF(V29<>"",VLOOKUP($G$33,$E$6:$S$19,$C$32+5),"")　　　 　 四則計算の記号を表示します。 セルＲ37 =IF($V$21<>"","＋",IF($V$23<>"","−",IF($V$25<>"","×",IF($V$27<>"","÷","")))) セルＲ39 =IF($V$21<>"","＋",IF($V$23<>"","−",IF($V$25<>"","×",IF($V$27<>"","÷","")))) セルＲ41 =IF($V$21<>"","＋",IF($V$23<>"","−",IF($V$25<>"","×",IF($V$27<>"","÷",""))))　 セルＲ43 =IF($V$21<>"","＋",IF($V$23<>"","−",IF($V$25<>"","×",IF($V$27<>"","÷","")))) セルＲ45 =IF($V$21<>"","＋",IF($V$23<>"","−",IF($V$25<>"","×",IF($V$27<>"","÷","")))) 　 計算のイコール記号を表示します。 セルＴ37 =IF(R37<>"","＝","")　 セルＴ39 =IF(R39<>"","＝","")　　　　　 セルＴ41 =IF(R41<>"","＝","")　　　　 セルＴ43 =IF(R43<>"","＝","")　　　 セルＴ45 =IF(R45<>"","＝","")　　　　　 　 問題の正解を計算しておきます。 セルＷ37 =IF($V$29<>"",IF(R37="＋",Q37+S37,IF(R37="−",Q37-S37,IF(R37="×",Q37*S37,IF(R37="÷",Q37/S37,"")))),"") セルＷ39 =IF($V$29<>"",IF(R39="＋",Q39+S39,IF(R39="−",Q39-S39,IF(R39="×",Q39*S39,IF(R39="÷",Q39/S39,"")))),"") セルＷ41 =IF($V$29<>"",IF(R41="＋",Q41+S41,IF(R41="−",Q41-S41,IF(R41="×",Q41*S41,IF(R41="÷",Q41/S41,"")))),"")　　 セルＷ43 =IF($V$29<>"",IF(R43="＋",Q43+S43,IF(R43="−",Q43-S43,IF(R43="×",Q43*S43,IF(R43="÷",Q43/S43,"")))),"") セルＷ45 =IF($V$29<>"",IF(R45="＋",Q45+S45,IF(R45="−",Q45-S45,IF(R45="×",Q45*S45,IF(R45="÷",Q45/S45,"")))),"")　 　 問題の答えが正解、不正解の判定をします。 セルＸ37 =IF($V$29<>"",IF(ISERR(DELTA(V37,W37)),1,DELTA(V37,W37)),"") セルＸ39 =IF($V$29<>"",IF(ISERR(DELTA(V39,W39)),1,DELTA(V39,W39)),"")　　 セルＸ41 =IF($V$29<>"",IF(ISERR(DELTA(V41,W41)),1,DELTA(V41,W41)),"")　　　 セルＸ43 =IF($V$29<>"",IF(ISERR(DELTA(V43,W43)),1,DELTA(V43,W43)),"")　　 セルＸ45 =IF($V$29<>"",IF(ISERR(DELTA(V45,W45)),1,DELTA(V45,W45)),"")　　 　 答えにより「正解」、「もう一度考えて」を表示します。 セルＺ37 =IF($V$52<>"",IF(X37=1,"正解",IF(X37=0,"もう一度かんがえて？","")),"") セルＺ39 =IF($V$52<>"",IF(X39=1,"正解",IF(X39=0,"もう一度かんがえて？","")),"") セルＺ41 =IF($V$52<>"",IF(X41=1,"正解",IF(X41=0,"もう一度かんがえて？","")),"") セルＺ43 =IF($V$52<>"",IF(X43=1,"正解",IF(X43=0,"もう一度かんがえて？","")),"") セルＺ45 =IF($V$52<>"",IF(X45=1,"正解",IF(X45=0,"もう一度かんがえて？","")),"") 　 正解の数を数えます。 セルＨ35 =IF(V52<>"",SUM(X37:X45),"")　 　 絵の表示 　 セルＣ 　 セルＩ 44 =IF($H$35=2,"","") 38 =IF($H$35=5,"",IF($H$35=3,"","")) 51 =IF($H$35=2,"","") 39 =IF(OR($H$35=5,$H$35=3),"","") 　 セルＤ 40 =IF(OR($H$35=5,$H$35=3),"",IF($H$35=2,"","")) 37 =IF($H$35=3,"","") 41 =IF($H$35=5,"",IF($H$35=3,"",IF(OR($H$35=2,$H$35=1),"",""))) 38 =IF($H$35=4,"",IF($H$35=3,"","")) 42 =IF($H$35=5,"",IF($H$35=4,"","")) 39 =IF($H$35=4,"","") 43 =IF($H$35=5,"",IF($H$35=4,"","")) 40 =IF($H$35=4,"","") 44 =IF($H$35=5,"",IF($H$35=4,"",IF($H$35=2,"",IF($H$35=1,"","")))) 43 =IF(OR($H$35=2,$H$35=1),"","") 45 =IF($H$35=5,"",IF($H$35=4,"",IF($H$35=1,"",""))) 44 =IF($H$35=2,"",IF($H$35=1,"","")) 46 =IF($H$35=5,"","") 48 =IF($H$35=4,"","") 48 =IF($H$35=4,"",IF($H$35=3,"","")) 49 =IF($H$35=5,"",IF($H$35=4,"�e","")) 49 =IF($H$35=5,"",IF($H$35=3,"",IF($H$35=1,"",""))) 51 =IF(OR($H$35=3,$H$35=2),"","") 50 =IF($H$35=5,"","") 　 セルＥ 51 =IF(OR($H$35=5,$H$35=3,$H$35=2),"","") 38 =IF($H$35=3,"","") 　 セルＪ 39 =IF($H$35=3,"","") 37 =IF($H$35=3,"","") 40 =IF($H$35=4,"","") 38 =IF($H$35=4,"",IF($H$35=3,"","")) 41 =IF($H$35=4,"","") 39 =IF($H$35=5,"",IF($H$35=4,"",IF($H$35=3,"",""))) 42 =IF($H$35=4,"",IF(OR($H$35=2,$H$35=1),"","")) 40 =IF($H$35=5,"",IF($H$35=4,"",IF($H$35=3,"",""))) 43 =IF($H$35=4,"",IF(OR($H$35=2,$H$35=1),"","")) 41 =IF($H$35=5,"",IF(OR($H$35=2,$H$35=1),"","")) 44 =IF($H$35=2,"","") 42 =IF($H$35=5,"",IF(OR($H$35=2,$H$35=1),"","")) 45 =IF($H$35=2,"","") 43 =IF($H$35=5,"","") 46 =IF($H$35=4,"",IF($H$35=3,"",IF($H$35=2,"",""))) 44 =IF($H$35=5,"",IF($H$35=4,"",IF($H$35=2,"",IF($H$35=1,"","")))) 47 =IF(OR($H$35=3,$H$35=4),"",IF($H$35=2,"","")) 45 =IF($H$35=5,"",IF($H$35=4,"",IF($H$35=1,"",""))) 48 =IF($H$35=2,"","") 47 =IF($H$35=3,"","") 49 =IF(OR($H$35=5,$H$35=2),"","") 48 =IF($H$35=4,"",IF($H$35=3,"","")) 50 =IF($H$35=5,"",IF($H$35=2,"","")) 49 =IF($H$35=5,"",IF($H$35=4,"",IF($H$35=1,"",""))) 51 =IF(OR($H$35=2,$H$35=3),"","") 50 =IF($H$35=5,"",IF($H$35=4,"",IF($H$35=1,"",""))) 　 セルＦ 51 =IF($H$35=5,"",IF(OR($H$35=3,$H$35=2),"","")) 37 =IF($H$35=3,"","") 　 セルＫ 38 =IF($H$35=4,"",IF($H$35=3,"","")) 38 =IF($H$35=3,"","") 39 =IF($H$35=4,"",IF($H$35=3,"","")) 39 =IF($H$35=3,"",IF($H$35=2,"","")) 40 =IF($H$35=4,"",IF($H$35=3,"","")) 40 =IF($H$35=4,"",IF($H$35=2,"","")) 41 =IF(OR($H$35=2,$H$35=1),"","") 41 =IF($H$35=5,"",IF($H$35=4,"",IF($H$35=2,"�n",""))) 42 =IF(OR($H$35=2,$H$35=1),"","") 42 =IF(OR($H$35=5,$H$35=2),"",IF($H$35=4,"",IF($H$35=1,"",""))) 44 =IF($H$35=4,"",IF($H$35=2,"",IF($H$35=1,"",""))) 43 =IF($H$35=5,"",IF($H$35=4,"",IF(OR($H$35=2,$H$35=1),"",""))) 45 =IF($H$35=4,"",IF($H$35=1,"","")) 44 =IF($H$35=2,"","") 47 =IF($H$35=3,"","") 45 =IF($H$35=2,"","") 48 =IF($H$35=4,"",IF($H$35=3,"","")) 46 =IF($H$35=4,"",IF($H$35=3,"",IF($H$35=2,"",""))) 49 =IF($H$35=5,"",IF($H$35=4,"",IF($H$35=1,"",""))) 47 =IF(OR($H$35=4,$H$35=3),"",IF($H$35=2,"","")) 50 =IF($H$35=5,"",IF($H$35=4,"",IF($H$35=1,"",""))) 48 =IF($H$35=2,"","") 51 =IF($H$35=5,"",IF(OR($H$35=3,$H$35=2),"","")) 49 =IF(OR($H$35=5,$H$35=2),"","") 　 セルＧ 50 =IF($H$35=5,"",IF($H$35=2,"","")) 38 =IF($H$35=3,"","") 51 =IF(OR($H$35=3,$H$35=2),"","") 39 =IF($H$35=3,"","") 　 セルＬ 40 =IF($H$35=3,"",IF($H$35=2,"","")) 37 =IF($H$35=3,"",IF($H$35=2,"","")) 41 =IF($H$35=3,"",IF(OR($H$35=2,$H$35=1),"","")) 38 =IF($H$35=4,"",IF($H$35=3,"",IF($H$35=2,"",""))) 42 =IF($H$35=4,"","") 39 =IF($H$35=4,"","") 43 =IF($H$35=4,"","") 40 =IF($H$35=4,"","") 44 =IF($H$35=4,"",IF($H$35=2,"",IF($H$35=1,"",""))) 42 =IF($H$35=5,"","") 45 =IF($H$35=4,"",IF($H$35=1,"","")) 43 =IF(OR($H$35=2,$H$35=1),"","") 48 =IF($H$35=4,"",IF($H$35=3,"","")) 44 =IF($H$35=2,"",IF($H$35=1,"","")) 49 =IF($H$35=5,"",IF($H$35=3,"",IF($H$35=1,"",""))) 48 =IF($H$35=4,"","") 50 =IF($H$35=5,"","") 49 =IF($H$35=5,"",IF($H$35=4,"","")) 51 =IF(OR($H$35=5,$H$35=3,$H$35=2),"","") 51 =IF(OR($H$35=2,$H$35=3),"","") 　 セルＨ 　 セルＭ 37 =IF($H$35=5,"",IF($H$35=3,"","")) 44 =IF($H$35=2,"","") 38 =IF($H$35=5,"",IF($H$35=3,"","")) 51 =IF($H$35=2,"","") 39 =IF($H$35=5,"",IF($H$35=3,"",IF($H$35=2,"",""))) 　 　 40 =IF($H$35=5,"",IF($H$35=3,"",IF($H$35=2,"",""))) 　 　 41 =IF($H$35=5,"",IF($H$35=3,"","")) 　 　 42 =IF($H$35=5,"",IF($H$35=3,"","")) 　 　 43 =IF($H$35=5,"",IF($H$35=3,"","")) 　 　 44 =IF($H$35=5,"",IF($H$35=3,"",IF($H$35=2,"",""))) 　 　 45 =IF($H$35=5,"",IF($H$35=4,"",IF($H$35=3,"",""))) 　 　 46 =IF(OR($H$35=5,$H$35=1),"",IF($H$35=3,"","")) 　 　 47 =IF(OR($H$35=5,$H$35=1),"",IF($H$35=3,"","")) 　 　 48 =IF($H$35=5,"",IF($H$35=4,"",IF($H$35=3,"",""))) 　 　 49 =IF($H$35=5,"",IF($H$35=3,"",IF($H$35=1,"",""))) 　 　 50 =IF($H$35=5,"",IF($H$35=3,"","")) 　 　 51 =IF(OR($H$35=5,$H$35=3,$H$35=2),"","")