| 関数式の作成 |
| |
階数を表示します |
| ｾﾙＨ |
| 4 |
=IF($E$4<>"",IF(OR(H5="",H5="PH"),"",IF(H5+$E$8>$E$4,"PH",H5+$E$8)),"") |
| 5 |
=IF($E$4<>"",IF(OR(H6="",H6="PH"),"",IF(H6+$E$8>$E$4,"PH",H6+$E$8)),"") |
| 6 |
=IF($E$4<>"",IF(OR(H7="",H7="PH"),"",IF(H7+$E$8>$E$4,"PH",H7+$E$8)),"") |
| 7 |
=IF(E4<>"",1,"") |
| 9 |
=IF(E6<>"",1,"") |
| 10 |
=IF(H9<>"",IF((H9+1)<=$E$6,H9+1,""),"") |
| |
絵を表示します |
| ｾﾙＱ |
| 11 |
=IF(H4<>"",IF(H4="PH",VLOOKUP($E$4,$I$13:$M$15,2),IF(AND(1<=H4,H4<=3),VLOOKUP($E$4,$I$13:$M$15,3),"")),"") |
| 12 |
=IF(H5<>"",IF(H5="PH",VLOOKUP($E$4,$I$13:$M$15,2),IF(AND(1<=H5,H5<=3),VLOOKUP($E$4,$I$13:$M$15,3),"")),"") |
| 13 |
=IF(AND(E4<>0,H6<>""),IF(H6="PH",VLOOKUP($E$4,$I$13:$M$15,2),IF(AND(1<=H6,H6<=3),VLOOKUP($E$4,$I$13:$M$15,3),"")),"") |
| 14 |
=IF(AND(E4<>0,H7<>""),IF(H7="PH",VLOOKUP($E$4,$I$13:$M$15,2),IF(AND(1<=H7,H7<=3),VLOOKUP($E$4,$I$13:$M$15,3),"")),"") |
| 15 |
=IF($E$6<>0,VLOOKUP($E$6,$I$13:$M$15,5),M15) |
| 16 |
=IF(AND(H10<>"",E6<=H10),IF(AND(1<=H10,H10<=2),VLOOKUP($E$6,$I$13:$M$15,4),""),"") |
| ｾﾙＲ |
| 11 |
=IF(H4<>"",IF(H4="PH",VLOOKUP($E$4,$I$13:$M$15,2),IF(AND(1<=H4,H4<=3),VLOOKUP($E$4,$I$13:$M$15,3),"")),"") |
| 12 |
=IF(H5<>"",IF(H5="PH",VLOOKUP($E$4,$I$13:$M$15,2),IF(AND(1<=H5,H5<=3),VLOOKUP($E$4,$I$13:$M$15,3),"")),"") |
| 13 |
=IF(AND(E4<>0,H6<>""),IF(H6="PH",VLOOKUP($E$4,$I$13:$M$15,2),IF(AND(1<=H6,H6<=3),VLOOKUP($E$4,$I$13:$M$15,3),"")),"") |
| 14 |
=IF(AND(E4<>0,H7<>""),IF(H7="PH",VLOOKUP($E$4,$I$13:$M$15,2),IF(AND(1<=H7,H7<=3),VLOOKUP($E$4,$I$13:$M$15,3),"")),"") |
| 15 |
=IF(AND(E6<>0,E6<=2),IF(AND(1<=H9,H9<=2),VLOOKUP($E$6,$I$13:$M$15,4),""),M15) |
| 16 |
=IF(AND(H10<>"",E6<=H10),IF(AND(1<=H10,H10<=2),VLOOKUP($E$6,$I$13:$M$15,4),""),"") |
| ｾﾙＳ |
| 11 |
=IF(H4<>"",IF(H4="PH",VLOOKUP($E$4,$I$13:$M$15,2),IF(AND(1<=H4,H4<=3),VLOOKUP($E$4,$I$13:$M$15,3),"")),"") |
| 12 |
=IF(H5<>"",IF(H5="PH",VLOOKUP($E$4,$I$13:$M$15,2),IF(AND(1<=H5,H5<=3),VLOOKUP($E$4,$I$13:$M$15,3),"")),"") |
| 13 |
=IF(AND(E4<>0,H6<>""),IF(H6="PH",VLOOKUP($E$4,$I$13:$M$15,2),IF(AND(1<=H6,H6<=3),VLOOKUP($E$4,$I$13:$M$15,3),"")),"") |
| 14 |
=IF(AND(E4<>0,H7<>""),IF(H7="PH",VLOOKUP($E$4,$I$13:$M$15,2),IF(AND(1<=H7,H7<=3),VLOOKUP($E$4,$I$13:$M$15,3),"")),"") |
| 15 |
=IF($E$6<>0,VLOOKUP($E$6,$I$13:$M$15,5),M15) |
| 16 |
=IF(AND(H10<>"",E6<=H10),IF(AND(1<=H10,H10<=2),VLOOKUP($E$6,$I$13:$M$15,4),""),"") | |
