| 関数式の作成 |
| |
段の数と正解を表示します |
| セルＨ6 |
=IF(E4<>"",E4,"") |
| セルＮ6 |
=IF(OR(ISERR(H6*J6),L6=""),"",IF(AND($S$4<>"",L6=H6*J6),"正解","")) |
| |
答えの数、絵を表示します |
| セルＨ |
| 9 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$H$8<=$H$6,G9<=$J$6),$C$8,"")) |
| 10 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$H$8<=$H$6,G10<=$J$6),$C$8,"")) |
| 11 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$H$8<=$H$6,G11<=$J$6),$C$8,"")) |
| 12 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$H$8<=$H$6,G12<=$J$6),$C$8,"")) |
| 13 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$H$8<=$H$6,G13<=$J$6),$C$8,"")) |
| 14 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$H$8<=$H$6,G14<=$J$6),$C$8,"")) |
| 15 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$H$8<=$H$6,G15<=$J$6),$C$8,"")) |
| 16 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$H$8<=$H$6,G16<=$J$6),$C$8,"")) |
| 17 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$H$8<=$H$6,G17<=$J$6),$C$8,"")) |
| セルＩ |
| 9 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$I$8<=$H$6,G9<=$J$6),$C$8,"")) |
| 10 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$I$8<=$H$6,G10<=$J$6),$C$8,"")) |
| 11 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$I$8<=$H$6,G11<=$J$6),$C$8,"")) |
| 12 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$I$8<=$H$6,G12<=$J$6),$C$8,"")) |
| 13 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$I$8<=$H$6,G13<=$J$6),$C$8,"")) |
| 14 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$I$8<=$H$6,G14<=$J$6),$C$8,"")) |
| 15 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$I$8<=$H$6,G15<=$J$6),$C$8,"")) |
| 16 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$I$8<=$H$6,G16<=$J$6),$C$8,"")) |
| 17 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$I$8<=$H$6,G17<=$J$6),$C$8,"")) |
| セルＪ |
| 9 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$J$8<=$H$6,G9<=$J$6),$C$8,"")) |
| 10 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$J$8<=$H$6,G10<=$J$6),$C$8,"")) |
| 11 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$J$8<=$H$6,G11<=$J$6),$C$8,"")) |
| 12 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$J$8<=$H$6,G12<=$J$6),$C$8,"")) |
| 13 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,J8<=$H$6,$G$13<=$J$6),$C$8, → |
| |
→ IF(AND($S$4<>"",$L$6<>$H$6*$J$6,$L$6<>""),"ま",""))) |
| 14 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$J$8<=$H$6,G14<=$J$6),$C$8,"")) |
| 15 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$J$8<=$H$6,G15<=$J$6),$C$8,"")) |
| 16 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$J$8<=$H$6,G16<=$J$6),$C$8,"")) |
| 17 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$J$8<=$H$6,G17<=$J$6),$C$8,"")) |
| セルＫ |
| 9 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$K$8<=$H$6,G9<=$J$6),$C$8,"")) |
| 10 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$K$8<=$H$6,G10<=$J$6),$C$8,"")) |
| 11 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$K$8<=$H$6,G11<=$J$6),$C$8,"")) |
| 12 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$K$8<=$H$6,G12<=$J$6),$C$8,"")) |
| 13 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,K8<=$H$6,$G$13<=$J$6),$C$8, → |
| |
→ IF(AND($S$4<>"",$L$6<>$H$6*$J$6,$L$6<>""),"ち",""))) |
| 14 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$K$8<=$H$6,G14<=$J$6),$C$8,"")) |
| 15 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$K$8<=$H$6,G15<=$J$6),$C$8,"")) |
| 16 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$K$8<=$H$6,G16<=$J$6),$C$8,"")) |
| 17 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$K$8<=$H$6,G17<=$J$6),$C$8,"")) |
| セルＬ |
| 9 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$L$8<=$H$6,G9<=$J$6),$C$8,"")) |
| 10 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$L$8<=$H$6,G10<=$J$6),$C$8,"")) |
| 11 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$L$8<=$H$6,G11<=$J$6),$C$8,"")) |
| 12 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$L$8<=$H$6,G12<=$J$6),$C$8,"")) |
| 13 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,L8<=$H$6,$G$13<=$J$6),$C$8, → |
| |
→ IF(AND($S$4<>"",$L$6<>$H$6*$J$6,L6<>""),"が",""))) |
| 14 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$L$8<=$H$6,G14<=$J$6),$C$8,"")) |
| 15 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$L$8<=$H$6,G15<=$J$6),$C$8,"")) |
| 16 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$L$8<=$H$6,G16<=$J$6),$C$8,"")) |
| 17 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$L$8<=$H$6,G17<=$J$6),$C$8,"")) |
| セルＭ |
| 9 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$M$8<=$H$6,G9<=$J$6),$C$8,"")) |
| 10 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$M$8<=$H$6,G10<=$J$6),$C$8,"")) |
| 11 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$M$8<=$H$6,G11<=$J$6),$C$8,"")) |
| 12 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$M$8<=$H$6,G12<=$J$6),$C$8,"")) |
| 13 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,M8<=$H$6,$G$13<=$J$6),$C$8, → |
| |
→ IF(AND($S$4<>"",$L$6<>$H$6*$J$6,$L$6<>""),"い",""))) |
| 14 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$M$8<=$H$6,G14<=$J$6),$C$8,"")) |
| 15 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$M$8<=$H$6,G15<=$J$6),$C$8,"")) |
| 16 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$M$8<=$H$6,G16<=$J$6),$C$8,"")) |
| 17 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$M$8<=$H$6,G17<=$J$6),$C$8,"")) |
| セルＮ |
| 9 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$N$8<=$H$6,G9<=$J$6),$C$8,"")) |
| 10 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$N$8<=$H$6,G10<=$J$6),$C$8,"")) |
| 11 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$N$8<=$H$6,G11<=$J$6),$C$8,"")) |
| 12 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$N$8<=$H$6,G12<=$J$6),$C$8,"")) |
| 13 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,N8<=$H$6,$G$13<=$J$6),$C$8, → |
| |
→ IF(AND($S$4<>"",$L$6<>$H$6*$J$6,$L$6<>""),"で",""))) |
| 14 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$N$8<=$H$6,G14<=$J$6),$C$8,"")) |
| 15 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$N$8<=$H$6,G15<=$J$6),$C$8,"")) |
| 16 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$N$8<=$H$6,G16<=$J$6),$C$8,"")) |
| 17 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$N$8<=$H$6,G17<=$J$6),$C$8,"")) |
| セルＯ |
| 9 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$O$8<=$H$6,G9<=$J$6),$C$8,"")) |
| 10 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$O$8<=$H$6,G10<=$J$6),$C$8,"")) |
| 11 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$O$8<=$H$6,G11<=$J$6),$C$8,"")) |
| 12 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$O$8<=$H$6,G12<=$J$6),$C$8,"")) |
| 13 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,O8<=$H$6,$G$13<=$J$6),$C$8, → |
| |
→ IF(AND($S$4<>"",$L$6<>$H$6*$J$6,$L$6<>""),"す",""))) |
| 14 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$O$8<=$H$6,G14<=$J$6),$C$8,"")) |
| 15 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$O$8<=$H$6,G15<=$J$6),$C$8,"")) |
| 16 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$O$8<=$H$6,G16<=$J$6),$C$8,"")) |
| 17 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$O$8<=$H$6,G17<=$J$6),$C$8,"")) |
| セルＰ |
| 9 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$P$8<=$H$6,G9<=$J$6),$C$8,"")) |
| 10 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$P$8<=$H$6,G10<=$J$6),$C$8,"")) |
| 11 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$P$8<=$H$6,G11<=$J$6),$C$8,"")) |
| 12 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$P$8<=$H$6,G12<=$J$6),$C$8,"")) |
| 13 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$P$8<=$H$6,G13<=$J$6),$C$8,"")) |
| 14 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$P$8<=$H$6,G14<=$J$6),$C$8,"")) |
| 15 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$P$8<=$H$6,G15<=$J$6),$C$8,"")) |
| 16 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$P$8<=$H$6,G16<=$J$6),$C$8,"")) |
| 17 |
=IF(ISERR($H$6*$J$6),"",IF(AND($S$4<>"",$L$6=$H$6*$J$6,$P$8<=$H$6,G17<=$J$6),$C$8,"")) | |
