| 関数式の作成 |
| |
|
| |
乱数の基準値を作成します(非表示) |
| セルＧ 7 |
=IF(J6<>"",IF(ISERR(LEFT(J6,2)/RIGHT(J6,2)),EXP(1),
→ |
| |
→IF(OR(LEFT(J6,2)/RIGHT(J6,2)=0,LEFT(J6,2)/RIGHT(J6,2)=1),PI(),LEFT(J6,2)/RIGHT(J6,2))),"") |
| |
|
| |
＋、−を表示します |
| セルＣ10 |
=IF(AND(OR($H$4="",$K$4=""),OR($H$4<>"",$K$4<>"")),IF($H$4<>"","＋","-"),"") |
| 16 |
=IF(AND(OR($H$4="",$K$4=""),OR($H$4<>"",$K$4<>"")),IF($H$4<>"","＋","-"),"") |
| 23 |
=IF(AND(OR($H$4="",$K$4=""),OR($H$4<>"",$K$4<>"")),IF($H$4<>"","＋","-"),"") |
| |
|
| |
上段の数値を表示します |
| セルＤ 9 |
=IF(AND(C10<>"",$J$6<>""),IF(C10="-",MID($G$7,RIGHT($J$6,1)+2,1)+D10,MID($G$7,RIGHT($J$6,1)+2,1)),"") |
| 15 |
=IF(AND(C16<>"",$J$6<>""),IF(C16="-",MID($G$7,RIGHT($J$6,1)+3,1)+D16,MID($G$7,RIGHT($J$6,1)+3,1)),"") |
| 22 |
=IF(AND(C23<>"",$J$6<>""),IF(C23="-",MID($G$7,RIGHT($J$6,1)+4,1)+D23,MID($G$7,RIGHT($J$6,1)+4,1)),"") |
| |
|
| |
下段の数値を表示します |
| セルＤ10 |
=IF(AND(C10<>"",$J$6<>""),MID($G$7,LEFT($J$6,1)+2,1),"") |
| 16 |
=IF(AND(C16<>"",$J$6<>""),MID($G$7,LEFT($J$6,1)+3,1),"") |
| 23 |
=IF(AND(C23<>"",$J$6<>""),MID($G$7,LEFT($J$6,1)+4,1),"") |
| |
|
| |
正解を計算します(非表示) |
| セルＤ12 |
=IF($J$6<>"",IF(C10="＋",D9+D10,IF(C10="-",D9-D10,"")),"") |
| 18 |
=IF($J$6<>"",IF(C16="＋",D15+D16,IF(C16="-",D15-D16,"")),"") |
| 25 |
=IF($J$6<>"",IF(C23="＋",D22+D23,IF(C23="-",D22-D23,"")),"") |
| |
|
| |
答えと正解を確認します(非表示) |
| セルＤ13 |
=IF(D12<>"",DELTA(D11,D12),"") |
| 19 |
=IF(D18<>"",DELTA(D17,D18),"") |
| 26 |
=IF(D25<>"",DELTA(D24,D25),"") |
| |
|
| |
正解を表示します |
| セルＤ14 |
=IF($N$6<>"",IF(D13=1,"正解",IF(D13=0,"もう一度かんがえて？","")),"") |
| 20 |
=IF($N$6<>"",IF(D19=1,"正解",IF(D19=0,"もう一度かんがえて？","")),"") |
| 27 |
=IF($N$6<>"",IF(D26=1,"正解",IF(D26=0,"もう一度かんがえて？","")),"") |
| |
|
| |
絵を表示します |
| セルＧ 9 |
=IF(D9<>"",REPT("  ",D9),"") |
| 10 |
=IF(D10<>"",REPT(" ",D10),"") |
| 11 |
=IF($N$6<>"",IF(C10="＋",REPT("
",D9+D10),IF(C10="-",(REPT(" ",D10) &REPT(" ",D9-D10)),"")),"") |
| 15 |
=IF(D15<>"",REPT("  ",D15),"") |
| 16 |
=IF(D16<>"",REPT(" ",D16),"") |
| 17 |
=IF($N$6<>"",IF(C16="＋",REPT("
",D15+D16),IF(C16="-",(REPT(" ",D16) &REPT("
",D15-D16)),"")),"") |
| 22 |
=IF(D22<>"",REPT("  ",D22),"") |
| 23 |
=IF(D23<>"",REPT(" ",D23),"") |
| 24 |
=IF($N$6<>"",IF(C23="＋",REPT("
",D22+D23),IF(C23="-",(REPT(" ",D23) &REPT(" ",D22-D23)),"")),"") | |
