関数 pac =LEN(D6)=ISBLANK(C6)=LEFT(D6,22)=IF(EXACT(H6,"（ shExpMatch ( host, """),"○","×")=MID(D6,23,F6-30)=IF(EXACT(J6,A6),"○","×")=MID(D6,F6-7,8)=IF(EXACT(L6,""" ) ) ||"),"○","×") =IF(AND(I6="○",K6="○",M6="○"),"OK","NG") IPアドレス計算ツ…