{"id":14160,"date":"2023-03-25T11:44:05","date_gmt":"2023-03-25T06:14:05","guid":{"rendered":"https:\/\/savewithnerds.com\/?p=14160"},"modified":"2024-03-16T14:26:12","modified_gmt":"2024-03-16T08:56:12","slug":"excel-formulas","status":"publish","type":"post","link":"https:\/\/savewithnerds.com\/kr\/excel-formulas\/","title":{"rendered":"\ub354 \ub9ce\uc740 \ud6a8\uc728\uc131\uc744 \uc704\ud55c \ud3b8\ub9ac\ud55c Excel \uacf5\uc2dd"},"content":{"rendered":"

Excel\uc740 \ube44\uc988\ub2c8\uc2a4 \uc138\uacc4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud558\uace0, \uacc4\uc0b0\uc744 \uc218\ud589\ud558\uace0, \uc815\ubcf4\uc758 \uc2dc\uac01\uc801 \ud45c\ud604\uc744 \ub9cc\ub4dc\ub294 \ub370 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uac15\ub825\ud55c \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc18c\ud504\ud2b8\uc6e8\uc5b4\uc785\ub2c8\ub2e4. Excel\uc758 \uc8fc\uc694 \uae30\ub2a5 \uc911 \ud558\ub098\ub294 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubcf5\uc7a1\ud55c \uacc4\uc0b0\uc744 \uc790\ub3d9\uc73c\ub85c \uc218\ud589\ud558\ub294 \uae30\ub2a5\uc785\ub2c8\ub2e4.\u00a0<\/span><\/p>\n

Excel \uc218\uc2dd\uc740 \uc0c1\ub2f9\ud55c \uc591\uc758 \ub370\uc774\ud130\ub97c \ub2e4\ub8e8\ub294 \ubaa8\ub4e0 \uc0ac\ub78c\uc5d0\uac8c \ub9e4\uc6b0 \uc720\uc6a9\ud55c \ub3c4\uad6c\uc785\ub2c8\ub2e4. Excel \uc218\uc2dd\uc740 \uc8fc\ub85c Excel \ubc31\ubd84\uc728 \uc218\uc2dd\uc73c\ub85c, \ub370\uc774\ud130 \ucc98\ub9ac\ub97c \ubcf4\ub2e4 \ud6a8\uc728\uc801\uc73c\ub85c \ub9cc\ub4e4\uace0, \uc0ac\uc6a9\uc790\uac00 \ubcf5\uc7a1\ud55c \uacc4\uc0b0\uc744 \uc27d\uac8c \ub9cc\ub4e4\uace0, \uc815\ud655\ud55c \ub370\uc774\ud130 \ubd84\uc11d\uc744 \ubcf4\uc7a5\ud558\uace0, \ub370\uc774\ud130\uc758 \uc2dc\uac01\uc801 \ud45c\ud604\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ub610\ud55c Excel \uc218\uc2dd\uc740 \ub370\uc774\ud130\uc758 \uc2dc\uac01\uc801 \ud45c\ud604\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. Excel \uc218\uc2dd\uacfc \ubc31\ubd84\uc728\uc5d0 \ub300\ud55c Excel \uc218\uc2dd\uc774\ub780 \ubb34\uc5c7\uc778\uc9c0 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\ub824\uba74 \uacc4\uc18d \uc77d\uc5b4\ubcf4\uc138\uc694.<\/span><\/p>\n\t\t

\n\t\t\t\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t
\n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t
\n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t
\n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t
\n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t
\n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t
<\/div>\n\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\n

\uae30\ubcf8\uc801\uc778 Excel \uc218\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/span><\/h2>\n

\ud569\uc9d1\ud569<\/span><\/h3>\n

SUM \ud568\uc218\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0\uc5d0 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <\/span>\uc22b\uc790 \ubc94\uc704\ub97c \ub354\ud558\ub2e4<\/span><\/a> \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c. \uc608\ub97c \ub4e4\uc5b4, \uc140\uc5d0 =SUM(A1:A10)\uc744 \uc785\ub825\ud558\uba74 \uc140 A1\uc5d0\uc11c A10\uae4c\uc9c0\uc758 \uc22b\uc790\uac00 \ub354\ud574\uc9d1\ub2c8\ub2e4.<\/span><\/p>\n

\ud3c9\uade0<\/span><\/h3>\n

AVERAGE \ud568\uc218\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0\uc5d0 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/span> \ud3c9\uade0\uc744 \uacc4\uc0b0\ud558\ub2e4<\/span><\/a> \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uc22b\uc790 \ubc94\uc704. \uc608\ub97c \ub4e4\uc5b4, \uc140\uc5d0 =AVERAGE(A1:A10)\uc744 \uc785\ub825\ud558\uba74 \ud574\ub2f9 \uc140\uc758 \ubaa8\ub4e0 \uac12\uc758 \ud3c9\uade0\uc744 \uacb0\uc815\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\ucd5c\uc18c\/\ucd5c\ub300<\/span><\/h3>\n

MIN \ubc0f MAX \ud568\uc218\ub294 \ub2e4\uc74c\uc744 \ucc3e\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <\/span>\ucd5c\uc18c\uac12\uacfc \ucd5c\ub300\uac12<\/span><\/a> \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \uc22b\uc790 \ubc94\uc704\uc5d0\uc11c. \uc608\ub97c \ub4e4\uc5b4, =MIN(A1:A10)\uc740 \uc140 A1\uc5d0\uc11c A10\uae4c\uc9c0 \uac00\uc7a5 \uc791\uc740 \uac12\uc744 \ucc3e\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

\uce74\uc6b4\ud2b8\/\uce74\uc6b4\ud2b8A<\/span><\/h3>\n

COUNT \ubc0f COUNTA \ud568\uc218\ub294 \ub2e4\uc74c \uc6a9\ub3c4\ub85c \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <\/span>\uc138\ud3ec\uc758 \uc218\ub97c \uc138\ub2e4<\/span><\/a> \uac01\uac01 \uc22b\uc790 \ub610\ub294 \ube44\uc5b4 \uc788\uc9c0 \uc54a\uc740 \uac12\uc744 \ud3ec\ud568\ud558\ub294 \ubc94\uc704\uc5d0 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, =COUNT(A1:A10)\uc740 \uc22b\uc790\uac00 \ud3ec\ud568\ub41c \uc140 A1~A10\uc758 \uc140 \uc218\ub97c \uacc4\uc0b0\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\ub9cc\uc57d\uc5d0<\/span><\/h3>\n

IF \ud568\uc218\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0\uc5d0 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <\/span>\uc870\uac74\uc744 \ud14c\uc2a4\ud2b8\ud558\ub2e4<\/span><\/a> \uadf8\ub9ac\uace0 \uc870\uac74\uc774 \ucc38\uc774\uba74 \ud55c \uac12\uc744 \ubc18\ud658\ud558\uace0 \uc870\uac74\uc774 \ucc38\uc774 \uc544\ub2c8\uba74 \ub2e4\ub978 \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4. IF\ub294 \uc870\uac74 \ud14c\uc2a4\ud2b8 \ubc0f \ud3c9\uac00 \ud568\uc218\uc758 \uc57d\uc5b4\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, =IF(A1>10,\u201dYes\u201d,\u201dNo\u201d)\ub294 \uc140 A1\uc758 \uac12\uc774 10\ubcf4\ub2e4 \ud06c\uba74 \u201cYes\u201d\ub97c \ubc18\ud658\ud558\uace0 \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \u201cNo\u201d\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\n

\uc880 \ub354 \uace0\uae09 \uc5d1\uc140 \uc218\uc2dd \uc911 \uc77c\ubd80<\/span><\/h2>\n

Excel\uc5d0\ub294 \uae30\ubcf8 \uc218\uc2dd \uc678\uc5d0\ub3c4 \ub2e4\uc591\ud55c \uc218\uc2dd\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. <\/span>\uace0\uae09 \uacf5\uc2dd<\/span><\/a> \ub354 \ubcf5\uc7a1\ud55c \uacc4\uc0b0\uc744 \uc218\ud589\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uac00\uc7a5 \uc77c\ubc18\uc801\uc73c\ub85c \uc0ac\uc6a9\ub418\ub294 \uace0\uae09 Excel \uc218\uc2dd\uc5d0\ub294 \ub2e4\uc74c\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/span><\/p>\n

VLOOKUP\/HLOOKUP<\/span><\/h3>\n
\"VLOOKUP\/HLOOKUP\"
VLOOKUP\/HLOOKUP | savewithnerds<\/figcaption><\/figure>\n

VLOOKUP \ubc0f HLOOKUP \ud568\uc218\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc6a9\ub3c4\ub85c \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <\/span>\uac12\uc744 \uc870\ud68c\ud558\ub2e4<\/span><\/a> \ud2b9\uc815 \uae30\uc900\uc5d0 \ub530\ub77c \ud45c\uc5d0\uc11c. VLOOKUP\uc740 \uc138\ub85c \uc5f4\uc5d0\uc11c \uac12\uc744 \uac80\uc0c9\ud558\ub294 \ubc18\uba74, HLOOKUP\uc740 \uac00\ub85c \ud589\uc5d0\uc11c \uac12\uc744 \uac80\uc0c9\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\uc778\ub371\uc2a4\/\ub9e4\uce58<\/span><\/h3>\n

INDEX \ubc0f MATCH \ud568\uc218\ub294 \ud2b9\uc815 \uae30\uc900\uc5d0 \ub530\ub77c \ud14c\uc774\ube14\uc5d0\uc11c \uac12\uc744 \ucc3e\ub294 \ub370 \ud568\uaed8 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. INDEX\ub294 \ubc94\uc704\uc758 \ud2b9\uc815 \uc704\uce58\uc5d0\uc11c \uac12\uc744 \ubc18\ud658\ud558\ub294 \ubc18\uba74 MATCH\ub294 \ubc94\uc704\uc5d0\uc11c \ud2b9\uc815 \uac12\uc744 \uac80\uc0c9\ud558\uc5ec \ud574\ub2f9 \uc704\uce58\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\uc0ac\uc2ac \uac19\uc774 \uc787\ub2e4<\/span><\/h3>\n

CONCATENATE \ud568\uc218\ub294 \ub450 \uac1c \uc774\uc0c1\uc758 \ud14d\uc2a4\ud2b8 \ubb38\uc790\uc5f4\uc744 \ud558\ub098\uc758 \uc140\ub85c \uacb0\ud569\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, =CONCATENATE(A1,\u201d \u201c, B1)\uc740 \uc140 A1\uacfc B1\uc758 \uac12\uc744 \uacf5\ubc31\uc744 \ub450\uace0 \uacb0\ud569\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\uc774\ud398\ub85c\ub974<\/span><\/h3>\n

IFERROR \ud568\uc218\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0\uc5d0 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <\/span>\uc624\ub958 \ucc98\ub9ac<\/span><\/a> \uc218\uc2dd\uc5d0\uc11c \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \uac12\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, =IFERROR(A1\/B1, "Error")\ub294 \uc218\uc2dd A1\/B1\uc774 \uc624\ub958\ub97c \ubc1c\uc0dd\uc2dc\ud0a4\ub294 \uacbd\uc6b0 \uac12 "Error"\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/span><\/p>\n

SUMIF\/SUMIFS<\/span><\/h3>\n

SUMIF \ubc0f SUMIFS \ud568\uc218\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0\uc5d0 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <\/span>\uac12\uc744 \ub354\ud558\ub2e4<\/span><\/a> \ud2b9\uc815 \uae30\uc900\uc744 \ucda9\uc871\ud558\ub294 \ubc94\uc704 \ub0b4\uc5d0\uc11c. SUMIF\ub294 \ub2e8\uc77c \uae30\uc900\uc5d0 \ub530\ub77c \ubc94\uc704 \ub0b4\uc758 \uac12\uc744 \ub354\ud558\ub294 \ubc18\uba74, SUMIFS\ub294 \uc5ec\ub7ec \uae30\uc900\uc5d0 \ub530\ub77c \ubc94\uc704 \ub0b4\uc758 \uac12\uc744 \ub354\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\n

\uacb0\ub860\u00a0<\/span><\/h2>\n

\uc5d1\uc140 \uc218\uc2dd<\/a> \uc77c\ubc18\uc801\uc73c\ub85c \uc5f0\uc0b0\uc790 \ucc38\uc870, \uac12 \ucc38\uc870, \uc140 \ucc38\uc870 \ucc38\uc870\uc758 \uc138 \uac00\uc9c0 \uad6c\uc131\uc694\uc18c\ub85c \uad6c\uc131\ub429\ub2c8\ub2e4. <\/span>\uc218\ud559\uc801 \uc808\ucc28 \uacc4\uc0b0<\/span><\/a> \ub367\uc148, \ube84\uc148, \uacf1\uc148, \ub098\ub217\uc148\uacfc \uac19\uc740 \uc5f0\uc0b0\uc5d0\ub294 \uc5f0\uc0b0\uc790\ub77c\uace0 \ud558\ub294 \ud2b9\uc218 \uae30\ud638\ub97c \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4. \uac12\uc758 \uc22b\uc790 \ubc0f \ud14d\uc2a4\ud2b8 \ud45c\ud604\uc740 \ubaa8\ub450 \ud5c8\uc6a9\ub429\ub2c8\ub2e4. Excel \uc218\uc2dd\uc744 \uc801\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\ub824\uba74 Data Camp \uc6f9\uc0ac\uc774\ud2b8\ub85c \uc774\ub3d9\ud558\uc138\uc694. \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ubc29\ubb38\ud558\uc138\uc694. \uc138\uc774\ube0c\uc704\ub4dc\ub108\ub4dc<\/a>.<\/span><\/p>\n

\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38<\/span><\/h2>\n
<\/span>Excel\uc758 \uae30\ubcf8 \uacf5\uc2dd 7\uac00\uc9c0\uac00 \ubb34\uc5c7\uc778\uac00\uc694?<\/div>
\n
    \n
  1. MAX: \uc140 \ubc94\uc704\uc5d0\uc11c \uac00\uc7a5 \ud070 \uac12\uc744 \ucc3e\uc2b5\ub2c8\ub2e4.<\/li>\n
  2. MIN: \uc140 \ubc94\uc704\uc5d0\uc11c \uac00\uc7a5 \uc791\uc740 \uac12\uc744 \ucc3e\uc2b5\ub2c8\ub2e4.<\/li>\n
  3. IF: \uc870\uac74\uc774 \ucc38\uc778\uc9c0 \uac70\uc9d3\uc778\uc9c0 \ud14c\uc2a4\ud2b8\ud558\uace0 \uacb0\uacfc\uc5d0 \ub530\ub77c \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n
  4. VLOOKUP: \ubc94\uc704\uc758 \uac00\uc7a5 \uc67c\ucabd \uc5f4\uc5d0\uc11c \uac12\uc744 \uac80\uc0c9\ud558\uc5ec \ub2e4\ub978 \uc5f4\uc5d0\uc11c \ud574\ub2f9 \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n
  5. SUM: \ub2e4\uc591\ud55c \uac12\uc744 \ub354\ud569\ub2c8\ub2e4.<\/li>\n
  6. \ud3c9\uade0: \uac12 \ubc94\uc704\uc758 \ud3c9\uade0\uc744 \uacc4\uc0b0\ud569\ub2c8\ub2e4.<\/li>\n
  7. COUNT: \ubc94\uc704 \ub0b4 \uc22b\uc790 \uac12\uc774 \uc788\ub294 \uc140\uc758 \uac1c\uc218\ub97c \uc13c\ub2e4<\/li>\n<\/ol>\n<\/div><\/div>
    <\/span>\uac00\uc7a5 \uc778\uae30 \uc788\ub294 Excel \uc218\uc2dd 10\uac1c\ub294 \ubb34\uc5c7\uc785\ub2c8\uae4c?<\/div>
    \n
      \n
    1. LEN: \uc140\uc758 \ubb38\uc790 \uc218\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n
    2. TODAY: \ud604\uc7ac \ub0a0\uc9dc\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n
    3. PMT: \uc77c\uc815\ud55c \uc774\uc790\uc728\uc744 \uae30\ubc18\uc73c\ub85c \ud55c \ub300\ucd9c\uc5d0 \ub300\ud55c \uc0c1\ud658\uc561\uc744 \uacc4\uc0b0\ud569\ub2c8\ub2e4.<\/li>\n
    4. SUM: \uc22b\uc790 \ubc94\uc704\uc758 \ud569\uacc4\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n
    5. AVERAGE: \uc22b\uc790 \ubc94\uc704\uc758 \ud3c9\uade0\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n
    6. IF: \ud14c\uc2a4\ud2b8\uac00 \ucc38\uc774\uba74 \ud55c \uac12\uc744 \ubc18\ud658\ud558\uace0 \uac70\uc9d3\uc774\uba74 \ub2e4\ub978 \uac12\uc744 \ubc18\ud658\ud558\ub294 \ub17c\ub9ac \ud14c\uc2a4\ud2b8\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/li>\n
    7. COUNTIF: \ud2b9\uc815 \uae30\uc900\uc744 \ucda9\uc871\ud558\ub294 \ubc94\uc704 \ub0b4 \uc140\uc758 \uac1c\uc218\ub97c \uc13c\ub2e4.<\/li>\n
    8. VLOOKUP: \uc9c0\uc815\ub41c \uc5f4\uc758 \uac12\uc744 \uae30\uc900\uc73c\ub85c \ud14c\uc774\ube14\uc5d0\uc11c \uac12\uc744 \ucc3e\uc2b5\ub2c8\ub2e4.<\/li>\n
    9. INDEX\/MATCH: INDEX\uc640 MATCH \uae30\ub2a5\uc744 \uacb0\ud569\ud558\uc5ec \ud45c\uc5d0\uc11c \uac12\uc744 \ucc3e\uc2b5\ub2c8\ub2e4.<\/li>\n
    10. CONCATENATE: \ub450 \uac1c \uc774\uc0c1\uc758 \uc140\uc5d0 \uc788\ub294 \ud14d\uc2a4\ud2b8 \ubb38\uc790\uc5f4\uc744 \ud558\ub098\uc758 \uc140\ub85c \uc5f0\uacb0\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n<\/div><\/div>
      <\/span>\uc5d1\uc140\uc758 20\uac00\uc9c0 \ud568\uc218\ub294 \ubb34\uc5c7\uc778\uac00?<\/div>
      \n
        \n
      1. ROUND: \uc22b\uc790\ub97c \uc9c0\uc815\ub41c \uc18c\uc218 \uc790\ub9bf\uc218\uae4c\uc9c0 \ubc18\uc62c\ub9bc\ud569\ub2c8\ub2e4.<\/li>\n
      2. FIND: \ud55c \ud14d\uc2a4\ud2b8 \ubb38\uc790\uc5f4\uc774 \ub2e4\ub978 \ud14d\uc2a4\ud2b8 \ubb38\uc790\uc5f4 \ub0b4\uc5d0\uc11c \uc704\uce58\ub97c \ucc3e\uc2b5\ub2c8\ub2e4.<\/li>\n
      3. \ub300\uccb4: \ud55c \ud14d\uc2a4\ud2b8 \ubb38\uc790\uc5f4\uc744 \ub2e4\ub978 \ubb38\uc790\uc5f4\ub85c \ub300\uccb4\ud569\ub2c8\ub2e4.<\/li>\n
      4. COUNTIF: \ud2b9\uc815 \uc870\uac74\uc744 \ucda9\uc871\ud558\ub294 \uc140\uc758 \uac1c\uc218\ub97c \uc13c\ub2e4.<\/li>\n
      5. SUMIF: \ud2b9\uc815 \uc870\uac74\uc744 \ucda9\uc871\ud558\ub294 \uc140\uc758 \uac12\uc744 \ud569\uc0b0\ud569\ub2c8\ub2e4.<\/li>\n
      6. IFERROR: \uc218\uc2dd\uc5d0\uc11c \uc624\ub958\uac00 \ubc18\ud658\ub418\uba74 \ub2e4\ub978 \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n
      7. INDEX: \ud589\uacfc \uc5f4 \ubc88\ud638\ub97c \uae30\uc900\uc73c\ub85c \uc140 \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n
      8. MATCH: \uc140 \ubc94\uc704\uc5d0\uc11c \ud558\ub098\uc758 \uac12\uc758 \uc704\uce58\ub97c \ucc3e\uc2b5\ub2c8\ub2e4.<\/li>\n
      9. OFFSET: \uc8fc\uc5b4\uc9c4 \ucc38\uc870\ub85c\ubd80\ud130 \uc624\ud504\uc14b\ub41c \uc140 \ubc94\uc704\uc5d0 \ub300\ud55c \ucc38\uc870\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n
      10. TODAY: \ud604\uc7ac \ub0a0\uc9dc\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n
      11. SUM: \uc140 \ubc94\uc704\uc758 \uc22b\uc790\ub97c \ub354\ud569\ub2c8\ub2e4.<\/li>\n
      12. \ud3c9\uade0: \uc140 \ubc94\uc704\uc758 \ud3c9\uade0\uc744 \uacc4\uc0b0\ud569\ub2c8\ub2e4.<\/li>\n
      13. COUNT: \uc22b\uc790\uac00 \ud3ec\ud568\ub41c \uc140\uc758 \uac1c\uc218\ub97c \uc13c\ub2e4.<\/li>\n
      14. IF: \ub17c\ub9ac\uc801 \ud14c\uc2a4\ud2b8\ub97c \uc218\ud589\ud558\uace0 \uc870\uac74\uc5d0 \ub530\ub77c \uacb0\uacfc\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n
      15. MAX: \uc140 \ubc94\uc704\uc5d0\uc11c \uac00\uc7a5 \ud070 \uac12\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/li>\n
      16. MIN: \uc140 \ubc94\uc704\uc5d0\uc11c \uac00\uc7a5 \uc791\uc740 \uac12\uc744 \uc785\ub825\ud569\ub2c8\ub2e4.<\/li>\n
      17. \ub0a0\uc9dc: \ud604\uc7ac \ub0a0\uc9dc\ub97c \uc140\uc5d0 \uc0bd\uc785\ud569\ub2c8\ub2e4.<\/li>\n
      18. VLOOKUP: \uc0ac\uc6a9\uc790\uac00 \uc815\uc758\ud55c \uae30\uc900\uc5d0 \ub530\ub77c \uc140\uc758 \uac12\uc744 \uc870\ud68c\ud558\uc5ec \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n
      19. HLOOKUP: \uc0ac\uc6a9\uc790 \uc815\uc758 \uae30\uc900\uc5d0 \ub530\ub77c \uc140 \uac12\uc744 \uc870\ud68c\ud558\uc5ec \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n
      20. \uc5f0\uacb0: \ub450 \uac1c \uc774\uc0c1\uc758 \uc140 \ub0b4\uc6a9\uc744 \ubcd1\ud569\ud569\ub2c8\ub2e4.<\/div><\/div><\/div><\/li>\n<\/ol>","protected":false},"excerpt":{"rendered":"

        Excel is a powerful spreadsheet software that is widely used in the business world to manage data, perform calculations, and create visual representations of information. One of the key features of Excel is its ability to use formulas to perform complex calculations automatically.\u00a0 Excel formulas are an extremely helpful instrument for anyone, whether they work<\/p>","protected":false},"author":2,"featured_media":14161,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[426,1870],"tags":[701],"class_list":{"0":"post-14160","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-tech-software","8":"category-datacamp","9":"tag-excel-formulas"},"_links":{"self":[{"href":"https:\/\/savewithnerds.com\/kr\/wp-json\/wp\/v2\/posts\/14160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savewithnerds.com\/kr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savewithnerds.com\/kr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savewithnerds.com\/kr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/savewithnerds.com\/kr\/wp-json\/wp\/v2\/comments?post=14160"}],"version-history":[{"count":0,"href":"https:\/\/savewithnerds.com\/kr\/wp-json\/wp\/v2\/posts\/14160\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/savewithnerds.com\/kr\/wp-json\/wp\/v2\/media\/14161"}],"wp:attachment":[{"href":"https:\/\/savewithnerds.com\/kr\/wp-json\/wp\/v2\/media?parent=14160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savewithnerds.com\/kr\/wp-json\/wp\/v2\/categories?post=14160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savewithnerds.com\/kr\/wp-json\/wp\/v2\/tags?post=14160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}