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アドレス計算ツール

f:id:nakka-yuzu:20170115202232p:plain

=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, """*""" ) ) ||"),"○","×")