{"id":1696,"date":"2017-07-25T20:03:54","date_gmt":"2017-07-25T11:03:54","guid":{"rendered":"https:\/\/pasocollege.com\/book\/?page_id=1696"},"modified":"2026-03-25T17:00:56","modified_gmt":"2026-03-25T08:00:56","slug":"excel_short_func","status":"publish","type":"page","link":"https:\/\/pasocollege.com\/book\/titles\/excel_short_func\/","title":{"rendered":"\u4ed5\u4e8b\u306b\u5f79\u7acb\u3064\u30a8\u30af\u30bb\u30eb\u95a2\u6570\uff5e\u3055\u307e\u3056\u307e\u306a\u95a2\u6570"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"724\" height=\"1024\" src=\"https:\/\/pasocollege.com\/book\/wp-content\/uploads\/2018\/05\/\u4e00\u89a7_e_\u4ed5\u4e8b\u306b\u5f79\u7acb\u3064\u30a8\u30af\u30bb\u30eb\u95a2\u6570\uff5e\u3055\u307e\u3056\u307e\u306a\u95a2\u6570\uff5e-1-724x1024.jpg\" alt=\"\" class=\"wp-image-2304\" style=\"width:389px\" srcset=\"https:\/\/pasocollege.com\/book\/wp-content\/uploads\/2018\/05\/\u4e00\u89a7_e_\u4ed5\u4e8b\u306b\u5f79\u7acb\u3064\u30a8\u30af\u30bb\u30eb\u95a2\u6570\uff5e\u3055\u307e\u3056\u307e\u306a\u95a2\u6570\uff5e-1-724x1024.jpg 724w, https:\/\/pasocollege.com\/book\/wp-content\/uploads\/2018\/05\/\u4e00\u89a7_e_\u4ed5\u4e8b\u306b\u5f79\u7acb\u3064\u30a8\u30af\u30bb\u30eb\u95a2\u6570\uff5e\u3055\u307e\u3056\u307e\u306a\u95a2\u6570\uff5e-1-1086x1536.jpg 1086w, https:\/\/pasocollege.com\/book\/wp-content\/uploads\/2018\/05\/\u4e00\u89a7_e_\u4ed5\u4e8b\u306b\u5f79\u7acb\u3064\u30a8\u30af\u30bb\u30eb\u95a2\u6570\uff5e\u3055\u307e\u3056\u307e\u306a\u95a2\u6570\uff5e-1-1448x2048.jpg 1448w, https:\/\/pasocollege.com\/book\/wp-content\/uploads\/2018\/05\/\u4e00\u89a7_e_\u4ed5\u4e8b\u306b\u5f79\u7acb\u3064\u30a8\u30af\u30bb\u30eb\u95a2\u6570\uff5e\u3055\u307e\u3056\u307e\u306a\u95a2\u6570\uff5e-1-100x141.jpg 100w, https:\/\/pasocollege.com\/book\/wp-content\/uploads\/2018\/05\/\u4e00\u89a7_e_\u4ed5\u4e8b\u306b\u5f79\u7acb\u3064\u30a8\u30af\u30bb\u30eb\u95a2\u6570\uff5e\u3055\u307e\u3056\u307e\u306a\u95a2\u6570\uff5e-1-297x420.jpg 297w, https:\/\/pasocollege.com\/book\/wp-content\/uploads\/2018\/05\/\u4e00\u89a7_e_\u4ed5\u4e8b\u306b\u5f79\u7acb\u3064\u30a8\u30af\u30bb\u30eb\u95a2\u6570\uff5e\u3055\u307e\u3056\u307e\u306a\u95a2\u6570\uff5e-1-768x1086.jpg 768w, https:\/\/pasocollege.com\/book\/wp-content\/uploads\/2018\/05\/\u4e00\u89a7_e_\u4ed5\u4e8b\u306b\u5f79\u7acb\u3064\u30a8\u30af\u30bb\u30eb\u95a2\u6570\uff5e\u3055\u307e\u3056\u307e\u306a\u95a2\u6570\uff5e-1-212x300.jpg 212w, https:\/\/pasocollege.com\/book\/wp-content\/uploads\/2018\/05\/\u4e00\u89a7_e_\u4ed5\u4e8b\u306b\u5f79\u7acb\u3064\u30a8\u30af\u30bb\u30eb\u95a2\u6570\uff5e\u3055\u307e\u3056\u307e\u306a\u95a2\u6570\uff5e-1-600x848.jpg 600w, https:\/\/pasocollege.com\/book\/wp-content\/uploads\/2018\/05\/\u4e00\u89a7_e_\u4ed5\u4e8b\u306b\u5f79\u7acb\u3064\u30a8\u30af\u30bb\u30eb\u95a2\u6570\uff5e\u3055\u307e\u3056\u307e\u306a\u95a2\u6570\uff5e-1.jpg 1654w\" sizes=\"auto, (max-width: 724px) 100vw, 724px\" \/><\/figure>\n\n\n\n<p>\u5b9f\u52d9\u306b\u6d3b\u304b\u305b\u308b\u95a2\u6570\u3092\u4e2d\u5fc3\u306b\u5b66\u3076\u30c6\u30ad\u30b9\u30c8\u3067\u3059\u3002ROUND\u3001\u6587\u5b57\u5217\u64cd\u4f5c\u95a2\u6570\u3001IF\u3001MATCH\u3001INDEX\u3001VLOOKUP\u3001COUNT\u306a\u3069\u3092\u5b66\u7fd2\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"clear:both\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u3054\u8cfc\u5165\u60c5\u5831<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\u63a8\u5968\u5b66\u7fd2\u6642\u9593<\/td><td>4\u6642\u9593<\/td><\/tr><tr><td>\u30da\u30fc\u30b8\u6570<\/td><td>69\u30da\u30fc\u30b8<\/td><\/tr><tr><td>\u4f53\u88c1<\/td><td>A4\u30b5\u30a4\u30ba<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-button vk_button vk_button-color-custom vk_button-b576b3e5-279a-488d-88b4-733bffb4aba0 vk_button-align-left\"><a href=\"https:\/\/pasocollege.com\/efcon\/excel_function.html\" class=\"vk_button_link btn has-background btn-md\" role=\"button\" aria-pressed=\"true\" target=\"_blank\" rel=\"noopener\"><div class=\"vk_button_link_caption\"><span class=\"vk_button_link_txt\">\u3053\u306e\u30c6\u30ad\u30b9\u30c8\u3067\u5b66\u3076\uff08E\u30e9\u30fc\u30cb\u30f3\u30b0\uff09<\/span><i class=\"fa-solid fa-circle-right vk_button_link_after\" aria-hidden=\"true\"><\/i><\/div><\/a><\/div><style type=\"text\/css\">.vk_button-b576b3e5-279a-488d-88b4-733bffb4aba0 .has-background {\n\t\t\t\tbackground-color: #0288d1;\n\t\t\t\tborder: 1px solid #0288d1;\n\t\t\t} <\/style>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u5185\u5bb9<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u95a2\u6570\u3068\u306f<\/li>\n\n\n\n<li>\u6587\u5b57\u5217\u306e\u64cd\u4f5c\uff081\uff09<\/li>\n\n\n\n<li>\u6587\u5b57\u5217\u306e\u64cd\u4f5c(2)<\/li>\n\n\n\n<li>\u540d\u524d\u306e\u5b9a\u7fa9<\/li>\n\n\n\n<li>\u6570\u3092\u8abf\u3079\u308b<\/li>\n\n\n\n<li>\u7d76\u5bfe\u53c2\u7167\u306e\u5fdc\u7528<\/li>\n\n\n\n<li>\u56db\u6368\u4e94\u5165\u3001\u5207\u308a\u4e0a\u3052\u3001\u5207\u308a\u6368\u3066<\/li>\n\n\n\n<li>\u6761\u4ef6\u306b\u3088\u3063\u3066\u7d50\u679c\u3092\u5909\u3048\u308b\u95a2\u6570<\/li>\n\n\n\n<li>\u691c\u7d22\u30fb\u884c\u5217\u95a2\u6570<\/li>\n\n\n\n<li>\u95a2\u6570\u306e\u30cd\u30b9\u30c8<\/li>\n<\/ol>\n\n\n","protected":false},"excerpt":{"rendered":"<p>\u4ed5\u4e8b\u3067\u5229\u7528\u3055\u308c\u308b\u3053\u3068\u306e\u591a\u3044\u95a2\u6570\u3092\u5e45\u5e83\u304f\u5b66\u7fd2\u3067\u304d\u307e\u3059\u3002<br \/>\n\u7df4\u7fd2\u554f\u984c\u304c\u3064\u3044\u3066\u3044\u308b\u306e\u3067\u3001\u7406\u89e3\u304c\u6df1\u307e\u308a\u307e\u3059\u3002\u5e45\u5e83\u304fExcel\u306e\u95a2\u6570\u3092\u5b66\u7fd2\u3057\u305f\u3044\u65b9\u306b\u6700\u9069\u3067\u3059\u3002\u4f01\u696d\u7814\u4fee\u306b\u3082\u63a1\u7528\u3055\u308c\u3066\u3044\u308b\u30b3\u30fc\u30b9\u3067\u3059\u3002<\/p>\n","protected":false},"author":6,"featured_media":2817,"parent":1514,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"vkexunit_cta_each_option":"","footnotes":""},"categories":[115,26,91,99,71,32,94,89,95,98,88,49,37,93,90,97,92],"tags":[],"class_list":["post-1696","page","type-page","status-publish","has-post-thumbnail","hentry","category-elearning","category-excel","category-consultant","category-text","category-marketing","category-office_job","category-hr","category-planning","category-medical","category-sales-office","category-sales","category-licentiate","category-practical","category-accounting","category-sales2","category-trade-office","category-finance"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/1696","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/comments?post=1696"}],"version-history":[{"count":14,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/1696\/revisions"}],"predecessor-version":[{"id":5645,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/1696\/revisions\/5645"}],"up":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/1514"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/media\/2817"}],"wp:attachment":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/media?parent=1696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/categories?post=1696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/tags?post=1696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}