| 対戦ゲーム |
| |
潜行する物体を選択します。 |
| セルＤ３ |
IF(C3<>""," ","") |
| 4 |
IF(C4<>""," ","") |
| |
対戦中、準備中の表示をします。 |
| セルＪ４ |
IF(AND(OR(COUNTIF(D28:I33,"*")>=1,COUNTIF(V4:AA9,"*")>=1),F6=O6),"対戦中","準備中") |
| |
潜行、準備中の表示をします。 |
| セルＪ６ |
IF(AND(F6<>"",O6<>"",F6=O6),"潜 行","準備中") |
| |
潜行物体を発見したときに「発見」を表示します。 |
| セルＪ８ |
IF(AND(OR(F8>=1,O8>=1),OR(F8<>"",O8<>"")),"発見","捜査中") |
| |
潜行している数を表示します。 |
| セルＦ６ |
IF(COUNTIF(D28:I33,"*")>0,COUNTIF(D28:I33,"*"),"") |
| セルＯ６ |
IF(COUNTIF(V4:AA9,"*")>0,COUNTIF(V4:AA9,"*"),"") |
| |
潜行している数の単位を表示します。 |
| セルＧ６ |
IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF($C$3<>"","隻","匹"),"") |
| セルＰ６ |
IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF($C$3<>"","隻","匹"),"") |
| |
発見した潜行数を表示します。 |
| セルＦ８ |
IF(F6="","",IF(COUNTIF(D12:I17,IF(C3<>""," "))<1,0,COUNTIF(D12:I17,IF(C3<>"","")))) |
| セルＯ８ |
IF(O6="","",IF(COUNTIF(M12:R17,IF(C3<>"",""))<1,0,COUNTIF(M12:R17,IF(C3<>"","")))) |
| |
発見した潜行数の単位を表示します。 |
| セルＧ８ |
IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF($C$3<>"","隻","匹"),"") |
| セルＰ８ |
IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF($C$3<>"","隻","匹"),"") |
| |
発見されない潜行数を表示します。 |
| セルＥ１０ |
IF(F6<>O6,"準備中",IF(F6="","",IF(AND(F6=F8,O6=O8),"引き分け",IF(AND(F6=F8,F8>O8),"勝利", → |
| |
→ IF(AND(O6=O8,F8<O8), "敗北","潜行
あと"&F6-F8&"隻"))))） |
| セルＮ１０ |
IF(F6<>O6,"準備中",IF(O6="","",IF(AND(O6=O8,F6=F8),"引き分け",IF(AND(O6=O8,O8>F8),"勝利", → |
| |
→ IF(AND(O6=O8,F8<O8), "敗北","潜行
あと"&F6-F8&"隻"))))） | |
| |
潜行物体を表示 |
| セルＤ |
| 12 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(D19<>"",D19=D28),IF($C$3<>"",""),""),"") |
| 13 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(D20<>"",D20=D29),IF($C$3<>"",""),""),"") |
| 14 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(D21<>"",D21=D30),IF($C$3<>"",""),""),"") |
| 15 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(D22<>"",D22=D31),IF($C$3<>"",""),""),"") |
| 16 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(D23<>"",D23=D32),IF($C$3<>"",""),""),"") |
| 17 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(D24<>"",D24=D33),IF($C$3<>"",""),""),"") |
| セルＥ |
| 12 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(E19<>"",E19=E28),IF($C$3<>"",""),""),"") |
| 13 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(E20<>"",E20=E29),IF($C$3<>"",""),""),"") |
| 14 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(E21<>"",E21=E30),IF($C$3<>"",""),""),"") |
| 15 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(E22<>"",E22=E31),IF($C$3<>"",""),""),"") |
| 16 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(E23<>"",E23=E32),IF($C$3<>"",""),""),"") |
| 17 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(E24<>"",E24=E33),IF($C$3<>"","),""),"") |
| セルＦ |
| 12 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(F19<>"",F19=F28),IF($C$3<>"",""),""),"") |
| 13 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(F20<>"",F20=F29),IF($C$3<>"",""),""),"") |
| 14 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(F21<>"",F21=F30),IF($C$3<>"",""),""),"") |
| 15 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(F22<>"",F22=F31),IF($C$3<>"",""),""),"") |
| 16 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(F23<>"",F23=F32),IF($C$3<>"",""),""),"") |
| 17 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(F24<>"",F24=F33),IF($C$3<>"",""),""),"") |
| セルＧ |
| 12 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(G19<>"",G19=G28),IF($C$3<>"",""),""),"") |
| 13 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(G20<>"",G20=G29),IF($C$3<>"",""),""),"") |
| 14 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(G21<>"",G21=G30),IF($C$3<>"",""),""),"") |
| 15 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(G22<>"",G22=G31),IF($C$3<>"",""),""),"") |
| 16 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(G23<>"",G23=G32),IF($C$3<>"",""),""),"") |
| 17 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(G24<>"",G24=G33),IF($C$3<>"",""),""),"") |
| セルＨ |
| 12 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(H19<>"",H19=H28),IF($C$3<>"",""),""),"") |
| 13 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(H20<>"",H20=H29),IF($C$3<>"",""),""),"") |
| 14 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(H21<>"",H21=H30),IF($C$3<>"",""),""),"") |
| 15 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(H22<>"",H22=H31),IF($C$3<>"",""),""),"") |
| 16 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(H23<>"",H23=H32),IF($C$3<>"",""),""),"") |
| 17 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(H24<>"",H24=H33),IF($C$3<>"",""),""),"") |
| セルＩ |
| 12 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(I19<>"",I19=I28),IF($C$3<>"",""),""),"") |
| 13 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(I20<>"",I20=I29),IF($C$3<>"",""),""),"") |
| 14 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(I21<>"",I21=I30),IF($C$3<>"",""),""),"") |
| 15 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(I22<>"",I22=I31),IF($C$3<>"",""),""),"") |
| 16 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(I23<>"",I23=I32),IF($C$3<>"",""),""),"") |
| 17 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(I24<>"",I24=I33),IF($C$3<>"",""),""),"") |
| セルＭ |
| 12 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(M19<>"",M19=V4),IF($C$3<>"",""),""),"") |
| 13 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(M20<>"",M20=V5),IF($C$3<>"",""),""),"") |
| 14 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(M21<>"",M21=V6),IF($C$3<>"",""),""),"") |
| 15 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(M22<>"",M22=V7),IF($C$3<>"",""),""),"") |
| 16 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(M23<>"",M23=V8),IF($C$3<>"",""),""),"") |
| 17 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(M24<>"",M24=V9),IF($C$3<>"",""),""),"") |
| セルＮ |
| 12 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(N19<>"",N19=W4),IF($C$3<>"",""),""),"") |
| 13 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(N20<>"",N20=W5),IF($C$3<>"",""),""),"") |
| 14 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(N21<>"",N21=W6),IF($C$3<>"",""),""),"") |
| 15 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(N22<>"",N22=W7),IF($C$3<>"",""),""),"") |
| 16 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(N23<>"",N23=W8),IF($C$3<>"",""),""),"") |
| 17 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(N24<>"",N24=W9),IF($C$3<>"",""),""),"") |
| セルＯ |
| 12 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(O19<>"",O19=X4),IF($C$3<>"",""),""),"") |
| 13 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(O20<>"",O20=X5),IF($C$3<>"",""),""),"") |
| 14 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(O21<>"",O21=X6),IF($C$3<>"",""),""),"") |
| 15 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(O22<>"",O22=X7),IF($C$3<>"",""),""),"") |
| 16 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(O23<>"",O23=X8),IF($C$3<>"",""),""),"") |
| 17 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(O24<>"",O24=X9),IF($C$3<>"",""),""),"") |
| セルＰ |
| 12 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(P19<>"",P19=Y4),IF($C$3<>"",""),""),"") |
| 13 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(P20<>"",P20=Y5),IF($C$3<>"",""),""),"") |
| 14 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(P21<>"",P21=Y6),IF($C$3<>"",""),""),"") |
| 15 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(P22<>"",P22=Y7),IF($C$3<>"",""),""),"") |
| 16 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(P23<>"",P23=Y8),IF($C$3<>"",""),""),"") |
| 17 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(P24<>"",P24=Y9),IF($C$3<>"",""),""),"") |
| セルＱ |
| 12 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(Q19<>"",Q19=Z4),IF($C$3<>"",""),""),"") |
| 13 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(Q20<>"",Q20=Z5),IF($C$3<>"",""),""),"") |
| 14 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(Q21<>"",Q21=Z6),IF($C$3<>"",""),""),"") |
| 15 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(Q22<>"",Q22=Z7),IF($C$3<>"",""),""),"") |
| 16 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(Q23<>"",Q23=Z8),IF($C$3<>"",""),""),"") |
| 17 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(Q24<>"",Q24=Z9),IF($C$3<>"",""),""),"") |
| セルＲ |
| 12 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(R19<>"",R19=AA4),IF($C$3<>"",""),""),"") |
| 13 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(R20<>"",R20=AA5),IF($C$3<>"",""),""),"") |
| 14 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(R21<>"",R21=AA6),IF($C$3<>"",""),""),"") |
| 15 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(R22<>"",R22=AA7),IF($C$3<>"",""),""),"") |
| 16 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(R23<>"",R23=AA8),IF($C$3<>"",""),""),"") |
| 17 |
=IF(AND(OR($C$3<>"",$C$4<>""),OR($C$3="",$C$4="")),IF(AND(R24<>"",R24=AA9),IF($C$3<>"",""),""),"") | |
