{"id":2397,"date":"2012-10-26T14:52:10","date_gmt":"2012-10-26T05:52:10","guid":{"rendered":"http:\/\/www.ka-net.org\/blog\/?p=2397"},"modified":"2013-09-26T17:17:09","modified_gmt":"2013-09-26T08:17:09","slug":"excel-2013-%e6%96%b0%e9%96%a2%e6%95%b0%e4%b8%80%e8%a6%a7","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=2397","title":{"rendered":"Excel 2013 \u65b0\u95a2\u6570\u4e00\u89a7"},"content":{"rendered":"<p>\u300c<a href=\"\/\/www.ka-net.org\/blog\/?p=1949\" title=\"\u95a2\u6570\u4e00\u89a7(Excel 2010)\" target=\"_blank\">\u95a2\u6570\u4e00\u89a7(Excel 2010)<\/a>\u300d\u3068\u300c<a href=\"\/\/www.ka-net.org\/blog\/?p=2387\" title=\"\u95a2\u6570\u4e00\u89a7(Excel 2013)\" target=\"_blank\">\u95a2\u6570\u4e00\u89a7(Excel 2013)<\/a>\u300d\u3092\u5143\u306b\u3001Excel 2013\u3067\u8ffd\u52a0\u3055\u308c\u305f\u65b0\u3057\u3044\u95a2\u6570\u306e\u8868\u3092\u4f5c\u6210\u3057\u3066\u307f\u307e\u3057\u305f\u3002<br \/>\nExcel 2013\u3067\u8ffd\u52a0\u3055\u308c\u305f\u95a2\u6570\u306f\u5168\u90e8\u3067<span style=\"color: #ff0000; font-weight: bold;\">50\u500b<\/span>\u3042\u308b\u3088\u3046\u3067\u3059\u3002<br \/>\nExcel 2010\u306b\u306f\u3042\u3063\u305f\u300c<span style=\"color: #ff0000; font-weight: bold;\">CEILING.PRECISE<\/span>\u300d\u95a2\u6570\u3068\u300c<span style=\"color: #ff0000; font-weight: bold;\">FLOOR.PRECISE<\/span>\u300d\u95a2\u6570\u306f2013\u3067\u306f\u524a\u9664\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n<p><a href=\"#\" name=\"MicrosoftExcelButton\" data-xl-tableTitle=\"Excel 2013 \u65b0\u95a2\u6570\u4e00\u89a7\" data-xl-buttonStyle=\"Standard\" data-xl-fileName=\"Excel_2013_NewWSFunctions\" data-xl-attribution=\"Data provided by ka-net.org\" ><\/a><br \/>\n<script type=\"text\/javascript\" src=\"http:\/\/r.office.microsoft.com\/r\/rlidExcelButton?v=1&#038;kip=1&#038;locale=ja-JP\"><\/script><\/p>\n<div style=\"width:550px;height:400px;overflow:auto;\">\n<table width=\"1200px\" style=\"border-collapse:collapse;\">\n<tr>\n<td style=\"border:1px #000000 solid;background-color:#ffccff;text-align:center;font-weight:bold;\">&nbsp;<\/td>\n<td style=\"border:1px #000000 solid;background-color:#ffccff;text-align:center;font-weight:bold;\">\u95a2\u6570\u540d<\/td>\n<td style=\"border:1px #000000 solid;background-color:#ffccff;text-align:center;font-weight:bold;\">\u66f8\u5f0f<\/td>\n<td style=\"border:1px #000000 solid;background-color:#ffccff;text-align:center;font-weight:bold;\">\u89e3\u8aac<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">1<\/td>\n<td style=\"border:1px #000000 solid;\">ACOT<\/td>\n<td style=\"border:1px #000000 solid;\">ACOT(\u6570\u5024)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6570\u5024\u306e\u9006\u4f59\u63a5\u3092\u8fd4\u3057\u307e\u3059\u3002\u623b\u308a\u5024\u306e\u89d2\u5ea6\u306f\u30010 \uff5e Pi \u306e\u7bc4\u56f2\u306e\u30e9\u30b8\u30a2\u30f3\u3068\u306a\u308a\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">2<\/td>\n<td style=\"border:1px #000000 solid;\">ACOTH<\/td>\n<td style=\"border:1px #000000 solid;\">ACOTH(\u6570\u5024)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6570\u5024\u306e\u9006\u53cc\u66f2\u7dda\u4f59\u63a5\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">3<\/td>\n<td style=\"border:1px #000000 solid;\">ARABIC<\/td>\n<td style=\"border:1px #000000 solid;\">ARABIC(\u6587\u5b57\u5217)<\/td>\n<td style=\"border:1px #000000 solid;\">\u30ed\u30fc\u30de\u6570\u5b57\u3092\u30a2\u30e9\u30d3\u30a2\u6570\u5b57\u306b\u5909\u63db\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">4<\/td>\n<td style=\"border:1px #000000 solid;\">BASE<\/td>\n<td style=\"border:1px #000000 solid;\">BASE(\u6570\u5024,\u57fa\u6570,\u6700\u5c0f\u9577)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6570\u5024\u3092\u7279\u5b9a\u306e\u57fa\u6570 (\u5e95) \u3092\u6301\u3064\u30c6\u30ad\u30b9\u30c8\u8868\u73fe\u306b\u5909\u63db\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">5<\/td>\n<td style=\"border:1px #000000 solid;\">BINOM.DIST.RANGE<\/td>\n<td style=\"border:1px #000000 solid;\">BINOM.DIST.RANGE(\u8a66\u884c\u56de\u6570,\u6210\u529f\u7387,\u6210\u529f\u6570,\u6210\u529f\u65702)<\/td>\n<td style=\"border:1px #000000 solid;\">\u4e8c\u9805\u5206\u5e03\u3092\u4f7f\u7528\u3057\u305f\u8a66\u884c\u7d50\u679c\u306e\u78ba\u7387\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">6<\/td>\n<td style=\"border:1px #000000 solid;\">BITAND<\/td>\n<td style=\"border:1px #000000 solid;\">BITAND(\u6570\u50241,\u6570\u50242)<\/td>\n<td style=\"border:1px #000000 solid;\">2 \u3064\u306e\u6570\u5024\u306e\u30d3\u30c3\u30c8\u5358\u4f4d\u306e &#8216;And&#8217; \u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">7<\/td>\n<td style=\"border:1px #000000 solid;\">BITLSHIFT<\/td>\n<td style=\"border:1px #000000 solid;\">BITLSHIFT(\u6570\u5024,\u79fb\u52d5\u6570)<\/td>\n<td style=\"border:1px #000000 solid;\">\u5de6\u306b\u79fb\u52d5\u6570\u30d3\u30c3\u30c8\u79fb\u52d5\u3059\u308b\u6570\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">8<\/td>\n<td style=\"border:1px #000000 solid;\">BITOR<\/td>\n<td style=\"border:1px #000000 solid;\">BITOR(\u6570\u50241,\u6570\u50242)<\/td>\n<td style=\"border:1px #000000 solid;\">2 \u3064\u306e\u6570\u5024\u306e\u30d3\u30c3\u30c8\u5358\u4f4d\u306e &#8216;Or&#8217; \u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">9<\/td>\n<td style=\"border:1px #000000 solid;\">BITRSHIFT<\/td>\n<td style=\"border:1px #000000 solid;\">BITRSHIFT(\u6570\u5024,\u79fb\u52d5\u6570)<\/td>\n<td style=\"border:1px #000000 solid;\">\u53f3\u306b\u79fb\u52d5\u6570\u30d3\u30c3\u30c8\u79fb\u52d5\u3059\u308b\u6570\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">10<\/td>\n<td style=\"border:1px #000000 solid;\">BITXOR<\/td>\n<td style=\"border:1px #000000 solid;\">BITXOR(\u6570\u50241,\u6570\u50242)<\/td>\n<td style=\"border:1px #000000 solid;\">2 \u3064\u306e\u6570\u5024\u306e\u30d3\u30c3\u30c8\u5358\u4f4d\u306e &#8216;Exclusive Or&#8217; \u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">11<\/td>\n<td style=\"border:1px #000000 solid;\">CEILING.MATH<\/td>\n<td style=\"border:1px #000000 solid;\">CEILING.MATH(\u6570\u5024,\u57fa\u6e96\u5024,\u30e2\u30fc\u30c9)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6570\u5024\u3092\u6700\u3082\u8fd1\u3044\u6574\u6570\u3001\u307e\u305f\u306f\u6700\u3082\u8fd1\u3044\u57fa\u6e96\u5024\u306e\u500d\u6570\u306b\u5207\u308a\u4e0a\u3052\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">12<\/td>\n<td style=\"border:1px #000000 solid;\">COMBINA<\/td>\n<td style=\"border:1px #000000 solid;\">COMBINA(\u6570\u5024,\u629c\u304d\u53d6\u308a\u6570)<\/td>\n<td style=\"border:1px #000000 solid;\">\u3059\u3079\u3066\u306e\u9805\u76ee\u304b\u3089\u6307\u5b9a\u3055\u308c\u305f\u500b\u6570\u3092\u9078\u629e\u3059\u308b\u3068\u304d\u306e\u7d44\u307f\u5408\u308f\u305b (\u53cd\u5fa9\u3042\u308a) \u306e\u6570\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">13<\/td>\n<td style=\"border:1px #000000 solid;\">COT<\/td>\n<td style=\"border:1px #000000 solid;\">COT(\u6570\u5024)<\/td>\n<td style=\"border:1px #000000 solid;\">\u89d2\u5ea6\u306e\u4f59\u63a5\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">14<\/td>\n<td style=\"border:1px #000000 solid;\">COTH<\/td>\n<td style=\"border:1px #000000 solid;\">COTH(\u6570\u5024)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6570\u5024\u306e\u53cc\u66f2\u7dda\u4f59\u63a5\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">15<\/td>\n<td style=\"border:1px #000000 solid;\">CSC<\/td>\n<td style=\"border:1px #000000 solid;\">CSC(\u6570\u5024)<\/td>\n<td style=\"border:1px #000000 solid;\">\u89d2\u5ea6\u306e\u4f59\u5272\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">16<\/td>\n<td style=\"border:1px #000000 solid;\">CSCH<\/td>\n<td style=\"border:1px #000000 solid;\">CSCH(\u6570\u5024)<\/td>\n<td style=\"border:1px #000000 solid;\">\u89d2\u5ea6\u306e\u53cc\u66f2\u7dda\u4f59\u5272\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">17<\/td>\n<td style=\"border:1px #000000 solid;\">DAYS<\/td>\n<td style=\"border:1px #000000 solid;\">DAYS(\u7d42\u4e86\u65e5,\u958b\u59cb\u65e5)<\/td>\n<td style=\"border:1px #000000 solid;\">2 \u3064\u306e\u65e5\u4ed8\u306e\u9593\u306e\u65e5\u6570\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">18<\/td>\n<td style=\"border:1px #000000 solid;\">DECIMAL<\/td>\n<td style=\"border:1px #000000 solid;\">DECIMAL(\u6570\u5024,\u57fa\u6570)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6307\u5b9a\u3055\u308c\u305f\u5e95\u306e\u6570\u5024\u306e\u30c6\u30ad\u30b9\u30c8\u8868\u73fe\u3092 10 \u9032\u6570\u306b\u5909\u63db\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">19<\/td>\n<td style=\"border:1px #000000 solid;\">ENCODEURL<\/td>\n<td style=\"border:1px #000000 solid;\">ENCODEURL(\u6587\u5b57\u5217)<\/td>\n<td style=\"border:1px #000000 solid;\">URL \u306b\u30a8\u30f3\u30b3\u30fc\u30c9\u3055\u308c\u305f\u6587\u5b57\u5217\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">20<\/td>\n<td style=\"border:1px #000000 solid;\">FILTERXML<\/td>\n<td style=\"border:1px #000000 solid;\">FILTERXML(xml,xpath)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6307\u5b9a\u3055\u308c\u305f XPath \u306b\u5f93\u3063\u3066\u3001XML \u30b3\u30f3\u30c6\u30f3\u30c4\u306e\u7279\u5b9a\u30c7\u30fc\u30bf\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">21<\/td>\n<td style=\"border:1px #000000 solid;\">FLOOR.MATH<\/td>\n<td style=\"border:1px #000000 solid;\">FLOOR.MATH(\u6570\u5024,\u57fa\u6e96\u5024,\u30e2\u30fc\u30c9)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6570\u5024\u3092\u6700\u3082\u8fd1\u3044\u6574\u6570\u3001\u307e\u305f\u306f\u6700\u3082\u8fd1\u3044\u57fa\u6e96\u5024\u306e\u500d\u6570\u306b\u5207\u308a\u4e0b\u3052\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">22<\/td>\n<td style=\"border:1px #000000 solid;\">FORMULATEXT<\/td>\n<td style=\"border:1px #000000 solid;\">FORMULATEXT(\u53c2\u7167)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6570\u5f0f\u3092\u6587\u5b57\u5217\u3068\u3057\u3066\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">23<\/td>\n<td style=\"border:1px #000000 solid;\">GAMMA<\/td>\n<td style=\"border:1px #000000 solid;\">GAMMA(x)<\/td>\n<td style=\"border:1px #000000 solid;\">\u30ac\u30f3\u30de\u95a2\u6570\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">24<\/td>\n<td style=\"border:1px #000000 solid;\">GAUSS<\/td>\n<td style=\"border:1px #000000 solid;\">GAUSS(x)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6a19\u6e96\u6b63\u898f\u5206\u5e03\u306e\u7d2f\u7a4d\u5206\u5e03\u95a2\u6570\u3088\u308a\u5c0f\u3055\u3044 0.5 \u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">25<\/td>\n<td style=\"border:1px #000000 solid;\">IFNA<\/td>\n<td style=\"border:1px #000000 solid;\">IFNA(\u5024,NA\u306e\u5834\u5408\u306e\u5024)<\/td>\n<td style=\"border:1px #000000 solid;\">\u5f0f\u304c #N\/A \u306b\u89e3\u6c7a\u3055\u308c\u308b\u5834\u5408\u306b\u6307\u5b9a\u3059\u308b\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002\u305d\u308c\u4ee5\u5916\u306e\u5834\u5408\u306f\u3001\u5f0f\u306e\u7d50\u679c\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">26<\/td>\n<td style=\"border:1px #000000 solid;\">IMCOSH<\/td>\n<td style=\"border:1px #000000 solid;\">IMCOSH(\u8907\u7d20\u6570)<\/td>\n<td style=\"border:1px #000000 solid;\">\u8907\u7d20\u6570\u306e\u53cc\u66f2\u7dda\u4f59\u5f26\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">27<\/td>\n<td style=\"border:1px #000000 solid;\">IMCOT<\/td>\n<td style=\"border:1px #000000 solid;\">IMCOT(\u8907\u7d20\u6570)<\/td>\n<td style=\"border:1px #000000 solid;\">\u8907\u7d20\u6570\u306e\u4f59\u63a5\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">28<\/td>\n<td style=\"border:1px #000000 solid;\">IMCSC<\/td>\n<td style=\"border:1px #000000 solid;\">IMCSC(\u8907\u7d20\u6570)<\/td>\n<td style=\"border:1px #000000 solid;\">\u8907\u7d20\u6570\u306e\u4f59\u5272\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">29<\/td>\n<td style=\"border:1px #000000 solid;\">IMCSCH<\/td>\n<td style=\"border:1px #000000 solid;\">IMCSCH(\u8907\u7d20\u6570)<\/td>\n<td style=\"border:1px #000000 solid;\">\u8907\u7d20\u6570\u306e\u53cc\u66f2\u7dda\u4f59\u5272\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">30<\/td>\n<td style=\"border:1px #000000 solid;\">IMSEC<\/td>\n<td style=\"border:1px #000000 solid;\">IMSEC(\u8907\u7d20\u6570)<\/td>\n<td style=\"border:1px #000000 solid;\">\u8907\u7d20\u6570\u306e\u6b63\u5272\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">31<\/td>\n<td style=\"border:1px #000000 solid;\">IMSECH<\/td>\n<td style=\"border:1px #000000 solid;\">IMSECH(\u8907\u7d20\u6570)<\/td>\n<td style=\"border:1px #000000 solid;\">\u8907\u7d20\u6570\u306e\u53cc\u66f2\u7dda\u6b63\u5272\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">32<\/td>\n<td style=\"border:1px #000000 solid;\">IMSINH<\/td>\n<td style=\"border:1px #000000 solid;\">IMSINH(\u8907\u7d20\u6570)<\/td>\n<td style=\"border:1px #000000 solid;\">\u8907\u7d20\u6570\u306e\u53cc\u66f2\u7dda\u6b63\u5f26\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">33<\/td>\n<td style=\"border:1px #000000 solid;\">IMTAN<\/td>\n<td style=\"border:1px #000000 solid;\">IMTAN(\u8907\u7d20\u6570)<\/td>\n<td style=\"border:1px #000000 solid;\">\u8907\u7d20\u6570\u306e\u6b63\u63a5\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">34<\/td>\n<td style=\"border:1px #000000 solid;\">ISFORMULA<\/td>\n<td style=\"border:1px #000000 solid;\">ISFORMULA(\u53c2\u7167)<\/td>\n<td style=\"border:1px #000000 solid;\">\u53c2\u7167\u304c\u6570\u5f0f\u3092\u542b\u3080\u30bb\u30eb\u306b\u5bfe\u3059\u308b\u3082\u306e\u304b\u3069\u3046\u304b\u3092\u78ba\u8a8d\u3057\u3001TRUE \u307e\u305f\u306f FALSE \u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">35<\/td>\n<td style=\"border:1px #000000 solid;\">ISOWEEKNUM<\/td>\n<td style=\"border:1px #000000 solid;\">ISOWEEKNUM(\u65e5\u4ed8)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6307\u5b9a\u3055\u308c\u305f\u65e5\u4ed8\u306e\u305d\u306e\u5e74\u306b\u304a\u3051\u308b ISO \u9031\u756a\u53f7\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">36<\/td>\n<td style=\"border:1px #000000 solid;\">MUNIT<\/td>\n<td style=\"border:1px #000000 solid;\">MUNIT(\u6b21\u5143)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6307\u5b9a\u3055\u308c\u305f\u6b21\u5143\u306e\u5358\u4f4d\u884c\u5217\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">37<\/td>\n<td style=\"border:1px #000000 solid;\">NUMBERVALUE<\/td>\n<td style=\"border:1px #000000 solid;\">NUMBERVALUE(\u6587\u5b57\u5217,\u5c0f\u6570\u70b9\u8a18\u53f7,\u6841\u533a\u5207\u308a\u8a18\u53f7)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6587\u5b57\u5217\u3092\u30ed\u30b1\u30fc\u30eb\u306b\u4f9d\u5b58\u3057\u306a\u3044\u65b9\u6cd5\u3067\u6570\u5024\u306b\u5909\u63db\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">38<\/td>\n<td style=\"border:1px #000000 solid;\">PDURATION<\/td>\n<td style=\"border:1px #000000 solid;\">PDURATION(\u5229\u7387,\u73fe\u5728\u4fa1\u5024,\u5c06\u6765\u4fa1\u5024)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6295\u8cc7\u304c\u6307\u5b9a\u3057\u305f\u4fa1\u5024\u306b\u9054\u3059\u308b\u307e\u3067\u306e\u6295\u8cc7\u671f\u9593\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">39<\/td>\n<td style=\"border:1px #000000 solid;\">PERMUTATIONA<\/td>\n<td style=\"border:1px #000000 solid;\">PERMUTATIONA(\u6570\u5024,\u629c\u304d\u53d6\u308a\u6570)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6307\u5b9a\u3057\u305f\u6570\u306e\u5bfe\u8c61 (\u53cd\u5fa9\u3042\u308a) \u304b\u3089\u3001\u6307\u5b9a\u3055\u308c\u305f\u6570\u3060\u3051\u629c\u304d\u53d6\u308b\u5834\u5408\u306e\u9806\u5217\u306e\u6570\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">40<\/td>\n<td style=\"border:1px #000000 solid;\">PHI<\/td>\n<td style=\"border:1px #000000 solid;\">PHI(x)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6a19\u6e96\u6b63\u898f\u5206\u5e03\u306e\u5bc6\u5ea6\u95a2\u6570\u306e\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">41<\/td>\n<td style=\"border:1px #000000 solid;\">RRI<\/td>\n<td style=\"border:1px #000000 solid;\">RRI(\u671f\u9593,\u73fe\u5728\u4fa1\u5024,\u5c06\u6765\u4fa1\u5024)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6295\u8cc7\u306e\u6210\u9577\u306b\u5bfe\u3059\u308b\u7b49\u4fa1\u5229\u7387\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">42<\/td>\n<td style=\"border:1px #000000 solid;\">SEC<\/td>\n<td style=\"border:1px #000000 solid;\">SEC(\u6570\u5024)<\/td>\n<td style=\"border:1px #000000 solid;\">\u89d2\u5ea6\u306e\u6b63\u5272\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">43<\/td>\n<td style=\"border:1px #000000 solid;\">SECH<\/td>\n<td style=\"border:1px #000000 solid;\">SECH(\u6570\u5024)<\/td>\n<td style=\"border:1px #000000 solid;\">\u89d2\u5ea6\u306e\u53cc\u66f2\u7dda\u6b63\u5272\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">44<\/td>\n<td style=\"border:1px #000000 solid;\">SHEET<\/td>\n<td style=\"border:1px #000000 solid;\">SHEET(\u5024)<\/td>\n<td style=\"border:1px #000000 solid;\">\u53c2\u7167\u3055\u308c\u308b\u30b7\u30fc\u30c8\u306e\u30b7\u30fc\u30c8\u756a\u53f7\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">45<\/td>\n<td style=\"border:1px #000000 solid;\">SHEETS<\/td>\n<td style=\"border:1px #000000 solid;\">SHEETS(\u53c2\u7167)<\/td>\n<td style=\"border:1px #000000 solid;\">\u53c2\u7167\u5185\u306e\u30b7\u30fc\u30c8\u6570\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">46<\/td>\n<td style=\"border:1px #000000 solid;\">SKEW.P<\/td>\n<td style=\"border:1px #000000 solid;\">SKEW.P(\u6570\u50241,\u6570\u50242,&#8230;)<\/td>\n<td style=\"border:1px #000000 solid;\">\u4eba\u53e3\u306b\u57fa\u3065\u304f\u5206\u5e03\u306e\u6b6a\u5ea6 (\u3072\u305a\u307f) \u3092\u8fd4\u3057\u307e\u3059\u3002\u6b6a\u5ea6\u3068\u306f\u3001\u5206\u5e03\u306e\u5e73\u5747\u5024\u5468\u8fba\u3067\u306e\u4e21\u5074\u306e\u975e\u5bfe\u79f0\u5ea6\u3092\u8868\u3059\u5024\u3067\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">47<\/td>\n<td style=\"border:1px #000000 solid;\">UNICHAR<\/td>\n<td style=\"border:1px #000000 solid;\">UNICHAR(\u6570\u5024)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6307\u5b9a\u3055\u308c\u305f\u6570\u5024\u306b\u3088\u308a\u53c2\u7167\u3055\u308c\u308b Unicode \u6587\u5b57\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">48<\/td>\n<td style=\"border:1px #000000 solid;\">UNICODE<\/td>\n<td style=\"border:1px #000000 solid;\">UNICODE(\u6587\u5b57\u5217)<\/td>\n<td style=\"border:1px #000000 solid;\">\u6587\u5b57\u5217\u306e\u6700\u521d\u306e\u6587\u5b57\u306b\u5bfe\u5fdc\u3059\u308b\u756a\u53f7 (\u30b3\u30fc\u30c9 \u30dd\u30a4\u30f3\u30c8) \u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">49<\/td>\n<td style=\"border:1px #000000 solid;\">WEBSERVICE<\/td>\n<td style=\"border:1px #000000 solid;\">WEBSERVICE(url)<\/td>\n<td style=\"border:1px #000000 solid;\">Web \u30b5\u30fc\u30d3\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"border:1px #000000 solid;\">50<\/td>\n<td style=\"border:1px #000000 solid;\">XOR<\/td>\n<td style=\"border:1px #000000 solid;\">XOR(\u8ad6\u7406\u5f0f1,\u8ad6\u7406\u5f0f2,&#8230;)<\/td>\n<td style=\"border:1px #000000 solid;\">\u3059\u3079\u3066\u306e\u5f15\u6570\u306e\u6392\u4ed6\u7684\u8ad6\u7406\u548c\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"\u300c\u95a2\u6570\u4e00\u89a7(Excel 2010)\u300d\u3068\u300c\u95a2\u6570\u4e00\u89a7(Excel 2013)\u300d\u3092\u5143\u306b\u3001Excel 2013\u3067\u8ffd\u52a0\u3055\u308c\u305f\u65b0\u3057\u3044\u95a2\u6570\u306e\u8868\u3092\u4f5c\u6210\u3057\u3066\u307f\u307e\u3057\u305f\u3002 Excel 2013\u3067\u8ffd\u52a0\u3055\u308c\u305f\u95a2\u6570\u306f\u5168\u90e8\u306750\u500b\u3042\u308b\u3088\u3046\u3067\u3059\u3002 Ex [&hellip;]","protected":false},"author":1,"featured_media":3429,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4,79],"tags":[81,74],"class_list":["post-2397","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","category-office2013","tag-excel-2013","tag-office-2013"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eye-catchExcel.png","jetpack_shortlink":"https:\/\/wp.me\/p4UZZr-CF","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2397","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2397"}],"version-history":[{"count":3,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2397\/revisions"}],"predecessor-version":[{"id":2400,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2397\/revisions\/2400"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/media\/3429"}],"wp:attachment":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}