{"id":16160,"date":"2021-12-10T16:47:07","date_gmt":"2021-12-10T07:47:07","guid":{"rendered":"https:\/\/www.agentgate.jp\/carechan\/change\/?post_type=carekotsu&#038;p=16160"},"modified":"2021-12-10T16:47:07","modified_gmt":"2021-12-10T07:47:07","slug":"iferror%e9%96%a2%e6%95%b0%e3%81%a8%e3%81%af%ef%bc%9f%e6%9b%b8%e5%bc%8f%e3%82%84%e4%bd%bf%e3%81%84%e6%96%b9%e3%80%81%e5%bf%9c%e7%94%a8%e6%96%b9%e6%b3%95%e3%82%92%e4%b8%80%e6%8c%99%e8%a7%a3%e8%aa%ac","status":"publish","type":"carekotsu","link":"https:\/\/www.agentgate.jp\/carechan\/change\/carekotsu\/16160\/","title":{"rendered":"IFERROR\u95a2\u6570\u3068\u306f\uff1f\u66f8\u5f0f\u3084\u4f7f\u3044\u65b9\u3001\u5fdc\u7528\u65b9\u6cd5\u3092\u4e00\u6319\u89e3\u8aac\uff01"},"content":{"rendered":"\n<p>\u30a8\u30af\u30bb\u30eb\u306f\u30aa\u30d5\u30a3\u30b9\u30ef\u30fc\u30af\u3060\u3051\u306b\u7559\u307e\u3089\u305a\u3001\u81ea\u5b85\u3067\u306e\u30d1\u30bd\u30b3\u30f3\u4f5c\u696d\u3084\u5bb6\u8a08\u7c3f\u306a\u3069\u591a\u5c90\u306b\u308f\u305f\u3063\u3066\u5927\u6d3b\u8e8d\u3059\u308b\u4f5c\u696d\u30c4\u30fc\u30eb\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u4f7f\u3044\u65b9\u3092\u30de\u30b9\u30bf\u30fc\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u3001\u3069\u306e\u4f5c\u696d\u306b\u306f\u3069\u306e\u95a2\u6570\u3092\u4f7f\u3048\u3070\u826f\u3044\u306e\u304b\u3092\u9078\u3076\u3053\u3068\u304c\u3067\u304d\u308b\u305f\u3081\u3001\u3088\u308a\u52b9\u7387\u3088\u304f\u4f5c\u696d\u3092\u9032\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4eca\u56de\u306f\u30a8\u30af\u30bb\u30eb\u95a2\u6570\u306e\u4e2d\u3067\u3082\u7279\u306b\u30e1\u30b8\u30e3\u30fc\u306a\u3010IFERROR\u95a2\u6570\u3011\u306b\u3064\u3044\u3066\u89e3\u8aac\u3002<\/p>\n\n\n\n<p>IFERROR\u95a2\u6570\u306e\u610f\u5473\u3084\u5fdc\u7528\u65b9\u6cd5\u3092\u753b\u50cf\u3068\u3042\u308f\u305b\u3066\u8aac\u660e\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u4e00\u7dd2\u306b\u3084\u3063\u3066\u307f\u308b\u3053\u3068\u3067\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5b9f\u969b\u306b\u3084\u3063\u3066\u307f\u308b\u3053\u3068\u3067\u3088\u308a\u65e9\u304f\u899a\u3048\u3089\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u304b\u3089\u3001\u30a8\u30af\u30bb\u30eb\u3092\u30de\u30b9\u30bf\u30fc\u3057\u305f\u3044\u65b9\u3084\u3001\u3082\u3063\u3068\u7c21\u5358\u306b\u65e9\u304f\u4f5c\u696d\u3092\u7d42\u308f\u3089\u305b\u305f\u3044\u65b9\u306f\u3001\u305c\u3072\u3053\u306e\u8a18\u4e8b\u3092\u304d\u3063\u304b\u3051\u306b\u30a8\u30af\u30bb\u30eb\u306e\u4f7f\u3044\u65b9\u3092\u899a\u3048\u3066\u304f\u3060\u3055\u3044\u306d\u3002<\/p>\n\n\n\n<h2>IFERROR\u95a2\u6570\u3068\u306f\uff1f<\/h2>\n\n\n\n<p>IFERROR\u95a2\u6570\u3068\u306f\u300c\u5024\u300d\u3067\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u3084\u6570\u5f0f\u306e\u7d50\u679c\u304c\u3001\u30a8\u30e9\u30fc\u3068\u306a\u3063\u305f\u5834\u5408\u306b\u306f\u300c\u30a8\u30e9\u30fc\u306e\u5834\u5408\u306e\u5024\u3092\u8868\u793a\u300d\u3055\u305b\u3001\u30a8\u30e9\u30fc\u5024\u3067\u306a\u3044\u5834\u5408\u306b\u306f\u6b63\u5e38\u306a\u300c\u5024\u300d\u3092\u8868\u793a\u3055\u305b\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u5bfe\u5fdc\u3059\u308b\u30a8\u30e9\u30fc\u306f\u4ee5\u4e0b\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<ol><li><strong>#N\/A<\/strong><\/li><li><strong>#VALUE!<\/strong><\/li><li><strong>#REF!<\/strong><\/li><li><strong>#DIV\/O!<\/strong><\/li><li><strong>#NUM!<\/strong><\/li><li><strong>#NAME\uff1f<\/strong><\/li><li><strong>#NULL!<\/strong><\/li><\/ol>\n\n\n\n<p>\u307e\u305f\u3001\u300c\u30a8\u30e9\u30fc\u306e\u5834\u5408\u306e\u5024\u300d\u90e8\u5206\u306b\u306f\u3001\u30a8\u30e9\u30fc\u5024\u306e\u4ee3\u308f\u308a\u3068\u3057\u3066<\/p>\n\n\n\n<ul><li><strong>\u6570\u5024<\/strong><\/li><li><strong>\u6570\u5f0f<\/strong><\/li><li><strong>\u7bc4\u56f2\u6307\u5b9a\u3057\u305f\u30bb\u30eb<\/strong><\/li><li><strong>\u6587\u5b57\u5217<\/strong><\/li><\/ul>\n\n\n\n<p>\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002\u307e\u305f\u3001\u6587\u5b57\u5217\u3092\u6307\u5b9a\u3059\u308b\u5834\u5408\u306b\u306f\u3010&#8221;&#8221;\u3011\u3067\u56f2\u3046\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h2>IFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3068\u66f8\u5f0f<\/h2>\n\n\n\n<p>IFERROR\u95a2\u6570\u306e\u66f8\u5f0f\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>=IFERROR(\u5024,\u30a8\u30e9\u30fc\u306e\u5834\u5408\u306e\u5024)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3>IFERROR\u95a2\u6570\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<p>IFERROR\u95a2\u6570\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>IFERROR\u95a2\u6570\u306f\u5f15\u6570\u306e\u610f\u5473\u3055\u3048\u3057\u3063\u304b\u308a\u7406\u89e3\u3067\u304d\u308c\u3070\u8ab0\u3067\u3082\u899a\u3048\u305f\u65e5\u304b\u3089\u5e45\u5e83\u3044\u30b7\u30fc\u30f3\u3067\u4f7f\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3088\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/eEl67qw38FvCnjgmiNvYPjfRP82arPRZ0Z_bT6c1unpvDzYizrNwIWwsiZZhN2xlwaast3ytRZeEziwtVSsnYdQTrO08aOKoq-hjqs64qwjOO6LJF_4tRPgkrvYkjnW-tviLU0iz\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306a\u5e97\u8217\u5168\u4f53\u306e\u524d\u5e74\u5ea6\u3001\u4eca\u5e74\u5ea6\u306e\u58f2\u308a\u4e0a\u3052\u3092\u8868\u793a\u3057\u305f\u30c6\u30fc\u30d6\u30eb\u30c7\u30fc\u30bf\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u524d\u5e74\u6bd4\u306e\u5165\u529b\u304c\u3067\u304d\u3066\u3044\u306a\u3044\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u308b\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305d\u308c\u3067\u306f\u524d\u5e74\u6bd4\u306bIFERROR\u95a2\u6570\u3092\u5165\u529b\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3055\u3063\u305d\u304fE3\u306e\u30bb\u30eb\u304b\u3089\u5165\u529b\u3057\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>E3\u30bb\u30eb\u306b\u5165\u529b\u3059\u308b\u95a2\u6570\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/iRWbZqPv4pjQ1MUM0TffIZ9cDhIp5oHwHLd2Tsvg5isCoV7tr8rvX7ID3c9iiB1nq-xY0Y3hu6N4njj11lTgA-Pz_CKkwrGqCl3I0KahqeD6LvtrcW-TF7pCvG2F2zmKps6TUPgB\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>=IFERROR(C3\/D3,&#8221;&#8221;)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u30a8\u30e9\u30fc\u306e\u3042\u308b\u8868\u793a\u306e\u5834\u5408\u306f\u3010&#8221;&#8221;\u3011\u3067\u6307\u5b9a\u3057\u305f\u3088\u3046\u306b\u3001\u7a7a\u767d\u3067\u77e5\u3089\u305b\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u95a2\u6570\u3092\u5165\u529b\u3057\u7d42\u3048\u305f\u3089\u3010Enter\u3011\u3092\u62bc\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/iUTn1z5RYzul5T3TgzHAbbT6tFQp4mybzGvHeaKOUWFK-WeZdO4pIPHCgb8MG7owjuxF3_o3yM4qMemIwwZpHw8aOJ4lGMTqiz-8KxOlxwFrNH5MDY0rf2Sbzsw57Wt46aS3ENIa\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u6771\u5e97\u306e\u524d\u5e74\u6bd4\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u8868\u793a\u3055\u308c\u305f\u3068\u3044\u3046\u3053\u3068\u306f\u3001\u30a8\u30e9\u30fc\u304c\u306a\u3044\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u3067\u306f\u3001\u95a2\u6570\u3092\u5165\u529b\u3057\u305fE3\u306e\u30bb\u30eb\u306e\u53f3\u4e0b\u89d2\u306b\u30de\u30a6\u30b9\u3092\u3042\u3066\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u7528\u3044\u3066E6\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u3066\u95a2\u6570\u3092\u5165\u529b\u3055\u305b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/71RtBAmbUYEA6yJ1tjGh8GgJtytPDLAwcBGq_3uRRRR4s0iaj_SvFU9F0WkewTJpu_-V1LpUYe8zyvVkOBYgAbXk_2xejXMImHvMYOKMIoMbbTQrX0EJaBnbtYpJS32MZX6rgkQY\" alt=\"\"\/><\/figure>\n\n\n\n<p>E4\u3001E6\u306b\u306f\u897f\u5e97\u3001\u5317\u5e97\u306e\u524d\u5e74\u6bd4\u304c\u305d\u308c\u305e\u308c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u304c\u3001\u5357\u5e97\u306e\u524d\u5e74\u6bd4\u306f\u7a7a\u767d\u3067\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3053\u308c\u306fIFERROR\u95a2\u6570\u306e\u7b2c1\u5f15\u6570\u3067\u3042\u308b\u3010\u5024\u3011\u306b\u7a7a\u767d\u304c\u3042\u308a\u3001\u524d\u5e74\u6bd4\u3092\u6c42\u3081\u3089\u308c\u305a\u306b\u30a8\u30e9\u30fc\u3068\u306a\u308a\u3001\u7a7a\u767d\u3067\u77e5\u3089\u305b\u305f\u3068\u3044\u3046\u610f\u5473\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305f\u3068\u3048\u3070\u7a7a\u767d\u3067\u306f\u306a\u304f\u3001\u3088\u308a\u308f\u304b\u308a\u3084\u3059\u3044\u8a18\u53f7\u306b\u8a2d\u5b9a\u3057\u3066\u3001\u30a8\u30e9\u30fc\u3092\u77e5\u3089\u305b\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/dh23Is-NXQC8zzewCMvOlVGNdzod7ro-ajpJx3NLhWvJDGnVotJb0LPIivDJJcEB2qUcu4VN1AV5hpfUWuRxvlmQ9X8QPwa3m0azYa6VLt8Gh4JM60z2-NEks4dj_VpdTHgv4Y3u\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/07uYEUbqfiYndwtJwP_qb_3z0OEQXoQRrc0K4rIyv5lgazR8OkjtPs0vZVcnLt1JQj7oLqX1GRVAdrcvXe7QXFLW2tu5Eoowa5DQwLa6WaZyHrnH36_WiCGkDOequN6I7RpPBFSb\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/PTyhERRr5ZRVSLjTblnEE8FfhN0QfGGgr3u6xnv9DqRz9FYhXwoegmkttLPiADyBQ9pNLNYwFHq-HuUj2v1MachSKd7P7tXPN5b5mTtg3IOeeIPXyxncqMW4w5lGxQDCj9hX3iGp\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306b\u3001\u3042\u3089\u304b\u3058\u3081\u3010&#8221;&#8221;\u3011\u306e\u9593\u306b\u30a8\u30e9\u30fc\u3067\u3042\u308b\u3053\u3068\u304c\u308f\u304b\u308a\u3084\u3059\u3044\u8a18\u53f7\u3084\u7d75\u6587\u5b57\u306a\u3069\u3092\u7528\u3044\u3066\u304a\u304f\u3053\u3068\u3067\u3001<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/iX8zeteBMBu6NiyC35RAdvkm2_C5uT5bWnfhT6BPG65g396GD6ELLXsdkzj4pSY6n_1VrJVU3ab1jkjA-nQjgavW5_ToVANAufsKFdsAI0OW04OelvGYxaAjX2rZa1lK5JVx8dSt\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/YxDmeCDo_5edtwMNSQo8eS90gFCnNqNEQh-ckQdoyuqm3dgmIIrTO-X5SRSzS9Z03qGa8NtYI0kpoNHGqvqozgNYgs7Lq0EZNwuKeNV7_i9VWG_TRxTfdpNrEe89jvX47KWeW3Dw\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/HU7MFz33R2D22YfiNs5dcpUzbEWqiqBeEoKfqClC97oC6zUaOBTqKc4xtR9vSXiFkH_jVTZ2X2kAIlgZuWW5-3OhfqJtZlJdXMyQdTri-yAqj833g-mG4nhPBwE5buMJTFtumfCT\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u4f7f\u3044\u95a2\u6570\u3092\u81ea\u52d5\u5165\u529b\u3057\u305f\u969b\u306b\u3001\u3088\u308a\u306f\u3063\u304d\u308a\u3068\u30a8\u30e9\u30fc\u304c\u3069\u3053\u306b\u3042\u308b\u306e\u304b\u3092\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4eca\u56de\u306f\u5e97\u8217\u306e\u58f2\u308a\u4e0a\u3052\u306e\u524d\u5e74\u6bd4\u306b\u3064\u3044\u3066\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u304c\u3001\u3069\u3093\u306a\u30b7\u30fc\u30f3\u3067\u3082\u4f7f\u3048\u307e\u3059\u304b\u3089\u3001\u30a8\u30e9\u30fc\u3084\u672a\u8a18\u5165\u306a\u3069\u3092\u77ac\u6642\u306b\u691c\u7d22\u3057\u305f\u3044\u65b9\u306f\u3001IFERROR\u95a2\u6570\u3092\u4f7f\u3063\u3066\u63a2\u3057\u51fa\u3059\u3068\u3001\u52b9\u7387\u3088\u304f\u30b9\u30e0\u30fc\u30ba\u306b\u4fee\u6b63\u30fb\u8ffd\u8a18\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3088\u3002<\/p>\n\n\n\n<h3>\u95a2\u6570\u306e\u633f\u5165\u3092\u4f7f\u3063\u3066IFERROR\u95a2\u6570\u3092\u884c\u3046<\/h3>\n\n\n\n<p>\u30a8\u30af\u30bb\u30eb\u3067\u306f\u624b\u5165\u529b\u3067\u8907\u6570\u306e\u5f15\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u3068\u306f\u5225\u306b\u3001\u3010\u95a2\u6570\u306e\u633f\u5165\u3011\u3068\u3044\u3046\u30c4\u30fc\u30eb\u3092\u7528\u3044\u3066\u95a2\u6570\u3092\u3088\u308a\u308f\u304b\u308a\u3084\u3059\u304f\u7c21\u5358\u306b\u4f5c\u6210\u3057\u5165\u529b\u3059\u308b\u65b9\u6cd5\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30a8\u30af\u30bb\u30eb\u521d\u5fc3\u8005\u3084\u30a8\u30af\u30bb\u30eb\u306e\u95a2\u6570\u3092\u4f7f\u3063\u305f\u3053\u3068\u304c\u306a\u3044\u65b9\u3001\u30d1\u30bd\u30b3\u30f3\u304c\u5bb6\u306b\u3042\u308b\u304b\u3089\u30a8\u30af\u30bb\u30eb\u3092\u4f7f\u3063\u3066\u898b\u3088\u3046\u3068\u601d\u3063\u305f\u65b9\u306a\u3069\u3001\u30a8\u30af\u30bb\u30eb\u306e\u95a2\u6570\u3068\u5f15\u6570\u306e\u610f\u5473\u306b\u8a73\u3057\u304f\u306a\u3044\u65b9\u3067\u3082\u3001\u3069\u3053\u306b\u306a\u306b\u3092\u5165\u529b\u3059\u308b\u3079\u304d\u306a\u306e\u304b\u3092\u8aac\u660e\u3092\u8aad\u307f\u306a\u304c\u3089\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u95a2\u6570\u306e\u633f\u5165\u306f480\u7a2e\u4ee5\u4e0a\u3082\u306e\u95a2\u6570\u306e\u306a\u304b\u304b\u3089\u3001\u3044\u304f\u3064\u304b\u306e\u82f1\u6587\u5b57\u3092\u5165\u529b\u3059\u308b\u3053\u3068\u3067\u3001\u691c\u7d22\u306b\u304b\u3051\u305f\u82f1\u6587\u5b57\u3092\u542b\u3080\u95a2\u6570\u3092\u691c\u7d22\u3057\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u95a2\u6570\u3092\u899a\u3048\u3066\u3044\u305f\u304c\u30b9\u30da\u30eb\u3092\u5fd8\u308c\u3066\u3057\u307e\u3046\u3068\u3044\u3063\u305f\u65b9\u306b\u3082\u975e\u5e38\u306b\u6709\u52b9\u306a\u30c4\u30fc\u30eb\u306a\u306e\u3067\u3001\u305c\u3072\u3053\u306e\u6a5f\u4f1a\u306b\u95a2\u6570\u306e\u633f\u5165\u3067\u306e\u95a2\u6570\u306e\u4f5c\u6210\u65b9\u6cd5\u3092\u5b66\u3093\u3067\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>\u307e\u305a\u306f\u95a2\u6570\u306e\u633f\u5165\u306e\u5834\u6240\u306b\u3064\u3044\u3066\u78ba\u8a8d\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/6oueZf6P1-45QWwQ5llR9YCPDcmbSAj5UhT9BoC5yUPIkLsRSIs_q2tN426I_zvqfCp-eiARThwK9q4OhZIIyRexBrtCZznDfwPFv2iFkJwz9eThSsyFPQH42aQVEpz358FVgBN4\" alt=\"\"\/><\/figure>\n\n\n\n<p>fx\u3068\u66f8\u304b\u308c\u305f\u90e8\u5206\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3053\u3068\u3067\u95a2\u6570\u306e\u633f\u5165\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3067\u306f\u3053\u306e\u90e8\u5206\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/pD5eGyUnuMRTIiQU0FBk680IYmd339lbVSHBDeehls501nNa9wgVjX-c27yTYFX3dmW6Xce83mv6O_6sU9hCJu4mFttjl2TNMdm17fBzO0mM3VDUtianIH1fAd94TprJIyO80pOL\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u95a2\u6570\u306e\u633f\u5165\u3068\u66f8\u304b\u308c\u305f\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u958b\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u4e0a\u8ff0\u3057\u305f\u3088\u3046\u306b\u3001\u3053\u306e\u90e8\u5206\u3067\u95a2\u6570\u306e\u82f1\u6587\u5b57\u3092\u5165\u529b\u3057\u691c\u7d22\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3010\u4f55\u304c\u3057\u305f\u3044\u304b\u3092\u7c21\u5358\u306b\u5165\u529b\u3057\u3066\u3001[\u691c\u7d22\u958b\u59cb]\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3011<\/p>\n\n\n\n<p>\u3068\u66f8\u304b\u308c\u305f\u90e8\u5206\u3092\u524a\u9664\u3057\u3001<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/foh4I9qM9gcmVrClcDOCbUqL0Wn6dCuok1wALZK1gRte1KNgOk8xN_0yDbXyVAiqUmuzMn7jIhCJxYuIAAJHG23sgYL6cB7nh_aDLZ-a1RX3GfwSjMSukhsGg9o7MQwk_Rc6UlNE\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u4eca\u56de\u306fIFERROR\u95a2\u6570\u3092\u4f7f\u7528\u3057\u305f\u3044\u306e\u3067\u3010IF\u3011\u3068\u5165\u529b\u3057\u3010\u691c\u7d22\u958b\u59cb\u3011\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3059\u308b\u3068\u3010IF\u3011\u3092\u542b\u3081\u305f\u95a2\u6570\u304c4\u7a2e\u985e\u30d2\u30c3\u30c8\u3057\u305f\u3053\u3068\u304c\u308f\u304b\u308b\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4e0a\u304b\u30892\u3064\u3081\u306e\u3010IFERROR\u3011\u3092\u9078\u629e\u3057\u305f\u3089\u3010OK\u3011\u3092\u62bc\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/rxn5nEedMDzCCUtuOIA2ODX5O5BmwsCqCvhKJpgeiAnHTGl7M5mom4OtAGq1wV4JU8tmfaUO86fu0AtKDjSiufuUWtBMJCLMX_pV7iJ2c-nPTE4V1VjCuENmZR5VKKIqKez7P5lZ\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3010OK\u3011\u3092\u62bc\u3059\u3068\u95a2\u6570\u306e\u5f15\u6570\u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u304c\u958b\u304d\u3001IFERROR\u95a2\u6570\u306b\u304a\u3051\u308b\u5f15\u6570\u306e\u5165\u529b\u306b\u9032\u307f\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u3053\u3067\u306f\u524d\u5e74\u5ea6\u3068\u4eca\u5e74\u5ea6\u306e2\u7a2e\u985e\u3092\u5024\u3068\u3057\u3066\u4f7f\u7528\u3059\u308b\u305f\u3081\u3001C3\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3001\u307e\u305f\u306f\u624b\u5165\u529b\u3057\u305f\u3089\u3001\u3010\/\u3011\u3092\u5165\u308c\u3066D3\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3001\u307e\u305f\u306f\u624b\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3010\/\u3011\u306f\u6f14\u7b97\u5b50\u306e\u3072\u3068\u3064\u3067\u3010\u30b9\u30e9\u30c3\u30b7\u30e5\u3011\u3068\u8aad\u307f\u3001\u5024\u3092\u5024\u3067\u5272\u308b\u3068\u3044\u3063\u305f\u610f\u5473\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4eca\u56de\u306e\u5834\u5408\u3060\u3068\u3001C3\u306e\u6570\u5024\u3092D3\u306e\u6570\u5024\u3067\u5272\u308b\u3001\u3068\u3044\u3063\u305f\u610f\u5473\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/t0naf9YNUSuFjT3ske_y4Luzfq2RaG2NdOkgBLf-uqBenFvNCU_ZpyPCa9hc4XrRVpp7kSY4js3LdnFyCXPkCWCT-IvJu4t2c8ND35v9s0SiCkzGb-4TaOp3FM5W0tfpgY4W7tbt\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3064\u304e\u306b\u30a8\u30e9\u30fc\u306e\u5834\u5408\u306e\u5024\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u3053\u3067\u306f\u7a7a\u767d\u3067\u30a8\u30e9\u30fc\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u306e\u3067\u3010&#8221;&#8221;\u3011\u3092\u5165\u529b\u3057\u3010OK\u3011\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/rOGdv85MRI0flirMU_dPBf5MXdyq4Wx43myw0yTO2J9Yecx-4tO-unBafiRexxtGJwpG9yw_9TJn51ggdLkLVORJdng1Oh0I6AMlHvcAKQ20Z_UFi__T9UDAuNuHFvyf1Ty7Gued\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u624b\u5165\u529b\u3067\u5165\u529b\u3057\u305f\u3068\u304d\u3068\u540c\u3058\u3088\u3046\u306b\u301089%\u3011\u3068\u3044\u3046\u524d\u5e74\u6bd4\u3068\u5171\u306b\u3001IFERRROR\u95a2\u6570\u304c\u5165\u529b\u3055\u308c\u305f\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30a8\u30e9\u30fc\u306e\u5834\u5408\u306e\u5024\u306e\u90e8\u5206\u3067\u3001<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/BbSeQKwd1ON6NXOA0fnFBLRv3mJKyzlm6dfAXAAD5gIFsb0VCTPzYUP3SocKr5P4dvWoLK748XqXGd4jYIQVjNh0SQVdugtn1w8FVZ4iE2JAVmC-gSe2T2spF7trgKHa9NKDR-wn\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/ft2STxzgbJJrWRxiKRgY2MG8cShKZqo-tw4dZlj2rzUJB6HWbkWB6HEZQcODTw45fkO52b56tULwYis-jM8A19bzqUW6hiFyGjbhHcdrLC8ue1OLwEoPLXy2vGQSs8QQVRAe7m6i\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/lOgiD5uypAAKjzqELD4J-G01fLJp_VwKLSJvH9Hnl3uoPgIuA-y831qS9b9GHlqBOyqQ77JaWdNQ2DEeF2sZRP5Gpg_yw__XxIKZk1QUcsw7Dw8fLmhmQfZI2Nsy8oEsfa2DO09U\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306b\u6587\u5b57\u5217\u3092\u633f\u5165\u3059\u308b\u3060\u3051\u3067\u3082\u3001<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/I5vAzthLekURKsFPOCmZTuUUGMOFH8AO5zOY6B9lCIOuBZS2jfPMOaDjYatqmD4KcWv8cIBLMm502_b3ijsHLv6pzw3gZoJ38mfjcy_DRay7NJKG2Gk0_iFJ5jawlTEZBIEVN5cM\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/rOdy0M26E6S1wo94mmqHQHQhQLxWwyixlWdCsQVp6ITVqoBSAK9_xGnNovU2fzMzIvCYMpUgn5TgsLF_zDNtJdEXY0IlMw_tQLiSK8s0oQH0rqqRY9pPMY1JUulS_fFYgHQlKoEA\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/SouUmDU9dL6uV08v4ZGuTyvILJdYpSAQNNamhjfNQoek-J_zDBPpojjMkLnIcYUTotAtvCU-yk8Z6NgEFg8FyDamHQypBBaHY-GdS-ESyGDM3uhBDP4WLeKyxtlNIykPtAquMiRk\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306b\u95a2\u6570\u3068\u3057\u3066\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u4f7f\u3048\u3070\u3001\u624b\u5165\u529b\u3068\u540c\u69d8\u306b\u3001\u3010\u2605\u3011\u3010\u00d7\u3011\u3010\ud83d\ude11\u3011\u306e\u6587\u5b57\u5217\u3067\u3001\u30a8\u30e9\u30fc\u3092\u77e5\u3089\u305b\u3066\u304f\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u203b\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u969b\u306b\u6587\u5b57\u5217\u3092\u4f7f\u7528\u3059\u308b\u5834\u5408\u306b\u306f\u3010&#8221;&#8221;\u3011\u3067\u533a\u5207\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3057\u304b\u3057\u3001\u95a2\u6570\u306e\u633f\u5165\u3067\u306f\u3001\u6587\u5b57\u5217\u3092\u5165\u529b\u3059\u308b\u3060\u3051\u3067\u81ea\u52d5\u3067\u3010\u201d\u201d\u3011\u3092\u7528\u3044\u3066\u533a\u5207\u3063\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5927\u5909\u4fbf\u5229\u3067\u3042\u308a\u304c\u305f\u3044\u6a5f\u80fd\u306a\u306e\u3067\u3059\u304c\u3001\u6587\u5b57\u5217\u3092\u4f7f\u3046\u5834\u5408\u306f\u3010&#8221;&#8221;\u3011\u3092\u4f7f\u3046\u3053\u3068\u3092\u610f\u8b58\u3057\u3066\u899a\u3048\u306a\u3051\u308c\u3070\u3001\u624b\u5165\u529b\u3067\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u969b\u306b\u3010\u201d\u201d\u3011\u3092\u629c\u3044\u305f\u95a2\u6570\u3092\u4f5c\u6210\u3057\u3001\u30a8\u30e9\u30fc\u3092\u62db\u3044\u3066\u3057\u307e\u3044\u304b\u306d\u307e\u305b\u3093\u304b\u3089\u3001\u65e5\u9803\u304b\u3089\u3010&#8221;&#8221;\u3011\u306e\u4f7f\u7528\u306f\u610f\u8b58\u3059\u308b\u306e\u304c\u304a\u3059\u3059\u3081\u3067\u3059\u3002<\/p>\n\n\n\n<h3>IFERROR\u95a2\u6570\u3092\u4f7f\u3063\u3066\u30a8\u30e9\u30fc\u306e\u5834\u5408\u306e\u5024\u30920\u3092\u7528\u3044\u3066\u8fd4\u3059\u65b9\u6cd5<\/h3>\n\n\n\n<p>\u3067\u306f\u5b9f\u969b\u306bIFERROR\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u306b\u3064\u3044\u3066\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/aO-rlY5ZFlpjlAgqsseBU4QKNS8OkFVOGuv9wj4qcKC75YV3lpn5HAf1gd8Gy7PcMg00JQdshKmY6WD6buwV8iiyFPO_2VQPrjAUptDpvfScKigtzV1qQNMsKKTsSiiSsqK8OIUa\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u5e97\u8217\u540d\u3068\u524d\u5e74\u5ea6\u3001\u4eca\u5e74\u5ea6\u304b\u3089\u306e\u524d\u5e74\u6bd4\u304c\u308f\u304b\u308b\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3057\u304b\u3057\u3001E5\u306e\u30bb\u30eb\u304c\u3010#DIV\/0!\u3011\u30a8\u30e9\u30fc\u306b\u306a\u3063\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u308b\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u30a8\u30e9\u30fc\u3092IFERROR\u95a2\u6570\u3092\u4f7f\u3063\u3066\u6539\u5584\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>\u305d\u306e\u969b\u3001E3\u306e\u30bb\u30eb\u306b\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u95a2\u6570\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>=IFERROR(C3\/D3,0)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u3088\u304f\u898b\u308b\u3068\u3001\u3082\u3068\u3082\u3068\u524d\u5e74\u6bd4\u3092\u51fa\u3059\u95a2\u6570\u3010=C3\/D3)\u3011\u3092\u5c11\u3057\u3060\u3051\u52a0\u5de5\u3057\u305f\u72b6\u614b\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u66f8\u5f0f\u306e\u30100\u3011\u306f\u3001\u300c\u30a8\u30e9\u30fc\u306e\u5834\u5408\u306e\u5024\u300d\u306b\u8868\u793a\u3055\u305b\u308b\u305f\u3081\u306b0\u3092\u5165\u529b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30100)\u3011\u307e\u3067\u5165\u529b\u3057\u305f\u3089\u3010Enter\u3011\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/oob34mwwn8wsSBfKBkw9Ruo9RpuWX-ghoGtTD0p_MnA7Y0Qu8V4W45zgJWa-aFNirtMASxWiOpv4cs4BFgpR3GRlpKXaRGHnzeuS9ymIqXIG2JAQHv6AvjHc_VcBsgx6RFBIB6Kl\" alt=\"\"\/><\/figure>\n\n\n\n<p>E3\u306e\u30bb\u30eb\u306bIFERROR\u95a2\u6570\u3092\u4f7f\u3063\u3066\u6c42\u3081\u305f\u7b54\u3048\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3064\u3065\u3044\u3066IFERROR\u95a2\u6570\u304c\u5165\u3063\u305fE3\u306e\u30bb\u30eb\u3092\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u4f7f\u3063\u3066E6\u306e\u30bb\u30eb\u307e\u3067\u5f15\u3063\u5f35\u308a\u30b3\u30d4\u30fc\u3055\u305b\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/Za-SR4r2fnq-ccACcZhTB2qQbRovqNJP1u9KO13tS5ElmUtYhwZESokOx0Z9uGHtvTloE5C93t6fIucQr6tPETTzbFJ2OKRSm56WcVihkJjP6HyW4ixLIgqlvFmI_gb8c6nBnvpL\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u30a8\u30e9\u30fc\u3068\u306a\u3063\u3066\u3044\u305fE5\u306e\u30bb\u30eb\u304c\u8a2d\u5b9a\u3057\u305f\u30100\u3011\u3068\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306b\u3001\u30a8\u30e9\u30fc\u3068\u3057\u3066\u8868\u793a\u3055\u308c\u308b\u5834\u5408\u306e\u7b54\u3048\u3092\u3001\u3042\u3089\u304b\u3058\u3081\u8a2d\u5b9a\u3057\u305f\u6570\u5024\u3092\u4f7f\u3063\u3066\u8868\u793a\u3055\u305b\u308b\u65b9\u6cd5\u304cIFERROR\u95a2\u6570\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3>IFERROR\u95a2\u6570\u3092\u4f7f\u3063\u3066\u30a8\u30e9\u30fc\u306e\u5024\u3092\u7a7a\u767d\u3092\u7528\u3044\u3066\u8fd4\u3059\u65b9\u6cd5<\/h3>\n\n\n\n<p>\u3055\u304d\u307b\u3069\u306f\u30100\u3011\u3092\u7528\u3044\u3066\u8868\u793a\u3055\u305b\u307e\u3057\u305f\u304c\u3001\u7a7a\u767d\u3092\u7528\u3044\u3066\u8fd4\u3059\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/NjF04ZImgMSYxvL_Hb2_hF68poEesfDPLf4eJ8S1JwCt6CRySRdGxlQeQ4v2wL2NTqtmW2w76_YJ5zfU0pU3xVPWFFaKvPOmneJZyyWNbQ8cOvYAmk0wkMcas6bdXO3QGH-6jVAS\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u4eca\u56de\u3082\u3053\u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u3066\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u7a7a\u767d\u3067\u8fd4\u3059\u5834\u5408\u306bE3\u30bb\u30eb\u5185\u306b\u8a18\u5165\u3059\u308b\u66f8\u5f0f\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>=IFERROR(C3\/D3,&#8221;&#8221;)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/AiRPCI8_0lEncoCrLW9us2FCffiBtFKTIzplPZ3lzBYYLjlfXhteeUHAQi1BShjVmtVZBGrfCqom0jaEVBNFlqtFYxBgnbu9r2V9_XSH3bG9IZK3lvejIptS6EeB491VKvXM5hV8\" alt=\"\"\/><\/figure>\n\n\n\n<p>E3\u306e\u30bb\u30eb\u306b\u3001\u30a8\u30e9\u30fc\u306e\u5834\u5408\u306e\u5024\u3092\u7a7a\u767d\u306b\u3059\u308b\u66f8\u5f0f\u304c\u5165\u308c\u7d42\u308f\u308a\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3053\u308c\u3092\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u4f7f\u3063\u3066E6\u30bb\u30eb\u307e\u3067\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/CXi5IJr7_qpof3JRpHqSkg4ezwMek1zlIrhxk1IwTvJpT5M3k1a5ECJ-sNcTgjke6B6c9GsvXCUqb4YFw5_qCg4h3w1Wm_YsFPtvV5iK-FtlpWsqjjupgywrHryh9DJNJG87fFlq\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u30a8\u30e9\u30fc\u304c\u51fa\u3066\u3044\u305fE5\u306e\u30bb\u30eb\u304c\u7a7a\u767d\u3067\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>IFERROR\u95a2\u6570\u306f\u4e3b\u306b\u3001\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u3066\u898b\u306b\u304f\u304f\u306a\u3063\u3066\u3057\u307e\u3046\u3053\u3068\u3092\u9632\u304e\u305f\u3044\u5834\u5408\u3084\u3001\u30a8\u30e9\u30fc\u304c\u51fa\u3066\u3057\u307e\u3046\u53ef\u80fd\u6027\u3092\u4e88\u60f3\u3057\u3066\u3001\u3042\u3089\u304b\u3058\u3081\u7a7a\u767d\u306a\u3069\u3092\u4f7f\u3063\u3066\u8868\u793a\u3055\u305b\u308b\u3088\u3046\u8a2d\u5b9a\u3057\u305f\u3044\u5834\u5408\u306b\u4f7f\u3046\u306e\u304c\u30de\u30b9\u30c8\u3068\u8a00\u3048\u307e\u3059\u3002<\/p>\n\n\n\n<h2>IFERROR\u95a2\u6570\u3092\u7528\u3044\u305f\u5fdc\u7528\u65b9\u6cd5<\/h2>\n\n\n\n<p>IFERROR\u95a2\u6570\u306f\u30a8\u30e9\u30fc\u306e\u5834\u5408\u306e\u5024\u3092\u3042\u3089\u304b\u3058\u3081\u8a2d\u5b9a\u3059\u308b\u3060\u3051\u3067\u306a\u304f\u3001\u8907\u6570\u306e\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3055\u307e\u3056\u307e\u306a\u30ef\u30fc\u30af\u30b7\u30fc\u30f3\u306b\u6d3b\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3>VLOOKUP\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u308b<\/h3>\n\n\n\n<p>IFERROR\u95a2\u6570\u3068VLOOKUP\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u5225\u3005\u306e\u30b7\u30fc\u30c8\u306e\u30c7\u30fc\u30bf\u3092\u7528\u3044\u30661\u3064\u306e\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305f\u3068\u3048\u3070\u3001A\u306b\u306f\u5546\u54c1\u306e\u30b3\u30fc\u30c9\u3084\u5546\u54c1\u540d\u3001\u4fa1\u683c\u3084\u5728\u5eab\u6570\u304c\u8a18\u8f09\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u304c\u3001B\u306b\u306f\u8acb\u6c42\u66f8\u304c\u3042\u308b\u3068\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u8acb\u6c42\u66f8\u306b\u306f\u3001\u3072\u3068\u3064\u305a\u3064\u5546\u54c1\u30b3\u30fc\u30c9\u3084\u5546\u54c1\u540d\u3001\u4fa1\u683c\u306a\u3069\u3092\u5165\u529b\u3057\u306a\u3051\u308c\u3070\u306a\u308a\u307e\u305b\u3093\u304c\u3001\u305d\u308c\u3092\u6bce\u56de\u8acb\u6c42\u306e\u305f\u3073\u306b\u884c\u3046\u306e\u306f\u5927\u5909\u3067\u3059\u3088\u306d\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306a\u5834\u5408\u306b\u3001IFERROR\u95a2\u6570\u3068VLOOKUP\u95a2\u6570\u3092\u7528\u3044\u308a\u3001\u3055\u3089\u306b\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3067\u30c9\u30e9\u30c3\u30b0\u3059\u308c\u3070\u3001\u8acb\u6c42\u66f8\u7b49\u306e\u91cd\u8981\u66f8\u985e\u3092\u52b9\u7387\u3088\u304f\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3088\u3002<\/p>\n\n\n\n<p>\u5b9f\u969b\u306b\u3069\u306e\u3088\u3046\u306a\u4f5c\u6210\u5de5\u7a0b\u3067\u3042\u308b\u306e\u304b\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/4LJ4E6VOph911HJzNo8FDWlVpwZ4N1N4iI_BxtqCGXjz9svMGe1UbBwwtsMS9i0KnoxZDc0SU_FSYikD7d-Ob78YY-Bkm6tAeRNr1NX-qWcmz2KB9Fq5kboW-b6-YA8Lnjfviguz\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/GgiwREPLbCDUVCavjK-tGUHvceoZUdWWv40JzOlXDyNw7lvGoLaz9yp3rCTMimdrmwKykxDFpxTNKp6ouFUOWV4kBQfO8gLaf_xg__pYgnwXeuXR_Mrj5NuugIx8xChWa09xaIs2\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306b\u3001\u5225\u3005\u306e\u30b7\u30fc\u30c8\u306b\u30c7\u30fc\u30bf\u304c\u4f5c\u6210\u3055\u308c\u3066\u3044\u308b\u3068\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u8acb\u6c42\u66f8\u5185\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u306f\u3042\u3089\u304b\u3058\u3081\u66f8\u304b\u308c\u3066\u3044\u3066\u3001\u305d\u306e\u6a2a\u306e\u5546\u54c1\u540d\u3084\u4fa1\u683c\u306a\u3069\u3092IFERROR\u95a2\u6570\u3068VLOOKUP\u95a2\u6570\u3092\u7528\u3044\u3066\u305d\u308c\u305e\u308c\u8868\u793a\u3055\u305b\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/FQqQhjMqNMwYWW7H0jdNkDOHDpzKtL0oQH9dSOf-JEiNxLRQTfd5dpr5IBAy23DW5pVOtcThoTNCG8lkJ8MiYIY68SEq2jfm_nu96PlAgNoq80inElrWdpPNaf5jIJQKqRfISh8W\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u307e\u305a\u306fNo1\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u30101001-001\u3011\u306e\u5546\u54c1\u540d\u3092\u8fd4\u3057\u305f\u3044\u306e\u3067\u3001C3\u306e\u30bb\u30eb\u5185\u306b\u3053\u306e\u3088\u3046\u306a\u66f8\u5f0f\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>=IFERROR(VLOOKUP(B3,\u5546\u54c1\u30ea\u30b9\u30c8!$B$3:$D$6,2,FALSE),&#8221;&#8221;)<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u305d\u308c\u305e\u308c\u306e\u610f\u5473\u3092\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>B3<\/strong><\/td><td>\u5546\u54c1\u30ea\u30b9\u30c8\u5185\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u3068\u4e00\u81f4\u3059\u308b\u5024\u304c\u8a18\u5165\u3055\u308c\u305f\u30bb\u30eb\u3092\u6307\u5b9a<\/td><\/tr><tr><td><strong>\u5546\u54c1\u30ea\u30b9\u30c8!<\/strong><\/td><td>\u5546\u54c1\u30ea\u30b9\u30c8\u3092\u9078\u629e\u3059\u308b\u3068\u81ea\u52d5\u3067\u5165\u529b\u3055\u308c\u308b(\u3010!\u3011\u307e\u3067\u81ea\u52d5\u5165\u529b\u3055\u308c\u308b)<\/td><\/tr><tr><td><strong>$B$3:$D$6<\/strong><\/td><td>\u5546\u54c1\u30ea\u30b9\u30c8\u5185\u306eB3~D6\u306e\u30bb\u30eb\u3092\u7bc4\u56f2\u6307\u5b9a\u3057\u3010F4\u3011\u30ad\u30fc\u3092\u62bc\u3057\u3066\u7d76\u5bfe\u53c2\u7167\u306b\u8a2d\u5b9a\u3057\u305f\u3082\u306e\u3002\u7d76\u5bfe\u53c2\u7167\u306b\u3059\u308b\u3053\u3068\u3067\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u4f7f\u3063\u3066\u3082\u9078\u629e\u7bc4\u56f2\u304c\u305a\u308c\u308b\u3053\u3068\u306a\u304f\u53c2\u7167\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308b\u3002<\/td><\/tr><tr><td><strong>2,FALSE),&#8221;&#8221;)<\/strong><\/td><td>2\u306fB3\u3068\u4e00\u81f4\u3059\u308b\u884c\u304c\u5546\u54c1\u30ea\u30b9\u30c8\u5185\u306b\u3042\u3063\u305f\u5834\u5408\u306f\u30012\u5217\u76ee(\u5546\u54c1\u30ea\u30b9\u30c8\u5185\u306e\u5546\u54c1\u540d\u306e\u306a\u304b)\u304b\u3089\u62bd\u51fa\u3059\u308b\u3088\u3046\u8a2d\u5b9a\u3059\u308b\u305f\u3081\u306e\u3010\u5546\u54c1\u540d=2\u5217\u76ee\u3011\u306e\u30102\u3011\u3002FALSE\u306f\u3010\u5b8c\u5168\u4e00\u81f4\u3011\u306e\u610f\u5473\u3002\u3010&#8221;&#8221;\u3011\u306f\u30a8\u30e9\u30fc\u3060\u3063\u305f\u5834\u5408\u306b\u7a7a\u767d\u3067\u8868\u793a\u3055\u305b\u308b\u610f\u5473\u304c\u3042\u308b\u3002<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u95a2\u6570\u3092\u5165\u529b\u3057\u305f\u3089\u3010Enter\u3011\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/Nc-SkIu3B0yDwadmmhtU95gwiDpg5foeZv9RUD5SbUx1iQaxv_CA_1y1eEhrSeVFh6lVc8ZFVquhDl8oKZEapzqb8leeb7ghhJGhvxrkmx6mFnmmfeApYtua2-aPMtK56WrvSmrc\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3010B3\u3011\u306b\u66f8\u304b\u308c\u305f\u5546\u54c1\u30b3\u30fc\u30c9\u30101001-001\u3011\u3068\u5b8c\u5168\u4e00\u81f4\u3057\u305f\u5546\u54c1\u540d\u3092\u95a2\u6570\u306b\u3088\u3063\u3066\u63a2\u3057\u51fa\u3057\u3001C3\u30bb\u30eb\u306b\u5546\u54c1\u540d\u3092\u8868\u793a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3064\u3065\u3044\u3066\u3053\u306eC3\u30bb\u30eb\u306e\u95a2\u6570\u3092\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u4f7f\u3063\u3066C6\u307e\u3067\u81ea\u52d5\u3067\u5165\u529b\u3055\u305b\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/WmQnNLN28VyzPnD3XmJifwfwq1KmOUDJ_i3cTgDsJ_xSVfaGtH94ob3FMHLWGDn23bnuMXBHvSH3CcG8NmPdxmSMoMPQE0rD3Q7r1pRpKgn4alw8_6kwKiiDYCo9ohxigUamZG90\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u5546\u54c1\u30ea\u30b9\u30c8\u306b\u639b\u304b\u308c\u305f\u5546\u54c1\u540d\u901a\u308a\u306b\u8868\u793a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u540c\u3058\u3088\u3046\u306b\u3001\u4fa1\u683c\u3082\u5165\u529b\u3057\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/p-I8tBd9OJdifvvNiB2aaN4pBLBisVqLFs8i1HotGE4B0QrgwGr50d0fZDnznnBe-WHo47fccc8xrFCbZEuwii5_-LnZYvnUuzG7avy1fcDlklLkMJj9POnBmt0L0qsG0UVkxqKJ\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u4fa1\u683c\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u5834\u5408\u306f\u3001\u95a2\u6570\u306e\u30102\u3011\u3068\u66f8\u3044\u305f\u90e8\u5206\u3092\u30103\u3011\u306b\u5909\u66f4\u3057\u3001\u4fa1\u683c\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u90e8\u5206\u306b\u5165\u529b\u3059\u308b\u3060\u3051\u3067\u5b8c\u6210\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u53c2\u7167\u3057\u305f\u3044\u5217\u306e\u6570\u5024\u3092\u5909\u3048\u308b\u3060\u3051\u3067\u3001<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/tK88WeORiLkyCJYexKZ2tg3jcW03ogGLRVOh97ZgvSsEK-tERjzhZ8MxOPI0iFgzNIJxiO-lwHv8I8orzL-jnDpAZW7Dd2wne4fjkn4bkMT5luf7NopqwxVo9ZlAYEP4SQmfdp1v\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u4fa1\u683c\u3092\u8fd4\u3059\u3053\u3068\u304c\u3067\u304d\u3001\u307e\u305f\u3010F4\u3011\u30ad\u30fc\u3067\u7d76\u5bfe\u53c2\u7167\u306b\u8a2d\u5b9a\u3057\u3066\u3044\u308b\u305f\u3081\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u4f7f\u7528\u3057\u3066\u3082\u3001<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/TVonrhO5b5fVwUwFp4z51VrRgazsCH80Ipko9LskatIs_h0mAovzGDi3O7UULm2bvpPVzyX0zEmh5oHfBQpfaiW-gngSdq_6Dn3auZBcw2212g0l6J9RWQ3ihs_rcIKnLoeRiRVW\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u3059\u3079\u3066\u306e\u5546\u54c1\u306e\u4fa1\u683c\u3092\u95a2\u6570\u3067\u8fd4\u3059\u3053\u3068\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u985e\u4f3c\u73874%\/\u4e00\u81f4\u738739%<\/p>\n\n\n\n<h2>IFERROR\u95a2\u6570\u306b\u304a\u3051\u308b\u4e3b\u306a\u30a8\u30e9\u30fc\u306e\u7406\u7531\u3068\u89e3\u6c7a\u65b9\u6cd5<\/h2>\n\n\n\n<h3>\u30100\u3011\u306b\u306a\u308b\u7406\u7531\u3068\u89e3\u6c7a\u65b9\u6cd5<\/h3>\n\n\n\n<p>\u53c2\u7167\u3057\u305f\u3044\u30bb\u30eb\u306e\u6570\u5024\u304c\u5165\u529b\u3055\u308c\u3066\u304a\u3089\u305a\u3001\u53c2\u7167\u5bfe\u8c61\u304c\u4e0d\u660e\u78ba\u3068\u306a\u308a0\u3068\u8868\u793a\u3055\u308c\u3066\u3057\u307e\u3046\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u5834\u5408\u306f\u53c2\u7167\u3057\u305f\u3044\u30bb\u30eb\u306e\u9805\u76ee\u3092\u3042\u3089\u304b\u3058\u3081\u5165\u529b\u3057\u3066\u304a\u304f\u3053\u3068\u3067\u3001\u305d\u306e\u5bfe\u8c61\u3068\u306a\u308b\u6570\u5024\u3068\u4e00\u81f4\u3059\u308b\u3082\u306e\u3092\u691c\u7d22\u3057\u8fd4\u3059\u3053\u3068\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h2>\u307e\u3068\u3081<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img width=\"2000\" height=\"1333\" src=\"https:\/\/www.agentgate.jp\/carechan\/change\/wp-content\/uploads\/2021\/11\/pixta_66554731_M.jpg\" alt=\"\" class=\"wp-image-15878\"\/><figcaption>\u307e\u3068\u3081\u3068\u30b0\u30e9\u30d5<\/figcaption><\/figure>\n\n\n\n<p>\u30d1\u30bd\u30b3\u30f3\u3067\u4f5c\u696d\u3059\u308b\u65b9\u306a\u3089\u7d76\u5bfe\u306b\u899a\u3048\u3066\u304a\u304d\u305f\u3044\u30a8\u30af\u30bb\u30eb\u3002\u3057\u304b\u3057\u3001\u305f\u304f\u3055\u3093\u306e\u95a2\u6570\u3084\u4f7f\u3044\u65b9\u304c\u3042\u3063\u3066\u899a\u3048\u308b\u3053\u3068\u306b\u305f\u3081\u3089\u3044\u3092\u611f\u3058\u3066\u3057\u307e\u3046\u65b9\u3082\u591a\u3044\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p>\u3057\u304b\u3057\u3001\u95a2\u6570\u3092\u4f7f\u3046\u30b7\u30fc\u30f3\u3055\u3048\u30a4\u30e1\u30fc\u30b8\u3067\u304d\u308c\u3070\u3001\u300c\u3053\u306e\u95a2\u6570\u306f\u3053\u3093\u306a\u4f5c\u696d\u306e\u6642\u306b\u4f7f\u3048\u305d\u3046\uff01\u300d\u3068\u6349\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u305f\u3081\u3001\u3088\u308a\u982d\u306b\u6d78\u900f\u3057\u3084\u3059\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u8a18\u4e8b\u3092\u304d\u3063\u304b\u3051\u306b\u3001\u305c\u3072\u30a8\u30af\u30bb\u30eb\u4e0a\u7d1a\u8005\u3092\u76ee\u6307\u3057\u3066\u304f\u3060\u3055\u3044\u306d\u3002<\/p>\n","protected":false},"featured_media":16012,"template":"","tags":[1539,2098,1974,1888,1986,1817,1794],"acf":[],"_links":{"self":[{"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/carekotsu\/16160"}],"collection":[{"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/carekotsu"}],"about":[{"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/types\/carekotsu"}],"version-history":[{"count":0,"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/carekotsu\/16160\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/media\/16012"}],"wp:attachment":[{"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/media?parent=16160"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.agentgate.jp\/carechan\/change\/wp-json\/wp\/v2\/tags?post=16160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}