{"id":8299,"date":"2024-01-18T10:56:45","date_gmt":"2024-01-18T01:56:45","guid":{"rendered":"https:\/\/www.still.co.jp\/new\/?page_id=8299"},"modified":"2024-02-13T10:48:55","modified_gmt":"2024-02-13T01:48:55","slug":"function","status":"publish","type":"page","link":"https:\/\/www.still.co.jp\/new\/function\/","title":{"rendered":"\u4fee\u5f97\u5fc5\u9808\u306eExcel\u95a2\u6570"},"content":{"rendered":"\n

\u4fee\u5f97\u5fc5\u9808\u306eExcel\u95a2\u6570<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n
\u77e5\u3063\u3066\u304a\u304d\u305f\u3044Excel\u95a2\u6570<\/span><\/strong><\/td>\n<\/tr>\n
\u8ad6\u7406<\/td>\n\uff1d<\/td>\n\uff06<\/td>\nAND<\/td>\nOR<\/td>\nIF<\/td>\n<\/tr>\n
\u30a8\u30e9\u30fc<\/td>\nIFERROR<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n<\/tr>\n
\u6587\u5b57\u5217\u64cd\u4f5c<\/td>\nTEXT<\/td>\nVALUE<\/td>\nMID<\/td>\nSEARCH<\/td>\n\u00a0<\/td>\n<\/tr>\n
\u65e5\u4ed8\/\u6642\u523b<\/td>\nDATE<\/td>\nDATEVALUE<\/td>\nTODAY<\/td>\nNOW<\/td>\n\u00a0<\/td>\n<\/tr>\n
\u6570\u5b57\/\u4e09\u89d2\/\u7d71\u8a08<\/td>\nSUM<\/td>\nSUMIF<\/td>\nCOUNTA<\/td>\nCOUNTIF<\/td>\nSUBTOTAL<\/td>\n<\/tr>\n
SUMIFS<\/td>\nCOUNTIFS<\/td>\n<\/tr>\n
\u691c\u7d22\/\u884c\u5217<\/td>\nINDEX<\/td>\nVLOOKUP<\/td>\nMATCH<\/td>\nADDRESS<\/td>\nINDIRECT<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u25cf\u95a2\u6570\u306e\u7fd2\u5f97\u306b\u3001\u4e0b\u8a18\u306e\u60c5\u5831\u3082\u3054\u5229\u7528\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\u30ab\u30c6\u30b4\u30ea<\/td>\n\u95a2\u6570<\/td>\n\u4f7f\u3044\u65b9<\/td>\n\u60c5\u5831No<\/td>\nDL<\/td>\n<\/tr>\n
\u8ad6\u7406<\/td>\n\uff1d<\/td>\n\u53f3\u8fba\u3068\u5de6\u8fba\u304c\u7b49\u3057\u3044\u3053\u3068\u3092\u8868\u3059\u8a18\u53f7<\/td>\n044<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
\uff06<\/td>\n\u6587\u5b57\u5217\u3092\u7d50\u5408\u3059\u308b<\/td>\n044<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
AND<\/td>\n\u3059\u3079\u3066\u306e\u6761\u4ef6\u304c\u6e80\u305f\u3055\u308c\u3066\u3044\u308b\u304b\u3092\u5224\u5b9a<\/td>\n023<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
OR<\/td>\n\u3044\u305a\u308c\u304b\u306e\u6761\u4ef6\u304c\u6e80\u305f\u3055\u308c\u3066\u3044\u308b\u304b\u3092\u5224\u5b9a<\/td>\n023<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
IF<\/td>\n\u5024\u307e\u305f\u306f\u6570\u5f0f\u304c\u6761\u4ef6\u3092\u6e80\u305f\u3057\u3066\u3044\u308b\u304b\u3069\u3046\u304b\u3092\u5224\u5b9a<\/td>\n033<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
\u30a8\u30e9\u30fc<\/td>\nIFERROR<\/td>\n\u30a8\u30e9\u30fc\u306e\u5834\u5408\u306b\u8fd4\u3059\u5024\u3092\u6307\u5b9a\u3059\u308b<\/td>\n244<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
\u6587\u5b57\u5217\u64cd\u4f5c<\/td>\nTEXT<\/td>\n\u6570\u5024\u306b\u8868\u793a\u5f62\u5f0f\u3092\u9069\u7528\u3057\u305f\u6587\u5b57\u5217\u3092\u8fd4\u3059<\/td>\n059<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
MID<\/td>\n\u6307\u5b9a\u3057\u305f\u4f4d\u7f6e\u304b\u3089\u4f55\u6587\u5b57\u304b\u3092\u53d6\u308a\u51fa\u3059<\/td>\n060<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
SEARCH<\/td>\n\u6587\u5b57\u5217\u306e\u4f4d\u7f6e\u3092\u8abf\u3079\u308b<\/td>\n080<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
\u65e5\u4ed8\/\u6642\u523b<\/td>\nTODAY<\/td>\n\u73fe\u5728\u306e\u65e5\u4ed8\u3092\u6c42\u3081\u308b<\/td>\n022<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
\u6570\u5b57\/\u4e09\u89d2\/\u7d71\u8a08<\/td>\nSUMIF<\/td>\n\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u3066\u6570\u5024\u3092\u5408\u8a08\u3059\u308b<\/td>\n011<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
SUMIFS<\/td>\n\u8907\u6570\u306e\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u3066\u6570\u5024\u3092\u5408\u8a08\u3059\u308b<\/td>\n256<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
COUNTA<\/td>\n\u30c7\u30fc\u30bf\u306e\u500b\u6570\u3092\u6c42\u3081\u308b<\/td>\n176<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
COUNTIF<\/td>\n\u6761\u4ef6\u306b\u4e00\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u306e\u500b\u6570\u3092\u6c42\u3081\u308b<\/td>\n039<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
COUNTIFS<\/td>\n\u8907\u6570\u306e\u6761\u4ef6\u306b\u4e00\u81f4\u3059\u308b\u30c7\u30fc\u30bf\u306e\u500b\u6570\u3092\u6c42\u3081\u308b<\/td>\n427<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
SUBTOTAL<\/td>\n\u3055\u307e\u3056\u307e\u306a\u96c6\u8a08\u5024\u3092\u6c42\u3081\u308b<\/td>\n356<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
\u691c\u7d22\/\u884c\u5217<\/td>\nINDEX<\/td>\n\u884c\u3068\u5217\u3067\u6307\u5b9a\u3057\u305f\u4f4d\u7f6e\u306e\u5024\u3092\u6c42\u3081\u308b<\/td>\n027<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
VLOOKUP<\/td>\n\u7bc4\u56f2\u3092\u7e26\u65b9\u5411\u306b\u691c\u7d22\u3059\u308b<\/td>\n017<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
MATCH<\/td>\n\u691c\u7d22\u5024\u306e\u76f8\u5bfe\u4f4d\u7f6e\u3092\u6c42\u3081\u308b<\/td>\n102<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
ADDRESS<\/td>\n\u884c\u756a\u53f7\u3068\u5217\u756a\u53f7\u304b\u3089\u30bb\u30eb\u53c2\u7167\u306e\u6587\u5b57\u5217\u3092\u6c42\u3081\u308b<\/td>\n178<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
INDIRECT<\/td>\n\u53c2\u7167\u6587\u5b57\u5217\u3092\u3082\u3068\u306b\u30bb\u30eb\u3092\u9593\u63a5\u53c2\u7167\u3059\u308b<\/td>\n057<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9<\/td>\n? (\u7591\u554f\u7b26)<\/span><\/td>\n\u7591\u554f\u7b26\u3068\u540c\u3058\u4f4d\u7f6e\u306b\u3042\u308b\u4efb\u610f\u306e 1 \u6587\u5b57\u304c\u691c\u7d22\u3055\u308c\u307e\u3059\u3002<\/td>\n024<\/a><\/span><\/td>\n\"\"<\/a><\/span><\/td>\n<\/tr>\n
* (\u30a2\u30b9\u30bf\u30ea\u30b9\u30af)<\/span><\/td>\n\u30a2\u30b9\u30bf\u30ea\u30b9\u30af\u3068\u540c\u3058\u4f4d\u7f6e\u306b\u3042\u308b\u4efb\u610f\u306e\u6570\u306e\u6587\u5b57\u304c\u691c\u7d22\u3055\u308c\u307e\u3059\u3002<\/td>\n<\/tr>\n
~ (\u30c1\u30eb\u30c0)<\/span><\/td>\n\u7591\u554f\u7b26\u3001\u30a2\u30b9\u30bf\u30ea\u30b9\u30af\u304c\u691c\u7d22\u3055\u308c\u307e\u3059\u3002<\/td>\n<\/tr>\n<\/tbody>\n<\/table>","protected":false},"excerpt":{"rendered":"\u4fee\u5f97\u5fc5\u9808\u306eExcel\u95a2\u6570 \u77e5\u3063\u3066\u304a\u304d\u305f\u3044Excel\u95a2\u6570 \u8ad6\u7406 \uff1d \uff06 AND OR IF \u30a8\u30e9\u30fc IFERROR \u00a0 \u00a0 \u00a0 \u00a0 \u6587\u5b57\u5217\u64cd\u4f5c TEXT VALUE MID SEARCH \u00a0 \u65e5\u4ed8\/\u6642\u523b...","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/www.still.co.jp\/new\/wp-json\/wp\/v2\/pages\/8299"}],"collection":[{"href":"https:\/\/www.still.co.jp\/new\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.still.co.jp\/new\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.still.co.jp\/new\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.still.co.jp\/new\/wp-json\/wp\/v2\/comments?post=8299"}],"version-history":[{"count":52,"href":"https:\/\/www.still.co.jp\/new\/wp-json\/wp\/v2\/pages\/8299\/revisions"}],"predecessor-version":[{"id":11777,"href":"https:\/\/www.still.co.jp\/new\/wp-json\/wp\/v2\/pages\/8299\/revisions\/11777"}],"wp:attachment":[{"href":"https:\/\/www.still.co.jp\/new\/wp-json\/wp\/v2\/media?parent=8299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}