| |
関数式の作成 |
| |
表示する絵を決めます。 |
| セルＤ11 |
=IF(AND(INT(RAND()*100)>=0,INT(RAND()*100)<25),B6,IF(AND(INT(RAND()*100)>=25,INT(RAND()*100)<50),B7,
→ |
| |
→ IF(AND(INT(RAND()*100)>=50,INT(RAND()*100)<75),B8,B9))) |
| セルＦ11 |
=IF(AND(INT(RAND()*100)>=0,INT(RAND()*100)<25),B6,IF(AND(INT(RAND()*100)>=25,INT(RAND()*100)<50),B7, → |
| |
→ IF(AND(INT(RAND()*100)>=50,INT(RAND()*100)<75),B8,B9))) |
| セルＨ11 |
=IF(AND(INT(RAND()*100)>=0,INT(RAND()*100)<25),B6,IF(AND(INT(RAND()*100)>=25,INT(RAND()*100)<50),B7, → |
| |
→ IF(AND(INT(RAND()*100)>=50,INT(RAND()*100)<75),B8,B9))) |
| |
絵の組み合わせにより点数を決めます。 |
| セルＦ15 |
=IF(F7<>"",IF(AND(D11=" ",F11="",H11=""),"１００点",IF(AND(D11=" ",F11="",H11=""),"８０点", → |
| |
→ IF(AND(D11=" ",F11="",H11=""),"６０点",IF(AND(D11=" ",F11="",H11=""),"４０点","ガンバレ")))),"") |
| |
又は |
| |
=IF(COUNTIF(D11:H11,B9)=3,"100",IF(COUNTIF(D11:H11,B8)=3,"80",IF(COUNTIF(D11:H11,B7)=3,"60", |
| |
→ IF(COUNTIF(D11:H11,B6)=3,"40","がんばれ")))) | |
