{"id":6056,"date":"2023-10-18T12:45:31","date_gmt":"2023-10-18T03:45:31","guid":{"rendered":"https:\/\/techmania.jp\/blog\/?p=6056"},"modified":"2024-01-24T15:02:39","modified_gmt":"2024-01-24T06:02:39","slug":"excel-function","status":"publish","type":"post","link":"https:\/\/techmania.jp\/blog\/excel-function\/","title":{"rendered":"\u3010Excel\u3011\u899a\u3048\u3066\u304a\u304f\u3079\u304d17\u306e\u57fa\u672c\u95a2\u6570\u3068\u76ee\u7684\u5225\u9006\u5f15\u304d\u4e00\u89a7"},"content":{"rendered":"

Excel\u95a2\u6570\u3092\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u624b\u4f5c\u696d\u306b\u6bd4\u3079\u3066\u3059\u3070\u3084\u304f\u4e14\u3064\u6b63\u78ba\u306b\u8a08\u7b97\u51e6\u7406\u304c\u3067\u304d\u308b\u306a\u3069\u3001Excel\u306b\u304a\u3051\u308b\u4f5c\u696d\u52b9\u7387\u3084\u6b63\u78ba\u6027\u3092\u4e0a\u3052\u308b\u3046\u3048\u3067\u95a2\u6570\u306f\u5fc5\u9808\u3068\u3044\u3048\u307e\u3059\u3002\u3057\u304b\u3057\u3001\u7121\u6570\u306e\u95a2\u6570\u304c\u3042\u308a\u3001\u3059\u3079\u3066\u3092\u899a\u3048\u308b\u5fc5\u8981\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u57fa\u672c\u7684\u306a\u95a2\u6570\u3068\u3001\u696d\u52d9\u5185\u5bb9\u306b\u5408\u308f\u305b\u3066\u5fc5\u8981\u306a\u3082\u306e\u3092\u899a\u3048\u3066\u3044\u304f\u306e\u304c\u304a\u3059\u3059\u3081\u3067\u3059\u3002\u305d\u3053\u3067\u3001\u672c\u8a18\u4e8b\u3067\u306f\u983b\u51fa\u306e\u57fa\u672c\u95a2\u6570\u306b\u52a0\u3048\u3066\u3001\u696d\u52d9\u5185\u5bb9\u5225\u306b\u899a\u3048\u3066\u304a\u304f\u3079\u304d\u95a2\u6570\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n

\u57fa\u672c\u306e\u95a2\u657017\u9078<\/h2>\n\n\n

\u8077\u7a2e\u3084\u696d\u52d9\u5185\u5bb9\u306b\u95a2\u4fc2\u306a\u304f\u3001Excel\u3092\u5229\u7528\u3059\u308b\u4eba\u3067\u3042\u308c\u3070\u899a\u3048\u3066\u304a\u304d\u305f\u3044\u95a2\u657017\u7a2e\u985e\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u4f7f\u7528\u983b\u5ea6\u304c\u9ad8\u3044\u306e\u3067\u7fd2\u5f97\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n

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

\u95a2\u6570<\/strong><\/td>\u7528\u9014<\/strong><\/td><\/tr>
SUM<\/a><\/td>\u5408\u8a08\u5024\u3092\u7b97\u51fa\u3059\u308b<\/td><\/tr>
MAX\uff0fMIN<\/a><\/td>\u6700\u5927\u5024\uff0f\u6700\u5c0f\u5024\u3092\u7b97\u51fa\u3059\u308b<\/td><\/tr>
AVERAGE<\/a><\/td>\u5e73\u5747\u5024\u3092\u7b97\u51fa\u3059\u308b<\/td><\/tr>
ROUND<\/a><\/td>\u56db\u6368\u4e94\u5165\u3059\u308b<\/td><\/tr>
AND<\/a><\/td>AND\u6761\u4ef6\u3092\u6e80\u305f\u3059\u304b\u8abf\u3079\u308b<\/td><\/tr>
OR<\/a><\/td>OR\u6761\u4ef6\u3092\u6e80\u305f\u3059\u304b\u8abf\u3079\u308b<\/td><\/tr>
LEN<\/a><\/td>\u6587\u5b57\u6570\u3092\u6570\u3048\u308b<\/td><\/tr>
IFERROR<\/a><\/td>\u30a8\u30e9\u30fc\u6642\u306b\u8868\u793a\u3092\u5207\u308a\u66ff\u3048\u308b<\/td><\/tr>
IF<\/a><\/td>\u6761\u4ef6\u3067\u5224\u5b9a\u3059\u308b<\/td><\/tr>
IFS<\/a><\/td>\u8907\u6570\u6761\u4ef6\u3067\u5224\u5b9a\u3059\u308b<\/td><\/tr>
SUMIF<\/a><\/td>\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u3066\u5408\u8a08\u5024\u3092\u7b97\u51fa\u3059\u308b<\/td><\/tr>
SUMIFS<\/a><\/td>\u8907\u6570\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u3066\u5408\u8a08\u5024\u3092\u7b97\u51fa\u3059\u308b<\/td><\/tr>
COUNTIF<\/a><\/td>\u6761\u4ef6\u3092\u6e80\u305f\u3059\u30bb\u30eb\u306e\u6570\u3092\u7b97\u51fa\u3059\u308b<\/td><\/tr>
COUNTIFS<\/a><\/td>\u8907\u6570\u6761\u4ef6\u3092\u6e80\u305f\u3059\u30bb\u30eb\u306e\u6570\u3092\u7b97\u51fa\u3059\u308b<\/td><\/tr>
VLOOKUP<\/a><\/td>\u5024\u3092\u691c\u7d22\u30fb\u8868\u793a\u3059\u308b<\/td><\/tr>
XLOOKUP<\/a><\/td>\u5024\u3092\u691c\u7d22\u30fb\u8868\u793a\u3059\u308b<\/td><\/tr>
EOMONTH<\/a><\/td>\u65e5\u4ed8\u3067\u8a08\u7b97\u3059\u308b<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n<\/a>

\u3042\u306a\u305f\u306e\u3054\u5e0c\u671b\u306b\u6cbf\u3063\u305f\u6848\u4ef6\u304c\u5fc5\u305a<\/span>\u898b\u3064\u304b\u308a\u307e\u3059
\u3010\u30d5\u30ea\u30fc\u30e9\u30f3\u30b9\u5411\u3051\u3011\u9ad8\u53ce\u5165<\/span>\u30fb\u597d\u5f85\u9047<\/span>\u306e\u6848\u4ef6\u3092\u3054\u7d39\u4ecb<\/p><\/a>\n<\/div>\n

\"TECH<\/a><\/div>\n
\n<\/a>

\u226b\u307e\u305a\u306f\u7c21\u535830<\/span>\u79d2\u3067\u7121\u6599\u304a\u554f\u3044\u5408\u308f\u305b<\/span>\u304b\u3089\u226a<\/p><\/a>\n\n\n\n

SUM\u95a2\u6570<\/h3>\n\n\n

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

SUM\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=SUM(\u30bb\u30eb\u7bc4\u56f2)<\/strong><\/p>\n<\/div>\n

\uff08\uff09\u5185\u306b\u8a08\u7b97\u5bfe\u8c61\u306e\u30bb\u30eb\u306e\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u3061\u306a\u307f\u306b\u3001\u95a2\u6570\u306b\u6307\u5b9a\u3059\u308b\u30bb\u30eb\u3084\u6761\u4ef6\u3092\u300c\u5f15\u6570\uff08\u3072\u304d\u3059\u3046\uff09\u300d\u3068\u3044\u3044\u307e\u3059\u3002<\/p>\n

\u30bb\u30eb\u7bc4\u56f2\u306e\u6307\u5b9a\u65b9\u6cd5\u306b\u306f\u300c\u7bc4\u56f2\u6307\u5b9a\u65b9\u5f0f\u300d\u3068\u300c\u500b\u5225\u6307\u5b9a\u65b9\u5f0f\u300d\u306e2\u7a2e\u985e\u304c\u3042\u308a\u307e\u3059\u3002\u203b\u4f75\u7528\u53ef<\/p>\n

\u7bc4\u56f2\u6307\u5b9a\u65b9\u5f0f<\/strong><\/p>\n

\u7bc4\u56f2\u6307\u5b9a\u65b9\u5f0f\u306f\u300c:\uff08\u30b3\u30ed\u30f3\uff09\u300d\u3067\u30bb\u30eb\u306e\u958b\u59cb\u5730\u70b9\u3068\u7d42\u4e86\u5730\u70b9\u3092\u6307\u5b9a\u3059\u308b\u65b9\u6cd5\u3067\u3059\u3002\u6307\u5b9a\u3057\u305f\u3044\u30bb\u30eb\u7bc4\u56f2\u3092\u30de\u30a6\u30b9\u3067\u30c9\u30e9\u30c3\u30b0\u3059\u308b\u3053\u3068\u3067\u300cA1:A3\u300d\u306e\u3088\u3046\u306b\u3001\u6307\u5b9a\u958b\u59cb\u3068\u7d42\u4e86\u307e\u3067\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n

\u500b\u5225\u6307\u5b9a\u65b9\u5f0f<\/strong><\/p>\n

\u500b\u5225\u306b\u30bb\u30eb\u3092\u6307\u5b9a\u3059\u308b\u5834\u5408\u306f\u3001\u300c,\uff08\u30ab\u30f3\u30de\uff09\u300d\u3067\u500b\u5225\u306e\u30bb\u30eb\u3092\u6307\u5b9a\u3059\u308b\u300c\u500b\u5225\u6307\u5b9a\u65b9\u5f0f\u300d\u3092\u7528\u3044\u307e\u3059\u3002Ctrl\u30ad\u30fc\u3092\u62bc\u3057\u306a\u304c\u3089\u5bfe\u8c61\u306e\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u300cA1,A2,A3\u300d\u306e\u3088\u3046\u306b\u3001\u500b\u5225\u306e\u30bb\u30eb\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n

\u306a\u304a\u3001\u30bb\u30eb\u3084\u30b3\u30ed\u30f3\u3001\u30ab\u30f3\u30de\u306f\u30ad\u30fc\u30dc\u30fc\u30c9\u5165\u529b\u3067\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n

MAX\uff0fMIN\u95a2\u6570<\/h3>\n\n\n

MAX\uff0fMIN\u95a2\u6570\u306f\u3001\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u7bc4\u56f2\u306e\u6700\u5927\u5024\uff0f\u6700\u5c0f\u5024\u3092\u7b97\u51fa\u3059\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n

MAX\uff0fMIN\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=MAX(\u30bb\u30eb\u7bc4\u56f2)<\/strong><\/p>\n<\/div>\n

\n

=MIN(\u30bb\u30eb\u7bc4\u56f2)<\/strong><\/p>\n<\/div>\n

\uff08\uff09\u5185\u306b\u8a08\u7b97\u5bfe\u8c61\u306e\u30bb\u30eb\u306e\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n

AVERAGE\u95a2\u6570<\/h3>\n\n\n

AVERAGE\u95a2\u6570\u306f\u3001\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u7bc4\u56f2\u306e\u5e73\u5747\u5024\u3092\u7b97\u51fa\u3059\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n

AVERAGE\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=AVERAGE(\u30bb\u30eb\u7bc4\u56f2)<\/strong><\/p>\n<\/div>\n

\uff08\uff09\u5185\u306b\u8a08\u7b97\u5bfe\u8c61\u306e\u30bb\u30eb\u306e\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n

ROUND\u95a2\u6570<\/h3>\n\n\n

ROUND\u95a2\u6570\u306f\u3001\u5024\u3092\u4efb\u610f\u306e\u6841\u6570\u306b\u56db\u6368\u4e94\u5165\u3059\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n

ROUND\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=ROUND(\u30bb\u30eb\u756a\u5730\u307e\u305f\u306f\u6570\u5024,\u6841\u6570)<\/strong><\/p>\n<\/div>\n

\u7b2c\u4e00\u5f15\u6570\u306b\u8a08\u7b97\u5bfe\u8c61\u306e\u30bb\u30eb\u756a\u5730\u307e\u305f\u306f\u6570\u5024\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u300c\u6841\u6570\u300d\u306f\u5c0f\u6570\u70b9\u4ee5\u4e0b\u306e\u6841\u6570\u306e\u3053\u3068\u3067\u30011\u306e\u4f4d\u3092\u56db\u6368\u4e94\u5165\u3059\u308b\u5834\u5408\u306f\u300c0\u300d\u3001\u5c0f\u6570\u7b2c1\u4f4d\u3092\u56db\u6368\u4e94\u5165\u3059\u308b\u306a\u3089\u300c1\u300d\u300110\u306e\u4f4d\u3092\u56db\u6368\u4e94\u5165\u3059\u308b\u306a\u3089\u300c-1\u300d\u3068\u3057\u307e\u3059\u3002\u5207\u308a\u6368\u3066\uff0f\u5207\u308a\u4e0a\u3052\u3092\u884c\u3046\u95a2\u6570\u306f\u3001ROUNDDOWN\u95a2\u6570\uff0fROUNDUP\u95a2\u6570\u3082\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n

AND\u95a2\u6570<\/h3>\n\n\n

AND\u95a2\u6570\u306f\u3001AND\u6761\u4ef6\u3092\u6e80\u305f\u3059\u304b\u5426\u304b\u3092\u8abf\u3079\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n

AND\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=AND(\u8ad6\u7406\u5f0f1, \u8ad6\u7406\u5f0f2,\u2026)<\/strong><\/p>\n<\/div>\n

\u5f15\u6570\u3067\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n

OR\u95a2\u6570<\/h3>\n\n\n

OR\u95a2\u6570\u306f\u3001OR\u6761\u4ef6\u3092\u6e80\u305f\u3059\u304b\u5426\u304b\u3092\u8abf\u3079\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n

OR\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=OR(\u8ad6\u7406\u5f0f1, \u8ad6\u7406\u5f0f2,\u2026)<\/strong><\/p>\n<\/div>\n

\u5f15\u6570\u3067\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n

LEN\u95a2\u6570<\/h3>\n\n\n

LEN\u95a2\u6570\u306f\u3001\u30bb\u30eb\u306e\u6587\u5b57\u6570\u3092\u8abf\u3079\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n

LEN\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=LEN(\u30bb\u30eb\u756a\u5730\u307e\u305f\u306f\u6587\u5b57\u5217<\/strong>)<\/strong><\/p>\n<\/div>\n

\u5f15\u6570\u3067\u8a08\u7b97\u5bfe\u8c61\u306e\u30bb\u30eb\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n

IFERROR\u95a2\u6570<\/h3>\n\n\n

IFERROR\u95a2\u6570\u306f\u3001\u30c7\u30fc\u30bf\u306e\u672a\u5165\u529b\u304c\u539f\u56e0\u3067\u30a8\u30e9\u30fc\u306b\u306a\u3063\u305f\u5834\u5408\u306b\u8868\u793a\u5185\u5bb9\u3092\u5909\u66f4\u3057\u3066\u308f\u304b\u308a\u3084\u3059\u304f\u3059\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n

IFERROR\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=IFERROR(\u30bb\u30eb\u7bc4\u56f2,”\u30a8\u30e9\u30fc\u6642\u306b\u8868\u793a\u3059\u308b\u5185\u5bb9”)<\/strong><\/p>\n<\/div>\n

\uff08\uff09\u5185\u306b\u8a08\u7b97\u5bfe\u8c61\u306e\u30bb\u30eb\u306e\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u6841\u6570\u306f\u5c0f\u6570\u70b9\u4ee5\u4e0b\u306e\u6841\u6570\u306e\u3053\u3068\u3067\u3001\u5c0f\u6570\u70b9\u4ee5\u4e0b\u3092\u56db\u6368\u4e94\u5165\u3059\u308b\u5834\u5408\u306f\u300c0\u300d\u3001\u5c0f\u6570\u7b2c1\u4f4d\u307e\u3067\u306a\u3089\u300c1\u300d\u3068\u3057\u307e\u3059\u3002<\/p>\n

\u300c\u30bb\u30eb\u7bc4\u56f2\u300d\u306b\u306f\u3001\u30a8\u30e9\u30fc\u306b\u306a\u308b\u53ef\u80fd\u6027\u306e\u3042\u308b\u30bb\u30eb\u3084\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n

\u6587\u5b57\u8868\u73fe\u3092\u3059\u308b\u306b\u306f\u30012\u3064\u306e\u300c”\uff08\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\uff09\u300d\u3067\u56f2\u3063\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n

IF\u95a2\u6570<\/h3>\n\n\n

IF\u95a2\u6570\u306f\u3001\u6761\u4ef6\u306b\u5fdc\u3058\u3066\u8868\u793a\u5185\u5bb9\u3092\u5909\u66f4\u3059\u308b\u95a2\u6570\u3067\u3059\u3002\u6307\u5b9a\u3057\u305f\u8ad6\u7406\u5f0f\u306e\u7d50\u679c\u3092\u300cTRUE\u300d\u304b\u300cFALSE\u300d\u306e2\u901a\u308a\u3067\u8868\u793a\u5185\u5bb9\u3092\u5909\u3048\u307e\u3059\u3002\u8ad6\u7406\u5f0f\u3068\u306f\u300c=\u300d\u300c<\u300d\u300c>\u300d\u306a\u3069\u306e\u6f14\u7b97\u5b50\u3092\u7528\u3044\u305f\u5f0f\u3067\u3059\u3002<\/p>\n

IF\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=IF(\u30bb\u30eb\u7bc4\u56f2,”TRUE\u306e\u5834\u5408\u306b\u8868\u793a\u3059\u308b\u5185\u5bb9”,”FALSE\u306e\u5834\u5408\u306b\u8868\u793a\u3059\u308b\u5185\u5bb9”)<\/strong><\/p>\n<\/div>\n

\u8ad6\u7406\u5f0f\u3092\u6e80\u305f\u3059\u5834\u5408\u3001\u300cTRUE\u300d\u3068\u306a\u308a\u3001\u7b2c2\u5f15\u6570\u3067\u6307\u5b9a\u3057\u305f\u300cTRUE\u306e\u5834\u5408\u306b\u8868\u793a\u3059\u308b\u5185\u5bb9\u300d\u3092\u8868\u793a\u3057\u307e\u3059\u3002\u4e00\u65b9\u3001\u8ad6\u7406\u5f0f\u3092\u6e80\u305f\u3055\u306a\u3044\u5834\u5408\u306f\u300cFALSE\u300d\u3068\u306a\u308a\u3001\u7b2c3\u5f15\u6570\u3067\u6307\u5b9a\u3057\u305f\u300cFALSE\u306e\u5834\u5408\u306e\u8868\u793a\u5185\u5bb9\u300d\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n

\u8ad6\u7406\u5f0f\u306b\u7528\u3044\u308b\u6bd4\u8f03\u6f14\u7b97\u5b50<\/strong><\/p>\n\n\n

\u6bd4\u8f03\u6f14\u7b97\u5b50<\/strong><\/td>\u6f14\u7b97\u5b50\u306e\u610f\u5473<\/strong><\/td>\u8ad6\u7406\u5f0f\uff08\u4f8b\uff09<\/strong><\/td>\u8ad6\u7406\u5f0f\u306e\u610f\u5473<\/strong><\/td><\/tr>
=<\/td>\u7b49\u3057\u3044<\/td>A1=5<\/td>A1\u306e\u5024\u304c5\u306e\u5834\u5408\u300cTRUE\u300d\u3068\u306a\u308b<\/td><\/tr>
<><\/td>\u7b49\u3057\u304f\u306a\u3044<\/td>A1<>5<\/td>A1\u306e\u5024\u304c5\u3067\u306a\u3044\u5834\u5408\u300cTRUE\u300d\u3068\u306a\u308b<\/td><\/tr>
<<\/td>\u672a\u6e80<\/td>A1<5<\/td>A1\u306e\u5024\u304c5\u3088\u308a\u5c0f\u3055\u3044\u5834\u5408\u300cTRUE\u300d\u3068\u306a\u308b<\/td><\/tr>
><\/td>\u8d85<\/td>A1>5<\/td>A1\u306e\u5024\u304c5\u3088\u308a\u5927\u304d\u3044\u5834\u5408\u300cTRUE\u300d\u3068\u306a\u308b<\/td><\/tr>
<=<\/td>\u4ee5\u4e0b<\/td>A1<=5<\/td>A1\u306e\u5024\u304c5\u4ee5\u4e0b\u306e\u5834\u5408\u300cTRUE\u300d\u3068\u306a\u308b<\/td><\/tr>
>=<\/td>\u4ee5\u4e0a<\/td>A1>=5<\/td>A1\u306e\u5024\u304c5\u4ee5\u4e0a\u306e\u5834\u5408\u300cTRUE\u300d\u3068\u306a\u308b<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

IFS\u95a2\u6570<\/h3>\n\n\n

\u8907\u6570\u306e\u6761\u4ef6\u3092\u540c\u6642\u306b\u6e80\u305f\u3059\u304b\u5426\u304b\u3092\u8abf\u3079\u308b\u306b\u306fIF\u95a2\u6570\u3092\u5165\u308c\u5b50\uff08\u30cd\u30b9\u30c8\uff09\u306b\u3059\u308b\u3068\u3044\u3046\u65b9\u6cd5\u3082\u3042\u308a\u307e\u3059\u304c\u3001\u5f0f\u304c\u8907\u96d1\u306b\u306a\u308b\u3068\u3044\u3046\u6b20\u70b9\u304c\u3042\u308a\u307e\u3059\u3002\u305d\u306e\u70b9\u3001IFS\u95a2\u6570\u3092\u4f7f\u3046\u3068\u4fbf\u5229\u3067\u3059\u3002IFS\u95a2\u6570\u306f\u3001Excel 2019\u304b\u3089\u65b0\u3057\u304f\u8ffd\u52a0\u3055\u308c\u305f\u6a5f\u80fd\u3067\u3001\u8907\u6570\u306e\u6761\u4ef6\u3092\u7c21\u6f54\u306a\u8ad6\u7406\u5f0f\u3067\u6307\u5b9a\u3067\u304d\u308b\u95a2\u6570\u3067\u3059\u3002\u95a2\u6570\u306e\u8a18\u8ff0\u306f\u3067\u304d\u308b\u3060\u3051\u30b7\u30f3\u30d7\u30eb\u306a\u307b\u3046\u304c\u3001\u6271\u3044\u3084\u3059\u3044\u3046\u3048\u306b\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u3082\u5bb9\u6613\u306b\u306a\u308a\u307e\u3059\u3002<\/span><\/p>\n

IFS\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=IFS(\u5f0f1,”\u5f0f1\u304cTRUE\u306e\u5834\u5408\u306b\u8868\u793a\u3059\u308b\u5185\u5bb9”,\u5f0f2,”\u5f0f2\u304cTRUE\u306e\u5834\u5408\u306b\u8868\u793a\u3059\u308b\u5185\u5bb9”,\u2026)<\/strong><\/p>\n<\/div>\n

IFS\u95a2\u6570\u3067\u306f\u3001\u5de6\u5074\u306e\u6761\u4ef6\u304b\u3089\u898b\u3066\u3044\u304d\u3001\u8ad6\u7406\u5f0f\u304c\u771f\u306b\u306a\u3063\u305f\u6642\u70b9\u3067\u8868\u793a\u5185\u5bb9\u3092\u5909\u66f4\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/span>\u8ad6\u7406\u5f0f\u306f\u6700\u5927127\u500b\u307e\u3067\u6307\u5b9a\u53ef\u80fd\u3067\u3059\u3002<\/p>\n

IFS\u95a2\u6570\u306e\u3088\u3046\u306a\u65b0\u3057\u3044\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u3082\u53e4\u3044Excel\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u306f\u30a8\u30e9\u30fc\u306b\u306a\u3063\u305f\u308a\u3001\u898b\u3089\u308c\u306a\u3044\u5834\u5408\u3082\u3042\u308b\u306e\u3067\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n

SUMIF\u95a2\u6570<\/h3>\n\n\n

SUMIF\u95a2\u6570\u306f\u3001\u6587\u5b57\u901a\u308a\u3001SUM\u95a2\u6570\u3068IF\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u3088\u3046\u306a\u95a2\u6570\u3067\u3042\u308a\u3001\u3042\u308b\u6761\u4ef6\u3092\u6e80\u305f\u3059\u30bb\u30eb\u306e\u5024\u3092\u5bfe\u8c61\u3068\u3057\u3066\u5408\u8a08\u5024\u3092\u7b97\u51fa\u3059\u308b\u95a2\u6570\u3067\u3059\u3002<\/span><\/span>\u8907\u6570\u306e\u30c7\u30fc\u30bf\u3092\u9031\u5358\u4f4d\u3084\u6708\u5358\u4f4d\u306a\u3069\u3001\u307e\u3068\u307e\u3063\u305f\u671f\u9593\u3054\u3068\u306e\u5408\u8a08\u5024\u3092\u7b97\u51fa\u3057\u305f\u3044\u5834\u5408\u306a\u3069\u306b\u4fbf\u5229\u3067\u3059\u3002<\/span><\/p>\n

SUMIF\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=SUMIF(\u7bc4\u56f2,\u691c\u7d22\u6761\u4ef6,\uff3b\u5408\u8a08\u7bc4\u56f2\uff3d<\/span><\/span>)<\/strong><\/p>\n<\/div>\n

\u300c\u7bc4\u56f2\u300d\u306b\u306f\u3001\u6761\u4ef6\u5224\u5b9a\u306e\u5bfe\u8c61\u3068\u3059\u308b\u30bb\u30eb\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u7b2c2\u5f15\u6570\u306b\u306f\u300c\u691c\u7d22\u6761\u4ef6\u300d\u3092\u6307\u5b9a\u3057\u3001\u7b2c3\u5f15\u6570\u306b\u306f\u96c6\u8a08\u5bfe\u8c61\u3068\u306a\u308b\u30c7\u30fc\u30bf\u306e\u30bb\u30eb\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/span><\/span><\/p>\n\n\n

SUMIFS\u95a2\u6570<\/h3>\n\n\n

SUMIFS\u95a2\u6570\u306f\u3001\u8907\u6570\u306e\u6761\u4ef6\u3092\u6e80\u305f\u3059\u30bb\u30eb\u306e\u5024\u3092\u5bfe\u8c61\u3068\u3057\u3066\u5408\u8a08\u5024\u3092\u7b97\u51fa\u3059\u308b\u95a2\u6570\u3067\u3059\u3002\u30c7\u30fc\u30bf\u306e\u96c6\u8a08\u4f5c\u696d\u304c\u3088\u308a\u52b9\u7387\u7684\u306b\u884c\u3048\u307e\u3059\u3002<\/span><\/span><\/span><\/p>\n

SUMIFS\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=SUMIFS(\u5408\u8a08\u5bfe\u8c61\u7bc4\u56f2,\u6761\u4ef61,\u6761\u4ef6\u7bc4\u56f22,\u6761\u4ef62,\u2026<\/span><\/span>)<\/strong><\/p>\n<\/div>\n

\u300c\u7bc4\u56f2\u300d\u306b\u306f\u3001\u6761\u4ef6\u5224\u5b9a\u306e\u5bfe\u8c61\u3068\u3059\u308b\u30bb\u30eb\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u7b2c2\u5f15\u6570\u306b\u306f\u300c\u691c\u7d22\u6761\u4ef6\u300d\u3092\u6307\u5b9a\u3057\u3001\u7b2c3\u5f15\u6570\u306b\u306f\u96c6\u8a08\u5bfe\u8c61\u3068\u306a\u308b\u30c7\u30fc\u30bf\u306e\u30bb\u30eb\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/span><\/span><\/p>\n\n\n

COUNTIF\u95a2\u6570<\/h3>\n\n\n

COUNTIF\u95a2\u6570\u306f\u3001\u30bb\u30eb\u306e\u6570\u3092COUNT\u3059\u308bCOUNT\u95a2\u6570\u306b\u6761\u4ef6\u3092\u4ed8\u5e2f\u3057\u3001\u7279\u5b9a\u306e\u6761\u4ef6\u3092\u6e80\u305f\u3059\u30bb\u30eb\u306e\u6570\u3092\u6570\u3048\u308b\u95a2\u6570\u3067\u3059\u3002<\/span><\/span><\/span><\/p>\n

COUNTIF\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=COUNTIF(\u7bc4\u56f2,\u691c\u7d22\u6761\u4ef6<\/span><\/span>)<\/strong><\/p>\n<\/div>\n

\u300c\u7bc4\u56f2\u300d\u306b\u306f\u3001\u6761\u4ef6\u5224\u5b9a\u306e\u5bfe\u8c61\u3068\u3059\u308b\u30bb\u30eb\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u7b2c2\u5f15\u6570\u306b\u306f\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/span><\/span><\/p>\n\n\n

COUNTIFS\u95a2\u6570<\/h3>\n\n\n

COUNTIFS\u95a2\u6570\u306f\u3001\u8907\u6570\u306e\u6761\u4ef6\u3092\u6e80\u305f\u3059\u30bb\u30eb\u306e\u6570\u3092\u6570\u3048\u308b\u95a2\u6570\u3067\u3059\u3002\u6761\u4ef6\u306f127\u500b\u307e\u3067\u6307\u5b9a\u53ef\u80fd\u3067\u3059\u3002<\/span><\/span><\/span><\/p>\n

COUNTIFS\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=COUNTIFS(\u691c\u7d22\u6761\u4ef6\u7bc4\u56f21,\u691c\u7d22\u6761\u4ef61,\u691c\u7d22\u6761\u4ef6\u7bc4\u56f22,\u691c\u7d22\u6761\u4ef62,\u2026<\/span><\/span>)<\/strong><\/p>\n<\/div>\n

\u5f15\u6570\u306b\u306f\u3001\u6761\u4ef6\u5224\u5b9a\u306e\u5bfe\u8c61\u3068\u3059\u308b\u30bb\u30eb\u7bc4\u56f2\u3068\u305d\u306e\u691c\u7d22\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/span><\/span><\/p>\n\n\n

VLOOKUP\u95a2\u6570<\/h3>\n\n\n

VLOOKUP\u95a2\u6570\u306f\u3001\u6307\u5b9a\u3057\u305f\u7bc4\u56f2\u306e\u4e2d\u304b\u3089\u691c\u7d22\u6761\u4ef6\u3092\u6e80\u305f\u3059\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u3001\u6307\u5b9a\u3057\u305f\u5217\u3068\u540c\u3058\u884c\u306b\u3042\u308b\u30bb\u30eb\u3092\u8fd4\u3059\u95a2\u6570\u3067\u3059\u3002\u3053\u306e\u3088\u3046\u306a\u4ed5\u7d44\u307f\u3092\u300c\u8868\u5f15\u304d\u300d\u3068\u3044\u3044\u3001VLOOKUP\u95a2\u6570\u3092\u5fdc\u7528\u3059\u308c\u3070\u3001\u305f\u3068\u3048\u3070\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u5165\u529b\u3059\u308b\u3060\u3051\u3067\u305d\u306e\u5546\u54c1\u540d\u3084\u4fa1\u683c\u3092\u8868\u793a\u3055\u305b\u308b\u3068\u3044\u3063\u305f\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u30c6\u30fc\u30d6\u30eb\u306f\u6607\u9806\u306b\u3057\u3066\u304a\u304f\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/span><\/span><\/p>\n

VLOOKUP\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=VLOOKUP(\u691c\u7d22\u5024,\u7bc4\u56f2,\u5217\u756a\u53f7,[\u691c\u7d22\u65b9\u6cd5])<\/strong><\/p>\n<\/div>\n

\u300c\u691c\u7d22\u5024\u300d\u306b\u306f\u5546\u54c1ID\u306a\u3069\u306e\u691c\u7d22\u30ad\u30fc\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u300c\u7bc4\u56f2\u300d\u306b\u306f\u3001\u30de\u30b9\u30bf\u30fc\u30c7\u30fc\u30bf\u306e\u8a18\u5165\u3055\u308c\u305f\u30bb\u30eb\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u300c\u5217\u756a\u53f7\u300d\u306b\u306f\u30bb\u30eb\u7bc4\u56f2\u306e\u3046\u3061\u3001\u4f55\u5217\u76ee\u306e\u30bb\u30eb\u3092\u8868\u793a\u3059\u308b\u304b\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u300c\u691c\u7d22\u65b9\u6cd5\u300d\u3067\u306f\u30c7\u30fc\u30bf\u306e\u691c\u7d22\u65b9\u6cd5\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/span><\/p>\n

\u30c7\u30fc\u30bf\u306e\u691c\u7d22\u65b9\u6cd5<\/strong><\/span><\/p>\n

\u5b8c\u5168\u4e00\u81f4\u691c\u7d22\u3068\u8fd1\u4f3c\u5024\u691c\u7d22\u306e2\u7a2e\u985e\u304b\u3089\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n

\u5b8c\u5168\u4e00\u81f4\u691c\u7d22<\/span><\/strong><\/p>\n

0\u307e\u305f\u306f\u7701\u7565\u307e\u305f\u306fFALSE<\/span><\/p>\n

\u8fd1\u4f3c\u5024\u691c\u7d22<\/strong><\/span><\/p>\n

-1\uff1a\u691c\u7d22\u5024\u4ee5\u4e0b\u306e\u6700\u5927\u5024<\/span>
1\uff1a\u691c\u7d22\u5024\u4ee5\u4e0a\u306e\u6700\u5927\u5024<\/span>
2\uff1a\u691c\u7d22\u5024\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9\u6587\u5b57\u3068\u4e00\u81f4\u3059\u308b\u5024<\/span><\/p>\n\n\n

XLOOKUP\u95a2\u6570<\/h3>\n\n\n

XLOOKUP\u95a2\u6570\u306f\u3001\u5de6\u7aef\u306e\u5217\u3057\u304b\u691c\u7d22\u3067\u304d\u306a\u3044\u3068\u3044\u3046VLOOKUP\u95a2\u6570\u306e\u6b20\u70b9\u3092\u88dc\u3046\u305f\u3081\u306b\u4f5c\u3089\u308c\u305f\u95a2\u6570\u3067\u3059\u3002\u3053\u306e\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308c\u3070\u691c\u7d22\u7bc4\u56f2\u306b\u542b\u307e\u308c\u308b\u3059\u3079\u3066\u306e\u5217\u3092\u5bfe\u8c61\u306b\u3067\u304d\u308b\u306e\u3067ID\u304b\u3089\u3060\u3051\u3067\u306a\u304f\u3001\u5546\u54c1\u540d\u304b\u3089\u691c\u7d22\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002Excel2021\u304a\u3088\u3073Microsoft365\u3067\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/span><\/span><\/p>\n

XLOOKUP\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=XLOOKUP(\u691c\u7d22\u5024,\u691c\u7d22\u7bc4\u56f2,\u623b\u308a\u7bc4\u56f2,[\u898b\u3064\u304b\u3089\u306a\u3044\u5834\u5408],[\u4e00\u81f4\u30e2\u30fc\u30c9],[\u691c\u7d22\u30e2\u30fc\u30c9])<\/strong><\/p>\n<\/div>\n

\u300c\u691c\u7d22\u5024\u300d\u306b\u306f\u691c\u7d22\u30ad\u30fc\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u5546\u54c1\u4fa1\u683c\u306f\u91cd\u8907\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\u306e\u3067\u4e0d\u5411\u304d\u3067\u3059\u3002\u300c\u691c\u7d22\u7bc4\u56f2\u300d\u306b\u306f\u3001\u30de\u30b9\u30bf\u30fc\u30c7\u30fc\u30bf\u306e\u8a18\u5165\u3055\u308c\u305f\u30bb\u30eb\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u300c\u623b\u308a\u7bc4\u56f2\u300d\u306b\u306f\u62bd\u51fa\u3059\u308b\u30bb\u30eb\u306e\u7bc4\u56f2\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/span><\/p>\n\n\n

EOMONTH\u95a2\u6570<\/h3>\n\n\n

EOMONTH\u95a2\u6570\u306f\u3001\u958b\u59cb\u65e5\u304b\u3089\u8d77\u7b97\u3057\u3001\u6307\u5b9a\u3057\u305f\u6708\u6570\u5206\u3001\u524d\u307e\u305f\u306f\u5f8c\u306e\u6708\u306e\u6700\u7d42\u65e5\u306b\u5bfe\u5fdc\u3059\u308b\u30b7\u30ea\u30a2\u30eb\u5024\u3092\u8fd4\u3059\u95a2\u6570\u3067\u3059\u3002\u3053\u306e\u95a2\u6570\u3092\u5229\u7528\u3059\u308c\u3070\u6708\u672b\u306b\u767a\u751f\u3059\u308b\u6e80\u671f\u65e5\u3084\u652f\u6255\u65e5\u3092\u7b97\u51fa\u3067\u304d\u307e\u3059\u3002<\/span><\/span><\/p>\n

EOMONTH\u95a2\u6570\u306e\u66f8\u5f0f<\/strong><\/p>\n

\n

=EOMONTH(\u958b\u59cb\u65e5,\u6708)<\/strong><\/p>\n<\/div>\n

\u7b2c\u4e00\u5f15\u6570\u306b\u300c\u958b\u59cb\u65e5\u300d\u3092\u6307\u5b9a\u3057\u3001\u7b2c\u4e8c\u5f15\u6570\u306b\u958b\u59cb\u65e5\u304b\u3089\u4f55\u30f6\u6708\u524d\u307e\u305f\u306f\u4f55\u30f6\u6708\u5f8c\u306e\u6708\u672b\u304b\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/span><\/p>\n\n\n

\u65e5\u4ed8\u8868\u793a\u306b\u95a2\u3059\u308b\u95a2\u6570<\/h2>\n\n\n

\u65e5\u4ed8\u3084\u6642\u523b\u3092\u8868\u793a\u3059\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n

\u95a2\u6570<\/strong><\/td>\u7528\u9014<\/strong><\/td>\u4f7f\u7528\u4f8b<\/strong><\/td><\/tr>
TODAY<\/td>\u73fe\u5728\u306e\u65e5\u4ed8\u3092\u8868\u793a\u3059\u308b
\uff08\u5f15\u6570\u306f\u4e0d\u8981\uff09<\/td>		=TODAY()<\/td><\/tr>
NOW<\/td>\u73fe\u5728\u306e\u6642\u523b\u3092\u8868\u793a\u3059\u308b
\uff08\u5f15\u6570\u306f\u4e0d\u8981\uff09<\/td>		=NOW()<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u65e5\u4ed8\u5f62\u5f0f\u3092\u5909\u63db\u3059\u308b\u95a2\u6570<\/h2>\n\n\n

\u5e74\u6708\u65e5\u3068\u30b7\u30ea\u30a2\u30eb\u5024\u3092\u5909\u63db\u3059\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n

\u95a2\u6570<\/strong><\/td>\u7528\u9014<\/strong><\/td>\u4f7f\u7528\u4f8b<\/strong><\/td><\/tr>
DATE<\/td>\u5e74\u6708\u65e5\u30c7\u30fc\u30bf\u3092\u30b7\u30ea\u30a2\u30eb\u5024\u306b\u5909\u63db\u3059\u308b<\/td>=DATE(\u5e74,\u6708,\u65e5)<\/td><\/tr>
DAY<\/td>\u30b7\u30ea\u30a2\u30eb\u5024\u3092\u5e74\u306b\u5909\u63db\u3059\u308b<\/td>=DAY(\u30b7\u30ea\u30a2\u30eb\u5024)<\/td><\/tr>
MONTH<\/td>\u30b7\u30ea\u30a2\u30eb\u5024\u3092\u6708\u306b\u5909\u63db\u3059\u308b<\/td>=MONTH(\u30b7\u30ea\u30a2\u30eb\u5024)<\/td><\/tr>
YEAR<\/td>\u30b7\u30ea\u30a2\u30eb\u5024\u3092\u65e5\u306b\u5909\u63db\u3059\u308b<\/td>=YEAR(\u30b7\u30ea\u30a2\u30eb\u5024)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n

\u30b7\u30ea\u30a2\u30eb\u5024\u3068\u306f\uff1f<\/strong><\/span><\/p>\n

\u30b7\u30ea\u30a2\u30eb\u5024\u3068\u306f\u30011900\u5e741\u67081\u65e5\u3092\u300c1\u300d\u3068\u3057\u3001\u305d\u3053\u304b\u3089\u306e\u7d4c\u904e\u65e5\u6570\u3092\u793a\u3059\u5024\u306e\u3053\u3068\u3067\u3059\u3002Excel\u3067\u306f\u3001\u65e5\u4ed8\u3084\u6642\u523b\u3092\u30b7\u30ea\u30a2\u30eb\u5024\u3068\u3057\u3066\u6271\u3044\u307e\u3059\u3002<\/p>\n\n\n

\u6587\u5b57\u5217\u306e\u629c\u7c8b\u306b\u95a2\u3059\u308b\u95a2\u6570<\/h2>\n\n\n

\u5bfe\u8c61\u30bb\u30eb\u306e\u6587\u5b57\u5217\u306e\u3046\u3061\u6307\u5b9a\u3057\u305f\u5b57\u6570\u5206\u3092\u629c\u7c8b\u3059\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n

\u95a2\u6570<\/strong><\/td>\u7528\u9014<\/strong><\/td>\u66f8\u5f0f<\/strong><\/td><\/tr>
LEFT<\/td>\u5de6\u304b\u3089\u6307\u5b9a\u3057\u305f\u5b57\u6570\u5206\u306e\u6587\u5b57\u5217\u3092\u62bd\u51fa\u3059\u308b<\/td>=LEFT(\u30bb\u30eb\u307e\u305f\u306f\u6587\u5b57\u5217,\u6587\u5b57\u6570)<\/td><\/tr>
RIGHT<\/td>\u53f3\u304b\u3089\u6307\u5b9a\u3057\u305f\u5b57\u6570\u5206\u306e\u6587\u5b57\u5217\u3092\u62bd\u51fa\u3059\u308b<\/td>=RIGHT(\u30bb\u30eb\u307e\u305f\u306f\u6587\u5b57\u5217,\u6587\u5b57\u6570)<\/td><\/tr>
MID<\/td>\u4efb\u610f\u306e\u4f4d\u7f6e\u304b\u3089\u6307\u5b9a\u3057\u305f\u5b57\u6570\u5206\u306e\u6587\u5b57\u5217\u3092\u62bd\u51fa\u3059\u308b
\u203b\u6700\u592730\u6587\u5b57<\/td>		=MID(\u30bb\u30eb\u307e\u305f\u306f\u6587\u5b57\u5217,\u958b\u59cb\u4f4d\u7f6e,\u6587\u5b57\u6570)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u30c7\u30fc\u30bf\u691c\u7d22\u306b\u95a2\u3059\u308b\u95a2\u6570<\/h2>\n\n\n

\u30c7\u30fc\u30bf\u691c\u7d22\u3092\u884c\u3046\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n

\u95a2\u6570<\/strong><\/td>\u7528\u9014<\/strong><\/td>\u66f8\u5f0f<\/strong><\/td><\/tr>
INDEX<\/td>\u6307\u5b9a\u7bc4\u56f2\u5185\u3067\u6307\u5b9a\u3057\u305f\u884c\u3068\u5217\u304c\u4ea4\u5dee\u3059\u308b\u5024\u3092\u8868\u793a\u3059\u308b<\/td>=INDEX(\u30bb\u30eb\u7bc4\u56f2,\u884c\u756a\u53f7,[\u5217\u756a\u53f7])<\/td><\/tr>
MATCH<\/td>\u63a2\u3057\u305f\u3044\u30c7\u30fc\u30bf\u306e\u30bb\u30eb\u756a\u5730\u3092\u8868\u793a\u3059\u308b
\u691c\u7d22\u65b9\u6cd5\uff1a\u300c-1\u300d\u300c0\u300d\u300c1\u300d\u306e\u3044\u305a\u308c\u304b\u3092\u6307\u5b9a<\/td>		=MATCH(\u691c\u7d22\u5024,\u30bb\u30eb\u7bc4\u56f2,[\u691c\u7d22\u65b9\u6cd5])<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u6570\u5b66\u7cfb\u306b\u7279\u5316\u3057\u305f\u95a2\u6570<\/h2>\n\n\n

\u6570\u5b66\u306b\u7279\u5316\u3057\u305f\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n

\u95a2\u6570<\/strong><\/td>\u7528\u9014<\/strong><\/td>\u4f7f\u7528\u4f8b<\/strong><\/td><\/tr>
SQRT<\/td>\u5e73\u65b9\u6839\uff08\u221a\uff09\u8a08\u7b97\u3092\u3059\u308b<\/td>=SQRT(A1)<\/td><\/tr>
^<\/td>\u7d2f\u4e57\u3092\u8a08\u7b97\u3059\u308b<\/td>=2^(-1)<\/td><\/tr>
*<\/td>\u639b\u3051\u7b97\u3092\u3059\u308b<\/td>=2*3<\/td><\/tr>
\/<\/td>\u5272\u308a\u7b97\u3092\u3059\u308b<\/td>=2\/3<\/td><\/tr>
SIN<\/td>\u6b63\u5f26\u3092\u6c42\u3081\u308b
(\u5f15\u6570\u306f\u30e9\u30b8\u30a2\u30f3\u3001\u5ea6\u3067\u5165\u529b\u3059\u308b\u5834\u5408\u306f\u30e9\u30b8\u30a2\u30f3\u306b\u5909\u63db\u3059\u308b\u300cRADIANS\u95a2\u6570\u300d\u3092\u7528\u3044\u308b)<\/td>		=SIN(PI()\/6)
=SIN(RADIANS(30))<\/td><\/tr>
RADIANS<\/td>\u5ea6\u3092\u30e9\u30b8\u30a2\u30f3\u306b\u5909\u63db\u3059\u308b<\/td>\uff1dRADIANS(30)<\/td><\/tr>
DEGREES<\/td>\u30e9\u30b8\u30a2\u30f3\u3092\u5ea6\u306b\u5909\u63db\u3059\u308b<\/td>=DEGREES(PI()\/6)<\/td><\/tr>
PI<\/td>\u5186\u5468\u7387\uff08\u03c0\uff09\u3092\u793a\u3059
\uff08\uff08\uff09\u4e2d\u306b\u306f\u4f55\u3082\u8a18\u5165\u3057\u306a\u3044\uff09<\/td>		=PI()<\/td><\/tr>
SINH<\/td>\u53cc\u66f2\u7dda\u95a2\u6570\u3092\u6c42\u3081\u308b<\/td>=SINH(PI()\/6)<\/td><\/tr>
ASIN<\/td>\u9006\u4e09\u89d2\u95a2\u6570\uff08\u30a2\u30fc\u30af\u30b5\u30a4\u30f3\uff09\u3092\u6c42\u3081\u308b<\/td>=ASIN(0.5)<\/td><\/tr>
EXP<\/td>\u6307\u6570\u95a2\u6570\u3092\u6c42\u3081\u308b<\/td>=EXP(A1)<\/td><\/tr>
LN<\/td>\u81ea\u7136\u5bfe\u6570\u3092\u6c42\u3081\u308b<\/td>=LN(A1)<\/td><\/tr>
LOG10<\/td>\u5e38\u7528\u5bfe\u6570\u3092\u6c42\u3081\u308b<\/td>=LOG10(1000)
=LOG(1000)<\/td><\/tr>
LOG<\/td>\u5bfe\u6570
\uff082\u3064\u76ee\u306e\u5024\u3092\u5e95\u3068\u3059\u308b\uff09<\/td>		=LOG(8,2)<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"Excel\u95a2\u6570\u3092\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u624b\u4f5c\u696d\u306b\u6bd4\u3079\u3066\u3059\u3070\u3084\u304f\u4e14\u3064\u6b63\u78ba\u306b\u8a08\u7b97\u51e6\u7406\u304c\u3067\u304d\u308b\u306a\u3069\u3001Excel\u306b\u304a\u3051\u308b\u4f5c\u696d\u52b9\u7387\u3084\u6b63\u78ba\u6027\u3092\u4e0a\u3052\u308b\u3046\u3048\u3067\u95a2\u6570\u306f\u5fc5\u9808\u3068\u3044\u3048\u307e\u3059\u3002\u3057\u304b\u3057\u3001\u7121\u6570\u306e\u95a2\u6570\u304c\u3042\u308a\u3001\u3059\u3079\u3066\u3092\u899a\u3048\u308b\u5fc5\u8981\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u57fa\u672c\u7684\u306a\u95a2\u6570\u3068\u3001\u696d\u52d9\u5185\u5bb9\u306b\u5408\u308f\u305b\u3066\u5fc5\u8981\u306a\u3082\u306e\u3092\u899a\u3048\u3066\u3044\u304f\u306e\u304c\u304a\u3059\u3059\u3081\u3067\u3059\u3002\u305d\u3053\u3067\u3001\u672c\u8a18\u4e8b\u3067\u306f\u983b\u51fa\u306e\u57fa\u672c\u95a2\u6570\u306b\u52a0\u3048\u3066\u3001\u696d\u52d9\u5185\u5bb9\u5225\u306b\u899a\u3048\u3066\u304a\u304f\u3079\u304d\u95a2\u6570\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002 \u57fa\u672c\u306e\u95a2\u657017\u9078 \u8077\u7a2e\u3084\u696d […]","protected":false},"author":8,"featured_media":6060,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/web-img.rensa.jp.net\/rensa\/images\/techmania\/thumbnail\/images\/excel0.png","fifu_image_alt":"\u3010Excel\u3011\u899a\u3048\u3066\u304a\u304f\u3079\u304d17\u306e\u57fa\u672c\u95a2\u6570\u3068\u6a5f\u80fd\u5225\u9006\u5f15\u304d\u8868","footnotes":""},"categories":[1],"tags":[],"class_list":["post-6056","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/techmania.jp\/blog\/wp-json\/wp\/v2\/posts\/6056","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techmania.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techmania.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techmania.jp\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/techmania.jp\/blog\/wp-json\/wp\/v2\/comments?post=6056"}],"version-history":[{"count":11,"href":"https:\/\/techmania.jp\/blog\/wp-json\/wp\/v2\/posts\/6056\/revisions"}],"predecessor-version":[{"id":6623,"href":"https:\/\/techmania.jp\/blog\/wp-json\/wp\/v2\/posts\/6056\/revisions\/6623"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/techmania.jp\/blog\/wp-json\/wp\/v2\/media\/6060"}],"wp:attachment":[{"href":"https:\/\/techmania.jp\/blog\/wp-json\/wp\/v2\/media?parent=6056"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techmania.jp\/blog\/wp-json\/wp\/v2\/categories?post=6056"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techmania.jp\/blog\/wp-json\/wp\/v2\/tags?post=6056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}