|
関数式の作成 |
|
表示する絵を決めます。 |
セルD11 |
=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))) |
セルF11 |
=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))) |
セルH11 |
=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))) |
|
絵の組み合わせにより点数を決めます。 |
セルF15 |
=IF(F7<>"",IF(AND(D11=" ",F11=" ",H11=" "),"100点",IF(AND(D11=" ",F11=" ",H11=" "),"80点", → |
|
→ IF(AND(D11=" ",F11=" ",H11=" "),"60点",IF(AND(D11=" ",F11=" ",H11=" "),"40点","ガンバレ")))),"") |
|
又は |
|
=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","がんばれ")))) | |