| 関数式の作成 |
| |
答えの枚数を計算します |
| セルＥ |
| 7 |
=IF(AND($C$4<>"",$I$4<>""),MOD(RIGHT(FIXED($C$4,0),1),5),"") |
| 8 |
=IF(AND($C$4<>"",$I$4<>""),(QUOTIENT(RIGHT(FIXED($C$4,0),1),5)),"") |
| 9 |
=IF(AND($C$4<>"",$I$4<>""),MOD(RIGHT(FIXED(INT($C$4/10),0),1),5),"") |
| 10 |
=IF(AND($C$4<>"",$I$4<>""),(QUOTIENT(RIGHT(FIXED(INT($C$4/10),0),1),5)),"") |
| 11 |
=IF(AND($C$4<>"",$I$4<>""),MOD(RIGHT(FIXED(INT($C$4/100),0),1),5),"") |
| 12 |
=IF(AND($C$4<>"",$I$4<>""),(QUOTIENT(RIGHT(FIXED(INT($C$4/100),0),1),5)),"") |
| 13 |
=IF(AND($C$4<>"",$I$4<>""),IF(OR(RIGHT(FIXED(INT($C$4/1000),0),1)="1",RIGHT(FIXED(INT($C$4/1000),0),1)="3",
→ |
| |
→ RIGHT(FIXED(INT($C$4/1000),0),1)="6",RIGHT(FIXED(INT($C$4/1000),0),1)="8"),1,0),"") |
| 14 |
=IF(AND($C$4<>"",$I$4<>""),QUOTIENT(MOD(RIGHT(FIXED(INT($C$4/1000),0),1),5),2),"") |
| 15 |
=IF(AND($C$4<>"",$I$4<>""),(QUOTIENT(RIGHT(FIXED(INT($C$4/1000),0),1),5)),"") |
| 16 |
=IF(AND(C4<>"",I4<>""),INT(C4/10^4),"") |
| |
金種を表示します |
| セルＧ |
| 7 |
=IF(F7<>"",IF(AND(F7<>"",I4=""),REPT("  ",F7),IF(AND($I$4<>"",F7<>"",E7=F7),REPT("
",E7),"まちがいです")),"") |
| 8 |
=IF(F8<>"",IF(AND(F8<>"",I4=""),REPT("  ",F8),IF(AND($I$4<>"",F8<>"",E8=F8),REPT("
",E8),"まちがいです")),"") |
| 9 |
=IF(F9<>"",IF(AND(F9<>"",I4=""),REPT("  ",F9),IF(AND($I$4<>"",F9<>"",E9=F9),REPT("
",E9),"まちがいです")),"") |
| 10 |
=IF(F10<>"",IF(AND(F10<>"",I4=""),REPT("  ",F10),IF(AND($I$4<>"",F10<>"",E10=F10),REPT("
",E10),"まちがいです")),"") |
| 11 |
=IF(F11<>"",IF(AND(F11<>"",I4=""),REPT("  ",F11),IF(AND($I$4<>"",F11<>"",E11=F11),REPT("
",E11),"まちがいです")),"") |
| 12 |
=IF(F12<>"",IF(AND(F12<>"",I4=""),REPT("  ",F12),IF(AND($I$4<>"",F12<>"",E12=F12),REPT(" ",E12),"まちがいです")),"") |
| 13 |
=IF(F13<>"",IF(AND(F13<>"",I4=""),REPT("  ",F13),IF(AND($I$4<>"",F13<>"",E13=F13),REPT("
",E13),"まちがいです")),"") |
| 14 |
=IF(F14<>"",IF(AND(F14<>"",I4=""),REPT("  ",F14),IF(AND($I$4<>"",F14<>"",E14=F14),REPT("
",E14),"まちがいです")),"") |
| 15 |
=IF(F15<>"",IF(AND(F15<>"",I4=""),REPT("  ",F15),IF(AND($I$4<>"",F15<>"",E15=F15),REPT("
",E15),"まちがいです")),"") |
| 16 |
=IF(F16<>"",IF(AND(F16<>"",I4=""),REPT("  ",F16),IF(AND($I$4<>"",F16<>"",E16=F16), → |
| |
→ (REPT("  ",INT(E16/10))&REPT(" ",MOD(RIGHT(FIXED(E16,0),1),10))),"まちがいです")),"") | |
