| 関数式の作成 |
| 問題を乱数表より求めます。 |
 |
| 問題の左の数値を選択する、基準値の引数を求めます。 |
| セルＡＡ１４ |
=IF(AE20<>"",IF(MOD(AE20,10)=0,10,MOD(AE20,10)),"") |
| セルＡＥ１４ |
=IF(AE20<>"",IF(MOD(AE20/10,10)=0,10,MOD(AE20/10,10)),"") |
| 第一問の左の数値基準を求めます。 |
| セルＡＨ１４ |
=IF(AE20<>"",HLOOKUP($AA$14,$D$4:$Q$18,$AE$14),"") |
| 問題の右の数値を選択する、基準値の引数を求めます。 |
| セルＡＡ１５ |
=IF(AE20<>"",IF(MOD(AE20,10)=0,10,MOD(AE20,10)),"") |
| セルＡＥ１５ |
=IF(AE20<>"",IF(MOD(AE20/10,10)=0,10,MOD(AE20/10,10)),"") |
| 第一問の右の数値基準を求めます。 |
| セルＡＨ１５ |
=IF(AE20<>"",VLOOKUP($AE$15,$C$5:$Q$18,$AA$15),"") |
| 問題の左枠の数値を求めます |
| セルＣ２３ |
=IF($AE$20<>"",HLOOKUP($AA$14,$D$4:$Q$18,$AE$14),"") |
| セルＯ２３ |
=IF($AE$20<>"",HLOOKUP($AA$14,$D$4:$Q$18,$AE$14+1),"") |
| セルＡＡ２３ |
=IF($AE$20<>"",HLOOKUP($AA$14,$D$4:$Q$18,$AE$14+2),"") |
| 問題の右枠の数値を求めます |
| セルＥ２３ |
=IF($AE$20<>"",VLOOKUP($AE$15,$C$5:$Q$18,$AA$15),"") |
| セルＱ２３ |
=IF($AE$20<>"",VLOOKUP($AE$15,$C$5:$Q$18,$AA$15+1),"") |
| セルＡＣ２３ |
=IF($AE$20<>"",VLOOKUP($AE$15,$C$5:$Q$18,$AA$15+2),"") |
| 絵の表示 |
| セルＣ |
| 26 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,C25<=C23,B26<=E23),B25,"")) |
| 27 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,C25<=C23,B27<=E23),B25,"")) |
| 28 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,C25<=C23,B28<=E23),B25,"")) |
| 29 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,C25<=C23,B29<=E23),B25,"")) |
| 30 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,C25<=C23,B30<=E23),B25,"")) |
| 31 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,C25<=C23,B31<=E23),B25,"")) |
| 32 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,C25<=C23,B32<=E23),B25,"")) |
| 33 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,C25<=C23,B33<=E23),B25,"")) |
| 34 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,C25<=C23,B34<=E23),B25,"")) |
| セルＤ |
| 26 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,D25<=C23,B26<=E23),B25,"")) |
| 27 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,D25<=C23,B27<=E23),B25,"")) |
| 28 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,D25<=C23,B28<=E23),B25,"")) |
| 29 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,D25<=C23,B29<=E23),B25,"")) |
| 30 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,D25<=C23,B30<=E23),B25,"")) |
| 31 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,D25<=C23,B31<=E23),B25,"")) |
| 32 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,D25<=C23,B32<=E23),B25,"")) |
| 33 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,D25<=C23,B33<=E23),B25,"")) |
| 34 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,D25<=C23,B34<=E23),B25,"")) |
| セルＥ |
| 26 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,E25<=C23,B26<=E23),B25,"")) |
| 27 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,E25<=C23,B27<=E23),B25,"")) |
| 28 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,E25<=C23,B28<=E23),B25,"")) |
| 29 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,E25<=C23,B29<=E23),B25,"")) |
| 30 |
=IF(OR(ISERR(C23*E23),G23=""),"",IF(AND($J$21<>"",G23=C23*E23,E25<=C23,B30<=E23),B25,
→IF(AND($J$21<>"",G23<>C23*E23),"ま",""))) |
| 31 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,E25<=C23,B31<=E23),B25,"")) |
| 32 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,E25<=C23,B32<=E23),B25,"")) |
| 33 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,E25<=C23,B33<=E23),B25,"")) |
| 34 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,E25<=C23,B34<=E23),B25,"")) |
| セルＦ |
| 26 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,F25<=C23,B26<=E23),B25,"")) |
| 27 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,F25<=C23,B27<=E23),B25,"")) |
| 28 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,F25<=C23,B28<=E23),B25,"")) |
| 29 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,F25<=C23,B29<=E23),B25,"")) |
| 30 |
=IF(OR(ISERR(C23*E23),G23=""),"",IF(AND($J$21<>"",G23=C23*E23,F25<=C23,B30<=E23),B25,
→IF(AND($J$21<>"",G23<>C23*E23),"ち",""))) |
| 31 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,F25<=C23,B31<=E23),B25,"")) |
| 32 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,F25<=C23,B32<=E23),B25,"")) |
| 33 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,F25<=C23,B33<=E23),B25,"")) |
| 34 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,F25<=C23,B34<=E23),B25,"")) |
| セルＧ |
| 26 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,G25<=C23,B26<=E23),B25,"")) |
| 27 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,G25<=C23,B27<=E23),B25,"")) |
| 28 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,G25<=C23,B28<=E23),B25,"")) |
| 29 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,G25<=C23,B29<=E23),B25,"")) |
| 30 |
=IF(OR(ISERR(C23*E23),G23=""),"",IF(AND($J$21<>"",G23=C23*E23,G25<=C23,B30<=E23),B25,
→IF(AND($J$21<>"",G23<>C23*E23),"が",""))) |
| 31 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,G25<=C23,B31<=E23),B25,"")) |
| 32 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,G25<=C23,B32<=E23),B25,"")) |
| 33 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,G25<=C23,B33<=E23),B25,"")) |
| 34 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,G25<=C23,B34<=E23),B25,"")) |
| セルＨ |
| 26 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,H25<=C23,B26<=E23),B25,"")) |
| 27 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,H25<=C23,B27<=E23),B25,"")) |
| 28 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,H25<=C23,B28<=E23),B25,"")) |
| 29 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,H25<=C23,B29<=E23),B25,"")) |
| 30 |
=IF(OR(ISERR(C23*E23),G23=""),"",IF(AND($J$21<>"",G23=C23*E23,H25<=C23,B30<=E23),B25,
→IF(AND($J$21<>"",G23<>C23*E23),"い",""))) |
| 31 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,H25<=C23,B31<=E23),B25,"")) |
| 32 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,H25<=C23,B32<=E23),B25,"")) |
| 33 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,H25<=C23,B33<=E23),B25,"")) |
| 34 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,H25<=C23,B34<=E23),B25,"")) |
| セルＩ |
| 26 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,I25<=C23,B26<=E23),B25,"")) |
| 27 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,I25<=C23,B27<=E23),B25,"")) |
| 28 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,I25<=C23,B28<=E23),B25,"")) |
| 29 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,I25<=C23,B29<=E23),B25,"")) |
| 30 |
=IF(OR(ISERR(C23*E23),G23=""),"",IF(AND($J$21<>"",G23=C23*E23,I25<=C23,B30<=E23),B25,
→IF(AND($J$21<>"",G23<>C23*E23),"で",""))) |
| 31 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,I25<=C23,B31<=E23),B25,"")) |
| 32 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,I25<=C23,B32<=E23),B25,"")) |
| 33 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,I25<=C23,B33<=E23),B25,"")) |
| 34 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,I25<=C23,B34<=E23),B25,"")) |
| セルＪ |
| 26 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,J25<=C23,B26<=E23),B25,"")) |
| 27 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,J25<=C23,B27<=E23),B25,"")) |
| 28 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,J25<=C23,B28<=E23),B25,"")) |
| 29 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,J25<=C23,B29<=E23),B25,"")) |
| 30 |
=IF(OR(ISERR(C23*E23),G23=""),"",IF(AND($J$21<>"",G23=C23*E23,J25<=C23,B30<=E23),B25,
→IF(AND($J$21<>"",G23<>C23*E23),"す",""))) |
| 31 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,J25<=C23,B31<=E23),B25,"")) |
| 32 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,J25<=C23,B32<=E23),B25,"")) |
| 33 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,J25<=C23,B33<=E23),B25,"")) |
| 34 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,J25<=C23,B34<=E23),B25,"")) |
| セルＫ |
| 26 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,K25<=C23,B26<=E23),B25,"")) |
| 27 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,K25<=C23,B27<=E23),B25,"")) |
| 28 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,K25<=C23,B28<=E23),B25,"")) |
| 29 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,K25<=C23,B29<=E23),B25,"")) |
| 30 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,K25<=C23,B30<=E23),B25,"")) |
| 31 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,K25<=C23,B31<=E23),B25,"")) |
| 32 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,K25<=C23,B32<=E23),B25,"")) |
| 33 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,K25<=C23,B33<=E23),B25,"")) |
| 34 |
=IF(ISERR(C23*E23),"",IF(AND($J$21<>"",G23=C23*E23,K25<=C23,B34<=E23),B25,"")) |
| * 一つの表を作成して、必要なだけコピーして使います |
| |
| |
