{"id":30755,"date":"2026-02-07T09:00:55","date_gmt":"2026-02-07T00:00:55","guid":{"rendered":"https:\/\/blog.agentsoft.co.kr\/index.php\/2026\/02\/07\/30755\/"},"modified":"2026-02-07T09:00:55","modified_gmt":"2026-02-07T00:00:55","slug":"%ec%bb%b4%ed%93%a8%ed%84%b0-%ed%99%9c%ec%9a%a9-%eb%8a%a5%eb%a0%a5-1%ea%b8%89-%ec%97%91%ec%85%80-%ed%95%a8%ec%88%98-%ec%a0%95%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/blog.agentsoft.co.kr\/index.php\/2026\/02\/07\/30755\/","title":{"rendered":"\ucef4\ud4e8\ud130 \ud65c\uc6a9 \ub2a5\ub825 1\uae09 \uc5d1\uc140 \ud568\uc218 \uc815\ub9ac"},"content":{"rendered":"<p><img decoding=\"async\" src=\"https:\/\/image4.happycampus.com\/Production\/thumbnail\/2024\/04\/23\/data29772547-0001.jpg\"><img decoding=\"async\" src=\"https:\/\/image4.happycampus.com\/Production\/thumbnail\/2024\/04\/23\/data29772547-0002.jpg\"><\/p>\n<p><strong>\ubaa9\ucc28<\/strong><\/p>\n<p>\uc5c6\uc74c<\/p>\n<p><strong>\ubcf8\ubb38\ub0b4\uc6a9<\/strong><\/p>\n<p>* \uc218\ud559\/\uc0bc\uac01 \ud568\uc218<br \/>\n1. SUM(\uac121, \uac122, &#8230;): \ud569\uacc4<br \/>\n2. SUMIF(\uc870\uac74\uac80\uc0c9\ubc94\uc704, \uac80\uc0c9\uc870\uac74, \ud569\uacc4\uacc4\uc0b0\ubc94\uc704): \uc870\uac74\uc5d0 \ub9de\ub294 \ud569\uacc4<br \/>\n3. SUMIFS(\ud569\uacc4\uacc4\uc0b0\ubc94\uc704, \uc870\uac74\uac80\uc0c9\ubc94\uc7041, \uc870\uac741, \uc870\uac74\uac80\uc0c9\ubc94\uc7042, \uc870\uac742, &#8230;): \uc870\uac74\uc2dd\ub4e4\uc5d0 \ub9de\ub294 \ud569\uacc4<br \/>\n4. ROUND(\uc218\uce58, \uc790\ub9ac\uc218): \ubc18\uc62c\ub9bc<br \/>\n5. ROUNDUP(\uc218\uce58, \uc790\ub9ac\uc218): \uc62c\ub9bc<br \/>\n6. ROUNDDOWN(\uc218\uce58, \uc790\ub9ac\uc218): \ub0b4\ub9bc<br \/>\n7. ABS(\uc218\uce58): \uc808\ub313\uac12<br \/>\n8. MOD(\ud53c\uc81c\uc218, \uc81c\uc218): \ub098\uba38\uc9c0<br \/>\n9. TRUNC(\uc218\uce58, \uc790\ub9ac\uc218): \ubc84\ub9bc<br \/>\n10. INT(\uc218\uce58): \uc815\uc218\uac12<br \/>\n11. SQRT(\uc218\uce58): \uc81c\uacf1\uae09<br \/>\n12. FACT(\uc218\uce58): !\uac12<br \/>\n13. POWER(\ubc11\uc218, \uc9c0\uc218): \uc9c0\uc218\uc2b9<br \/>\n14. EXP(\uc218\uce58): \uc790\uc5f0\ub85c\uadf8(e)\ub97c \uc218\uce58\ub9cc\ud07c \uacf1\ud568<br \/>\n15. PI( ): \u213c<br \/>\n16. RAND( ): 0\uacfc 1\uc0ac\uc774 \uac12 \uc911\uc5d0\uc11c \ub79c\ub364\uc73c\ub85c \uacc4\uc0b0<br \/>\n17. PRODUCT(\uac121, \uac122, &#8230;): \uac12\uc744 \ubaa8\ub450 \uacf1\ud568<br \/>\n18. SUMPRODUCT(\ubc30\uc5f41, \ubc30\uc5f42): \ubc30\uc5f4\uc5d0\uc11c \ud574\ub2f9 \uc694\uc18c\ub97c \ubaa8\ub450 \uacf1\ud55c \ud6c4 \uadf8 \uacf1\uc758 \ud569\uacc4<br \/>\n19. QUOTINENT(\ud53c\uc81c\uc218, \uc81c\uc218): \ub098\ub217\uc148 \ubaab\uc758 \uc815\uc218\ubd80\ubd84(\ub098\uba38\uc9c0\ub294 \ubc84\ub9bc)<\/p>\n<p>\ucd9c\ucc98 : <a href=\"https:\/\/www.happycampus.com\/report-doc\/29772547\/\" target=\"_blank\">\ud574\ud53c\ucea0\ud37c\uc2a4<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ubaa9\ucc28 \uc5c6\uc74c \ubcf8\ubb38\ub0b4\uc6a9 * \uc218\ud559\/\uc0bc\uac01 \ud568\uc218 1. SUM(\uac121, \uac122, &#8230;): \ud569\uacc4 2. SUMIF(\uc870\uac74\uac80\uc0c9\ubc94\uc704, \uac80\uc0c9\uc870\uac74, \ud569\uacc4\uacc4\uc0b0\ubc94\uc704): \uc870\uac74\uc5d0 \ub9de\ub294 \ud569\uacc4 3. SUMIFS(\ud569\uacc4\uacc4\uc0b0\ubc94\uc704, \uc870\uac74\uac80\uc0c9\ubc94\uc7041, \uc870\uac741, \uc870\uac74\uac80\uc0c9\ubc94\uc7042, \uc870\uac742, &#8230;): \uc870\uac74\uc2dd\ub4e4\uc5d0 \ub9de\ub294 \ud569\uacc4 4. ROUND(\uc218\uce58, \uc790\ub9ac\uc218): \ubc18\uc62c\ub9bc 5. ROUNDUP(\uc218\uce58, \uc790\ub9ac\uc218): \uc62c\ub9bc 6. ROUNDDOWN(\uc218\uce58, \uc790\ub9ac\uc218): \ub0b4\ub9bc 7. ABS(\uc218\uce58): \uc808\ub313\uac12 8. MOD(\ud53c\uc81c\uc218, \uc81c\uc218): \ub098\uba38\uc9c0 9. TRUNC(\uc218\uce58, \uc790\ub9ac\uc218): \ubc84\ub9bc 10. INT(\uc218\uce58): \uc815\uc218\uac12 11. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[26158,38433,27028,28993,5982,38432,38431],"class_list":["post-30755","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-26158","tag-excel","tag-pos","tag-28993","tag-5982","tag-38432","tag-38431"],"_links":{"self":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/posts\/30755","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/comments?post=30755"}],"version-history":[{"count":0,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/posts\/30755\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/media?parent=30755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/categories?post=30755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/tags?post=30755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}