| 関数式の作成 |
| |
さいころの出目を決める式の、引数を決めます。 |
| セルＣ3 |
=RIGHT(A6,2) |
セルＤ3 |
=LEFT(A6,2) |
| セルＥ3 |
=MID(A6,2,2) |
セルＦ3 |
=MID(A6,4,2) |
| |
さいころの出目を決める数値を計算します。 |
| セルＪ3 |
=IF(A6<>"",IF(OR(ISERR(C3/E3),ISERR(E3/C3)),PI(),IF(OR(C3/E3=1,E3/C3=1),EXP(1),IF(E3>C3,C3/E3,E3/C3))),"") |
| セルＪ30 |
=IF(A6<>"",IF(OR(ISERR(D3/F3),ISERR(F3/D3)),EXP(1),IF(OR(D3/F3=1,F3/D3=1),PI(),IF(F3>D3,D3/F3,F3/D3))),"") |
| |
何回目かを表示します。 |
|
|
| セルＧ2 |
=IF(G6<>"","１回","") |
セルＩ2 |
=IF(I6<>"","２回","") |
| セルＫ2 |
=IF(K6<>"","３回","") |
セルＭ2 |
=IF(M6<>"","４回","") |
| セルＯ2 |
=IF(O6<>"","５回","") |
セルＱ2 |
=IF(Q6<>"","６回","") |
| セルＳ2 |
=IF(S6<>"","７回","") |
セルＵ2 |
=IF(U6<>"","８回","") |
| セルＷ2 |
=IF(W6<>"","９回","") |
セルＹ2 |
=IF(Y6<>"","１０回","") |
| セルＡＡ2 |
=IF(AA6<>"","１１回","") |
セルＡＣ2 |
=IF(AC6<>"","１２回","") |
| |
順番のときに、さいころの出目を表示します。 |
| セルＫ4 |
=IF(A6<>"",MOD(MID(J3,K3,2),6),"") |
| セルＬ4 |
=IF(COUNTIF($C$9:$AB$27,"*")>=7,MOD(MID($J$3,L3,2),6),"") |
| セルＭ4 |
=IF(COUNTIF($C$9:$AＢ$27,"*")>=９,MOD(MID($J$3,M3,2),6),"") |
| セルＮ4 |
=IF(COUNTIF($C$9:$AＢ$27,"*")>=1１,MOD(MID($J$3,N3,2),6),"") |
| セルＯ4 |
=IF(COUNTIF($C$9:$AB$27,"*")>=13,MOD(MID($J$3,O3,2),6),"") |
| セルＰ4 |
=IF(COUNTIF($C$9:$AB$27,"*")>=15,MOD(MID($J$3,P3,2),6),"") |
| セルＱ4 |
=IF(COUNTIF($C$9:$AB$27,"*")>=17,MOD(MID($J$3,Q3,2),6),"") |
| セルＲ4 |
=IF(COUNTIF($C$9:$AB$27,"*")>=19,MOD(MID($J$3,R3,2),6),"") |
| セルＳ4 |
=IF(COUNTIF($C$9:$AB$27,"*")>=21,MOD(MID($J$3,S3,2),6),"") |
| セルＴ4 |
=IF(COUNTIF($C$9:$AB$27,"*")>=23,MOD(MID($J$3,T3,2),6),"") |
| セルＵ4 |
=IF(COUNTIF($C$9:$AB$27,"*")>=25,MOD(MID($J$3,U3,2),6),"") |
| セルＶ4 |
=IF(COUNTIF($C$9:$AB$27,"*")>=27,MOD(MID($J$3,L3,3),6),"") |
| |
順番のとき、さいころの色を変えて表示する条件式を表します。 |
| セルＫ5 |
=AND(K4<>"",COUNT(L4:$V$4)<1,COUNT(K31:$V$31)<1) |
| セルＬ5 |
=AND(L4<>"",COUNT(M4:$V$4)<1,COUNT(L31:$V$31)<1) |
| セルＭ5 |
=AND(M4<>"",COUNT(N4:$V$4)<1,COUNT(M31:$V$31)<1) |
| セルＮ5 |
=AND(N4<>"",COUNT(O4:$V$4)<1,COUNT(N31:$V$31)<1) |
| セルＯ5 |
=AND(O4<>"",COUNT(P4:$V$4)<1,COUNT(O31:$V$31)<1) |
| セルＰ5 |
=AND(P4<>"",COUNT(Q4:$V$4)<1,COUNT(P31:$V$31)<1) |
| セルＱ5 |
=AND(Q4<>"",COUNT(R4:$V$4)<1,COUNT(Q31:$V$31)<1) |
| セルＲ5 |
=AND(R4<>"",COUNT(S4:$V$4)<1,COUNT(R31:$V$31)<1) |
| セルＳ5 |
=AND(S4<>"",COUNT(T4:$V$4)<1,COUNT(S31:$V$31)<1) |
| セルＴ5 |
=AND(T4<>"",COUNT(U4:$V$4)<1,COUNT(T31:$V$31)<1) |
| セルＵ5 |
=AND(U4<>"",COUNT($V4:V$4)<1,COUNT(U31:$V$31)<1) |
| セルＶ5 |
=AND(V4<>"",COUNT($W4:W$4)<1,COUNT($V31:V$31)<1) |
| |
さいころを表示します。 |
| セルＧ6 |
=IF(C18<>"",IF(K4=1," ",IF(K4=2," ",IF(K4=3," ",IF(K4=4," ",IF(K4=5," ",IF(K4=0," ","")))))),"") |
| セルＩ6 |
=IF(L4=1,"",IF(L4=2,"",IF(L4=3,"",IF(L4=4,"",IF(L4=5,"",IF(L4=0,"","")))))) |
| セルＫ6 |
=IF(M4=1,"",IF(M4=2,"",IF(M4=3,"",IF(M4=4,"",IF(M4=5,"",IF(M4=0,"","")))))) |
| セルＭ6 |
=IF(N4=1,"",IF(N4=2,"",IF(N4=3,"",IF(N4=4,"",IF(N4=5,"",IF(N4=0,"","")))))) |
| セルＯ6 |
=IF(O4=1,"",IF(O4=2,"",IF(O4=3,"",IF(O4=4,"",IF(O4=5,"",IF(O4=0,"","")))))) |
| セルＱ6 |
=IF(P4=1,"",IF(P4=2,"",IF(P4=3,"",IF(P4=4,"",IF(P4=5,"",IF(P4=0,"","")))))) |
| セルＳ6 |
=IF(Q4=1,"",IF(Q4=2,"",IF(Q4=3,"",IF(Q4=4,"",IF(Q4=5,"",IF(Q4=0,"","")))))) |
| セルＵ6 |
=IF(R4=1,"",IF(R4=2,"",IF(R4=3,"",IF(R4=4,"",IF(R4=5,"",IF(R4=0,"","")))))) |
| セルＷ6 |
=IF(S4=1,"",IF(S4=2,"",IF(S4=3,"",IF(S4=4,"",IF(S4=5,"",IF(S4=0,"","")))))) |
| セルＹ6 |
=IF(T4=1,"",IF(T4=2,"",IF(T4=3,"",IF(T4=4,"",IF(T4=5,"",IF(T4=0,"","")))))) |
| セルＡＡ6 |
=IF(U4=1,"",IF(U4=2,"",IF(U4=3,"",IF(U4=4,"",IF(U4=5,"",IF(U4=0,"","")))))) |
| セルＡＣ6 |
=IF(V4=1,"",IF(V4=2,"",IF(V4=3,"",IF(V4=4,"",IF(V4=5,"",IF(V4=0,"","")))))) |
| |
角のセルに止まったら絵（セルＡＭ１１からＡＮ２５に入力しておく）を表示させます。 |
| セルＲ11 |
=IF(P12<>"",AM13,"") |
セルＲ23 |
=IF(P24<>"",AN13,"") |
| セルＹ12 |
=IF(W15<>"",AM20,"") |
セルＹ22 |
=IF(W21<>"",AN20,"") |
| |
順番の表示をします。 |
| セルＡ12 |
=IF(OR(A15<>"",AD20<>""),"",IF(COUNTIF(C8:AD17,"*")-2=COUNTIF(C19:AD27,"*")-2, → |
| |
→ "順番だよ",COUNTIF(C8:AD17,"*")-2)) |
| セルＡ23 |
=IF(OR(A21<>"",AD16<>""),"",IF(COUNTIF(C8:AD17,"*")-2>COUNTIF(C19:AD27,"*")-2, → |
| |
→ "順番だよ",COUNTIF(C19:AD27,"*")-2)) |
| |
勝敗の表示をします。 |
| セルＡ15 |
=IF(AND(COUNTIF($C$8:$AD$17,"*")=COUNTIF($C$19:$AD$28,"*"),
AND($AD$16<>"",$AD$20="")),"勝ちました", → |
| |
→ IF(AND(COUNTIF($C$8:$AD$17,"*")=COUNTIF($C$19:$AD$28,"*"),AND($AD$16<>"",$AD$20<>"")),"引き分け","")) |
| セルＡ21 |
=IF(AND(COUNTIF($C$8:$AD$17,"*")=COUNTIF($C$19:$AD$28,"*"),AND($AD$16="",$AD$20<>"")),"勝ちました", → |
| |
→ IF(AND(COUNTIF($C$8:$AD$17,"*")=COUNTIF($C$19:$AD$28,"*"),AND($AD$16<>"",$AD$20<>"")),"引き分け","")) |
| |
条件付き書式 |
| |
さいころの色を、セルＫ５の順番のとき、式が「ＴＲＵＥ」のとき変化させます。 |
| |
条件１（１）は、セルＫ５に入力してある式を条件として使います。 |
| |
セルＧ６ 条件付き書式は =Ｋ５ |
| |
セルＩ６ 条件付き書式は =Ｌ５ |
| |
セルＫ６ 条件付き書式は =Ｍ５ |
| |
セルＬ６ 条件付き書式は =Ｎ５ |
| |
セルＭ６ 条件付き書式は =Ｏ５ |
| |
セルＯ６ 条件付き書式は =Ｐ５ |
| |
セルＱ６ 条件付き書式は =Ｑ５ |
| |
セルＳ６ 条件付き書式は =Ｒ５ |
| |
セルＵ６ 条件付き書式は =Ｓ５ |
| |
セルＷ６ 条件付き書式は =Ｔ５ |
| |
セルＡＡ６ 条件付き書式は =Ｕ５ |
| |
セルＡＣ６ 条件付き書式は =Ｖ５ |
| |
さいころの色を、セルＫ３１のさいころの数が表示されたとき変化させます。 |
| |
セルＧ３３ 条件付き書式は =AND(ｋ31<>"",COUNT(Ｌ4:$W$4)<1) |
| |
セルＩ３３
条件付き書式は =AND(L31<>"",COUNT(M4:$W$4)<1) |
| |
セルＫ３３ 条件付き書式は =AND(M31<>"",COUNT(N4:$W$4)<1) |
| |
セルＬ３３ 条件付き書式は =AND(N31<>"",COUNT(O4:$W$4)<1) |
| |
セルＭ３３ 条件付き書式は =AND(O31<>"",COUNT(P4:$W$4)<1) |
| |
セルＯ３３ 条件付き書式は =AND(P31<>"",COUNT(Q4:$W$4)<1) |
| |
セルＱ３３ 条件付き書式は =AND(Q31<>"",COUNT(R4:$W$4)<1) |
| |
セルＳ３３ 条件付き書式は =AND(R31<>"",COUNT(S4:$W$4)<1) |
| |
セルＵ３３ 条件付き書式は =AND(S31<>"",COUNT(T4:$W$4)<1) |
| |
セルＷ３３ 条件付き書式は =AND(T31<>"",COUNT(U4:$W$4)<1) |
| |
セルＡＡ３３ 条件付き書式は =AND(U31<>"",COUNT(V4:$W$4)<1) |
| |
セルＡＣ３３ 条件付き書式は =AND(V31<>"",COUNT(W4:$W$4)<1) |
| |
何回目かを表示します。 |
| セルＧ32 |
=IF(G33<>"","１回","") |
セルＩ32 |
=IF(I33<>"","２回","") |
| セルＫ32 |
=IF(K33<>"","３回","") |
セルＭ32 |
=IF(M33<>"","４回","") |
| セルＯ32 |
=IF(O33<>"","５回","") |
セルＱ32 |
=IF(Q33<>"","６回","") |
| セルＳ32 |
=IF(S33<>"","７回","") |
セルＵ32 |
=IF(U33<>"","８回","") |
| セルＷ32 |
=IF(W33<>"","９回","") |
セルＹ32 |
=IF(Y33<>"","１０回","") |
| セルＡＡ32 |
=IF(AA33<>"","１１回","") |
セルＡＣ32 |
=IF(AC33<>"","１２回","") |
| |
順番のときに、さいころの出目を表示します。 |
| セルＫ31 |
=IF(COUNTIF(C9:AB17,"*")>=3,MOD(MID(J30,K30,2),6),"") |
| セルＬ31 |
=IF(COUNTIF($C$9:$AD$27,"*")>=8,MOD(MID($J$30,L30,2),6),"") |
| セルＭ31 |
=IF(COUNTIF($C$9:$AD$27,"*")>=10,MOD(MID($J$30,M30,2),6),"") |
| セルＮ31 |
=IF(COUNTIF($C$9:$AD$27,"*")>=12,MOD(MID($J$30,N30,2),6),"") |
| セルＯ31 |
=IF(COUNTIF($C$9:$AD$27,"*")>=14,MOD(MID($J$30,O30,2),6),"") |
| セルＰ31 |
=IF(COUNTIF($C$9:$AD$27,"*")>=16,MOD(MID($J$30,P30,2),6),"") |
| セルＱ31 |
=IF(COUNTIF($C$9:$AD$27,"*")>=18,MOD(MID($J$30,Q30,2),6),"") |
| セルＲ31 |
=IF(COUNTIF($C$9:$AD$27,"*")>=20,MOD(MID($J$30,R30,2),6),"") |
| セルＳ31 |
=IF(COUNTIF($C$9:$AD$27,"*")>=22,MOD(MID($J$30,S30,2),6),"") |
| セルＴ31 |
=IF(COUNTIF($C$9:$AD$27,"*")>=24,MOD(MID($J$30,T30,2),6),"") |
| セルＵ31 |
=IF(COUNTIF($C$9:$AD$27,"*")>=26,MOD(MID($J$30,U30,2),6),"") |
| セルＶ31 |
=IF(COUNTIF($C$9:$AD$27,"*")>=28,MOD(MID($J$30,K30,3),6),"") |
| |
さいころを表示します。 |
| セルＧ33 |
=IF(K31=1,"",IF(K31=2,"",IF(K31=3,"",IF(K31=4,"",IF(K31=5,"",IF(K31=0,"","")))))) |
| セルＩ33 |
=IF(L31=1,"",IF(L31=2,"",IF(L31=3,"",IF(L31=4,"",IF(L31=5,"",IF(L31=0,"","")))))) |
| セルＫ33 |
=IF(M31=1,"",IF(M31=2,"",IF(M31=3,"",IF(M31=4,"",IF(M31=5,"",IF(M31=0,"","")))))) |
| セルＭ33 |
=IF(N31=1,"",IF(N31=2,"",IF(N31=3,"",IF(N31=4,"",IF(N31=5,"",IF(N31=0,"","")))))) |
| セルＯ33 |
=IF(O31=1,"",IF(O31=2,"",IF(O31=3,"",IF(O31=4,"",IF(O31=5,"",IF(O31=0,"","")))))) |
| セルＱ33 |
=IF(P31=1,"",IF(P31=2,"",IF(P31=3,"",IF(P31=4,"",IF(P31=5,"",IF(P31=0,"","")))))) |
| セルＳ33 |
=IF(Q31=1,"",IF(Q31=2,"",IF(Q31=3,"",IF(Q31=4,"",IF(Q31=5,"",IF(Q31=0,"","")))))) |
| セルＵ33 |
=IF(R31=1,"",IF(R31=2,"",IF(R31=3,"",IF(R31=4,"",IF(R31=5,"",IF(R31=0,"","")))))) |
| セルＷ33 |
=IF(S31=1,"",IF(S31=2,"",IF(S31=3,"",IF(S31=4,"",IF(S31=5,"",IF(S31=0,"","")))))) |
| セルＹ33 |
=IF(T31=1,"",IF(T31=2,"",IF(T31=3,"",IF(T31=4,"",IF(T31=5,"",IF(T31=0,"","")))))) |
| セルＡＡ33 |
=IF(U31=1,"",IF(U31=2,"",IF(U31=3,"",IF(U31=4,"",IF(U31=5,"",IF(U31=0,"","")))))) |
| セルＡＣ33 |
=IF(V31=1,"",IF(V31=2,"",IF(V31=3,"",IF(V31=4,"",IF(V31=5,"",IF(V31=0,"","")))))) | |
