{"id":414,"date":"2019-08-28T15:08:04","date_gmt":"2019-08-28T06:08:04","guid":{"rendered":"https:\/\/elelog.net\/?p=414"},"modified":"2020-07-31T10:41:26","modified_gmt":"2020-07-31T01:41:26","slug":"%e3%80%90excel%e3%80%91%e3%82%a8%e3%82%af%e3%82%bb%e3%83%ab%e3%81%a7%e3%81%ae%e8%a4%87%e7%b4%a0%e6%95%b0%e8%a8%88%e7%ae%97%e6%b3%95%e3%81%a8%e5%a4%a7%e3%81%8d%e3%81%95%e3%81%a8%e4%bd%8d%e7%9b%b8","status":"publish","type":"post","link":"https:\/\/elelog.net\/?p=414","title":{"rendered":"\u3010Excel\u3011\u30a8\u30af\u30bb\u30eb\u3067\u306e\u8907\u7d20\u6570\u8a08\u7b97\u6cd5\u3068\u5927\u304d\u3055\u30fb\u4f4d\u76f8\u3092\u51fa\u3057\u30dc\u30fc\u30c9\u7dda\u56f3\u3092\u63cf\u304f\u65b9\u6cd5\u307e\u3068\u3081"},"content":{"rendered":"<h2>\u305d\u3082\u305d\u3082\u30dc\u30fc\u30c9\u7dda\u56f3\u3063\u3066\u4f55\uff1f\u30a8\u30af\u30bb\u30eb\u3067\u8907\u7d20\u6570\u8a08\u7b97\u3092\u3069\u3046\u884c\u3046\uff1f<\/h2>\n<p>\u6e29\u5ea6\u3092\u4e00\u5b9a\u306b\u4fdd\u3061\u305f\u3044\uff01\u306a\u3069\uff0c\u4f55\u3089\u304b\u306e\u5236\u5fa1\u5bfe\u8c61\u306b\u5bfe\u3057\u3066\u5236\u5fa1\u3092\u884c\u3046\u5236\u5fa1\u5de5\u5b66\u3068\u3044\u3046\u5b66\u554f\u306b\u304a\u3044\u3066\uff0c\u305d\u306e\u5236\u5fa1\u7cfb\u304c\u5b89\u5b9a\u3067\u3042\u308b\u304b\uff1f\u3092\u898b\u308b\u4e00\u3064\u306e\u65b9\u6cd5\u3068\u3057\u3066\u30dc\u30fc\u30c9\u7dda\u56f3\u3068\u3044\u3046\u3082\u306e\u304c\u3042\u308a\u307e\u3059\uff0e<\/p>\n<p>\u30dc\u30fc\u30c9\u7dda\u56f3\u306f\u5468\u6ce2\u6570\u30fc\u4f4d\u76f8\u7279\u6027\u3068\u5468\u6ce2\u6570\u30fc\u5229\u5f97\uff08\u5927\u304d\u3055\uff09\u306e\uff12\u3064\u306e\u30b0\u30e9\u30d5\u3092\u30bb\u30c3\u30c8\u3067\u30dc\u30fc\u30c9\u7dda\u56f3\u3068\u8a00\u3044\u307e\u3059\uff0e\u30dc\u30fc\u30c9\u7dda\u56f3\u3092\u63cf\u304f\u305f\u3081\u306e\u5143\u306e\u30b0\u30e9\u30d5\u306e\u95a2\u6570\uff08\u4f1d\u9054\u95a2\u6570\uff09\u306f\u8907\u7d20\u6570\u3067\u3042\u308a\uff0c\u305d\u306e\u8907\u7d20\u6570\u3092\u5b9f\u90e8\u3068\u865a\u90e8\u306b\u5206\u3051\uff0c\u5927\u304d\u3055\u3068\u504f\u89d2(\u4f4d\u76f8)\u3092\u5468\u6ce2\u6570\u3092\u5909\u6570\u3068\u3057\u3066\u5909\u5316\u3055\u305b\u3066\u30d7\u30ed\u30c3\u30c8\u3059\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\uff0e<\/p>\n<p>\u3057\u304b\u3057\uff0c\u30a8\u30af\u30bb\u30eb\u306b\u8907\u7d20\u6570\u3092\u76f4\u63a5\u5165\u529b\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\uff0e\u4f8b\u3048\u3070\uff0c1+i\u3068\u30bb\u30eb\u306b\u5165\u529b\u3059\u308b\u3068\u6570\u5024\u30c7\u30fc\u30bf\u3067\u306f\u306a\u304f\u6587\u5b57\u30c7\u30fc\u30bf\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u308b\u305f\u3081\u306b\u901a\u5e38\u306e\u3088\u3046\u306b\u8a08\u7b97\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u305b\u3093\uff0e<\/p>\n<p>\u3053\u306e\u8a18\u4e8b\u3067\u306f\uff0c\u30a8\u30af\u30bb\u30eb\u3067\u8907\u7d20\u6570\u3092\u64cd\u308b\u65b9\u6cd5\u3068\u30dc\u30fc\u30c9\u7dda\u56f3\u306e\u66f8\u304d\u65b9\u3092\u8aac\u660e\u3057\u307e\u3059\uff0e<\/p>\n<h2>\u8907\u7d20\u6570\u306e\u8868\u73fe\u65b9\u6cd5\u3068\u56db\u5247\u6f14\u7b97<\/h2>\n<p><strong>\u8907\u7d20\u6570\u8a08\u7b97\u3067\u306f\u901a\u5e38\u306e\u8a08\u7b97\u306e\u3088\u3046\u306b*\/+-\u306f\u4f7f\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u305b\u3093\uff0e\u30bb\u30eb\u306b\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u8907\u7d20\u6570\u30c7\u30fc\u30bf\u306f\u6587\u5b57\u30c7\u30fc\u30bf\u3068\u3057\u3066\u30a8\u30af\u30bb\u30eb\u304c\u8a8d\u8b58\u3057\u3066\u3044\u308b\u304b\u3089\u3067\u3059\uff0e\u3053\u308c\u3092\u56db\u5247\u6f14\u7b97\u3059\u308b\u306b\u306f\u4ee5\u4e0b\u306e\u95a2\u6570\u3092\u7528\u3044\u307e\u3059\uff0e<\/strong><\/p>\n<p><strong>\u4ee5\u4e0b\uff0c\u8907\u7d20\u6570\u3068\u8a18\u8f09\u304c\u3042\u308b\u90e8\u5206\u306b\u304a\u3044\u3066\u8907\u7d20\u6570\u3092\u5165\u529b\u3059\u308b\u969b\"1+i\"\u306e\u3088\u3046\u306b\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u3067\u304f\u304f\u3063\u3066\u5165\u529b\u3057\u307e\u3059\uff0e\u8907\u7d20\u6570\u30c7\u30fc\u30bf\u306e\u3042\u308b\u30bb\u30eb\u3092\u5165\u529b\u3059\u308b\u5834\u5408\u305d\u306e\u307e\u307eB35\u306e\u3088\u3046\u306b\u5165\u529b\u3057\u307e\u3059\uff0e<\/strong><\/p>\n<ul>\n<li><strong>\u30a8\u30af\u30bb\u30eb\u4e0a\u3067\u306e\u8907\u7d20\u6570\u306e\u8868\u73fe<\/strong><\/li>\n<\/ul>\n<p><strong>\u95a2\u6570\uff1a=COMPLEX(\u5b9f\u90e8,\u865a\u90e8,\"j\")<\/strong><br \/>\n[\u5165\u529b\u4f8b]=COMPLEX(3,4,\"j\")\u2192[\u8868\u793a\u4f8b]3+4j<\/p>\n<p>\"j\"\u306e\u9805\u306b\"i\"\u304b\"j\"\u3092\u5165\u529b\u3059\u308b\u3053\u3068\u3067\u865a\u90e8\u306ej\u304bi\u3092\u9078\u629e\uff0e\u5165\u529b\u3057\u306a\u3044\u5834\u5408i\u306b\u306a\u308b\uff0e<\/p>\n<ul>\n<li><strong>\u8907\u7d20\u6570\u306e\u548c\u3092\u8a08\u7b97<\/strong><\/li>\n<\/ul>\n<p><strong>\u95a2\u6570\uff1a=IMSUM(\u8907\u7d20\u65701,\u8907\u7d20\u65702,\u8907\u7d20\u65703,....)\u2192<\/strong>(\u8907\u7d20\u65701)+(\u8907\u7d20\u65702)+(\u8907\u7d20\u65703)<br \/>\n[\u5165\u529b\u4f8b]=IMSUM(\"1+i\",B45,D12)\u2192[\u8868\u793a\u4f8b]4+3j<\/p>\n<p>\u8907\u7d20\u6570\u3092\u76f4\u63a5\u5165\u529b\u3059\u308b\u5834\u5408\u306f\"\u00a0 \"\u3067\u304f\u308b\u308b\uff0eB45\u3084D12\u306e\u3088\u3046\u306b\u8907\u7d20\u6570\u30c7\u30fc\u30bf\u306e\u3042\u308b\u30bb\u30eb\u3092\u6307\u5b9a\u3082\u3067\u304d\u308b\uff0e<\/p>\n<ul>\n<li><strong>\u8907\u7d20\u6570\u306e\u5dee\u3092\u8a08\u7b97<\/strong><\/li>\n<\/ul>\n<p><strong>\u95a2\u6570\uff1a=IMSUB(\u8907\u7d20\u65701,\u8907\u7d20\u65702)<\/strong>\u2192(\u8907\u7d20\u65701)-(\u8907\u7d20\u65702)<br \/>\n[\u5165\u529b\u4f8b]=IMSUB(\"5+3j\",\"2+j\")\u2192[\u8868\u793a\u4f8b]3+2j<\/p>\n<ul>\n<li><strong>\u8907\u7d20\u6570\u306e\u7a4d\u3092\u8a08\u7b97<\/strong><\/li>\n<\/ul>\n<p><strong>\u95a2\u6570\uff1aIMPRODUCT(\u8907\u7d20\u65701,\u8907\u7d20\u65702)<\/strong>\u2192(\u8907\u7d20\u65701)*(\u8907\u7d20\u65702)<br \/>\n[\u5165\u529b\u4f8b]=IMPRODUCT(\"5+3j\",\"1+2j\")\u2192[\u8868\u793a\u4f8b]-1+13j<\/p>\n<ul>\n<li><strong>\u8907\u7d20\u6570\u306e\u5546\u3092\u8a08\u7b97<\/strong><\/li>\n<\/ul>\n<p><strong>\u95a2\u6570\uff1a=IMDIV(\u8907\u7d20\u65701\uff0c\u8907\u7d20\u65702)<\/strong>\u2192(\u8907\u7d20\u65701)\/(\u8907\u7d20\u65702)<br \/>\n[\u5165\u529b\u4f8b]=IMDIV(\"5+2i\",\"1+i\")\u2192[\u8868\u793a\u4f8b]3.5-1.5i<\/p>\n<ul>\n<li><strong>\u8907\u7d20\u6570\u306e\u3079\u304d\u4e57\u3092\u8a08\u7b97<\/strong><\/li>\n<\/ul>\n<p><strong>\u95a2\u6570\uff1a=IMPOWER(\u8907\u7d20\u6570\uff0c\u6570\u5024)\u2192<\/strong>(\u8907\u7d20\u6570)^(\u6570\u5024)<br \/>\n[\u5165\u529b\u4f8b]=IMPOWER(\"1+j\",3)\u2192[\u8868\u793a\u4f8b]-2+2j<\/p>\n<ul>\n<li><strong>\u8907\u7d20\u6570\u306e\u5e73\u65b9\u6839\u3092\u8a08\u7b97<\/strong><\/li>\n<\/ul>\n<p><strong>\u95a2\u6570\uff1aIMSQRT(\u8907\u7d20\u6570)<\/strong>\u2192\u221a(\u8907\u7d20\u6570)<br \/>\n[\u5165\u529b\u4f8b]=IMSQRT(\"3+4j\")\u2192[\u8868\u793a\u4f8b]2+j<\/p>\n<h2>\u8907\u7d20\u6570\u306e\u5927\u304d\u3055\u3068\u4f4d\u76f8\u3092\u6c42\u3081\u308b<\/h2>\n<p><strong>\u8907\u7d20\u6570\u306e\u8a08\u7b97\u304c\u5b8c\u4e86\u3057(X+Yj)\u306e\u5f62\u306b\u306a\u3063\u305f\u3089\uff0c\u305d\u306e\u8907\u7d20\u6570\u306e\u5927\u304d\u3055\u3068\u4f4d\u76f8\u3092\u6c42\u3081\u307e\u3057\u3087\u3046\uff0e<\/strong><\/p>\n<ul>\n<li><strong>\u8907\u7d20\u6570\u306e\u5927\u304d\u3055\u3092\u6c42\u3081\u308b<\/strong><\/li>\n<\/ul>\n<p><strong>\u95a2\u6570\uff1a=IMABS(\u8907\u7d20\u6570)<br \/>\n<\/strong>[\u5165\u529b\u4f8b]IMABS(\"1+j\")\u2192[\u8868\u793a\u4f8b]\u221a2<\/p>\n<p>\u3053\u3053\u3067\uff0c\u30dc\u30fc\u30c9\u7dda\u56f3\u306e\u6a2a\u8ef8\u306f\u5bfe\u6570\u3092\u53d6\u308b\u306e\u3067<br \/>\n[\u5165\u529b\u4f8b]=20*LOG10(IMABS(A10)) \u306e\u3088\u3046\u306b\u3059\u308b\u3068\u5bfe\u6570\u3092\u3068\u3063\u305f\u5927\u304d\u3055\u3092\u6c42\u3081\u3089\u308c\u307e\u3059\uff0e<\/p>\n<ul>\n<li><strong>\u8907\u7d20\u6570\u306e\u4f4d\u76f8(\u504f\u89d2)\u3092\u6c42\u3081\u308b\uff1a\u30e9\u30b8\u30a2\u30f3<\/strong><\/li>\n<\/ul>\n<p><strong>\u95a2\u6570\uff1a=IMARGUMENT(\u8907\u7d20\u6570)<br \/>\n<\/strong>[\u5165\u529b\u4f8b]=IMARGUMENT(\"1+i\")\u2192[\u8868\u793a\u4f8b]0.785(\u30e9\u30b8\u30a2\u30f3\u8868\u793a)<\/p>\n<p>\u3053\u3053\u3067\uff0cDEGREE(\u00b0)\u8868\u793a\u306b\u5909\u63db\u3059\u308b\u5834\u5408\uff0c\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u5165\u529b\u3057\u307e\u3059\uff0e<br \/>\n[\u5165\u529b\u4f8b]=DEGREES(IMARGUMENT(\"1+j\"))\u2192[\u8868\u793a\u4f8b]45<\/p>\n<h2>\u304a\u307e\u3051\uff1a\u8907\u7d20\u6570\u306e\u5b9f\u90e8\u3068\u865a\u90e8\u3092\u53d6\u308a\u51fa\u3059<\/h2>\n<ul>\n<li><strong>\u8907\u7d20\u6570\u304b\u3089\u5b9f\u90e8\u3092\u53d6\u308a\u51fa\u3059<\/strong><\/li>\n<\/ul>\n<p><strong>\u95a2\u6570\uff1a=IMREAL(\u8907\u7d20\u6570)<br \/>\n<\/strong>[\u5165\u529b\u4f8b]=IMREAL(\"2+i\")\u2192[\u8868\u793a\u4f8b]2<strong><br \/>\n<\/strong><\/p>\n<ul>\n<li><strong>\u8907\u7d20\u6570\u304b\u3089\u865a\u90e8\u3092\u53d6\u308a\u51fa\u3059<\/strong><\/li>\n<\/ul>\n<p><strong>\u95a2\u6570\uff1a=IMAGINARY(\u8907\u7d20\u6570)<\/strong><br \/>\n[\u5165\u529b\u4f8b]=IMAGINARY(COMPLEX(2,1))\u2192[\u8868\u793a\u4f8b]1<\/p>\n<hr \/>\n<div class=\"kattene\">\n    <div class=\"kattene__imgpart\"><a target=\"_blank\" rel=\"noopener\" href=\"https:\/\/amzn.to\/2UH1mmu\"><img decoding=\"async\" src=\"https:\/\/ws-fe.amazon-adsystem.com\/widgets\/q?_encoding=UTF8&amp;ASIN=B01MYC8LPQ&amp;Format=_SL160_&amp;ID=AsinImage&amp;MarketPlace=JP&amp;ServiceVersion=20070822&amp;WS=1&amp;tag=tmtyoutube-22&amp;language=ja_JP\"><\/a><\/div>\n    <div class=\"kattene__infopart\">\n      <div class=\"kattene__title\"><a target=\"_blank\" rel=\"noopener\" href=\"https:\/\/amzn.to\/2UH1mmu\">Excel \u6700\u5f37\u306e\u6559\u79d1\u66f8\uff3b\u5b8c\u5168\u7248\uff3d\u2015\u2015\u3059\u3050\u306b\u4f7f\u3048\u3066\u3001\u4e00\u751f\u5f79\u7acb\u3064\u300c\u6210\u679c\u3092\u751f\u307f\u51fa\u3059\u300d\u8d85\u30a8\u30af\u30bb\u30eb\u4ed5\u4e8b\u8853<\/a><\/div>\n      <div class=\"kattene__description\">Excel\u3068\u4e0a\u624b\u306b\u4ed8\u304d\u5408\u3044\u305f\u3044\u3042\u306a\u305f\u306b\u306f\u3053\u306e\u4e00\u518a\u3002<\/div>\n      <div class=\"kattene__btns __four\"><div><a class=\"kattene__btn __orange\" target=\"_blank\" rel=\"noopener\" href=\"https:\/\/amzn.to\/2UH1mmu\">Amazon<\/a><\/div><div><a class=\"kattene__btn __blue\" target=\"_blank\" rel=\"noopener\" href=\"https:\/\/amzn.to\/3hoiQhb\">Kindle<\/a><\/div><div><a class=\"kattene__btn __red\" target=\"_blank\" rel=\"noopener\" href=\"https:\/\/hb.afl.rakuten.co.jp\/ichiba\/1c053609.4c09c383.1c05360a.22ae359d\/?pc=https%3A%2F%2Fitem.rakuten.co.jp%2Fbook%2F14531947%2F&amp;link_type=hybrid_url&amp;ut=eyJwYWdlIjoiaXRlbSIsInR5cGUiOiJoeWJyaWRfdXJsIiwic2l6ZSI6IjI0MHgyNDAiLCJuYW0iOjEsIm5hbXAiOiJyaWdodCIsImNvbSI6MSwiY29tcCI6ImxlZnQiLCJwcmljZSI6MSwiYm9yIjoxLCJjb2wiOjAsImJidG4iOjEsInByb2QiOjB9\">\u697d\u5929<\/a><\/div><div><a class=\"kattene__btn __green\" target=\"_blank\" rel=\"noopener\" href=\"https:\/\/hb.afl.rakuten.co.jp\/ichiba\/1c053681.6aec010d.1c053682.0af5a40f\/?pc=https%3A%2F%2Fitem.rakuten.co.jp%2Frakutenkobo-ebooks%2F4cdee117d88b387397f097b29abf4069%2F&amp;link_type=hybrid_url&amp;ut=eyJwYWdlIjoiaXRlbSIsInR5cGUiOiJoeWJyaWRfdXJsIiwic2l6ZSI6IjI0MHgyNDAiLCJuYW0iOjEsIm5hbXAiOiJyaWdodCIsImNvbSI6MSwiY29tcCI6ImxlZnQiLCJwcmljZSI6MSwiYm9yIjoxLCJjb2wiOjAsImJidG4iOjEsInByb2QiOjB9\">\u697d\u5929Kobo<\/a><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u305d\u3082\u305d\u3082\u30dc\u30fc\u30c9\u7dda\u56f3\u3063\u3066\u4f55\uff1f\u30a8\u30af\u30bb\u30eb\u3067\u8907\u7d20\u6570\u8a08\u7b97\u3092\u3069\u3046\u884c\u3046\uff1f \u6e29\u5ea6\u3092\u4e00\u5b9a\u306b\u4fdd\u3061\u305f\u3044\uff01\u306a\u3069\uff0c\u4f55\u3089\u304b\u306e\u5236\u5fa1\u5bfe\u8c61\u306b\u5bfe\u3057\u3066\u5236\u5fa1\u3092\u884c\u3046\u5236\u5fa1\u5de5\u5b66\u3068\u3044\u3046\u5b66\u554f\u306b\u304a\u3044\u3066\uff0c\u305d\u306e\u5236\u5fa1\u7cfb\u304c\u5b89\u5b9a\u3067\u3042\u308b\u304b\uff1f\u3092\u898b\u308b\u4e00\u3064\u306e\u65b9\u6cd5\u3068\u3057\u3066\u30dc\u30fc\u30c9\u7dda\u56f3\u3068\u3044\u3046\u3082\u306e\u304c&#8230;<\/p>\n","protected":false},"author":1,"featured_media":425,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31,45],"tags":[42,48,46,47,49],"class_list":{"0":"post-414","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-office365","8":"category-45","9":"tag-excel","10":"tag-48","11":"tag-46","12":"tag-47","13":"tag-49","14":"article cf"},"_links":{"self":[{"href":"https:\/\/elelog.net\/index.php?rest_route=\/wp\/v2\/posts\/414","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elelog.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elelog.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elelog.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elelog.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=414"}],"version-history":[{"count":19,"href":"https:\/\/elelog.net\/index.php?rest_route=\/wp\/v2\/posts\/414\/revisions"}],"predecessor-version":[{"id":630,"href":"https:\/\/elelog.net\/index.php?rest_route=\/wp\/v2\/posts\/414\/revisions\/630"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/elelog.net\/index.php?rest_route=\/wp\/v2\/media\/425"}],"wp:attachment":[{"href":"https:\/\/elelog.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elelog.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elelog.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}