Calender

S M T W T F S
    123
45678910
11121314151617
18192021222324
25262728293031
<< August 2019 >>

Categories

Archives

Recent Entries

中学生のためのExcel VBA

3-14 郵便番号と住所(1)Web APIの利用(if関数)

JUGEMテーマ:Office VBA

 

 =IF(論理式,真の場合,偽の場合)
=if($s4="","",FILTERXML(WEBSERVICE("http://zip.cgis.biz/xml/zip.php?zn=" & $S4),"/ZIP_result/ADDRESS_value/value[@state]/@state"))
=if($s4="","",FILTERXML(WEBSERVICE("http://zip.cgis.biz/xml/zip.php?zn=" & $S4),"/ZIP_result/ADDRESS_value/value[@city]/@city"))
=if($s4="","",FILTERXML(WEBSERVICE("http://zip.cgis.biz/xml/zip.php?zn=" & $S4),"/ZIP_result/ADDRESS_value/value[@address]/@address"))

  • 2019.05.22 Wednesday
  • 15:25

Comment
Send Comment