Excel関連
関数
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アドレス計算ツール
=LEN(B6)
=LEFT(B6,FIND("-",B6&"-",1)-1)
=SEARCH(".",E6&".",FIND(".",E6&".",9))
=MID(E6,F6+1,LEN(E6))
=MID(B6,FIND("-",B6&"-",1)+1,D6)
=SEARCH(".",H6&".",FIND(".",H6&".",9))
=MID(H6,I6+1,LEN(H6))
=IFERROR(VLOOKUP(N6,$R$6:$S$37,2,0),"")
=IF(AND(E6<>"",H6=""),1,IFERROR(J6-G6+1,""))
LEFT
RIGHT
MID
LEN
FIND
SEARCH
=IF(COUNTIF(D6,"( shExpMatch ( host, """*""" ) ) ||"),"○","×")