{"id":427,"date":"2021-11-15T09:00:00","date_gmt":"2021-11-15T00:00:00","guid":{"rendered":"http:\/\/itoop-blog.yuima-ru-tokyo.com\/?p=427"},"modified":"2022-04-20T01:54:56","modified_gmt":"2022-04-19T16:54:56","slug":"20211115-article","status":"publish","type":"post","link":"https:\/\/itoop-blog.yuima-ru-tokyo.com\/?p=427","title":{"rendered":"Excel\u521d\u5fc3\u8005\u306e\u30a2\u30ca\u30bf\u3082\u3059\u3050\u3067\u304d\u308b\uff01\u4ed5\u4e8b\u52b9\u7387\u30a2\u30c3\u30d7\u5c0f\u62805\u9078\uff01\uff01\u3010\u5f8c\u7de8\u3011"},"content":{"rendered":"\n

\u306f\u3058\u3081\u306b<\/strong><\/p>\n\n\n\n

\u3053\u3093\u306b\u3061\u306f\u3001Itoop\uff08\u30a2\u30a4\u30c6\u30a3\u30fc\u30d7\uff09\u306e\u5e83\u5831\u62c5\u5f53\u306e\u9ed2\u6fa4\u3067\u3059\uff01<\/p>\n\n\n\n

\u524d\u56de\u306b\u5f15\u304d\u7d9a\u304dExcel\u306e\u4ed5\u4e8b\u52b9\u7387\u30a2\u30c3\u30d7\u306e\u5c0f\u6280\u3092\u7d39\u4ecb\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\u2192\u524d\u56de\u8a18\u4e8b\uff1aExcel\u521d\u5fc3\u8005\u306e\u30a2\u30ca\u30bf\u3082\u3059\u3050\u3067\u304d\u308b\uff01\u4ed5\u4e8b\u52b9\u7387\u30a2\u30c3\u30d7\u5c0f\u62805\u9078\uff01\uff01\u3010\u524d\u7de8\u3011<\/a><\/p>\n\n\n\n

\u4eca\u56de\u306f\u3001\u8eab\u306b\u3064\u3051\u3066\u304a\u304f\u3068\u4fbf\u5229\u306a\u3010\u95a2\u6570\u3011\u306b\u3064\u3044\u3066\u3067\u3059\u3002<\/p>\n\n\n\n

\u4ed5\u4e8b\u306e\u30b9\u30d4\u30fc\u30c9\u304c\u30b0\u30f3\u3068\u3042\u304c\u308b\u95a2\u6570\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\uff01<\/p>\n\n\n\n

<\/p>\n\n\n\n

\u2460SUM\u95a2\u6570<\/p>\n\n\n\n

=SUM\uff08\u6570\u50241, \u6570\u50242, …, \u6570\u5024255\uff09<\/strong><\/p>\n\n\n\n

SUM\u95a2\u6570\u306f\u3001\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u306e\u5408\u8a08\u5024\u3092\u7b97\u51fa\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u300cA1:A3\u300d\u306e\u3088\u3046\u306b\u30bb\u30eb\u7bc4\u56f2\u3082\u6307\u5b9a\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n

\u2461ROUND\u95a2\u6570<\/p>\n\n\n\n

=ROUND\uff08\u6570\u5024, \u6841\u6570\uff09<\/strong><\/p>\n\n\n\n

\u6570\u5024\uff1a\u3082\u3068\u306e\u6570\u5024\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u6841\u6570\uff1a\u3069\u306e\u6841\u3092\u56db\u6368\u4e94\u5165\u3059\u308b\u304b<\/p>\n\n\n\n

ROUND\u95a2\u6570\u306f\u3001\u6570\u5024\u3068\u6841\u6570\u3092\u5f15\u6570\u306b\u56db\u6368\u4e94\u5165\u3092\u884c\u3046\u306e\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

(\u985e\u4f3c\u95a2\u6570)<\/p>\n\n\n\n

ROUNDUP\uff1a\u6307\u5b9a\u306e\u6841\u6570\u5207\u308a\u4e0a\u3052<\/p>\n\n\n\n

ROUNDDOWN\u3001TRUNC\uff1a\u6307\u5b9a\u306e\u6841\u6570\u5207\u308a\u6368\u3066\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

\u7528\u9014\u306b\u5fdc\u3058\u3066\u3001\u56db\u6368\u4e94\u5165\u3084\u5207\u308a\u4e0a\u3052\u5207\u308a\u6368\u3066\u3001\u96c6\u8a08\u3057\u305f\u6570\u5024\u3092\u5c0f\u6570\u70b9\u4ed8\u304d\u3067\u96c6\u8a08\u3059\u308b\u3068\u304d\u306a\u3069\u306b\u4f7f\u308f\u308c\u308b\u3053\u3068\u304c\u591a\u3044\u3067\u3059\u3002<\/p>\n\n\n\n

\u4f8b\uff1ahttps:\/\/office-hack.com\/excel\/round\/<\/a> <\/p>\n\n\n\n

\u2462MAX\u95a2\u6570<\/p>\n\n\n\n

\uff1dMAX\uff08\u6570\u50241, \u6570\u50242, …, \u6570\u5024255\uff09<\/strong><\/p>\n\n\n\n

MAX\u95a2\u6570\u306f\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u306e\u6700\u5927\u5024\u3092\u6c42\u3081\u308b\u306e\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

(\u985e\u4f3c\u95a2\u6570)<\/p>\n\n\n\n

MIN\uff1a\u6700\u5c0f\u5024<\/p>\n\n\n\n

MEDIAN\uff1a\u4e2d\u592e\u5024<\/p>\n\n\n\n

\u2463TODAY\u95a2\u6570<\/p>\n\n\n\n

=TODAY()<\/strong><\/p>\n\n\n\n

TODAY\u95a2\u6570\u306f\u30d6\u30c3\u30af\u3092\u958b\u3044\u305f\u5f53\u65e5\u65e5\u4ed8\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

Ctrl+\uff1b\u3067\u5f53\u65e5\u65e5\u4ed8\u3092\u8868\u793a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\u2464ROW\u95a2\u6570\uff0fCOLUMN\u95a2\u6570<\/p>\n\n\n\n

\uff1dROW(),COLUMN()<\/strong><\/p>\n\n\n\n

ROW\u95a2\u6570\uff0fCOLUMN\u95a2\u6570\u306f\u3001\u884c\u6570\uff0f\u5217\u6570\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u4f8b\uff1ahttps:\/\/www.tech-teacher.jp\/blog\/excel-row\/<\/a> <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u7279\u306b\u4f7f\u308f\u308c\u308b\u95a2\u65705\u9078\uff01\uff01<\/strong><\/p>\n\n\n\n

\u3053\u3053\u304b\u3089\u306f\u7279\u306b\u4f7f\u308f\u308c\u308b\u3068\u601d\u308f\u308c\u308b\u95a2\u6570\u30925\u3064\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u2460IF\u95a2\u6570\uff08\u8ad6\u7406\u5f0f, \u771f\u306e\u5834\u5408, \u507d\u306e\u5834\u5408\uff09<\/p>\n\n\n\n

=IF\uff08\u8ad6\u7406\u5f0f, \u771f\u306e\u5834\u5408, \u507d\u306e\u5834\u5408\uff09<\/strong><\/p>\n\n\n\n

IF\u95a2\u6570\u306f\u3001\u3010\u3082\u3057\u6761\u4ef6\u3092\u6e80\u305f\u305b\u3070\u301c(\u6b63\u306e\u5834\u5408)\u3002\u305d\u3046\u3067\u306a\u3051\u308c\u3070\u301c(\u8ca0\u306e\u5834\u5408)\u3011\u3068\u3044\u3046\u95a2\u6570\u3067\u3001\u6761\u4ef6\u3054\u3068\u306b\u51e6\u7406\u3092\u5909\u3048\u305f\u3044\u5834\u5408\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u8ad6\u7406\u5f0f\uff1aTRUE\uff08\u771f\uff09\uff0fFALSE\uff08\u507d\uff09\u3092\u8fd4\u3059\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u771f\u306e\u5834\u5408\uff1a\u8ad6\u7406\u5f0f\u306e\u5024\u304cTRUE\u306e\u5834\u5408\u3001\u884c\u3046\u51e6\u7406\u3002<\/p>\n\n\n\n

\u507d\u306e\u5834\u5408\uff1a\u8ad6\u7406\u5f0f\u306e\u5024\u304cFALSE\u306e\u5834\u5408\u3001\u884c\u3046\u51e6\u7406\u3002<\/p>\n\n\n\n

\u5e74\u9f62\u5225\u306b\u91d1\u984d\u3092\u5909\u3048\u308b\u306a\u3069\u3001\u307b\u304b\u306e\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u304c\u591a\u3044\u3067\u3059\u3002<\/p>\n\n\n\n

\u4f8b\uff1ahttps:\/\/udemy.benesse.co.jp\/business\/office\/excel-if.html<\/a> <\/p>\n\n\n\n

\u2461VLOOKUP\u95a2\u6570<\/p>\n\n\n\n

=VLOOKUP\uff08\u691c\u7d22\u5024, \u7bc4\u56f2, \u5217\u756a\u53f7, \u691c\u7d22\u65b9\u6cd5\uff09<\/strong><\/p>\n\n\n\n

\u691c\u7d22\u5024\uff1a\u691c\u7d22\u3059\u308b\u5024<\/p>\n\n\n\n

\u7bc4\u56f2\uff1a\u691c\u7d22\u3055\u308c\u308b\u30bb\u30eb\u7bc4\u56f2<\/p>\n\n\n\n

\u5217\u756a\u53f7\uff1a\u7bc4\u56f2\u306e\u5148\u982d\u306e\u5217\u304b\u3089\u6570\u3048\u305f\u5217\u6570<\/p>\n\n\n\n

\u691c\u7d22\u65b9\u6cd5\uff1a\u691c\u7d22\u65b9\u6cd5\u3092\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u6570\u5024\u3092\u6307\u5b9a<\/p>\n\n\n\n

\u30001\u2192\uff3b\u691c\u7d22\u5024\uff3d\u4ee5\u4e0b\u306e\u6700\u5927\u5024\u3092\u691c\u7d22<\/p>\n\n\n\n

\u30000\u2192\uff3b\u691c\u7d22\u5024\uff3d\u306b\u4e00\u81f4\u3059\u308b\u5024\u306e\u307f\u3092\u691c\u7d22<\/p>\n\n\n\n

\u4e00\u89a7\u304b\u3089\u3001\u3042\u308b\u691c\u7d22\u5024\u3092\u7bc4\u56f2\u306e\u4e0b\u306b\u5411\u304b\u3063\u3066\u691c\u7d22\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u4f8b\uff1ahttps:\/\/xtrend.nikkei.com\/atcl\/contents\/18\/00069\/00013\/<\/a> <\/p>\n\n\n\n

\u2462COUNTA\u95a2\u6570<\/p>\n\n\n\n

\uff1dCOUNTA\uff08\u50241, \u50242, …, \u5024255\uff09<\/strong><\/p>\n\n\n\n

\u5024\uff1a\u500b\u6570\u3092\u6c42\u3081\u305f\u3044\u5024\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u5f15\u6570\u306f255\u500b\u307e\u3067\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

COUNTA\u95a2\u6570\u306f\u3001\u6587\u5b57\u5217\u3001\u8a08\u7b97\u5f0f\u3001\u7a7a\u767d\u3082\u96c6\u8a08\u5bfe\u8c61\u3068\u3057\u3001\u30ab\u30a6\u30f3\u30c8\u3067\u304d\u308b\u306e\u304c\u7279\u5fb4\u3067\u3059\u3002<\/p>\n\n\n\n

\u4f8b\uff1ahttps:\/\/office-hack.com\/excel\/counta\/<\/a> <\/p>\n\n\n\n

\u2463HYPERLINK\u95a2\u6570\uff08\u30ea\u30f3\u30af\u5148, \u5225\u540d\uff09<\/p>\n\n\n\n

\uff1dHYPERLINK\uff08\u30ea\u30f3\u30af\u5148, \u5225\u540d\uff09<\/strong><\/p>\n\n\n\n

\u30ea\u30f3\u30af\u5148\uff1a\u30ea\u30f3\u30af\u5148\u3092\u8868\u3059\u6587\u5b57\u5217\u3092\u6307\u5b9a<\/p>\n\n\n\n

\u5225\u540d\uff1a\u30bb\u30eb\u306b\u8868\u793a\u3055\u308c\u308b\u6587\u5b57\u5217\u3092\u6307\u5b9a\u3057\u3001\u7701\u7565\u3082\u53ef\u80fd<\/p>\n\n\n\n

\u30ed\u30fc\u30ab\u30eb\u30d5\u30a1\u30a4\u30eb\u306b\u3042\u308b\u30b7\u30fc\u30c8\u3084\u30d6\u30c3\u30af\u306e\u5185\u90e8\u30ea\u30f3\u30af\u3092\u4f5c\u6210\u304c\u3067\u304d\u3001\u5916\u90e8\u3078\u306e\u30ea\u30f3\u30af\u3082\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\u2464CONCATENATE\u95a2\u6570\uff08\u6587\u5b57\u52171, \u6587\u5b57\u52172, …, \u6587\u5b57\u5217255\uff09<\/p>\n\n\n\n

=CONCATENATE\uff08\u6587\u5b57\u52171, \u6587\u5b57\u52172, …, \u6587\u5b57\u5217255\uff09<\/strong><\/p>\n\n\n\n

\u6587\u5b57\u5217\uff1a\u6307\u5b9a\u3057\u305f\u6587\u5b57\u3092\u3059\u3079\u3066\u7d50\u5408<\/p>\n\n\n\n

CONCATENATE\u95a2\u6570\u306f\u3001\u6587\u5b57\u3068\u6587\u5b57\u3092\u7d50\u5408\u3057\u3066\u6587\u5b57\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u6570\u5024\u3084\u6570\u5f0f\u306a\u3069\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u3001\u5f15\u6570\u306f255\u500b\u307e\u3067\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\u307e\u305f\u3001\u3010&”\u5bfe\u8c61\u306e\u6587\u5b57\u5217”&\u3011\u3068\u884c\u3046\u3053\u3068\u3082\u540c\u69d8\u306e\u610f\u5473\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

\u9023\u7d50\u3057\u3066\u6587\u5b57\u3092\u7d50\u5408\u3059\u308b\u6642\u306a\u3069\u306b\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n

\u4f8b\uff1ahttps:\/\/kokodane.com\/kansu_mojiretu_06.htm<\/a> <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u304a\u308f\u308a\u306b<\/strong><\/p>\n\n\n\n

\u306f\u3058\u3081\u306f\u96e3\u3057\u3044\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u3001\u6163\u308c\u308b\u3068\u683c\u6bb5\u306b\u52b9\u7387\u304c\u4e0a\u304c\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

\u7686\u3055\u3093\u3082\u305c\u3072\u8a66\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u306f\u3058\u3081\u306b \u3053\u3093\u306b\u3061\u306f\u3001Itoop\uff08\u30a2\u30a4\u30c6\u30a3\u30fc\u30d7\uff09\u306e\u5e83\u5831\u62c5\u5f53\u306e\u9ed2\u6fa4\u3067\u3059\uff01 \u524d\u56de\u306b\u5f15\u304d\u7d9a\u304dExcel\u306e\u4ed5 \u7d9a\u304d\u3092\u8aad\u3080 →<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[2,15,12],"class_list":["post-427","post","type-post","status-publish","format-standard","hentry","category-public-relation","tag-it-industry","tag-work-style","tag-episode"],"_links":{"self":[{"href":"https:\/\/itoop-blog.yuima-ru-tokyo.com\/index.php?rest_route=\/wp\/v2\/posts\/427","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itoop-blog.yuima-ru-tokyo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itoop-blog.yuima-ru-tokyo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itoop-blog.yuima-ru-tokyo.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/itoop-blog.yuima-ru-tokyo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=427"}],"version-history":[{"count":1,"href":"https:\/\/itoop-blog.yuima-ru-tokyo.com\/index.php?rest_route=\/wp\/v2\/posts\/427\/revisions"}],"predecessor-version":[{"id":1116,"href":"https:\/\/itoop-blog.yuima-ru-tokyo.com\/index.php?rest_route=\/wp\/v2\/posts\/427\/revisions\/1116"}],"wp:attachment":[{"href":"https:\/\/itoop-blog.yuima-ru-tokyo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itoop-blog.yuima-ru-tokyo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itoop-blog.yuima-ru-tokyo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}