{"id":10478,"date":"2025-05-23T12:08:26","date_gmt":"2025-05-23T03:08:26","guid":{"rendered":"https:\/\/corp.genialtech.io\/?p=10478"},"modified":"2026-09-15T09:42:42","modified_gmt":"2026-09-15T00:42:42","slug":"iferror","status":"publish","type":"post","link":"https:\/\/corp.genialtech.io\/ja\/column\/iferror\/","title":{"rendered":"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" width=\"602\" height=\"339\" src=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9.jpg\" alt=\"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5\" class=\"wp-image-10480\" style=\"width:600px\" srcset=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9.jpg 602w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9-300x169.jpg 300w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9-18x10.jpg 18w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Excel\u3067\u696d\u52d9\u3092\u3057\u3066\u3044\u308b\u3068\u3001\u300c#DIV\/0!\u300d\u3084\u300c#N\/A\u300d\u306a\u3069\u306e\u30a8\u30e9\u30fc\u8868\u793a\u306b\u51fa\u304f\u308f\u3059\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002\u6700\u521d\u306f\u300c\u306a\u306b\u3053\u308c\uff1f\u300d\u3068\u6238\u60d1\u3046\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u3001\u3053\u308c\u306f\u6570\u5f0f\u306b\u4f55\u3089\u304b\u306e\u554f\u984c\u304c\u3042\u308b\u3068\u3044\u3046\u30b5\u30a4\u30f3\u3067\u3059\u3002\u305f\u3068\u3048\u3070\u30010\u3067\u5272\u3063\u3066\u3057\u307e\u3063\u305f\u308a\u3001\u6307\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u304c\u898b\u3064\u304b\u3089\u306a\u304b\u3063\u305f\u308a\u3059\u308b\u3068\u3001\u3053\u3046\u3057\u305f\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u3046\u3057\u305f\u30a8\u30e9\u30fc\u306f\u3001\u898b\u305f\u76ee\u304c\u308f\u304b\u308a\u3065\u3089\u304f\u3001\u5370\u5237\u7269\u3084\u8cc7\u6599\u63d0\u51fa\u306e\u969b\u306b\u306f\u4e0d\u81ea\u7136\u306b\u6620\u3063\u3066\u3057\u307e\u3044\u304c\u3061\u3067\u3059\u3002\u7279\u306b\u304a\u5ba2\u69d8\u3084\u4e0a\u53f8\u306b\u898b\u305b\u308b\u8cc7\u6599\u3067\u306f\u3001\u3067\u304d\u308b\u3060\u3051\u907f\u3051\u305f\u3044\u3068\u3053\u308d\u3067\u3059\u3088\u306d\u3002\u305d\u3093\u306a\u3068\u304d\u306b\u4fbf\u5229\u306a\u306e\u304c<strong> IFERROR\u95a2\u6570<\/strong>\u3002\u3053\u306e\u95a2\u6570\u3092\u4f7f\u3048\u3070\u3001\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u3068\u304d\u3060\u3051\u4efb\u610f\u306e\u5024\u3084\u30e1\u30c3\u30bb\u30fc\u30b8\u306b\u7f6e\u304d\u63db\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u3001\u8cc7\u6599\u306e\u898b\u305f\u76ee\u3092\u30b9\u30de\u30fc\u30c8\u306b\u6574\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Excel\u521d\u5fc3\u8005\u306e\u65b9\u3067\u3082\u5b89\u5fc3\u3057\u3066\u4f7f\u3048\u308b\u3088\u3046\u306b\u3001IFERROR\u95a2\u6570\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3068\u5b9f\u7528\u7684\u306a\u6d3b\u7528\u4f8b\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac\u3057\u307e\u3059\u3002\u660e\u65e5\u304b\u3089\u306e\u696d\u52d9\u3067\u3059\u3050\u306b\u5f79\u7acb\u3064\u5185\u5bb9\u3067\u3059\u306e\u3067\u3001\u305c\u3072\u53c2\u8003\u306b\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n<div class='code-block code-block-4' style='margin: 8px 0; clear: both;'>\n\n<div class='ai-rotate ai-unprocessed ai-rotate-4-88781327' style='position: relative;'>\n<div class=\"ai-rotate-option\" data-index=\"1\" data-name=\"QQ==\" data-code=\"CjxkaXYgZGF0YS1wb3N0LWlkPSIxMzQ5OCIgY2xhc3M9Imluc2VydC1wYWdlIGluc2VydC1wYWdlLTEzNDk4ICI+CjxzdHlsZT4KICAuZ3QtYmFubmVyIHsKICAgIGRpc3BsYXk6IGZsZXg7CiAgICBhbGlnbi1pdGVtczogY2VudGVyOwogICAganVzdGlmeS1jb250ZW50OiBzcGFjZS1iZXR3ZWVuOwogICAgZ2FwOiAyOHB4OwogICAgbWF4LXdpZHRoOiAxMDAwcHg7CiAgICBtYXJnaW46IDAgYXV0bzsKICAgIHBhZGRpbmc6IDI4cHggMzZweDsKICAgIGJhY2tncm91bmQ6ICNFMkY1Rjc7CiAgICBib3JkZXI6IDFweCBzb2xpZCAjRDhEOEQ4OwogICAgYm9yZGVyLXJhZGl1czogMTZweDsKICAgIGJveC1zaXppbmc6IGJvcmRlci1ib3g7CiAgICBmb250LWZhbWlseTogIk5vdG8gU2FucyBKUCIsICJIaXJhZ2lubyBLYWt1IEdvdGhpYyBQcm9OIiwgIll1IEdvdGhpYyIsICJNZWlyeW8iLCBzYW5zLXNlcmlmOwogIH0KICAuZ3QtYmFubmVyX19ib2R5IHsKICAgIGZsZXg6IDEgMSBhdXRvOwogICAgbWluLXdpZHRoOiAwOwogIH0KICAuZ3QtYmFubmVyX19sYWJlbCB7CiAgICBkaXNwbGF5OiBpbmxpbmUtYmxvY2s7CiAgICBiYWNrZ3JvdW5kOiAjRkZGRkZGOwogICAgYm9yZGVyOiAxcHggc29saWQgIzFEODE4QjsKICAgIGNvbG9yOiAjMEYyNDNFOwogICAgZm9udC1zaXplOiAxMnB4OwogICAgZm9udC13ZWlnaHQ6IDcwMDsKICAgIGxpbmUtaGVpZ2h0OiAxOwogICAgcGFkZGluZzogN3B4IDE2cHg7CiAgICBib3JkZXItcmFkaXVzOiA5OTlweDsKICAgIG1hcmdpbjogMCAwIDE2cHg7CiAgfQogIC5ndC1iYW5uZXJfX2hlYWRsaW5lIHsKICAgIG1hcmdpbjogMCAwIDEycHg7CiAgICBmb250LXNpemU6IDI0cHg7CiAgICBsaW5lLWhlaWdodDogMS41OwogICAgZm9udC13ZWlnaHQ6IDcwMDsKICAgIGNvbG9yOiAjMEYyNDNFOwogIH0KICAuZ3QtYmFubmVyX19zdWIgewogICAgbWFyZ2luOiAwIDAgMjJweDsKICAgIGZvbnQtc2l6ZTogMTRweDsKICAgIGxpbmUtaGVpZ2h0OiAxLjc1OwogICAgY29sb3I6ICMzMzMzMzM7CiAgfQogIC5ndC1iYW5uZXJfX2Zvb3RlciB7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgYWxpZ24taXRlbXM6IGNlbnRlcjsKICAgIGZsZXgtd3JhcDogd3JhcDsKICAgIGdhcDogMThweDsKICB9CiAgLmd0LWJhbm5lcl9fY3RhIHsKICAgIGRpc3BsYXk6IGlubGluZS1ibG9jazsKICAgIGJhY2tncm91bmQ6ICNGRkU5Mjk7CiAgICBjb2xvcjogIzBGMjQzRTsKICAgIGZvbnQtd2VpZ2h0OiA3MDA7CiAgICBmb250LXNpemU6IDE1cHg7CiAgICBsaW5lLWhlaWdodDogMTsKICAgIHBhZGRpbmc6IDEzcHggMjZweDsKICAgIGJvcmRlci1yYWRpdXM6IDEwcHg7CiAgICB3aGl0ZS1zcGFjZTogbm93cmFwOwogICAgdGV4dC1kZWNvcmF0aW9uOiBub25lOwogICAgdHJhbnNpdGlvbjogdHJhbnNmb3JtIDAuMTVzIGVhc2UsIGJveC1zaGFkb3cgMC4xNXMgZWFzZTsKICB9CiAgLmd0LWJhbm5lcl9fY3RhOmhvdmVyIHsKICAgIHRyYW5zZm9ybTogdHJhbnNsYXRlWSgtMnB4KTsKICAgIGJveC1zaGFkb3c6IDAgNHB4IDEwcHggcmdiYSgwLCAwLCAwLCAwLjEyKTsKICB9CiAgLmd0LWJhbm5lcl9fdGh1bWIgewogICAgZmxleDogMCAwIDMwMHB4OwogIH0KICAuZ3QtYmFubmVyX190aHVtYiBhIHsKICAgIGRpc3BsYXk6IGJsb2NrOwogICAgdHJhbnNpdGlvbjogdHJhbnNmb3JtIDAuMTVzIGVhc2UsIGJveC1zaGFkb3cgMC4xNXMgZWFzZTsKICB9CiAgLmd0LWJhbm5lcl9fdGh1bWIgYTpob3ZlciB7CiAgICB0cmFuc2Zvcm06IHRyYW5zbGF0ZVkoLTJweCk7CiAgICBib3gtc2hhZG93OiAwIDRweCAxMHB4IHJnYmEoMCwgMCwgMCwgMC4xMik7CiAgfQogIC5ndC1iYW5uZXJfX3RodW1iIGltZyB7CiAgICBkaXNwbGF5OiBibG9jazsKICAgIHdpZHRoOiAxMDAlOwogICAgaGVpZ2h0OiBhdXRvOwogICAgYm9yZGVyLXJhZGl1czogNHB4OwogICAgYm9yZGVyOiAxcHggc29saWQgcmdiYSgwLCAwLCAwLCAwLjE1KTsKICB9CgogIEBtZWRpYSAobWF4LXdpZHRoOiA3MDBweCkgewogICAgLmd0LWJhbm5lciB7CiAgICAgIGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47CiAgICAgIGFsaWduLWl0ZW1zOiBzdHJldGNoOwogICAgICBwYWRkaW5nOiAyNHB4OwogICAgICBnYXA6IDIwcHg7CiAgICB9CiAgICAuZ3QtYmFubmVyX190aHVtYiB7CiAgICAgIG9yZGVyOiAtMTsKICAgICAgZmxleC1iYXNpczogYXV0bzsKICAgICAgd2lkdGg6IDEwMCU7CiAgICAgIG1heC13aWR0aDogMzIwcHg7CiAgICAgIG1hcmdpbjogMCBhdXRvOwogICAgfQogICAgLmd0LWJhbm5lcl9faGVhZGxpbmUgewogICAgICBmb250LXNpemU6IDIwcHg7CiAgICB9CiAgICAuZ3QtYmFubmVyX19mb290ZXIgewogICAgICBmbGV4LWRpcmVjdGlvbjogY29sdW1uOwogICAgICBhbGlnbi1pdGVtczogZmxleC1zdGFydDsKICAgICAgZ2FwOiAxMnB4OwogICAgfQogIH0KPC9zdHlsZT4KCjxkaXYgY2xhc3M9Imd0LWJhbm5lciI+CiAgPGRpdiBjbGFzcz0iZ3QtYmFubmVyX19ib2R5Ij4KICAgIDxzcGFuIGNsYXNzPSJndC1iYW5uZXJfX2xhYmVsIj7nhKHmlpnjg5vjg6\/jgqTjg4jjg5rjg7zjg5Hjg7w8L3NwYW4+CiAgICA8aDMgY2xhc3M9Imd0LWJhbm5lcl9faGVhZGxpbmUiPgogICAgICDjgZ3jga7pm4boqIjjgIHjgb7jgaDmiYvkvZzmpa3jgafmtojogJfjgZfjgabjgYTjgb7jgZvjgpPjgYvvvJ88YnI+CiAgICAgIOaciOasoeOBruaui+alreOCkua4m+OCieOBmUV4Y2Vs6Zai5pWwMzTpgbgKICAgIDwvaDM+CiAgICA8cCBjbGFzcz0iZ3QtYmFubmVyX19zdWIiPgogICAgICDnqoHlkIjjg7vpm4boqIjjg7vnq6\/mlbDlh6bnkIbjga7jgIzjgoHjgpPjganjgYbjgarkvZzmpa3jgI3jgpLjgIHplqLmlbDjgafoh6rli5XljJbjgILntYznkIbjga7nj77loLTjgafmnKzlvZPjgavkvb\/jgYYzNOmWouaVsOOCkuOAgeani+aWh+OBqOS9v+OBhOOBqeOBk+OCjeS7mOOBjeOBp+ino+iqrOOBl+OBvuOBmeOAggogICAgPC9wPgogICAgPGRpdiBjbGFzcz0iZ3QtYmFubmVyX19mb290ZXIiPgogICAgICA8YSBjbGFzcz0iZ3QtYmFubmVyX19jdGEgY29sdW1uX3RvX2V4Y2VsMzRfYSIgaHJlZj0iaHR0cHM6Ly9jb3JwLmdlbmlhbHRlY2guaW8vamEvd2hpdGVwYXBlci9leGNlbC1mdW5jdGlvbnMvIiB0YXJnZXQ9Il9ibGFuayIgcmVsPSJub29wZW5lciI+CiAgICAgICAg54Sh5paZ44Gn44OA44Km44Oz44Ot44O844OJ44GZ44KLIOKWtgogICAgICA8L2E+CiAgICA8L2Rpdj4KICA8L2Rpdj4KICA8ZGl2IGNsYXNzPSJndC1iYW5uZXJfX3RodW1iIj4KICAgIDxhIGNsYXNzPSJjb2x1bW5fdG9fZXhjZWwzNF9hIiBocmVmPSJodHRwczovL2NvcnAuZ2VuaWFsdGVjaC5pby9qYS93aGl0ZXBhcGVyL2V4Y2VsLWZ1bmN0aW9ucy8iIHRhcmdldD0iX2JsYW5rIiByZWw9Im5vb3BlbmVyIj4KICAgICAgPGltZyBkZWNvZGluZz0iYXN5bmMiIHNyYz0iaHR0cHM6Ly9jb3JwLmdlbmlhbHRlY2guaW8vd3AtY29udGVudC91cGxvYWRzL3NpdGVzLzIvMjAyNS8xMS9FeGNlbOmWouaVsC5wbmciIGFsdD0i57WM55CG5ouF5b2T6ICF44GM55+l44Gj44Gm44GK44GN44Gf44GERXhjZWzplqLmlbAzNOmBuCI+CiAgICA8L2E+CiAgPC9kaXY+CjwvZGl2Pgo8L2Rpdj4KCg==\">\n<\/div>\n<div class=\"ai-rotate-option\" data-index=\"2\" data-name=\"Qg==\" data-code=\"CjxkaXYgZGF0YS1wb3N0LWlkPSIxMzUwMSIgY2xhc3M9Imluc2VydC1wYWdlIGluc2VydC1wYWdlLTEzNTAxICI+CjxzdHlsZT4KICAuZ2UtYmFubmVyLXdyYXAgewogICAgbWF4LXdpZHRoOiAxMjAwcHg7CiAgICBtYXJnaW46IDAgYXV0bzsKICAgIGZvbnQtZmFtaWx5OiAiSGlyYWdpbm8gS2FrdSBHb3RoaWMgUHJvTiIsICJZdSBHb3RoaWMiLCAiTm90byBTYW5zIEpQIiwgc2Fucy1zZXJpZjsKICAgIGNvbG9yOiAjMEYyNDNFOwogIH0KICAuZ2UtYmFubmVyIHsKICAgIGRpc3BsYXk6IGJsb2NrOwogICAgYmFja2dyb3VuZDogI2ZmZmZmZjsKICAgIGJvcmRlcjogMnB4IHNvbGlkICMxRDgxOEI7CiAgICBib3JkZXItcmFkaXVzOiAyMHB4OwogICAgcGFkZGluZzogMjhweDsKICAgIGJveC1zaXppbmc6IGJvcmRlci1ib3g7CiAgfQogIC5nZS1iYW5uZXItaW5uZXIgewogICAgZGlzcGxheTogZmxleDsKICAgIGFsaWduLWl0ZW1zOiBzdHJldGNoOwogICAgZ2FwOiAyNHB4OwogIH0KICAvKiDlt6bvvJozNOmWouaVsOODnOODg+OCr+OCuSAqLwogIC5nZS1udW0tYm94IHsKICAgIGZsZXg6IDAgMCAxOTBweDsKICAgIGJhY2tncm91bmQ6ICMxRDgxOEI7CiAgICBib3JkZXItcmFkaXVzOiAxNHB4OwogICAgY29sb3I6ICNmZmZmZmY7CiAgICBwYWRkaW5nOiAyNHB4IDE2cHg7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGFsaWduLWl0ZW1zOiBjZW50ZXI7CiAgICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICAgIHRleHQtYWxpZ246IGNlbnRlcjsKICB9CiAgLmdlLW51bS1ib3ggLmdlLW51bS1sYWJlbCB7CiAgICBmb250LXNpemU6IDE0cHg7CiAgICBmb250LXdlaWdodDogNzAwOwogICAgbGV0dGVyLXNwYWNpbmc6IDAuMDJlbTsKICAgIG1hcmdpbi1ib3R0b206IDRweDsKICB9CiAgLmdlLW51bS1ib3ggLmdlLW51bS1tYWluIHsKICAgIGZvbnQtc2l6ZTogNTZweDsKICAgIGZvbnQtd2VpZ2h0OiA4MDA7CiAgICBsaW5lLWhlaWdodDogMTsKICAgIG1hcmdpbjogNHB4IDA7CiAgfQogIC5nZS1udW0tYm94IC5nZS1udW0tbWFpbiBzcGFuIHsKICAgIGZvbnQtc2l6ZTogMjBweDsKICAgIGZvbnQtd2VpZ2h0OiA3MDA7CiAgICBtYXJnaW4tbGVmdDogNHB4OwogIH0KICAuZ2UtbnVtLWJveCAuZ2UtbnVtLWJyZWFrZG93biB7CiAgICBmb250LXNpemU6IDEycHg7CiAgICBvcGFjaXR5OiAwLjk7CiAgICBtYXJnaW4tdG9wOiA4cHg7CiAgfQogIC8qIOS4reWkru+8muODhuOCreOCueODiOOBqENUQSAqLwogIC5nZS1tYWluIHsKICAgIGZsZXg6IDEgMSBhdXRvOwogICAgZGlzcGxheTogZmxleDsKICAgIGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47CiAgICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICAgIG1pbi13aWR0aDogMDsKICB9CiAgLmdlLWV5ZWJyb3cgewogICAgZm9udC1zaXplOiAxM3B4OwogICAgZm9udC13ZWlnaHQ6IDcwMDsKICAgIG1hcmdpbi1ib3R0b206IDhweDsKICAgIGNvbG9yOiAjMUQ4MThCOwogIH0KICAuZ2UtZXllYnJvdyAuZ2UtZGl2aWRlciB7CiAgICBtYXJnaW46IDAgNnB4OwogICAgY29sb3I6ICMxRDgxOEI7CiAgfQogIC5nZS1oZWFkbGluZSB7CiAgICBmb250LXNpemU6IDI2cHg7CiAgICBmb250LXdlaWdodDogODAwOwogICAgbGluZS1oZWlnaHQ6IDEuNDsKICAgIG1hcmdpbjogMCAwIDE0cHg7CiAgfQogIC5nZS1jaGVja2xpc3QgewogICAgbGlzdC1zdHlsZTogbm9uZTsKICAgIG1hcmdpbjogMCAwIDIwcHg7CiAgICBwYWRkaW5nOiAwOwogICAgZm9udC1zaXplOiAxNXB4OwogICAgbGluZS1oZWlnaHQ6IDEuNzsKICB9CiAgLmdlLWNoZWNrbGlzdCBsaSB7CiAgICBwb3NpdGlvbjogcmVsYXRpdmU7CiAgICBwYWRkaW5nLWxlZnQ6IDIycHg7CiAgfQogIC5nZS1jaGVja2xpc3QgbGk6OmJlZm9yZSB7CiAgICBjb250ZW50OiAi4pyTIjsKICAgIHBvc2l0aW9uOiBhYnNvbHV0ZTsKICAgIGxlZnQ6IDA7CiAgICB0b3A6IDA7CiAgICBjb2xvcjogIzFEODE4QjsKICAgIGZvbnQtd2VpZ2h0OiA4MDA7CiAgfQogIC5nZS1jaGVja2xpc3QgYiB7CiAgICBmb250LXdlaWdodDogNzAwOwogIH0KICAuZ2UtY3RhIHsKICAgIGRpc3BsYXk6IGlubGluZS1mbGV4OwogICAgYWxpZ24taXRlbXM6IGNlbnRlcjsKICAgIGp1c3RpZnktY29udGVudDogY2VudGVyOwogICAgZ2FwOiA4cHg7CiAgICBiYWNrZ3JvdW5kOiAjRkZFOTI5OwogICAgY29sb3I6ICMwRjI0M0U7CiAgICB0ZXh0LWRlY29yYXRpb246IG5vbmU7CiAgICBmb250LXdlaWdodDogNzAwOwogICAgZm9udC1zaXplOiAxNnB4OwogICAgcGFkZGluZzogMTRweCAyOHB4OwogICAgYm9yZGVyLXJhZGl1czogOHB4OwogICAgd2lkdGg6IGZpdC1jb250ZW50OwogICAgdHJhbnNpdGlvbjogZmlsdGVyIDAuMnMgZWFzZTsKICB9CiAgLmdlLWN0YTpob3ZlciB7CiAgICBmaWx0ZXI6IGJyaWdodG5lc3MoMC45Nik7CiAgfQogIC8qIOWPs++8muOCueODqeOCpOODieeUu+WDjyAqLwogIC5nZS12aXN1YWwgewogICAgZmxleDogMCAwIDM0MHB4OwogICAgZGlzcGxheTogZmxleDsKICAgIGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47CiAgICBhbGlnbi1pdGVtczogY2VudGVyOwogICAganVzdGlmeS1jb250ZW50OiBjZW50ZXI7CiAgfQogIC5nZS12aXN1YWwgYSB7CiAgICBkaXNwbGF5OiBibG9jazsKICAgIHdpZHRoOiAxMDAlOwogICAgdHJhbnNpdGlvbjogb3BhY2l0eSAwLjJzIGVhc2U7CiAgfQogIC5nZS12aXN1YWwgYTpob3ZlciB7CiAgICBvcGFjaXR5OiAwLjg1OwogIH0KICAuZ2UtdmlzdWFsIGltZyB7CiAgICB3aWR0aDogMTAwJTsKICAgIGhlaWdodDogYXV0bzsKICAgIGJvcmRlci1yYWRpdXM6IDEwcHg7CiAgICBib3JkZXI6IDFweCBzb2xpZCAjZGJlN2U4OwogICAgZGlzcGxheTogYmxvY2s7CiAgfQogIC5nZS12aXN1YWwtY2FwdGlvbiB7CiAgICBmb250LXNpemU6IDEycHg7CiAgICBjb2xvcjogIzRhNWE2MzsKICAgIG1hcmdpbi10b3A6IDhweDsKICAgIHRleHQtYWxpZ246IGNlbnRlcjsKICB9CgogIC8qIOODrOOCueODneODs+OCt+ODlu+8iOOCv+ODluODrOODg+ODiO+8iSAqLwogIEBtZWRpYSAobWF4LXdpZHRoOiA4MDBweCkgewogICAgLmdlLWJhbm5lci1pbm5lciB7CiAgICAgIGZsZXgtd3JhcDogd3JhcDsKICAgIH0KICAgIC5nZS1udW0tYm94IHsKICAgICAgZmxleDogMCAwIGF1dG87CiAgICAgIHdpZHRoOiAxMDAlOwogICAgICBmbGV4LWRpcmVjdGlvbjogcm93OwogICAgICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICAgICAgZ2FwOiAxMnB4OwogICAgICBwYWRkaW5nOiAxNnB4OwogICAgfQogICAgLmdlLW51bS1ib3ggLmdlLW51bS1icmVha2Rvd24geyBtYXJnaW4tdG9wOiAwOyB9CiAgICAuZ2UtdmlzdWFsIHsKICAgICAgZmxleDogMSAxIDEwMCU7CiAgICAgIG9yZGVyOiAzOwogICAgfQogICAgLmdlLXZpc3VhbCBpbWcgeyBtYXgtd2lkdGg6IDMyMHB4OyB9CiAgfQoKICAvKiDjg6zjgrnjg53jg7Pjgrfjg5bvvIjjgrnjg57jg5vvvIkgKi8KICBAbWVkaWEgKG1heC13aWR0aDogNDgwcHgpIHsKICAgIC5nZS1iYW5uZXIgeyBwYWRkaW5nOiAxOHB4OyBib3JkZXItcmFkaXVzOiAxNnB4OyB9CiAgICAuZ2UtbnVtLWJveCB7IGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47IH0KICAgIC5nZS1oZWFkbGluZSB7IGZvbnQtc2l6ZTogMjFweDsgfQogICAgLmdlLWN0YSB7IHdpZHRoOiAxMDAlOyBmb250LXNpemU6IDE1cHg7IHBhZGRpbmc6IDE0cHggMThweDsgfQogIH0KPC9zdHlsZT4KCjxkaXYgY2xhc3M9ImdlLWJhbm5lci13cmFwIj4KICA8ZGl2IGNsYXNzPSJnZS1iYW5uZXIiPgogICAgPGRpdiBjbGFzcz0iZ2UtYmFubmVyLWlubmVyIj4KCiAgICAgIDwhLS0g5bem77yaMzTplqLmlbDjg5zjg4Pjgq\/jgrkgLS0+CiAgICAgIDxkaXYgY2xhc3M9ImdlLW51bS1ib3giPgogICAgICAgIDxkaXYgY2xhc3M9ImdlLW51bS1sYWJlbCI+57WM55CG44Gu44Gf44KB44GuPC9kaXY+CiAgICAgICAgPGRpdiBjbGFzcz0iZ2UtbnVtLW1haW4iPjM0PHNwYW4+6Zai5pWwPC9zcGFuPjwvZGl2PgogICAgICAgIDxkaXYgY2xhc3M9ImdlLW51bS1icmVha2Rvd24iPuWInee0mjEx77yP5Lit57SaMTLvvI\/kuIrntJoxMTwvZGl2PgogICAgICA8L2Rpdj4KCiAgICAgIDwhLS0g5Lit5aSu77ya5pys5paH77yLQ1RBIC0tPgogICAgICA8ZGl2IGNsYXNzPSJnZS1tYWluIj4KICAgICAgICA8cCBjbGFzcz0iZ2UtZXllYnJvdyI+CiAgICAgICAgICDjg5vjg6\/jgqTjg4jjg5rjg7zjg5Hjg7w8c3BhbiBjbGFzcz0iZ2UtZGl2aWRlciI+772cPC9zcGFuPjxzcGFuIGNsYXNzPSJnZS1obCI+57WM55CG44GuRXhjZWzlrp\/ot7XjgqzjgqTjg4nvvIjnhKHmlpnvvIk8L3NwYW4+CiAgICAgICAgPC9wPgogICAgICAgIDxwIGNsYXNzPSJnZS1oZWFkbGluZSI+57WM55CG44Gn5L2\/44GGRXhjZWzplqLmlbDjgpLjgIHlvrnlupXop6PoqqzjgII8L3A+CiAgICAgICAgPHVsIGNsYXNzPSJnZS1jaGVja2xpc3QiPgogICAgICAgICAgPGxpPuWInee0mu+8mjxiPlNVTe+8j1JPVU5E77yPVE9EQVk8L2I+44Gn5pel5qyh6ZuG6KiI44KS6auY6YCf5YyWPC9saT4KICAgICAgICAgIDxsaT7kuK3ntJrvvJo8Yj5TVU1JRlPvvI9YTE9PS1VQPC9iPuOBp+eqgeWQiOODu+eFp+WQiOOCkuiHquWLleWMljwvbGk+CiAgICAgICAgICA8bGk+5LiK57Sa77yaPGI+VU5JUVVF77yPUkVHRVjns7s8L2I+44Gu5pyA5paw6Zai5pWw44G+44Gn57+S5b6XPC9saT4KICAgICAgICA8L3VsPgogICAgICAgIDxhIGNsYXNzPSJnZS1jdGEgY29sdW1uX3RvX2V4Y2VsMzRfYiIgaHJlZj0iaHR0cHM6Ly9jb3JwLmdlbmlhbHRlY2guaW8vamEvd2hpdGVwYXBlci9leGNlbC1mdW5jdGlvbnMvIiB0YXJnZXQ9Il9ibGFuayIgcmVsPSJub29wZW5lciI+6LOH5paZ44KS44OA44Km44Oz44Ot44O844OJ77yI54Sh5paZ77yJIOKWtjwvYT4KICAgICAgPC9kaXY+CgogICAgICA8IS0tIOWPs++8muOCueODqeOCpOODieeUu+WDjyAtLT4KICAgICAgPGRpdiBjbGFzcz0iZ2UtdmlzdWFsIj4KICAgICAgICA8YSBjbGFzcz0iY29sdW1uX3RvX2V4Y2VsMzRfYiIgaHJlZj0iaHR0cHM6Ly9jb3JwLmdlbmlhbHRlY2guaW8vamEvd2hpdGVwYXBlci9leGNlbC1mdW5jdGlvbnMvIiB0YXJnZXQ9Il9ibGFuayIgcmVsPSJub29wZW5lciI+CiAgICAgICAgICA8aW1nIGRlY29kaW5nPSJhc3luYyIgc3JjPSJodHRwczovL2NvcnAuZ2VuaWFsdGVjaC5pby93cC1jb250ZW50L3VwbG9hZHMvc2l0ZXMvMi8yMDI1LzExL0V4Y2Vs6Zai5pWwLTEuanBnIiBhbHQ9IklG6Zai5pWw44O7SUZFUlJPUumWouaVsOOBruino+iqrOOCueODqeOCpOODie+8iOani+aWh+OBqOS9v+eUqOS+i++8iSI+CiAgICAgICAgPC9hPgogICAgICAgIDxkaXYgY2xhc3M9ImdlLXZpc3VhbC1jYXB0aW9uIj7mp4vmlofvvIvkvb\/nlKjkvovjgaTjgY08L2Rpdj4KICAgICAgPC9kaXY+CgogICAgPC9kaXY+CiAgPC9kaXY+CjwvZGl2Pgo8L2Rpdj4=\">\n<\/div>\n<\/div>\n<script>if (typeof ai_js_code == 'boolean') {var ai_block_div = document.querySelector ('.ai-rotate-4-88781327'); ai_process_rotation (ai_block_div); ai_block_div.classList.remove ('ai-rotate-4-88781327');};<\/script>\n<\/div>\n\n\n\n\n<h2 class=\"wp-block-heading is-style-vk-heading-background_fill_lightgray\"><strong>IFERROR\u95a2\u6570\u3068\u306f<\/strong><\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" width=\"602\" height=\"402\" src=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b91.jpg\" alt=\"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5\" class=\"wp-image-10481\" style=\"width:600px\" srcset=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b91.jpg 602w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b91-300x200.jpg 300w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b91-18x12.jpg 18w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">IFERROR\u95a2\u6570\u306f\u3001Excel\u3067\u6570\u5f0f\u306e\u7d50\u679c\u304c\u30a8\u30e9\u30fc\u306b\u306a\u3063\u305f\u3068\u304d\u306b\u3001\u3042\u3089\u304b\u3058\u3081\u6307\u5b9a\u3057\u305f\u5225\u306e\u5024\u3084\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8868\u793a\u3057\u3066\u304f\u308c\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30a8\u30e9\u30fc\u304c\u306a\u3044\u5834\u5408\u306f\u3001\u901a\u5e38\u3069\u304a\u308a\u306e\u8a08\u7b97\u7d50\u679c\u304c\u305d\u306e\u307e\u307e\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-background has-fixed-layout\" style=\"background-color:#effdff\"><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>IFERROR(\u6570\u5f0f, \u30a8\u30e9\u30fc\u6642\u306b\u8868\u793a\u3059\u308b\u5024)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u305f\u3068\u3048\u3070\u3001\u30bb\u30ebA1\u3092\u30bb\u30ebB1\u3067\u5272\u308b\u6570\u5f0f\u306f\u901a\u5e38\u3053\u3046\u66f8\u304d\u307e\u3059\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-vk-image-border\"><img decoding=\"async\" width=\"324\" height=\"134\" src=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570.png\" alt=\"IFERROR\u95a2\u6570\u3068\u306f\" class=\"wp-image-10485\" style=\"width:300px\" srcset=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570.png 324w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570-300x124.png 300w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570-18x7.png 18w\" sizes=\"(max-width: 324px) 100vw, 324px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u3057\u304b\u3057\u3001B1\u304c\u300c0\u300d\u307e\u305f\u306f\u7a7a\u767d\u306e\u5834\u5408\u3001\u300c#DIV\/0!\u300d\u3068\u3044\u3046\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-vk-image-border\"><img decoding=\"async\" width=\"342\" height=\"163\" src=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u65702.png\" alt=\"IFERROR\u95a2\u6570\u3068\u306f\" class=\"wp-image-10486\" style=\"width:300px\" srcset=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u65702.png 342w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u65702-300x143.png 300w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u65702-18x9.png 18w\" sizes=\"(max-width: 342px) 100vw, 342px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u305d\u3093\u306a\u3068\u304d\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306bIFERROR\u95a2\u6570\u3092\u4f7f\u3063\u3066\u66f8\u304d\u63db\u3048\u308b\u3053\u3068\u3067\u3001\u30a8\u30e9\u30fc\u3092\u5225\u306e\u8868\u793a\u306b\u7f6e\u304d\u63db\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-vk-image-border\"><img decoding=\"async\" width=\"469\" height=\"125\" src=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u65703.png\" alt=\"IFERROR\u95a2\u6570\u3068\u306f\" class=\"wp-image-10487\" style=\"width:400px\" srcset=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u65703.png 469w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u65703-300x80.png 300w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u65703-18x5.png 18w\" sizes=\"(max-width: 469px) 100vw, 469px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u5834\u5408\u3067\u3082\u898b\u3084\u3059\u3044\u30e1\u30c3\u30bb\u30fc\u30b8\u306b\u7f6e\u304d\u63db\u3048\u308b\u3053\u3068\u3067\u3001\u8cc7\u6599\u306e\u898b\u305f\u76ee\u3092\u6574\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading is-style-vk-heading-background_fill_lightgray\"><strong>\u4ee3\u8868\u7684\u306a\u30a8\u30e9\u30fc\u3068\u539f\u56e0<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Excel\u3067\u306f\u3001\u3055\u307e\u3056\u307e\u306a\u539f\u56e0\u3067\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3059\u3002\u4ee5\u4e0b\u306f\u3088\u304f\u3042\u308b\u30a8\u30e9\u30fc\u306e\u4e00\u89a7\u3067\u3059\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-vk-table-border-top-bottom\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\"><strong>\u30a8\u30e9\u30fc\u5185\u5bb9<\/strong><\/th><th class=\"has-text-align-left\" data-align=\"left\"><strong>\u8868\u793a\u3055\u308c\u308b\u8a18\u53f7<\/strong><\/th><th class=\"has-text-align-left\" data-align=\"left\"><strong>\u4e3b\u306a\u539f\u56e0\u4f8b<\/strong><\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\">0\u3067\u5272\u3063\u305f\u3068\u304d<\/td><td class=\"has-text-align-left\" data-align=\"left\">#DIV\/0!<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u5272\u308a\u7b97\u306e\u5206\u6bcd\u304c\u300c0\u300d\u307e\u305f\u306f\u7a7a\u767d<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">\u30c7\u30fc\u30bf\u304c\u898b\u3064\u304b\u3089\u306a\u3044<\/td><td class=\"has-text-align-left\" data-align=\"left\">#N\/A<\/td><td class=\"has-text-align-left\" data-align=\"left\">VLOOKUP\u306a\u3069\u3067\u691c\u7d22\u7d50\u679c\u304c\u898b\u3064\u304b\u3089\u306a\u3044<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">\u5024\u304c\u4e0d\u6b63\u306a\u3068\u304d<\/td><td class=\"has-text-align-left\" data-align=\"left\">#VALUE!<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u6570\u5024\u3068\u6587\u5b57\u5217\u3092\u4e00\u7dd2\u306b\u8a08\u7b97\u3057\u305f\u306a\u3069<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">\u53c2\u7167\u5148\u304c\u6d88\u3048\u305f<\/td><td class=\"has-text-align-left\" data-align=\"left\">#REF!<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u53c2\u7167\u3057\u3066\u3044\u305f\u30bb\u30eb\u3084\u884c\u304c\u524a\u9664\u3055\u308c\u305f<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">\u95a2\u6570\u540d\u30df\u30b9<\/td><td class=\"has-text-align-left\" data-align=\"left\">#NAME?<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u95a2\u6570\u540d\u3084\u540d\u524d\u306e\u7db4\u308a\u9593\u9055\u3044\u3001\u672a\u5b9a\u7fa9\u306e\u540d\u524d<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">\u6570\u5024\u304c\u7570\u5e38<\/td><td class=\"has-text-align-left\" data-align=\"left\">#NUM!<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u4e0d\u6b63\u306a\u6570\u5024\u8a08\u7b97\uff08\u4f8b\uff1a\u8ca0\u306e\u5024\u306e\u5e73\u65b9\u6839\uff09\u306a\u3069<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">NULL\u95a2\u4fc2\u306e\u554f\u984c<\/td><td class=\"has-text-align-left\" data-align=\"left\">#NULL!<\/td><td class=\"has-text-align-left\" data-align=\"left\">\u7121\u52b9\u306a\u30bb\u30eb\u7bc4\u56f2\u306e\u4ea4\u5dee\u3001\u6f14\u7b97\u5b50\u30df\u30b9\u306a\u3069<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u308c\u3089\u306e\u30a8\u30e9\u30fc\u306f\u3001\u6163\u308c\u3066\u3044\u306a\u3044\u3068\u6238\u60d1\u3063\u3066\u3057\u307e\u3046\u3053\u3068\u3082\u3042\u308a\u307e\u3059\u304c\u3001<strong>IFERROR\u95a2\u6570\u3092\u4f7f\u3048\u3070\u3053\u308c\u3089\u3059\u3079\u3066\u306b\u4e00\u62ec<\/strong>\u3067\u5bfe\u5fdc\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading is-style-vk-heading-background_fill_lightgray\"><strong>ISERROR\u95a2\u6570\u3068ISERR\u95a2\u6570\u306e\u9055\u3044<\/strong><\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" width=\"602\" height=\"402\" src=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b92.jpg\" alt=\"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5\" class=\"wp-image-10482\" style=\"width:600px\" srcset=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b92.jpg 602w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b92-300x200.jpg 300w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b92-18x12.jpg 18w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">IFERROR\u95a2\u6570\u3068\u3042\u308f\u305b\u3066\u77e5\u3063\u3066\u304a\u304f\u3068\u4fbf\u5229\u306a\u306e\u304c\u3001ISERROR\u95a2\u6570\u3084ISERR\u95a2\u6570\u3067\u3059\u3002\u4ee5\u4e0b\u306b\u305d\u308c\u305e\u308c\u306e\u7279\u5fb4\u3092\u307e\u3068\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading is-style-vk-heading-background_fill_lightgray\"><strong>ISERROR\u95a2\u6570\u3068\u306f\uff1f<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-background has-fixed-layout\" style=\"background-color:#effdff\"><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>ISERROR(\u5024)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u203b\u5024\uff1a\u30a8\u30e9\u30fc\u304b\u3069\u3046\u304b\u3092\u8abf\u3079\u305f\u3044\u6570\u5f0f\u3084\u30bb\u30eb\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<br>\u6307\u5b9a\u3057\u305f\u5024\u304c\u30a8\u30e9\u30fc\u3067\u3042\u308c\u3070<strong> TRUE<\/strong>\u3001\u6b63\u5e38\u306a\u5024\u3067\u3042\u308c\u3070<strong> FALSE <\/strong>\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list is-style-vk-check-square-mark vk_list_2\">\n<li>TRUE\uff1a\u6307\u5b9a\u3057\u305f\u5024\u304c\u30a8\u30e9\u30fc\u3067\u3042\u308b\u5834\u5408<\/li>\n\n\n\n<li>FALSE\uff1a\u6307\u5b9a\u3057\u305f\u5024\u304c\u30a8\u30e9\u30fc\u3067\u306a\u3044\u5834\u5408<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u95a2\u6570\u306f\u3001\u30bb\u30eb\u306e\u5024\u304c\u30a8\u30e9\u30fc\u304b\u3069\u3046\u304b\u3092\u5224\u5b9a\u3057\u305f\u3044\u3068\u304d\u306b\u4fbf\u5229\u3067\u3059\u3002<br>ISERROR(A1\/B1) \u2192 B1\u304c0\u306e\u5834\u5408 \u2192 TRUE<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-vk-image-border\"><img decoding=\"async\" width=\"424\" height=\"159\" src=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/ISERROR\u95a2\u6570.png\" alt=\"ISERROR\u95a2\u6570\u3068\u306f\uff1f\" class=\"wp-image-10488\" style=\"width:300px\" srcset=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/ISERROR\u95a2\u6570.png 424w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/ISERROR\u95a2\u6570-300x113.png 300w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/ISERROR\u95a2\u6570-18x7.png 18w\" sizes=\"(max-width: 424px) 100vw, 424px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">IF\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u305f\u4f7f\u3044\u65b9<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">ISERROR\u95a2\u6570\u3092IF\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u30a8\u30e9\u30fc\u6642\u3060\u3051\u7279\u5b9a\u306e\u5024\u3092\u8868\u793a\u3055\u305b\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-vk-image-border\"><img decoding=\"async\" width=\"435\" height=\"114\" src=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/ISERROR\u95a2\u65702.png\" alt=\"ISERROR\u95a2\u6570\u3068\u306f\uff1f\" class=\"wp-image-10489\" style=\"width:350px\" srcset=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/ISERROR\u95a2\u65702.png 435w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/ISERROR\u95a2\u65702-300x79.png 300w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/ISERROR\u95a2\u65702-18x5.png 18w\" sizes=\"(max-width: 435px) 100vw, 435px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u305f\u3060\u3057\u3001Excel 2007\u4ee5\u964d\u3067\u306f\u3001\u3088\u308a\u30b7\u30f3\u30d7\u30eb\u306b\u66f8\u3051\u308bIFERROR\u95a2\u6570\u306e\u4f7f\u7528\u304c\u63a8\u5968\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading is-style-vk-heading-background_fill_lightgray\"><strong>ISERR\u95a2\u6570\u3068\u306f\uff1f<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ISERR\u95a2\u6570\u306f\u3001ISERROR\u95a2\u6570\u3068\u4f3c\u3066\u3044\u307e\u3059\u304c\u3001\u5927\u304d\u306a\u9055\u3044\u304c\u3072\u3068\u3064\u3042\u308a\u307e\u3059\u3002<br>\u305d\u308c\u306f\u3001\u300c#N\/A\u30a8\u30e9\u30fc\u3092\u9664\u5916\u3057\u3066\u5224\u5b9a\u3059\u308b\u300d\u3068\u3044\u3046\u70b9\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-background has-fixed-layout\" style=\"background-color:#effdff\"><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>ISERR\u95a2\u6570(\u5024)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u203b\u5024\uff1a\u30a8\u30e9\u30fc\u304b\u3069\u3046\u304b\u3092\u8abf\u3079\u305f\u3044\u6570\u5f0f\u3084\u30bb\u30eb\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list is-style-default vk_list_3\">\n<li>TRUE\uff1a#N\/A \u4ee5\u5916\u306e\u30a8\u30e9\u30fc\uff08\u4f8b\uff1a#DIV\/0!\u3001#VALUE!\u3001#REF!\u306a\u3069\uff09<\/li>\n\n\n\n<li>FALSE\uff1a\u6b63\u5e38\u306a\u5024 \u307e\u305f\u306f #N\/A \u30a8\u30e9\u30fc <\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u3064\u307e\u308a\u3001ISERR\u95a2\u6570\u306f\u300c#N\/A\u300d\u4ee5\u5916\u306e\u30a8\u30e9\u30fc\u306b\u5bfe\u3057\u3066TRUE\u3092\u8fd4\u3059\u95a2\u6570\u3067\u3059\u3002<br>\u305d\u306e\u305f\u3081\u3001VLOOKUP\u95a2\u6570\u306a\u3069\u3067\u300c\u898b\u3064\u304b\u3089\u306a\u3044\u300d\u3068\u3044\u3063\u305f<strong>#N\/A\u30a8\u30e9\u30fc\u3092\u60f3\u5b9a\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u6ce8\u610f\u304c\u5fc5\u8981<\/strong>\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading is-style-vk-heading-background_fill_lightgray\"><strong>IFERROR\u3068\u306e\u9055\u3044<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ISERROR\u95a2\u6570\u3084ISERR\u95a2\u6570\u306f\u3001\u5358\u4f53\u3067\u306f\u300c\u30a8\u30e9\u30fc\u304b\u3069\u3046\u304b\u300d\u3092\u5224\u5b9a\u3059\u308b\u3060\u3051\u3067\u3001<strong>\u30a8\u30e9\u30fc\u6642\u306b\u5225\u306e\u5024\u3092\u8868\u793a\u3059\u308b\u6a5f\u80fd\u306f\u3042\u308a\u307e\u305b\u3093<\/strong>\u3002\u305d\u306e\u305f\u3081\u3001\u5b9f\u969b\u306b\u5225\u306e\u6587\u5b57\u3084\u5024\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u5834\u5408\u306f\u3001<strong>IF\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u3066\u4f7f\u3046\u5fc5\u8981<\/strong>\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u306b\u3088\u308a\u3001\u6570\u5f0f\u304c\u5c11\u3057\u8907\u96d1\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e00\u65b9\u3001<strong>IFERROR\u95a2\u6570<\/strong>\u306f\u3001\u300c\u30a8\u30e9\u30fc\u304b\u3069\u3046\u304b\u3092\u5224\u5b9a\u3059\u308b\u300d\uff0b\u300c\u30a8\u30e9\u30fc\u6642\u306b\u5225\u306e\u5024\u3092\u8868\u793a\u3059\u308b\u300d\u3068\u3044\u3046<strong>2\u3064\u306e\u51e6\u7406\u30921\u3064\u306e\u95a2\u6570\u3067\u5b9f\u73fe\u3067\u304d\u308b<\/strong>\u305f\u3081\u3001\u3068\u3066\u3082\u7c21\u5358\u306b\u4f7f\u3048\u307e\u3059\u3002<strong>Excel\u306b\u4e0d\u6163\u308c\u306a\u65b9\u306b\u306f\u3001\u307e\u305aIFERROR\u95a2\u6570\u306e\u5229\u7528\u3092\u304a\u3059\u3059\u3081<\/strong>\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class='code-block code-block-4' style='margin: 8px 0; clear: both;'>\n\n<div class='ai-rotate ai-unprocessed ai-rotate-4-28112504' style='position: relative;'>\n<div class=\"ai-rotate-option\" data-index=\"1\" data-name=\"QQ==\" data-code=\"CjxkaXYgZGF0YS1wb3N0LWlkPSIxMzQ5OCIgY2xhc3M9Imluc2VydC1wYWdlIGluc2VydC1wYWdlLTEzNDk4ICI+CjxzdHlsZT4KICAuZ3QtYmFubmVyIHsKICAgIGRpc3BsYXk6IGZsZXg7CiAgICBhbGlnbi1pdGVtczogY2VudGVyOwogICAganVzdGlmeS1jb250ZW50OiBzcGFjZS1iZXR3ZWVuOwogICAgZ2FwOiAyOHB4OwogICAgbWF4LXdpZHRoOiAxMDAwcHg7CiAgICBtYXJnaW46IDAgYXV0bzsKICAgIHBhZGRpbmc6IDI4cHggMzZweDsKICAgIGJhY2tncm91bmQ6ICNFMkY1Rjc7CiAgICBib3JkZXI6IDFweCBzb2xpZCAjRDhEOEQ4OwogICAgYm9yZGVyLXJhZGl1czogMTZweDsKICAgIGJveC1zaXppbmc6IGJvcmRlci1ib3g7CiAgICBmb250LWZhbWlseTogIk5vdG8gU2FucyBKUCIsICJIaXJhZ2lubyBLYWt1IEdvdGhpYyBQcm9OIiwgIll1IEdvdGhpYyIsICJNZWlyeW8iLCBzYW5zLXNlcmlmOwogIH0KICAuZ3QtYmFubmVyX19ib2R5IHsKICAgIGZsZXg6IDEgMSBhdXRvOwogICAgbWluLXdpZHRoOiAwOwogIH0KICAuZ3QtYmFubmVyX19sYWJlbCB7CiAgICBkaXNwbGF5OiBpbmxpbmUtYmxvY2s7CiAgICBiYWNrZ3JvdW5kOiAjRkZGRkZGOwogICAgYm9yZGVyOiAxcHggc29saWQgIzFEODE4QjsKICAgIGNvbG9yOiAjMEYyNDNFOwogICAgZm9udC1zaXplOiAxMnB4OwogICAgZm9udC13ZWlnaHQ6IDcwMDsKICAgIGxpbmUtaGVpZ2h0OiAxOwogICAgcGFkZGluZzogN3B4IDE2cHg7CiAgICBib3JkZXItcmFkaXVzOiA5OTlweDsKICAgIG1hcmdpbjogMCAwIDE2cHg7CiAgfQogIC5ndC1iYW5uZXJfX2hlYWRsaW5lIHsKICAgIG1hcmdpbjogMCAwIDEycHg7CiAgICBmb250LXNpemU6IDI0cHg7CiAgICBsaW5lLWhlaWdodDogMS41OwogICAgZm9udC13ZWlnaHQ6IDcwMDsKICAgIGNvbG9yOiAjMEYyNDNFOwogIH0KICAuZ3QtYmFubmVyX19zdWIgewogICAgbWFyZ2luOiAwIDAgMjJweDsKICAgIGZvbnQtc2l6ZTogMTRweDsKICAgIGxpbmUtaGVpZ2h0OiAxLjc1OwogICAgY29sb3I6ICMzMzMzMzM7CiAgfQogIC5ndC1iYW5uZXJfX2Zvb3RlciB7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgYWxpZ24taXRlbXM6IGNlbnRlcjsKICAgIGZsZXgtd3JhcDogd3JhcDsKICAgIGdhcDogMThweDsKICB9CiAgLmd0LWJhbm5lcl9fY3RhIHsKICAgIGRpc3BsYXk6IGlubGluZS1ibG9jazsKICAgIGJhY2tncm91bmQ6ICNGRkU5Mjk7CiAgICBjb2xvcjogIzBGMjQzRTsKICAgIGZvbnQtd2VpZ2h0OiA3MDA7CiAgICBmb250LXNpemU6IDE1cHg7CiAgICBsaW5lLWhlaWdodDogMTsKICAgIHBhZGRpbmc6IDEzcHggMjZweDsKICAgIGJvcmRlci1yYWRpdXM6IDEwcHg7CiAgICB3aGl0ZS1zcGFjZTogbm93cmFwOwogICAgdGV4dC1kZWNvcmF0aW9uOiBub25lOwogICAgdHJhbnNpdGlvbjogdHJhbnNmb3JtIDAuMTVzIGVhc2UsIGJveC1zaGFkb3cgMC4xNXMgZWFzZTsKICB9CiAgLmd0LWJhbm5lcl9fY3RhOmhvdmVyIHsKICAgIHRyYW5zZm9ybTogdHJhbnNsYXRlWSgtMnB4KTsKICAgIGJveC1zaGFkb3c6IDAgNHB4IDEwcHggcmdiYSgwLCAwLCAwLCAwLjEyKTsKICB9CiAgLmd0LWJhbm5lcl9fdGh1bWIgewogICAgZmxleDogMCAwIDMwMHB4OwogIH0KICAuZ3QtYmFubmVyX190aHVtYiBhIHsKICAgIGRpc3BsYXk6IGJsb2NrOwogICAgdHJhbnNpdGlvbjogdHJhbnNmb3JtIDAuMTVzIGVhc2UsIGJveC1zaGFkb3cgMC4xNXMgZWFzZTsKICB9CiAgLmd0LWJhbm5lcl9fdGh1bWIgYTpob3ZlciB7CiAgICB0cmFuc2Zvcm06IHRyYW5zbGF0ZVkoLTJweCk7CiAgICBib3gtc2hhZG93OiAwIDRweCAxMHB4IHJnYmEoMCwgMCwgMCwgMC4xMik7CiAgfQogIC5ndC1iYW5uZXJfX3RodW1iIGltZyB7CiAgICBkaXNwbGF5OiBibG9jazsKICAgIHdpZHRoOiAxMDAlOwogICAgaGVpZ2h0OiBhdXRvOwogICAgYm9yZGVyLXJhZGl1czogNHB4OwogICAgYm9yZGVyOiAxcHggc29saWQgcmdiYSgwLCAwLCAwLCAwLjE1KTsKICB9CgogIEBtZWRpYSAobWF4LXdpZHRoOiA3MDBweCkgewogICAgLmd0LWJhbm5lciB7CiAgICAgIGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47CiAgICAgIGFsaWduLWl0ZW1zOiBzdHJldGNoOwogICAgICBwYWRkaW5nOiAyNHB4OwogICAgICBnYXA6IDIwcHg7CiAgICB9CiAgICAuZ3QtYmFubmVyX190aHVtYiB7CiAgICAgIG9yZGVyOiAtMTsKICAgICAgZmxleC1iYXNpczogYXV0bzsKICAgICAgd2lkdGg6IDEwMCU7CiAgICAgIG1heC13aWR0aDogMzIwcHg7CiAgICAgIG1hcmdpbjogMCBhdXRvOwogICAgfQogICAgLmd0LWJhbm5lcl9faGVhZGxpbmUgewogICAgICBmb250LXNpemU6IDIwcHg7CiAgICB9CiAgICAuZ3QtYmFubmVyX19mb290ZXIgewogICAgICBmbGV4LWRpcmVjdGlvbjogY29sdW1uOwogICAgICBhbGlnbi1pdGVtczogZmxleC1zdGFydDsKICAgICAgZ2FwOiAxMnB4OwogICAgfQogIH0KPC9zdHlsZT4KCjxkaXYgY2xhc3M9Imd0LWJhbm5lciI+CiAgPGRpdiBjbGFzcz0iZ3QtYmFubmVyX19ib2R5Ij4KICAgIDxzcGFuIGNsYXNzPSJndC1iYW5uZXJfX2xhYmVsIj7nhKHmlpnjg5vjg6\/jgqTjg4jjg5rjg7zjg5Hjg7w8L3NwYW4+CiAgICA8aDMgY2xhc3M9Imd0LWJhbm5lcl9faGVhZGxpbmUiPgogICAgICDjgZ3jga7pm4boqIjjgIHjgb7jgaDmiYvkvZzmpa3jgafmtojogJfjgZfjgabjgYTjgb7jgZvjgpPjgYvvvJ88YnI+CiAgICAgIOaciOasoeOBruaui+alreOCkua4m+OCieOBmUV4Y2Vs6Zai5pWwMzTpgbgKICAgIDwvaDM+CiAgICA8cCBjbGFzcz0iZ3QtYmFubmVyX19zdWIiPgogICAgICDnqoHlkIjjg7vpm4boqIjjg7vnq6\/mlbDlh6bnkIbjga7jgIzjgoHjgpPjganjgYbjgarkvZzmpa3jgI3jgpLjgIHplqLmlbDjgafoh6rli5XljJbjgILntYznkIbjga7nj77loLTjgafmnKzlvZPjgavkvb\/jgYYzNOmWouaVsOOCkuOAgeani+aWh+OBqOS9v+OBhOOBqeOBk+OCjeS7mOOBjeOBp+ino+iqrOOBl+OBvuOBmeOAggogICAgPC9wPgogICAgPGRpdiBjbGFzcz0iZ3QtYmFubmVyX19mb290ZXIiPgogICAgICA8YSBjbGFzcz0iZ3QtYmFubmVyX19jdGEgY29sdW1uX3RvX2V4Y2VsMzRfYSIgaHJlZj0iaHR0cHM6Ly9jb3JwLmdlbmlhbHRlY2guaW8vamEvd2hpdGVwYXBlci9leGNlbC1mdW5jdGlvbnMvIiB0YXJnZXQ9Il9ibGFuayIgcmVsPSJub29wZW5lciI+CiAgICAgICAg54Sh5paZ44Gn44OA44Km44Oz44Ot44O844OJ44GZ44KLIOKWtgogICAgICA8L2E+CiAgICA8L2Rpdj4KICA8L2Rpdj4KICA8ZGl2IGNsYXNzPSJndC1iYW5uZXJfX3RodW1iIj4KICAgIDxhIGNsYXNzPSJjb2x1bW5fdG9fZXhjZWwzNF9hIiBocmVmPSJodHRwczovL2NvcnAuZ2VuaWFsdGVjaC5pby9qYS93aGl0ZXBhcGVyL2V4Y2VsLWZ1bmN0aW9ucy8iIHRhcmdldD0iX2JsYW5rIiByZWw9Im5vb3BlbmVyIj4KICAgICAgPGltZyBkZWNvZGluZz0iYXN5bmMiIHNyYz0iaHR0cHM6Ly9jb3JwLmdlbmlhbHRlY2guaW8vd3AtY29udGVudC91cGxvYWRzL3NpdGVzLzIvMjAyNS8xMS9FeGNlbOmWouaVsC5wbmciIGFsdD0i57WM55CG5ouF5b2T6ICF44GM55+l44Gj44Gm44GK44GN44Gf44GERXhjZWzplqLmlbAzNOmBuCI+CiAgICA8L2E+CiAgPC9kaXY+CjwvZGl2Pgo8L2Rpdj4KCg==\">\n<\/div>\n<div class=\"ai-rotate-option\" data-index=\"2\" data-name=\"Qg==\" data-code=\"CjxkaXYgZGF0YS1wb3N0LWlkPSIxMzUwMSIgY2xhc3M9Imluc2VydC1wYWdlIGluc2VydC1wYWdlLTEzNTAxICI+CjxzdHlsZT4KICAuZ2UtYmFubmVyLXdyYXAgewogICAgbWF4LXdpZHRoOiAxMjAwcHg7CiAgICBtYXJnaW46IDAgYXV0bzsKICAgIGZvbnQtZmFtaWx5OiAiSGlyYWdpbm8gS2FrdSBHb3RoaWMgUHJvTiIsICJZdSBHb3RoaWMiLCAiTm90byBTYW5zIEpQIiwgc2Fucy1zZXJpZjsKICAgIGNvbG9yOiAjMEYyNDNFOwogIH0KICAuZ2UtYmFubmVyIHsKICAgIGRpc3BsYXk6IGJsb2NrOwogICAgYmFja2dyb3VuZDogI2ZmZmZmZjsKICAgIGJvcmRlcjogMnB4IHNvbGlkICMxRDgxOEI7CiAgICBib3JkZXItcmFkaXVzOiAyMHB4OwogICAgcGFkZGluZzogMjhweDsKICAgIGJveC1zaXppbmc6IGJvcmRlci1ib3g7CiAgfQogIC5nZS1iYW5uZXItaW5uZXIgewogICAgZGlzcGxheTogZmxleDsKICAgIGFsaWduLWl0ZW1zOiBzdHJldGNoOwogICAgZ2FwOiAyNHB4OwogIH0KICAvKiDlt6bvvJozNOmWouaVsOODnOODg+OCr+OCuSAqLwogIC5nZS1udW0tYm94IHsKICAgIGZsZXg6IDAgMCAxOTBweDsKICAgIGJhY2tncm91bmQ6ICMxRDgxOEI7CiAgICBib3JkZXItcmFkaXVzOiAxNHB4OwogICAgY29sb3I6ICNmZmZmZmY7CiAgICBwYWRkaW5nOiAyNHB4IDE2cHg7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGFsaWduLWl0ZW1zOiBjZW50ZXI7CiAgICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICAgIHRleHQtYWxpZ246IGNlbnRlcjsKICB9CiAgLmdlLW51bS1ib3ggLmdlLW51bS1sYWJlbCB7CiAgICBmb250LXNpemU6IDE0cHg7CiAgICBmb250LXdlaWdodDogNzAwOwogICAgbGV0dGVyLXNwYWNpbmc6IDAuMDJlbTsKICAgIG1hcmdpbi1ib3R0b206IDRweDsKICB9CiAgLmdlLW51bS1ib3ggLmdlLW51bS1tYWluIHsKICAgIGZvbnQtc2l6ZTogNTZweDsKICAgIGZvbnQtd2VpZ2h0OiA4MDA7CiAgICBsaW5lLWhlaWdodDogMTsKICAgIG1hcmdpbjogNHB4IDA7CiAgfQogIC5nZS1udW0tYm94IC5nZS1udW0tbWFpbiBzcGFuIHsKICAgIGZvbnQtc2l6ZTogMjBweDsKICAgIGZvbnQtd2VpZ2h0OiA3MDA7CiAgICBtYXJnaW4tbGVmdDogNHB4OwogIH0KICAuZ2UtbnVtLWJveCAuZ2UtbnVtLWJyZWFrZG93biB7CiAgICBmb250LXNpemU6IDEycHg7CiAgICBvcGFjaXR5OiAwLjk7CiAgICBtYXJnaW4tdG9wOiA4cHg7CiAgfQogIC8qIOS4reWkru+8muODhuOCreOCueODiOOBqENUQSAqLwogIC5nZS1tYWluIHsKICAgIGZsZXg6IDEgMSBhdXRvOwogICAgZGlzcGxheTogZmxleDsKICAgIGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47CiAgICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICAgIG1pbi13aWR0aDogMDsKICB9CiAgLmdlLWV5ZWJyb3cgewogICAgZm9udC1zaXplOiAxM3B4OwogICAgZm9udC13ZWlnaHQ6IDcwMDsKICAgIG1hcmdpbi1ib3R0b206IDhweDsKICAgIGNvbG9yOiAjMUQ4MThCOwogIH0KICAuZ2UtZXllYnJvdyAuZ2UtZGl2aWRlciB7CiAgICBtYXJnaW46IDAgNnB4OwogICAgY29sb3I6ICMxRDgxOEI7CiAgfQogIC5nZS1oZWFkbGluZSB7CiAgICBmb250LXNpemU6IDI2cHg7CiAgICBmb250LXdlaWdodDogODAwOwogICAgbGluZS1oZWlnaHQ6IDEuNDsKICAgIG1hcmdpbjogMCAwIDE0cHg7CiAgfQogIC5nZS1jaGVja2xpc3QgewogICAgbGlzdC1zdHlsZTogbm9uZTsKICAgIG1hcmdpbjogMCAwIDIwcHg7CiAgICBwYWRkaW5nOiAwOwogICAgZm9udC1zaXplOiAxNXB4OwogICAgbGluZS1oZWlnaHQ6IDEuNzsKICB9CiAgLmdlLWNoZWNrbGlzdCBsaSB7CiAgICBwb3NpdGlvbjogcmVsYXRpdmU7CiAgICBwYWRkaW5nLWxlZnQ6IDIycHg7CiAgfQogIC5nZS1jaGVja2xpc3QgbGk6OmJlZm9yZSB7CiAgICBjb250ZW50OiAi4pyTIjsKICAgIHBvc2l0aW9uOiBhYnNvbHV0ZTsKICAgIGxlZnQ6IDA7CiAgICB0b3A6IDA7CiAgICBjb2xvcjogIzFEODE4QjsKICAgIGZvbnQtd2VpZ2h0OiA4MDA7CiAgfQogIC5nZS1jaGVja2xpc3QgYiB7CiAgICBmb250LXdlaWdodDogNzAwOwogIH0KICAuZ2UtY3RhIHsKICAgIGRpc3BsYXk6IGlubGluZS1mbGV4OwogICAgYWxpZ24taXRlbXM6IGNlbnRlcjsKICAgIGp1c3RpZnktY29udGVudDogY2VudGVyOwogICAgZ2FwOiA4cHg7CiAgICBiYWNrZ3JvdW5kOiAjRkZFOTI5OwogICAgY29sb3I6ICMwRjI0M0U7CiAgICB0ZXh0LWRlY29yYXRpb246IG5vbmU7CiAgICBmb250LXdlaWdodDogNzAwOwogICAgZm9udC1zaXplOiAxNnB4OwogICAgcGFkZGluZzogMTRweCAyOHB4OwogICAgYm9yZGVyLXJhZGl1czogOHB4OwogICAgd2lkdGg6IGZpdC1jb250ZW50OwogICAgdHJhbnNpdGlvbjogZmlsdGVyIDAuMnMgZWFzZTsKICB9CiAgLmdlLWN0YTpob3ZlciB7CiAgICBmaWx0ZXI6IGJyaWdodG5lc3MoMC45Nik7CiAgfQogIC8qIOWPs++8muOCueODqeOCpOODieeUu+WDjyAqLwogIC5nZS12aXN1YWwgewogICAgZmxleDogMCAwIDM0MHB4OwogICAgZGlzcGxheTogZmxleDsKICAgIGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47CiAgICBhbGlnbi1pdGVtczogY2VudGVyOwogICAganVzdGlmeS1jb250ZW50OiBjZW50ZXI7CiAgfQogIC5nZS12aXN1YWwgYSB7CiAgICBkaXNwbGF5OiBibG9jazsKICAgIHdpZHRoOiAxMDAlOwogICAgdHJhbnNpdGlvbjogb3BhY2l0eSAwLjJzIGVhc2U7CiAgfQogIC5nZS12aXN1YWwgYTpob3ZlciB7CiAgICBvcGFjaXR5OiAwLjg1OwogIH0KICAuZ2UtdmlzdWFsIGltZyB7CiAgICB3aWR0aDogMTAwJTsKICAgIGhlaWdodDogYXV0bzsKICAgIGJvcmRlci1yYWRpdXM6IDEwcHg7CiAgICBib3JkZXI6IDFweCBzb2xpZCAjZGJlN2U4OwogICAgZGlzcGxheTogYmxvY2s7CiAgfQogIC5nZS12aXN1YWwtY2FwdGlvbiB7CiAgICBmb250LXNpemU6IDEycHg7CiAgICBjb2xvcjogIzRhNWE2MzsKICAgIG1hcmdpbi10b3A6IDhweDsKICAgIHRleHQtYWxpZ246IGNlbnRlcjsKICB9CgogIC8qIOODrOOCueODneODs+OCt+ODlu+8iOOCv+ODluODrOODg+ODiO+8iSAqLwogIEBtZWRpYSAobWF4LXdpZHRoOiA4MDBweCkgewogICAgLmdlLWJhbm5lci1pbm5lciB7CiAgICAgIGZsZXgtd3JhcDogd3JhcDsKICAgIH0KICAgIC5nZS1udW0tYm94IHsKICAgICAgZmxleDogMCAwIGF1dG87CiAgICAgIHdpZHRoOiAxMDAlOwogICAgICBmbGV4LWRpcmVjdGlvbjogcm93OwogICAgICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICAgICAgZ2FwOiAxMnB4OwogICAgICBwYWRkaW5nOiAxNnB4OwogICAgfQogICAgLmdlLW51bS1ib3ggLmdlLW51bS1icmVha2Rvd24geyBtYXJnaW4tdG9wOiAwOyB9CiAgICAuZ2UtdmlzdWFsIHsKICAgICAgZmxleDogMSAxIDEwMCU7CiAgICAgIG9yZGVyOiAzOwogICAgfQogICAgLmdlLXZpc3VhbCBpbWcgeyBtYXgtd2lkdGg6IDMyMHB4OyB9CiAgfQoKICAvKiDjg6zjgrnjg53jg7Pjgrfjg5bvvIjjgrnjg57jg5vvvIkgKi8KICBAbWVkaWEgKG1heC13aWR0aDogNDgwcHgpIHsKICAgIC5nZS1iYW5uZXIgeyBwYWRkaW5nOiAxOHB4OyBib3JkZXItcmFkaXVzOiAxNnB4OyB9CiAgICAuZ2UtbnVtLWJveCB7IGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47IH0KICAgIC5nZS1oZWFkbGluZSB7IGZvbnQtc2l6ZTogMjFweDsgfQogICAgLmdlLWN0YSB7IHdpZHRoOiAxMDAlOyBmb250LXNpemU6IDE1cHg7IHBhZGRpbmc6IDE0cHggMThweDsgfQogIH0KPC9zdHlsZT4KCjxkaXYgY2xhc3M9ImdlLWJhbm5lci13cmFwIj4KICA8ZGl2IGNsYXNzPSJnZS1iYW5uZXIiPgogICAgPGRpdiBjbGFzcz0iZ2UtYmFubmVyLWlubmVyIj4KCiAgICAgIDwhLS0g5bem77yaMzTplqLmlbDjg5zjg4Pjgq\/jgrkgLS0+CiAgICAgIDxkaXYgY2xhc3M9ImdlLW51bS1ib3giPgogICAgICAgIDxkaXYgY2xhc3M9ImdlLW51bS1sYWJlbCI+57WM55CG44Gu44Gf44KB44GuPC9kaXY+CiAgICAgICAgPGRpdiBjbGFzcz0iZ2UtbnVtLW1haW4iPjM0PHNwYW4+6Zai5pWwPC9zcGFuPjwvZGl2PgogICAgICAgIDxkaXYgY2xhc3M9ImdlLW51bS1icmVha2Rvd24iPuWInee0mjEx77yP5Lit57SaMTLvvI\/kuIrntJoxMTwvZGl2PgogICAgICA8L2Rpdj4KCiAgICAgIDwhLS0g5Lit5aSu77ya5pys5paH77yLQ1RBIC0tPgogICAgICA8ZGl2IGNsYXNzPSJnZS1tYWluIj4KICAgICAgICA8cCBjbGFzcz0iZ2UtZXllYnJvdyI+CiAgICAgICAgICDjg5vjg6\/jgqTjg4jjg5rjg7zjg5Hjg7w8c3BhbiBjbGFzcz0iZ2UtZGl2aWRlciI+772cPC9zcGFuPjxzcGFuIGNsYXNzPSJnZS1obCI+57WM55CG44GuRXhjZWzlrp\/ot7XjgqzjgqTjg4nvvIjnhKHmlpnvvIk8L3NwYW4+CiAgICAgICAgPC9wPgogICAgICAgIDxwIGNsYXNzPSJnZS1oZWFkbGluZSI+57WM55CG44Gn5L2\/44GGRXhjZWzplqLmlbDjgpLjgIHlvrnlupXop6PoqqzjgII8L3A+CiAgICAgICAgPHVsIGNsYXNzPSJnZS1jaGVja2xpc3QiPgogICAgICAgICAgPGxpPuWInee0mu+8mjxiPlNVTe+8j1JPVU5E77yPVE9EQVk8L2I+44Gn5pel5qyh6ZuG6KiI44KS6auY6YCf5YyWPC9saT4KICAgICAgICAgIDxsaT7kuK3ntJrvvJo8Yj5TVU1JRlPvvI9YTE9PS1VQPC9iPuOBp+eqgeWQiOODu+eFp+WQiOOCkuiHquWLleWMljwvbGk+CiAgICAgICAgICA8bGk+5LiK57Sa77yaPGI+VU5JUVVF77yPUkVHRVjns7s8L2I+44Gu5pyA5paw6Zai5pWw44G+44Gn57+S5b6XPC9saT4KICAgICAgICA8L3VsPgogICAgICAgIDxhIGNsYXNzPSJnZS1jdGEgY29sdW1uX3RvX2V4Y2VsMzRfYiIgaHJlZj0iaHR0cHM6Ly9jb3JwLmdlbmlhbHRlY2guaW8vamEvd2hpdGVwYXBlci9leGNlbC1mdW5jdGlvbnMvIiB0YXJnZXQ9Il9ibGFuayIgcmVsPSJub29wZW5lciI+6LOH5paZ44KS44OA44Km44Oz44Ot44O844OJ77yI54Sh5paZ77yJIOKWtjwvYT4KICAgICAgPC9kaXY+CgogICAgICA8IS0tIOWPs++8muOCueODqeOCpOODieeUu+WDjyAtLT4KICAgICAgPGRpdiBjbGFzcz0iZ2UtdmlzdWFsIj4KICAgICAgICA8YSBjbGFzcz0iY29sdW1uX3RvX2V4Y2VsMzRfYiIgaHJlZj0iaHR0cHM6Ly9jb3JwLmdlbmlhbHRlY2guaW8vamEvd2hpdGVwYXBlci9leGNlbC1mdW5jdGlvbnMvIiB0YXJnZXQ9Il9ibGFuayIgcmVsPSJub29wZW5lciI+CiAgICAgICAgICA8aW1nIGRlY29kaW5nPSJhc3luYyIgc3JjPSJodHRwczovL2NvcnAuZ2VuaWFsdGVjaC5pby93cC1jb250ZW50L3VwbG9hZHMvc2l0ZXMvMi8yMDI1LzExL0V4Y2Vs6Zai5pWwLTEuanBnIiBhbHQ9IklG6Zai5pWw44O7SUZFUlJPUumWouaVsOOBruino+iqrOOCueODqeOCpOODie+8iOani+aWh+OBqOS9v+eUqOS+i++8iSI+CiAgICAgICAgPC9hPgogICAgICAgIDxkaXYgY2xhc3M9ImdlLXZpc3VhbC1jYXB0aW9uIj7mp4vmlofvvIvkvb\/nlKjkvovjgaTjgY08L2Rpdj4KICAgICAgPC9kaXY+CgogICAgPC9kaXY+CiAgPC9kaXY+CjwvZGl2Pgo8L2Rpdj4=\">\n<\/div>\n<\/div>\n<script>if (typeof ai_js_code == 'boolean') {var ai_block_div = document.querySelector ('.ai-rotate-4-28112504'); ai_process_rotation (ai_block_div); ai_block_div.classList.remove ('ai-rotate-4-28112504');};<\/script>\n<\/div>\n\n\n\n\n<h2 class=\"wp-block-heading is-style-vk-heading-background_fill_lightgray\"><strong>IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9<\/strong><\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" width=\"602\" height=\"402\" src=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b93.jpg\" alt=\"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5\" class=\"wp-image-10483\" style=\"width:600px\" srcset=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b93.jpg 602w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b93-300x200.jpg 300w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b93-18x12.jpg 18w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">\u3053\u3053\u3067\u306f\u3001\u5b9f\u52d9\u3067\u5f79\u7acb\u3064IFERROR\u95a2\u6570\u306e\u6d3b\u7528\u4f8b\u3092\u3044\u304f\u3064\u304b\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading is-style-vk-heading-background_fill_lightgray\"><strong>\u3010\u4f8b1\u30110\u3067\u5272\u3063\u305f\u3068\u304d\u306e\u30a8\u30e9\u30fc\u5bfe\u7b56<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-background has-fixed-layout\" style=\"background-color:#effdff\"><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>=IFERROR(A1\/B1, &#8220;\u8a08\u7b97\u3067\u304d\u307e\u305b\u3093&#8221;)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-vk-image-border\"><img decoding=\"async\" width=\"1024\" height=\"311\" src=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/0\u3067\u5272\u3063\u305f\u3068\u304d\u306e\u30a8\u30e9\u30fc\u5bfe\u7b56-1024x311.png\" alt=\"\u3010\u4f8b1\u30110\u3067\u5272\u3063\u305f\u3068\u304d\u306e\u30a8\u30e9\u30fc\u5bfe\u7b56\" class=\"wp-image-10490\" style=\"width:350px\" srcset=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/0\u3067\u5272\u3063\u305f\u3068\u304d\u306e\u30a8\u30e9\u30fc\u5bfe\u7b56-1024x311.png 1024w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/0\u3067\u5272\u3063\u305f\u3068\u304d\u306e\u30a8\u30e9\u30fc\u5bfe\u7b56-300x91.png 300w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/0\u3067\u5272\u3063\u305f\u3068\u304d\u306e\u30a8\u30e9\u30fc\u5bfe\u7b56-768x233.png 768w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/0\u3067\u5272\u3063\u305f\u3068\u304d\u306e\u30a8\u30e9\u30fc\u5bfe\u7b56-1536x466.png 1536w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/0\u3067\u5272\u3063\u305f\u3068\u304d\u306e\u30a8\u30e9\u30fc\u5bfe\u7b56-2048x621.png 2048w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/0\u3067\u5272\u3063\u305f\u3068\u304d\u306e\u30a8\u30e9\u30fc\u5bfe\u7b56-18x5.png 18w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">B1\u304c\u300c0\u300d\u3084\u7a7a\u767d\u3067\u3082\u3001\u300c#DIV\/0!\u300d\u3067\u306f\u306a\u304f\u300c\u8a08\u7b97\u3067\u304d\u307e\u305b\u3093\u300d\u3068\u8868\u793a\u3055\u308c\u3001\u8cc7\u6599\u304c\u3088\u308a\u308f\u304b\u308a\u3084\u3059\u304f\u4e01\u5be7\u306a\u5370\u8c61\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading is-style-vk-heading-background_fill_lightgray\"><strong>\u3010\u4f8b2\u3011\u6587\u5b57\u5217\u5909\u63db\u30a8\u30e9\u30fc\u306e\u51e6\u7406<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-background has-fixed-layout\" style=\"background-color:#effdff\"><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>=IFERROR(VALUE(A1), &#8220;\u6570\u5024\u3067\u306f\u3042\u308a\u307e\u305b\u3093&#8221;)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-vk-image-border\"><img decoding=\"async\" width=\"538\" height=\"132\" src=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u6587\u5b57\u5217\u5909\u63db\u30a8\u30e9\u30fc\u306e\u51e6\u7406.png\" alt=\"\u3010\u4f8b2\u3011\u6587\u5b57\u5217\u5909\u63db\u30a8\u30e9\u30fc\u306e\u51e6\u7406\" class=\"wp-image-10491\" style=\"width:400px\" srcset=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u6587\u5b57\u5217\u5909\u63db\u30a8\u30e9\u30fc\u306e\u51e6\u7406.png 538w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u6587\u5b57\u5217\u5909\u63db\u30a8\u30e9\u30fc\u306e\u51e6\u7406-300x74.png 300w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u6587\u5b57\u5217\u5909\u63db\u30a8\u30e9\u30fc\u306e\u51e6\u7406-18x4.png 18w\" sizes=\"(max-width: 538px) 100vw, 538px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">A1\u306b\u300cABC\u300d\u306a\u3069\u306e\u6587\u5b57\u5217\u304c\u5165\u3063\u3066\u3044\u308b\u3068\u3001\u300c\u6570\u5024\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u300d\u3068\u8868\u793a\u3055\u308c\u308b\u3053\u3068\u3067\u3001\u5165\u529b\u30df\u30b9\u306b\u3082\u3059\u3050\u306b\u6c17\u3065\u3051\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading is-style-vk-heading-background_fill_lightgray\"><strong>\u3010\u4f8b3\u3011\u5e73\u5747\u8a08\u7b97\u306e\u30a8\u30e9\u30fc\u3092\u907f\u3051\u308b<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-background has-fixed-layout\" style=\"background-color:#effdff\"><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>=IFERROR(AVERAGE(A1:A10), &#8220;\u30c7\u30fc\u30bf\u306a\u3057&#8221;)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-vk-image-border\"><img decoding=\"async\" width=\"472\" height=\"240\" src=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u5e73\u5747\u8a08\u7b97\u306e\u30a8\u30e9\u30fc\u3092\u907f\u3051\u308b.png\" alt=\"\u3010\u4f8b3\u3011\u5e73\u5747\u8a08\u7b97\u306e\u30a8\u30e9\u30fc\u3092\u907f\u3051\u308b\" class=\"wp-image-10492\" style=\"width:350px\" srcset=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u5e73\u5747\u8a08\u7b97\u306e\u30a8\u30e9\u30fc\u3092\u907f\u3051\u308b.png 472w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u5e73\u5747\u8a08\u7b97\u306e\u30a8\u30e9\u30fc\u3092\u907f\u3051\u308b-300x153.png 300w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u5e73\u5747\u8a08\u7b97\u306e\u30a8\u30e9\u30fc\u3092\u907f\u3051\u308b-18x9.png 18w\" sizes=\"(max-width: 472px) 100vw, 472px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u5bfe\u8c61\u306e\u30bb\u30eb\u304c\u3059\u3079\u3066\u7a7a\u3067\u3082\u3001\u300c#DIV\/0!\u300d\u3067\u306f\u306a\u304f\u300c\u30c7\u30fc\u30bf\u306a\u3057\u300d\u3068\u8868\u793a\u3055\u308c\u3001<strong>\u5165\u529b\u304c\u5fc5\u8981\u3067\u3042\u308b\u3053\u3068\u304c\u4e00\u76ee\u3067\u5206\u304b\u308a\u307e\u3059<\/strong>\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-vk-image-border\"><img decoding=\"async\" width=\"467\" height=\"243\" src=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u5e73\u5747\u8a08\u7b97\u306e\u30a8\u30e9\u30fc\u3092\u907f\u3051\u308b2.png\" alt=\"\u3010\u4f8b3\u3011\u5e73\u5747\u8a08\u7b97\u306e\u30a8\u30e9\u30fc\u3092\u907f\u3051\u308b\" class=\"wp-image-10493\" style=\"width:350px\" srcset=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u5e73\u5747\u8a08\u7b97\u306e\u30a8\u30e9\u30fc\u3092\u907f\u3051\u308b2.png 467w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u5e73\u5747\u8a08\u7b97\u306e\u30a8\u30e9\u30fc\u3092\u907f\u3051\u308b2-300x156.png 300w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u5e73\u5747\u8a08\u7b97\u306e\u30a8\u30e9\u30fc\u3092\u907f\u3051\u308b2-18x9.png 18w\" sizes=\"(max-width: 467px) 100vw, 467px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading is-style-vk-heading-background_fill_lightgray\"><strong>IFERROR\u95a2\u6570\u3068VLOOKUP\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u4f7f\u3044\u65b9<\/strong><\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" width=\"602\" height=\"401\" src=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b94.jpg\" alt=\"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5\" class=\"wp-image-10484\" style=\"width:600px\" srcset=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b94.jpg 602w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b94-300x200.jpg 300w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b94-18x12.jpg 18w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Excel\u306e\u4ee3\u8868\u7684\u306a\u95a2\u6570\u3067\u3042\u308bVLOOKUP\u95a2\u6570\u3068IFERROR\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308c\u3070\u3001<strong>\u5b9f\u8df5\u7684\u306a\u30a8\u30e9\u30fc\u51e6\u7406\u304c\u53ef\u80fd<\/strong>\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading is-style-vk-heading-background_fill_lightgray\"><strong>\u3010\u4f8b\u3011\u793e\u54e1\u540d\u7c3f\u304b\u3089\u90e8\u7f72\u540d\u3092\u53d6\u5f97\u3059\u308b<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-background has-fixed-layout\" style=\"background-color:#effdff\"><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>=IFERROR(VLOOKUP(A1, A5:C142, 3, FALSE), &#8220;\u672a\u767b\u9332&#8221;)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-vk-image-border\"><img decoding=\"async\" width=\"453\" height=\"275\" src=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u793e\u54e1\u540d\u7c3f\u304b\u3089\u90e8\u7f72\u540d\u3092\u53d6\u5f97\u3059\u308b.png\" alt=\"\u3010\u4f8b\u3011\u793e\u54e1\u540d\u7c3f\u304b\u3089\u90e8\u7f72\u540d\u3092\u53d6\u5f97\u3059\u308b\" class=\"wp-image-10494\" style=\"width:350px\" srcset=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u793e\u54e1\u540d\u7c3f\u304b\u3089\u90e8\u7f72\u540d\u3092\u53d6\u5f97\u3059\u308b.png 453w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u793e\u54e1\u540d\u7c3f\u304b\u3089\u90e8\u7f72\u540d\u3092\u53d6\u5f97\u3059\u308b-300x182.png 300w, https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/\u793e\u54e1\u540d\u7c3f\u304b\u3089\u90e8\u7f72\u540d\u3092\u53d6\u5f97\u3059\u308b-18x12.png 18w\" sizes=\"(max-width: 453px) 100vw, 453px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u5f0f\u3067\u306f\u3001A1\u306b\u5165\u529b\u3055\u308c\u305f\u793e\u54e1ID\u3092A\u5217\u3067\u691c\u7d22\u3057\u3001\u5bfe\u5fdc\u3059\u308b\u90e8\u7f72\u540d\uff08C\u5217\uff09\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A1\u306eID\u304c\u898b\u3064\u304b\u3089\u306a\u3044\u5834\u5408\u3001\u901a\u5e38\u306f\u300c#N\/A\u300d\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u304c\u3001IFERROR\u95a2\u6570\u3092\u4f7f\u3048\u3070\u300c\u672a\u767b\u9332\u300d\u3068\u8868\u793a\u3055\u308c\u308b\u305f\u3081\u3001\u898b\u3084\u3059\u304f\u4e01\u5be7\u306a\u5370\u8c61\u306b\u306a\u308a\u307e\u3059\u3002<br>\u3068\u304f\u306b<strong>\u63d0\u51fa\u8cc7\u6599\u3084\u5e33\u7968<\/strong>\u3067\u306f\u3001\u3053\u3046\u3057\u305f\u7d30\u304b\u306a\u6c17\u914d\u308a\u304c<strong>\u8cc7\u6599\u5168\u4f53\u306e\u4fe1\u983c\u611f\u30a2\u30c3\u30d7\u306b\u3082\u3064\u306a\u304c\u308a\u307e\u3059<\/strong>\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading is-style-vk-heading-background_fill_lightgray\"><strong>\u307e\u3068\u3081<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">IFERROR\u95a2\u6570\u306f\u3001Excel\u3067\u767a\u751f\u3059\u308b\u3055\u307e\u3056\u307e\u306a\u30a8\u30e9\u30fc\u3092\u3001\u3042\u3089\u304b\u3058\u3081\u8a2d\u5b9a\u3057\u305f\u30e1\u30c3\u30bb\u30fc\u30b8\u3084\u5024\u306b\u7f6e\u304d\u63db\u3048\u3089\u308c\u308b\u4fbf\u5229\u306a\u95a2\u6570\u3067\u3059\u3002\u305f\u3068\u3048\u3070\u3001\u300c#DIV\/0!\u300d\u3084\u300c#N\/A\u300d\u306a\u3069\u306e\u30a8\u30e9\u30fc\u3092\u3001\u308f\u304b\u308a\u3084\u3059\u304f\u610f\u5473\u306e\u3042\u308b\u6587\u8a00\u306b\u5909\u3048\u308b\u3053\u3068\u3067\u3001\u8cc7\u6599\u306e\u898b\u305f\u76ee\u3084\u5370\u8c61\u3092\u5927\u304d\u304f\u6539\u5584\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ISERROR\u95a2\u6570\u3084ISERR\u95a2\u6570\u3082\u30a8\u30e9\u30fc\u51e6\u7406\u306b\u4f7f\u3048\u307e\u3059\u304c\u3001IFERROR\u95a2\u6570\u306f\u3088\u308a\u30b7\u30f3\u30d7\u30eb\u3067\u6271\u3044\u3084\u3059\u304f\u3001Excel\u521d\u5fc3\u8005\u306b\u3082\u304a\u3059\u3059\u3081\u3067\u3059\u3002\u7279\u306bVLOOKUP\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u691c\u7d22\u30a8\u30e9\u30fc\u306b\u3082\u67d4\u8edf\u306b\u5bfe\u5fdc\u3067\u304d\u3001\u5b9f\u52d9\u3067\u306e\u6d3b\u7528\u7bc4\u56f2\u304c\u5e83\u304c\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3059\u3079\u3066\u306e\u30c7\u30fc\u30bf\u304c\u5e38\u306b\u6b63\u3057\u3044\u3068\u306f\u9650\u3089\u306a\u3044\u304b\u3089\u3053\u305d\u3001\u30a8\u30e9\u30fc\u3092\u524d\u63d0\u306b\u3057\u305f\u6570\u5f0f\u8a2d\u8a08\u304c\u91cd\u8981\u3067\u3059\u3002IFERROR\u95a2\u6570\u3092\u4e0a\u624b\u306b\u53d6\u308a\u5165\u308c\u3001\u696d\u52d9\u52b9\u7387\u306e\u5411\u4e0a\u3068\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u8cc7\u6599\u3065\u304f\u308a\u306b\u5f79\u7acb\u3066\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n<div class='code-block code-block-4' style='margin: 8px 0; clear: both;'>\n\n<div class='ai-rotate ai-unprocessed ai-rotate-4-97154630' style='position: relative;'>\n<div class=\"ai-rotate-option\" data-index=\"1\" data-name=\"QQ==\" data-code=\"CjxkaXYgZGF0YS1wb3N0LWlkPSIxMzQ5OCIgY2xhc3M9Imluc2VydC1wYWdlIGluc2VydC1wYWdlLTEzNDk4ICI+CjxzdHlsZT4KICAuZ3QtYmFubmVyIHsKICAgIGRpc3BsYXk6IGZsZXg7CiAgICBhbGlnbi1pdGVtczogY2VudGVyOwogICAganVzdGlmeS1jb250ZW50OiBzcGFjZS1iZXR3ZWVuOwogICAgZ2FwOiAyOHB4OwogICAgbWF4LXdpZHRoOiAxMDAwcHg7CiAgICBtYXJnaW46IDAgYXV0bzsKICAgIHBhZGRpbmc6IDI4cHggMzZweDsKICAgIGJhY2tncm91bmQ6ICNFMkY1Rjc7CiAgICBib3JkZXI6IDFweCBzb2xpZCAjRDhEOEQ4OwogICAgYm9yZGVyLXJhZGl1czogMTZweDsKICAgIGJveC1zaXppbmc6IGJvcmRlci1ib3g7CiAgICBmb250LWZhbWlseTogIk5vdG8gU2FucyBKUCIsICJIaXJhZ2lubyBLYWt1IEdvdGhpYyBQcm9OIiwgIll1IEdvdGhpYyIsICJNZWlyeW8iLCBzYW5zLXNlcmlmOwogIH0KICAuZ3QtYmFubmVyX19ib2R5IHsKICAgIGZsZXg6IDEgMSBhdXRvOwogICAgbWluLXdpZHRoOiAwOwogIH0KICAuZ3QtYmFubmVyX19sYWJlbCB7CiAgICBkaXNwbGF5OiBpbmxpbmUtYmxvY2s7CiAgICBiYWNrZ3JvdW5kOiAjRkZGRkZGOwogICAgYm9yZGVyOiAxcHggc29saWQgIzFEODE4QjsKICAgIGNvbG9yOiAjMEYyNDNFOwogICAgZm9udC1zaXplOiAxMnB4OwogICAgZm9udC13ZWlnaHQ6IDcwMDsKICAgIGxpbmUtaGVpZ2h0OiAxOwogICAgcGFkZGluZzogN3B4IDE2cHg7CiAgICBib3JkZXItcmFkaXVzOiA5OTlweDsKICAgIG1hcmdpbjogMCAwIDE2cHg7CiAgfQogIC5ndC1iYW5uZXJfX2hlYWRsaW5lIHsKICAgIG1hcmdpbjogMCAwIDEycHg7CiAgICBmb250LXNpemU6IDI0cHg7CiAgICBsaW5lLWhlaWdodDogMS41OwogICAgZm9udC13ZWlnaHQ6IDcwMDsKICAgIGNvbG9yOiAjMEYyNDNFOwogIH0KICAuZ3QtYmFubmVyX19zdWIgewogICAgbWFyZ2luOiAwIDAgMjJweDsKICAgIGZvbnQtc2l6ZTogMTRweDsKICAgIGxpbmUtaGVpZ2h0OiAxLjc1OwogICAgY29sb3I6ICMzMzMzMzM7CiAgfQogIC5ndC1iYW5uZXJfX2Zvb3RlciB7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgYWxpZ24taXRlbXM6IGNlbnRlcjsKICAgIGZsZXgtd3JhcDogd3JhcDsKICAgIGdhcDogMThweDsKICB9CiAgLmd0LWJhbm5lcl9fY3RhIHsKICAgIGRpc3BsYXk6IGlubGluZS1ibG9jazsKICAgIGJhY2tncm91bmQ6ICNGRkU5Mjk7CiAgICBjb2xvcjogIzBGMjQzRTsKICAgIGZvbnQtd2VpZ2h0OiA3MDA7CiAgICBmb250LXNpemU6IDE1cHg7CiAgICBsaW5lLWhlaWdodDogMTsKICAgIHBhZGRpbmc6IDEzcHggMjZweDsKICAgIGJvcmRlci1yYWRpdXM6IDEwcHg7CiAgICB3aGl0ZS1zcGFjZTogbm93cmFwOwogICAgdGV4dC1kZWNvcmF0aW9uOiBub25lOwogICAgdHJhbnNpdGlvbjogdHJhbnNmb3JtIDAuMTVzIGVhc2UsIGJveC1zaGFkb3cgMC4xNXMgZWFzZTsKICB9CiAgLmd0LWJhbm5lcl9fY3RhOmhvdmVyIHsKICAgIHRyYW5zZm9ybTogdHJhbnNsYXRlWSgtMnB4KTsKICAgIGJveC1zaGFkb3c6IDAgNHB4IDEwcHggcmdiYSgwLCAwLCAwLCAwLjEyKTsKICB9CiAgLmd0LWJhbm5lcl9fdGh1bWIgewogICAgZmxleDogMCAwIDMwMHB4OwogIH0KICAuZ3QtYmFubmVyX190aHVtYiBhIHsKICAgIGRpc3BsYXk6IGJsb2NrOwogICAgdHJhbnNpdGlvbjogdHJhbnNmb3JtIDAuMTVzIGVhc2UsIGJveC1zaGFkb3cgMC4xNXMgZWFzZTsKICB9CiAgLmd0LWJhbm5lcl9fdGh1bWIgYTpob3ZlciB7CiAgICB0cmFuc2Zvcm06IHRyYW5zbGF0ZVkoLTJweCk7CiAgICBib3gtc2hhZG93OiAwIDRweCAxMHB4IHJnYmEoMCwgMCwgMCwgMC4xMik7CiAgfQogIC5ndC1iYW5uZXJfX3RodW1iIGltZyB7CiAgICBkaXNwbGF5OiBibG9jazsKICAgIHdpZHRoOiAxMDAlOwogICAgaGVpZ2h0OiBhdXRvOwogICAgYm9yZGVyLXJhZGl1czogNHB4OwogICAgYm9yZGVyOiAxcHggc29saWQgcmdiYSgwLCAwLCAwLCAwLjE1KTsKICB9CgogIEBtZWRpYSAobWF4LXdpZHRoOiA3MDBweCkgewogICAgLmd0LWJhbm5lciB7CiAgICAgIGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47CiAgICAgIGFsaWduLWl0ZW1zOiBzdHJldGNoOwogICAgICBwYWRkaW5nOiAyNHB4OwogICAgICBnYXA6IDIwcHg7CiAgICB9CiAgICAuZ3QtYmFubmVyX190aHVtYiB7CiAgICAgIG9yZGVyOiAtMTsKICAgICAgZmxleC1iYXNpczogYXV0bzsKICAgICAgd2lkdGg6IDEwMCU7CiAgICAgIG1heC13aWR0aDogMzIwcHg7CiAgICAgIG1hcmdpbjogMCBhdXRvOwogICAgfQogICAgLmd0LWJhbm5lcl9faGVhZGxpbmUgewogICAgICBmb250LXNpemU6IDIwcHg7CiAgICB9CiAgICAuZ3QtYmFubmVyX19mb290ZXIgewogICAgICBmbGV4LWRpcmVjdGlvbjogY29sdW1uOwogICAgICBhbGlnbi1pdGVtczogZmxleC1zdGFydDsKICAgICAgZ2FwOiAxMnB4OwogICAgfQogIH0KPC9zdHlsZT4KCjxkaXYgY2xhc3M9Imd0LWJhbm5lciI+CiAgPGRpdiBjbGFzcz0iZ3QtYmFubmVyX19ib2R5Ij4KICAgIDxzcGFuIGNsYXNzPSJndC1iYW5uZXJfX2xhYmVsIj7nhKHmlpnjg5vjg6\/jgqTjg4jjg5rjg7zjg5Hjg7w8L3NwYW4+CiAgICA8aDMgY2xhc3M9Imd0LWJhbm5lcl9faGVhZGxpbmUiPgogICAgICDjgZ3jga7pm4boqIjjgIHjgb7jgaDmiYvkvZzmpa3jgafmtojogJfjgZfjgabjgYTjgb7jgZvjgpPjgYvvvJ88YnI+CiAgICAgIOaciOasoeOBruaui+alreOCkua4m+OCieOBmUV4Y2Vs6Zai5pWwMzTpgbgKICAgIDwvaDM+CiAgICA8cCBjbGFzcz0iZ3QtYmFubmVyX19zdWIiPgogICAgICDnqoHlkIjjg7vpm4boqIjjg7vnq6\/mlbDlh6bnkIbjga7jgIzjgoHjgpPjganjgYbjgarkvZzmpa3jgI3jgpLjgIHplqLmlbDjgafoh6rli5XljJbjgILntYznkIbjga7nj77loLTjgafmnKzlvZPjgavkvb\/jgYYzNOmWouaVsOOCkuOAgeani+aWh+OBqOS9v+OBhOOBqeOBk+OCjeS7mOOBjeOBp+ino+iqrOOBl+OBvuOBmeOAggogICAgPC9wPgogICAgPGRpdiBjbGFzcz0iZ3QtYmFubmVyX19mb290ZXIiPgogICAgICA8YSBjbGFzcz0iZ3QtYmFubmVyX19jdGEgY29sdW1uX3RvX2V4Y2VsMzRfYSIgaHJlZj0iaHR0cHM6Ly9jb3JwLmdlbmlhbHRlY2guaW8vamEvd2hpdGVwYXBlci9leGNlbC1mdW5jdGlvbnMvIiB0YXJnZXQ9Il9ibGFuayIgcmVsPSJub29wZW5lciI+CiAgICAgICAg54Sh5paZ44Gn44OA44Km44Oz44Ot44O844OJ44GZ44KLIOKWtgogICAgICA8L2E+CiAgICA8L2Rpdj4KICA8L2Rpdj4KICA8ZGl2IGNsYXNzPSJndC1iYW5uZXJfX3RodW1iIj4KICAgIDxhIGNsYXNzPSJjb2x1bW5fdG9fZXhjZWwzNF9hIiBocmVmPSJodHRwczovL2NvcnAuZ2VuaWFsdGVjaC5pby9qYS93aGl0ZXBhcGVyL2V4Y2VsLWZ1bmN0aW9ucy8iIHRhcmdldD0iX2JsYW5rIiByZWw9Im5vb3BlbmVyIj4KICAgICAgPGltZyBkZWNvZGluZz0iYXN5bmMiIHNyYz0iaHR0cHM6Ly9jb3JwLmdlbmlhbHRlY2guaW8vd3AtY29udGVudC91cGxvYWRzL3NpdGVzLzIvMjAyNS8xMS9FeGNlbOmWouaVsC5wbmciIGFsdD0i57WM55CG5ouF5b2T6ICF44GM55+l44Gj44Gm44GK44GN44Gf44GERXhjZWzplqLmlbAzNOmBuCI+CiAgICA8L2E+CiAgPC9kaXY+CjwvZGl2Pgo8L2Rpdj4KCg==\">\n<\/div>\n<div class=\"ai-rotate-option\" data-index=\"2\" data-name=\"Qg==\" data-code=\"CjxkaXYgZGF0YS1wb3N0LWlkPSIxMzUwMSIgY2xhc3M9Imluc2VydC1wYWdlIGluc2VydC1wYWdlLTEzNTAxICI+CjxzdHlsZT4KICAuZ2UtYmFubmVyLXdyYXAgewogICAgbWF4LXdpZHRoOiAxMjAwcHg7CiAgICBtYXJnaW46IDAgYXV0bzsKICAgIGZvbnQtZmFtaWx5OiAiSGlyYWdpbm8gS2FrdSBHb3RoaWMgUHJvTiIsICJZdSBHb3RoaWMiLCAiTm90byBTYW5zIEpQIiwgc2Fucy1zZXJpZjsKICAgIGNvbG9yOiAjMEYyNDNFOwogIH0KICAuZ2UtYmFubmVyIHsKICAgIGRpc3BsYXk6IGJsb2NrOwogICAgYmFja2dyb3VuZDogI2ZmZmZmZjsKICAgIGJvcmRlcjogMnB4IHNvbGlkICMxRDgxOEI7CiAgICBib3JkZXItcmFkaXVzOiAyMHB4OwogICAgcGFkZGluZzogMjhweDsKICAgIGJveC1zaXppbmc6IGJvcmRlci1ib3g7CiAgfQogIC5nZS1iYW5uZXItaW5uZXIgewogICAgZGlzcGxheTogZmxleDsKICAgIGFsaWduLWl0ZW1zOiBzdHJldGNoOwogICAgZ2FwOiAyNHB4OwogIH0KICAvKiDlt6bvvJozNOmWouaVsOODnOODg+OCr+OCuSAqLwogIC5nZS1udW0tYm94IHsKICAgIGZsZXg6IDAgMCAxOTBweDsKICAgIGJhY2tncm91bmQ6ICMxRDgxOEI7CiAgICBib3JkZXItcmFkaXVzOiAxNHB4OwogICAgY29sb3I6ICNmZmZmZmY7CiAgICBwYWRkaW5nOiAyNHB4IDE2cHg7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGFsaWduLWl0ZW1zOiBjZW50ZXI7CiAgICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICAgIHRleHQtYWxpZ246IGNlbnRlcjsKICB9CiAgLmdlLW51bS1ib3ggLmdlLW51bS1sYWJlbCB7CiAgICBmb250LXNpemU6IDE0cHg7CiAgICBmb250LXdlaWdodDogNzAwOwogICAgbGV0dGVyLXNwYWNpbmc6IDAuMDJlbTsKICAgIG1hcmdpbi1ib3R0b206IDRweDsKICB9CiAgLmdlLW51bS1ib3ggLmdlLW51bS1tYWluIHsKICAgIGZvbnQtc2l6ZTogNTZweDsKICAgIGZvbnQtd2VpZ2h0OiA4MDA7CiAgICBsaW5lLWhlaWdodDogMTsKICAgIG1hcmdpbjogNHB4IDA7CiAgfQogIC5nZS1udW0tYm94IC5nZS1udW0tbWFpbiBzcGFuIHsKICAgIGZvbnQtc2l6ZTogMjBweDsKICAgIGZvbnQtd2VpZ2h0OiA3MDA7CiAgICBtYXJnaW4tbGVmdDogNHB4OwogIH0KICAuZ2UtbnVtLWJveCAuZ2UtbnVtLWJyZWFrZG93biB7CiAgICBmb250LXNpemU6IDEycHg7CiAgICBvcGFjaXR5OiAwLjk7CiAgICBtYXJnaW4tdG9wOiA4cHg7CiAgfQogIC8qIOS4reWkru+8muODhuOCreOCueODiOOBqENUQSAqLwogIC5nZS1tYWluIHsKICAgIGZsZXg6IDEgMSBhdXRvOwogICAgZGlzcGxheTogZmxleDsKICAgIGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47CiAgICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICAgIG1pbi13aWR0aDogMDsKICB9CiAgLmdlLWV5ZWJyb3cgewogICAgZm9udC1zaXplOiAxM3B4OwogICAgZm9udC13ZWlnaHQ6IDcwMDsKICAgIG1hcmdpbi1ib3R0b206IDhweDsKICAgIGNvbG9yOiAjMUQ4MThCOwogIH0KICAuZ2UtZXllYnJvdyAuZ2UtZGl2aWRlciB7CiAgICBtYXJnaW46IDAgNnB4OwogICAgY29sb3I6ICMxRDgxOEI7CiAgfQogIC5nZS1oZWFkbGluZSB7CiAgICBmb250LXNpemU6IDI2cHg7CiAgICBmb250LXdlaWdodDogODAwOwogICAgbGluZS1oZWlnaHQ6IDEuNDsKICAgIG1hcmdpbjogMCAwIDE0cHg7CiAgfQogIC5nZS1jaGVja2xpc3QgewogICAgbGlzdC1zdHlsZTogbm9uZTsKICAgIG1hcmdpbjogMCAwIDIwcHg7CiAgICBwYWRkaW5nOiAwOwogICAgZm9udC1zaXplOiAxNXB4OwogICAgbGluZS1oZWlnaHQ6IDEuNzsKICB9CiAgLmdlLWNoZWNrbGlzdCBsaSB7CiAgICBwb3NpdGlvbjogcmVsYXRpdmU7CiAgICBwYWRkaW5nLWxlZnQ6IDIycHg7CiAgfQogIC5nZS1jaGVja2xpc3QgbGk6OmJlZm9yZSB7CiAgICBjb250ZW50OiAi4pyTIjsKICAgIHBvc2l0aW9uOiBhYnNvbHV0ZTsKICAgIGxlZnQ6IDA7CiAgICB0b3A6IDA7CiAgICBjb2xvcjogIzFEODE4QjsKICAgIGZvbnQtd2VpZ2h0OiA4MDA7CiAgfQogIC5nZS1jaGVja2xpc3QgYiB7CiAgICBmb250LXdlaWdodDogNzAwOwogIH0KICAuZ2UtY3RhIHsKICAgIGRpc3BsYXk6IGlubGluZS1mbGV4OwogICAgYWxpZ24taXRlbXM6IGNlbnRlcjsKICAgIGp1c3RpZnktY29udGVudDogY2VudGVyOwogICAgZ2FwOiA4cHg7CiAgICBiYWNrZ3JvdW5kOiAjRkZFOTI5OwogICAgY29sb3I6ICMwRjI0M0U7CiAgICB0ZXh0LWRlY29yYXRpb246IG5vbmU7CiAgICBmb250LXdlaWdodDogNzAwOwogICAgZm9udC1zaXplOiAxNnB4OwogICAgcGFkZGluZzogMTRweCAyOHB4OwogICAgYm9yZGVyLXJhZGl1czogOHB4OwogICAgd2lkdGg6IGZpdC1jb250ZW50OwogICAgdHJhbnNpdGlvbjogZmlsdGVyIDAuMnMgZWFzZTsKICB9CiAgLmdlLWN0YTpob3ZlciB7CiAgICBmaWx0ZXI6IGJyaWdodG5lc3MoMC45Nik7CiAgfQogIC8qIOWPs++8muOCueODqeOCpOODieeUu+WDjyAqLwogIC5nZS12aXN1YWwgewogICAgZmxleDogMCAwIDM0MHB4OwogICAgZGlzcGxheTogZmxleDsKICAgIGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47CiAgICBhbGlnbi1pdGVtczogY2VudGVyOwogICAganVzdGlmeS1jb250ZW50OiBjZW50ZXI7CiAgfQogIC5nZS12aXN1YWwgYSB7CiAgICBkaXNwbGF5OiBibG9jazsKICAgIHdpZHRoOiAxMDAlOwogICAgdHJhbnNpdGlvbjogb3BhY2l0eSAwLjJzIGVhc2U7CiAgfQogIC5nZS12aXN1YWwgYTpob3ZlciB7CiAgICBvcGFjaXR5OiAwLjg1OwogIH0KICAuZ2UtdmlzdWFsIGltZyB7CiAgICB3aWR0aDogMTAwJTsKICAgIGhlaWdodDogYXV0bzsKICAgIGJvcmRlci1yYWRpdXM6IDEwcHg7CiAgICBib3JkZXI6IDFweCBzb2xpZCAjZGJlN2U4OwogICAgZGlzcGxheTogYmxvY2s7CiAgfQogIC5nZS12aXN1YWwtY2FwdGlvbiB7CiAgICBmb250LXNpemU6IDEycHg7CiAgICBjb2xvcjogIzRhNWE2MzsKICAgIG1hcmdpbi10b3A6IDhweDsKICAgIHRleHQtYWxpZ246IGNlbnRlcjsKICB9CgogIC8qIOODrOOCueODneODs+OCt+ODlu+8iOOCv+ODluODrOODg+ODiO+8iSAqLwogIEBtZWRpYSAobWF4LXdpZHRoOiA4MDBweCkgewogICAgLmdlLWJhbm5lci1pbm5lciB7CiAgICAgIGZsZXgtd3JhcDogd3JhcDsKICAgIH0KICAgIC5nZS1udW0tYm94IHsKICAgICAgZmxleDogMCAwIGF1dG87CiAgICAgIHdpZHRoOiAxMDAlOwogICAgICBmbGV4LWRpcmVjdGlvbjogcm93OwogICAgICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICAgICAgZ2FwOiAxMnB4OwogICAgICBwYWRkaW5nOiAxNnB4OwogICAgfQogICAgLmdlLW51bS1ib3ggLmdlLW51bS1icmVha2Rvd24geyBtYXJnaW4tdG9wOiAwOyB9CiAgICAuZ2UtdmlzdWFsIHsKICAgICAgZmxleDogMSAxIDEwMCU7CiAgICAgIG9yZGVyOiAzOwogICAgfQogICAgLmdlLXZpc3VhbCBpbWcgeyBtYXgtd2lkdGg6IDMyMHB4OyB9CiAgfQoKICAvKiDjg6zjgrnjg53jg7Pjgrfjg5bvvIjjgrnjg57jg5vvvIkgKi8KICBAbWVkaWEgKG1heC13aWR0aDogNDgwcHgpIHsKICAgIC5nZS1iYW5uZXIgeyBwYWRkaW5nOiAxOHB4OyBib3JkZXItcmFkaXVzOiAxNnB4OyB9CiAgICAuZ2UtbnVtLWJveCB7IGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47IH0KICAgIC5nZS1oZWFkbGluZSB7IGZvbnQtc2l6ZTogMjFweDsgfQogICAgLmdlLWN0YSB7IHdpZHRoOiAxMDAlOyBmb250LXNpemU6IDE1cHg7IHBhZGRpbmc6IDE0cHggMThweDsgfQogIH0KPC9zdHlsZT4KCjxkaXYgY2xhc3M9ImdlLWJhbm5lci13cmFwIj4KICA8ZGl2IGNsYXNzPSJnZS1iYW5uZXIiPgogICAgPGRpdiBjbGFzcz0iZ2UtYmFubmVyLWlubmVyIj4KCiAgICAgIDwhLS0g5bem77yaMzTplqLmlbDjg5zjg4Pjgq\/jgrkgLS0+CiAgICAgIDxkaXYgY2xhc3M9ImdlLW51bS1ib3giPgogICAgICAgIDxkaXYgY2xhc3M9ImdlLW51bS1sYWJlbCI+57WM55CG44Gu44Gf44KB44GuPC9kaXY+CiAgICAgICAgPGRpdiBjbGFzcz0iZ2UtbnVtLW1haW4iPjM0PHNwYW4+6Zai5pWwPC9zcGFuPjwvZGl2PgogICAgICAgIDxkaXYgY2xhc3M9ImdlLW51bS1icmVha2Rvd24iPuWInee0mjEx77yP5Lit57SaMTLvvI\/kuIrntJoxMTwvZGl2PgogICAgICA8L2Rpdj4KCiAgICAgIDwhLS0g5Lit5aSu77ya5pys5paH77yLQ1RBIC0tPgogICAgICA8ZGl2IGNsYXNzPSJnZS1tYWluIj4KICAgICAgICA8cCBjbGFzcz0iZ2UtZXllYnJvdyI+CiAgICAgICAgICDjg5vjg6\/jgqTjg4jjg5rjg7zjg5Hjg7w8c3BhbiBjbGFzcz0iZ2UtZGl2aWRlciI+772cPC9zcGFuPjxzcGFuIGNsYXNzPSJnZS1obCI+57WM55CG44GuRXhjZWzlrp\/ot7XjgqzjgqTjg4nvvIjnhKHmlpnvvIk8L3NwYW4+CiAgICAgICAgPC9wPgogICAgICAgIDxwIGNsYXNzPSJnZS1oZWFkbGluZSI+57WM55CG44Gn5L2\/44GGRXhjZWzplqLmlbDjgpLjgIHlvrnlupXop6PoqqzjgII8L3A+CiAgICAgICAgPHVsIGNsYXNzPSJnZS1jaGVja2xpc3QiPgogICAgICAgICAgPGxpPuWInee0mu+8mjxiPlNVTe+8j1JPVU5E77yPVE9EQVk8L2I+44Gn5pel5qyh6ZuG6KiI44KS6auY6YCf5YyWPC9saT4KICAgICAgICAgIDxsaT7kuK3ntJrvvJo8Yj5TVU1JRlPvvI9YTE9PS1VQPC9iPuOBp+eqgeWQiOODu+eFp+WQiOOCkuiHquWLleWMljwvbGk+CiAgICAgICAgICA8bGk+5LiK57Sa77yaPGI+VU5JUVVF77yPUkVHRVjns7s8L2I+44Gu5pyA5paw6Zai5pWw44G+44Gn57+S5b6XPC9saT4KICAgICAgICA8L3VsPgogICAgICAgIDxhIGNsYXNzPSJnZS1jdGEgY29sdW1uX3RvX2V4Y2VsMzRfYiIgaHJlZj0iaHR0cHM6Ly9jb3JwLmdlbmlhbHRlY2guaW8vamEvd2hpdGVwYXBlci9leGNlbC1mdW5jdGlvbnMvIiB0YXJnZXQ9Il9ibGFuayIgcmVsPSJub29wZW5lciI+6LOH5paZ44KS44OA44Km44Oz44Ot44O844OJ77yI54Sh5paZ77yJIOKWtjwvYT4KICAgICAgPC9kaXY+CgogICAgICA8IS0tIOWPs++8muOCueODqeOCpOODieeUu+WDjyAtLT4KICAgICAgPGRpdiBjbGFzcz0iZ2UtdmlzdWFsIj4KICAgICAgICA8YSBjbGFzcz0iY29sdW1uX3RvX2V4Y2VsMzRfYiIgaHJlZj0iaHR0cHM6Ly9jb3JwLmdlbmlhbHRlY2guaW8vamEvd2hpdGVwYXBlci9leGNlbC1mdW5jdGlvbnMvIiB0YXJnZXQ9Il9ibGFuayIgcmVsPSJub29wZW5lciI+CiAgICAgICAgICA8aW1nIGRlY29kaW5nPSJhc3luYyIgc3JjPSJodHRwczovL2NvcnAuZ2VuaWFsdGVjaC5pby93cC1jb250ZW50L3VwbG9hZHMvc2l0ZXMvMi8yMDI1LzExL0V4Y2Vs6Zai5pWwLTEuanBnIiBhbHQ9IklG6Zai5pWw44O7SUZFUlJPUumWouaVsOOBruino+iqrOOCueODqeOCpOODie+8iOani+aWh+OBqOS9v+eUqOS+i++8iSI+CiAgICAgICAgPC9hPgogICAgICAgIDxkaXYgY2xhc3M9ImdlLXZpc3VhbC1jYXB0aW9uIj7mp4vmlofvvIvkvb\/nlKjkvovjgaTjgY08L2Rpdj4KICAgICAgPC9kaXY+CgogICAgPC9kaXY+CiAgPC9kaXY+CjwvZGl2Pgo8L2Rpdj4=\">\n<\/div>\n<\/div>\n<script>if (typeof ai_js_code == 'boolean') {var ai_block_div = document.querySelector ('.ai-rotate-4-97154630'); ai_process_rotation (ai_block_div); ai_block_div.classList.remove ('ai-rotate-4-97154630');};<\/script>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Excel\u3067\u696d\u52d9\u3092\u3057\u3066\u3044\u308b\u3068\u3001\u300c#DIV\/0!\u300d\u3084\u300c#N\/A\u300d\u306a\u3069\u306e\u30a8\u30e9\u30fc\u8868\u793a\u306b\u51fa\u304f\u308f\u3059\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002\u6700\u521d\u306f\u300c\u306a\u306b\u3053\u308c\uff1f\u300d\u3068\u6238\u60d1\u3046\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u3001\u3053\u308c\u306f\u6570\u5f0f\u306b\u4f55\u3089\u304b\u306e\u554f\u984c\u304c\u3042\u308b\u3068\u3044\u3046\u30b5\u30a4\u30f3\u3067\u3059\u3002\u305f\u3068\u3048\u3070\u30010\u3067\u5272\u3063\u3066\u3057\u307e\u3063\u305f\u308a\u3001\u6307\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u304c\u898b\u3064\u304b\u3089\u306a\u304b\u3063\u305f\u308a\u3059\u308b\u3068\u3001\u3053\u3046\u3057\u305f\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<br \/>\n\u3053\u3046\u3057\u305f\u30a8\u30e9\u30fc\u306f\u3001\u898b\u305f\u76ee\u304c\u308f\u304b\u308a\u3065\u3089\u304f\u3001\u5370\u5237\u7269\u3084\u8cc7\u6599\u63d0\u51fa\u306e\u969b\u306b\u306f\u4e0d\u81ea\u7136\u306b\u6620\u3063\u3066\u3057\u307e\u3044\u304c\u3061\u3067\u3059\u3002\u7279\u306b\u304a\u5ba2\u69d8\u3084\u4e0a\u53f8\u306b\u898b\u305b\u308b\u8cc7\u6599\u3067\u306f\u3001\u3067\u304d\u308b\u3060\u3051\u907f\u3051\u305f\u3044\u3068\u3053\u308d\u3067\u3059\u3088\u306d\u3002<br \/>\n\u305d\u3093\u306a\u3068\u304d\u306b\u4fbf\u5229\u306a\u306e\u304c IFERROR\u95a2\u6570\u3002\u3053\u306e\u95a2\u6570\u3092\u4f7f\u3048\u3070\u3001\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u3068\u304d\u3060\u3051\u4efb\u610f\u306e\u5024\u3084\u30e1\u30c3\u30bb\u30fc\u30b8\u306b\u7f6e\u304d\u63db\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u3001\u8cc7\u6599\u306e\u898b\u305f\u76ee\u3092\u30b9\u30de\u30fc\u30c8\u306b\u6574\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<br \/>\n\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Excel\u521d\u5fc3\u8005\u306e\u65b9\u3067\u3082\u5b89\u5fc3\u3057\u3066\u4f7f\u3048\u308b\u3088\u3046\u306b\u3001IFERROR\u95a2\u6570\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3068\u5b9f\u7528\u7684\u306a\u6d3b\u7528\u4f8b\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac\u3057\u307e\u3059\u3002\u660e\u65e5\u304b\u3089\u306e\u696d\u52d9\u3067\u3059\u3050\u306b\u5f79\u7acb\u3064\u5185\u5bb9\u3067\u3059\u306e\u3067\u3001\u305c\u3072\u53c2\u8003\u306b\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>","protected":false},"author":4,"featured_media":10480,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","veu_display_promotion_alert":"common","footnotes":""},"categories":[10],"tags":[],"class_list":["post-10478","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-column"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5 - Genial Technology<\/title>\n<meta name=\"description\" content=\"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3092\u521d\u5fc3\u8005\u5411\u3051\u306b\u89e3\u8aac\u3002\u30a8\u30e9\u30fc\u6642\u306e\u8868\u793a\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u6574\u3048\u3001\u696d\u52d9\u52b9\u7387\u3068\u8cc7\u6599\u306e\u54c1\u8cea\u3092\u5411\u4e0a\u3055\u305b\u307e\u3057\u3087\u3046\u3002\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/corp.genialtech.io\/ja\/column\/iferror\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5 - Genial Technology\" \/>\n<meta property=\"og:description\" content=\"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3092\u521d\u5fc3\u8005\u5411\u3051\u306b\u89e3\u8aac\u3002\u30a8\u30e9\u30fc\u6642\u306e\u8868\u793a\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u6574\u3048\u3001\u696d\u52d9\u52b9\u7387\u3068\u8cc7\u6599\u306e\u54c1\u8cea\u3092\u5411\u4e0a\u3055\u305b\u307e\u3057\u3087\u3046\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/corp.genialtech.io\/ja\/column\/iferror\/\" \/>\n<meta property=\"og:site_name\" content=\"Genial Technology\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-23T03:08:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-15T00:42:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"602\" \/>\n\t<meta property=\"og:image:height\" content=\"339\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Mana Kotani\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mana Kotani\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"11\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/column\\\/iferror\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/column\\\/iferror\\\/\"},\"author\":{\"name\":\"Mana Kotani\",\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/#\\\/schema\\\/person\\\/49c2973d5614c3c4cd3b9bae1f01ab4c\"},\"headline\":\"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5\",\"datePublished\":\"2025-05-23T03:08:26+00:00\",\"dateModified\":\"2026-09-15T00:42:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/column\\\/iferror\\\/\"},\"wordCount\":133,\"publisher\":{\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/column\\\/iferror\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/corp.genialtech.io\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/05\\\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9.jpg\",\"articleSection\":[\"Column\"],\"inLanguage\":\"ja\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/column\\\/iferror\\\/\",\"url\":\"https:\\\/\\\/corp.genialtech.io\\\/column\\\/iferror\\\/\",\"name\":\"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5 - Genial Technology\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/column\\\/iferror\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/column\\\/iferror\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/corp.genialtech.io\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/05\\\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9.jpg\",\"datePublished\":\"2025-05-23T03:08:26+00:00\",\"dateModified\":\"2026-09-15T00:42:42+00:00\",\"description\":\"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3092\u521d\u5fc3\u8005\u5411\u3051\u306b\u89e3\u8aac\u3002\u30a8\u30e9\u30fc\u6642\u306e\u8868\u793a\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u6574\u3048\u3001\u696d\u52d9\u52b9\u7387\u3068\u8cc7\u6599\u306e\u54c1\u8cea\u3092\u5411\u4e0a\u3055\u305b\u307e\u3057\u3087\u3046\u3002\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/column\\\/iferror\\\/#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/corp.genialtech.io\\\/column\\\/iferror\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/column\\\/iferror\\\/#primaryimage\",\"url\":\"https:\\\/\\\/corp.genialtech.io\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/05\\\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9.jpg\",\"contentUrl\":\"https:\\\/\\\/corp.genialtech.io\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/05\\\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9.jpg\",\"width\":602,\"height\":339},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/column\\\/iferror\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\\\/\\\/corp.genialtech.io\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/#website\",\"url\":\"https:\\\/\\\/corp.genialtech.io\\\/\",\"name\":\"\u682a\u5f0f\u4f1a\u793e\u30b8\u30fc\u30cb\u30a2\u30eb\u30c6\u30af\u30ce\u30ed\u30b8\u30fc\",\"description\":\"AI\u3067\u3082\u3063\u3068\u5f79\u7acb\u3064\u76e3\u67fb\u3092\u3002\",\"publisher\":{\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/#organization\"},\"alternateName\":\"Genial Technology\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/corp.genialtech.io\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/#organization\",\"name\":\"Genial Technology\",\"url\":\"https:\\\/\\\/corp.genialtech.io\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/corp.genialtech.io\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2021\\\/10\\\/icon.png\",\"contentUrl\":\"https:\\\/\\\/corp.genialtech.io\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2021\\\/10\\\/icon.png\",\"width\":512,\"height\":512,\"caption\":\"Genial Technology\"},\"image\":{\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/corp.genialtech.io\\\/#\\\/schema\\\/person\\\/49c2973d5614c3c4cd3b9bae1f01ab4c\",\"name\":\"Mana Kotani\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7f8685b8249cba781fa21a62439875b0f8e85f1289f2a95ee2c82abd18705aef?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7f8685b8249cba781fa21a62439875b0f8e85f1289f2a95ee2c82abd18705aef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7f8685b8249cba781fa21a62439875b0f8e85f1289f2a95ee2c82abd18705aef?s=96&d=mm&r=g\",\"caption\":\"Mana Kotani\"},\"sameAs\":[\"mana.kotani@genialtech.io\"],\"url\":\"https:\\\/\\\/corp.genialtech.io\\\/ja\\\/author\\\/mana\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5 - Genial Technology","description":"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3092\u521d\u5fc3\u8005\u5411\u3051\u306b\u89e3\u8aac\u3002\u30a8\u30e9\u30fc\u6642\u306e\u8868\u793a\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u6574\u3048\u3001\u696d\u52d9\u52b9\u7387\u3068\u8cc7\u6599\u306e\u54c1\u8cea\u3092\u5411\u4e0a\u3055\u305b\u307e\u3057\u3087\u3046\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/corp.genialtech.io\/ja\/column\/iferror\/","og_locale":"ja_JP","og_type":"article","og_title":"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5 - Genial Technology","og_description":"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3092\u521d\u5fc3\u8005\u5411\u3051\u306b\u89e3\u8aac\u3002\u30a8\u30e9\u30fc\u6642\u306e\u8868\u793a\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u6574\u3048\u3001\u696d\u52d9\u52b9\u7387\u3068\u8cc7\u6599\u306e\u54c1\u8cea\u3092\u5411\u4e0a\u3055\u305b\u307e\u3057\u3087\u3046\u3002","og_url":"https:\/\/corp.genialtech.io\/ja\/column\/iferror\/","og_site_name":"Genial Technology","article_published_time":"2025-05-23T03:08:26+00:00","article_modified_time":"2026-09-15T00:42:42+00:00","og_image":[{"width":602,"height":339,"url":"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9.jpg","type":"image\/jpeg"}],"author":"Mana Kotani","twitter_card":"summary_large_image","twitter_misc":{"\u57f7\u7b46\u8005":"Mana Kotani","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"11\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/corp.genialtech.io\/column\/iferror\/#article","isPartOf":{"@id":"https:\/\/corp.genialtech.io\/column\/iferror\/"},"author":{"name":"Mana Kotani","@id":"https:\/\/corp.genialtech.io\/#\/schema\/person\/49c2973d5614c3c4cd3b9bae1f01ab4c"},"headline":"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5","datePublished":"2025-05-23T03:08:26+00:00","dateModified":"2026-09-15T00:42:42+00:00","mainEntityOfPage":{"@id":"https:\/\/corp.genialtech.io\/column\/iferror\/"},"wordCount":133,"publisher":{"@id":"https:\/\/corp.genialtech.io\/#organization"},"image":{"@id":"https:\/\/corp.genialtech.io\/column\/iferror\/#primaryimage"},"thumbnailUrl":"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9.jpg","articleSection":["Column"],"inLanguage":"ja"},{"@type":"WebPage","@id":"https:\/\/corp.genialtech.io\/column\/iferror\/","url":"https:\/\/corp.genialtech.io\/column\/iferror\/","name":"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5 - Genial Technology","isPartOf":{"@id":"https:\/\/corp.genialtech.io\/#website"},"primaryImageOfPage":{"@id":"https:\/\/corp.genialtech.io\/column\/iferror\/#primaryimage"},"image":{"@id":"https:\/\/corp.genialtech.io\/column\/iferror\/#primaryimage"},"thumbnailUrl":"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9.jpg","datePublished":"2025-05-23T03:08:26+00:00","dateModified":"2026-09-15T00:42:42+00:00","description":"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3092\u521d\u5fc3\u8005\u5411\u3051\u306b\u89e3\u8aac\u3002\u30a8\u30e9\u30fc\u6642\u306e\u8868\u793a\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u6574\u3048\u3001\u696d\u52d9\u52b9\u7387\u3068\u8cc7\u6599\u306e\u54c1\u8cea\u3092\u5411\u4e0a\u3055\u305b\u307e\u3057\u3087\u3046\u3002","breadcrumb":{"@id":"https:\/\/corp.genialtech.io\/column\/iferror\/#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/corp.genialtech.io\/column\/iferror\/"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/corp.genialtech.io\/column\/iferror\/#primaryimage","url":"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9.jpg","contentUrl":"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2025\/05\/IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9.jpg","width":602,"height":339},{"@type":"BreadcrumbList","@id":"https:\/\/corp.genialtech.io\/column\/iferror\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/corp.genialtech.io\/"},{"@type":"ListItem","position":2,"name":"IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\uff1a\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u7c21\u5358\u306b\u3059\u308b\u65b9\u6cd5"}]},{"@type":"WebSite","@id":"https:\/\/corp.genialtech.io\/#website","url":"https:\/\/corp.genialtech.io\/","name":"\u682a\u5f0f\u4f1a\u793e\u30b8\u30fc\u30cb\u30a2\u30eb\u30c6\u30af\u30ce\u30ed\u30b8\u30fc","description":"AI\u3067\u3082\u3063\u3068\u5f79\u7acb\u3064\u76e3\u67fb\u3092\u3002","publisher":{"@id":"https:\/\/corp.genialtech.io\/#organization"},"alternateName":"Genial Technology","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/corp.genialtech.io\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Organization","@id":"https:\/\/corp.genialtech.io\/#organization","name":"\u30b8\u30fc\u30cb\u30a2\u30eb\u30c6\u30af\u30ce\u30ed\u30b8\u30fc","url":"https:\/\/corp.genialtech.io\/","logo":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/corp.genialtech.io\/#\/schema\/logo\/image\/","url":"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2021\/10\/icon.png","contentUrl":"https:\/\/corp.genialtech.io\/wp-content\/uploads\/sites\/2\/2021\/10\/icon.png","width":512,"height":512,"caption":"Genial Technology"},"image":{"@id":"https:\/\/corp.genialtech.io\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/corp.genialtech.io\/#\/schema\/person\/49c2973d5614c3c4cd3b9bae1f01ab4c","name":"Mana Kotani","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/secure.gravatar.com\/avatar\/7f8685b8249cba781fa21a62439875b0f8e85f1289f2a95ee2c82abd18705aef?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7f8685b8249cba781fa21a62439875b0f8e85f1289f2a95ee2c82abd18705aef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7f8685b8249cba781fa21a62439875b0f8e85f1289f2a95ee2c82abd18705aef?s=96&d=mm&r=g","caption":"Mana Kotani"},"sameAs":["mana.kotani@genialtech.io"],"url":"https:\/\/corp.genialtech.io\/ja\/author\/mana\/"}]}},"_links":{"self":[{"href":"https:\/\/corp.genialtech.io\/ja\/wp-json\/wp\/v2\/posts\/10478","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/corp.genialtech.io\/ja\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/corp.genialtech.io\/ja\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/corp.genialtech.io\/ja\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/corp.genialtech.io\/ja\/wp-json\/wp\/v2\/comments?post=10478"}],"version-history":[{"count":14,"href":"https:\/\/corp.genialtech.io\/ja\/wp-json\/wp\/v2\/posts\/10478\/revisions"}],"predecessor-version":[{"id":13623,"href":"https:\/\/corp.genialtech.io\/ja\/wp-json\/wp\/v2\/posts\/10478\/revisions\/13623"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/corp.genialtech.io\/ja\/wp-json\/wp\/v2\/media\/10480"}],"wp:attachment":[{"href":"https:\/\/corp.genialtech.io\/ja\/wp-json\/wp\/v2\/media?parent=10478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/corp.genialtech.io\/ja\/wp-json\/wp\/v2\/categories?post=10478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/corp.genialtech.io\/ja\/wp-json\/wp\/v2\/tags?post=10478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}