{"id":14495,"date":"2023-01-19T10:22:03","date_gmt":"2023-01-19T01:22:03","guid":{"rendered":"https:\/\/www.eformsign.com\/kr\/blog\/?p=14495"},"modified":"2023-02-09T10:56:29","modified_gmt":"2023-02-09T01:56:29","slug":"how-to-use-excel-formulas-and-functions-in-eformsign","status":"publish","type":"post","link":"https:\/\/www.eformsign.com\/kr\/blog\/how-to-use-excel-formulas-and-functions-in-eformsign\/","title":{"rendered":"\uc5d1\uc140 \uc218\uc2dd \ubc0f \ud568\uc218 \ud65c\uc6a9\ubc95"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"1146\" height=\"607\" src=\"https:\/\/www.eformsign.com\/kr\/blog\/wp-content\/uploads\/sites\/2\/2023\/01\/\ube14\ub85c\uadf8\uc378\ub124\uc77c_\uc5d1\uc140\uc218\uc2dd\ud568\uc218\ud65c\uc6a9\ubc95_kr.png\" alt=\"\" class=\"wp-image-14572\" \/><\/figure>\n\n\n\n<p>\uc5d1\uc140 \uc218\uc2dd\uacfc \ud568\uc218\ub97c \ud65c\uc6a9\ud558\uba74 \ubcf5\uc7a1\ud55c \uacc4\uc0b0\uc744 \ub2e8\uc21c\ud654\ud558\uace0 \ubc18\ubcf5 \uc791\uc5c5\uc744 \uc790\ub3d9\ud654\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 \uc0ac\ub0b4 \ubaa8\ub4e0 \ubd80\uc11c\/\ud300\uc5d0\uc11c \ub370\uc774\ud130 \uad00\ub9ac \ubc0f \ubd84\uc11d \uc2dc \uc5d1\uc140\uc744 \ub9ce\uc774 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uc804\uc790\ubb38\uc11c\ub97c \ub9cc\ub4e4\ub54c\ub3c4 \uc5d1\uc140 \uc218\uc2dd\uacfc \ud568\uc218\ub97c \uadf8\ub300\ub85c \uc801\uc6a9\ud560 \uc218 \uc788\ub2e4\uba74 \uad49\uc7a5\ud788 \ud6a8\uc728\uc801\uc774\uaca0\uc8e0? \uc774\ud3fc\uc0ac\uc778\uc5d0\uc11c\ub294 \uc218\uc2dd\uacfc \ud568\uc218\uac00 \uc801\uc6a9\ub41c \uc5d1\uc140 \ud30c\uc77c\uc744 \uadf8\ub300\ub85c \uc804\uc790\ubb38\uc11c \ud15c\ud50c\ub9bf\uc73c\ub85c \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc740 \uc774\ud3fc\uc0ac\uc778\uc5d0\uc11c\ub9cc \uc720\uc77c\ud558\uac8c \uc81c\uacf5\ud558\ub294 \uae30\ub2a5\uc785\ub2c8\ub2e4. ? <\/p>\n\n\n\n<p>\uc774\ud3fc\uc0ac\uc778\uc758 \uac15\ub825\ud55c \uae30\ub2a5 \uc911 \ud558\ub098\uc778 <strong>\uc774\ud3fc\uc0ac\uc778 Microsoft Office Add-in<\/strong>\uc744 \uc0ac\uc6a9\ud558\uba74 \uc5d1\uc140 \uc218\uc2dd\/\ud568\uc218\ub97c \uc801\uc6a9\ud55c \ubb38\uc11c\ub97c \uc27d\uac8c \uc804\uc790\ubb38\uc11c\ub85c \ub9cc\ub4e4\uc5b4 \uc774\ud3fc\uc0ac\uc778\uc5d0 \uc5c5\ub85c\ub4dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\ubc88 \ube14\ub85c\uadf8\uc5d0\uc11c\ub294 \uc5d1\uc140 \ud568\uc218\/\uc218\uc2dd\uc774 \uc801\uc6a9\ub41c \ud15c\ud50c\ub9bf\uc744 \ub9cc\ub4dc\ub294 \ubc29\ubc95\uc744 \uac04\ub2e8\ud55c \uc608\uc81c\ub97c \ud1b5\ud574 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>\uc608\uc81c: \uc544\ub798 \ud68c\uc6d0 \uac00\uc785 \uc2e0\uccad\uc11c\uc5d0 \ub450 \uac1c\uc758 \uc785\ub825 \ud56d\ubaa9\uc758 \uac12 \uc989, <strong>\ud68c\uc6d0 \uac00\uc785\ube44\uc640 \uce74\ub4dc \ubc1c\uae09\ube44\uc758 \ud569\uacc4(\ucd1d \uae08\uc561)<\/strong>\uc744 \uad6c\ud558\ub294 \uac04\ub2e8\ud55c \uc218\uc2dd\uc744 \uc801\uc6a9\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p><\/blockquote>\n\n\n\n<h2><strong>\uc0ac\uc6a9 \ubc29\ubc95:<\/strong><\/h2>\n\n\n\n<p>1. \uc774\ud3fc\uc0ac\uc778 Microsoft Office Add-in\uc744 <a href=\"https:\/\/manual-kr.eformsign.com\/help\/chapter5.html#id1\">\ub2e4\uc6b4\ub85c\ub4dc \ubc0f \uc124\uce58\ud569\ub2c8\ub2e4<\/a>.<\/p>\n\n\n\n<p>2. \uc5d1\uc140\ub85c \ub9cc\ub4e0 \ud30c\uc77c\uc744 \uc5fd\ub2c8\ub2e4. (\uc608\uc81c\uc5d0\uc11c\ub294 &#8216;\ud68c\uc6d0 \uac00\uc785 \uc2e0\uccad\uc11c&#8217; \uc0ac\uc6a9)<\/p>\n\n\n\n<p>3. \uc5d1\uc140 \ub9ac\ubcf8 \uba54\ub274\uc5d0\uc11c OZ in Office \ud0ed\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<p>4. \uac01 \uc140\uc5d0 \ud574\ub2f9\ud558\ub294 \uc785\ub825\ud56d\ubaa9\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>5. \uc218\uc2dd\uc744 \uc785\ub825\ud560 \uc785\ub825\ud56d\ubaa9(\uc140)\uc744 \ud074\ub9ad\ud558\uace0 \uc6b0\uce21 \uc18d\uc131\ucc3d\uc5d0\uc11c \uc785\ub825\ud56d\ubaa9\uc758 ID(ex. \ucd1d \uae08\uc561)\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><img loading=\"lazy\" width=\"1920\" height=\"1458\" src=\"https:\/\/www.eformsign.com\/kr\/blog\/wp-content\/uploads\/sites\/2\/2023\/01\/excel-formula-kr-take-2_part-1-2.gif\" alt=\"\" data-id=\"14552\" data-link=\"https:\/\/www.eformsign.com\/kr\/blog\/?attachment_id=14552\" class=\"wp-image-14552\" \/><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p>6.<strong> \ucd1d \uae08\uc561<\/strong> \uc140\uc774 \uc120\ud0dd\ub41c \uc0c1\ud0dc\uc5d0\uc11c <span style=\"font-size: revert;color: initial\">\ud654\uba74 \uc0c1\ub2e8\uc758 \uc218\uc2dd \uc785\ub825\uc904\uc5d0 \uc218\uc2dd\uc744 \uc785\ub825\ud569\ub2c8\ub2e4. <\/span>\uc774 \uc608\uc81c\uc5d0\uc11c\ub294 \uc140 C15( \ud68c\uc6d0 \uac00\uc785\ube44)\uc640 \uc140 C17(\uce74\ub4dc \ubc1c\uae09\ube44)\uc758 \ud569\uacc4\uac00 \ucd1d \uae08\uc561 \uc140\uc5d0 \uc790\ub3d9 \uacc4\uc0b0\ub418\ub3c4\ub85d <span style=\"font-size: revert;color: initial\">\uc218\uc2dd \uc785\ub825\uc904<\/span>\uc5d0 &#8220;=C15+C17&#8243;\ub97c \uc785\ub825\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"1920\" height=\"1458\" src=\"https:\/\/www.eformsign.com\/kr\/blog\/wp-content\/uploads\/sites\/2\/2023\/01\/excel-formula-kr-take-2_part-2-2.gif\" alt=\"\" class=\"wp-image-14553\" \/><\/figure>\n\n\n\n<p>7. <strong>\uc2e4\ud589<\/strong>\uc744 \ud074\ub9ad\ud574 \ubbf8\ub9ac\ubcf4\uae30\ub85c \ubb38\uc11c\uc5d0 \uac12\uc774 \uc81c\ub300\ub85c \uc785\ub825\ub418\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4. <strong>\ud68c\uc6d0 \uac00\uc785\ube44<\/strong>\uc640 <strong>\uce74\ub4dc \ubc1c\uae09\ube44<\/strong>\uc5d0 \uc785\ub825\ud55c \uac12\uc758 \ud569\uacc4\uac00 <strong>\ucd1d \uae08\uc561<\/strong>\uc5d0 \uc798 \uc785\ub825\ub418\ub294\uc9c0 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"1920\" height=\"1458\" src=\"https:\/\/www.eformsign.com\/kr\/blog\/wp-content\/uploads\/sites\/2\/2023\/01\/excel-formula-kr-take-2_part-3-3.gif\" alt=\"\" class=\"wp-image-14554\" \/><\/figure>\n\n\n\n<p>8. <strong>\uc5c5\ub85c\ub4dc<\/strong> \ubc84\ud2bc\uc744 \ud074\ub9ad\ud574 \uc774\ud3fc\uc0ac\uc778\uc5d0 Excel \uc218\uc2dd\/\ud568\uc218\uac00 \uc801\uc6a9\ub41c \uc11c\uc2dd\uc744 \ud15c\ud50c\ub9bf\uc73c\ub85c \uc5c5\ub85c\ub4dc\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"1920\" height=\"1458\" src=\"https:\/\/www.eformsign.com\/kr\/blog\/wp-content\/uploads\/sites\/2\/2023\/01\/excel-formula-kr-take-2_part-4-1.gif\" alt=\"\" class=\"wp-image-14555\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group has-background\" style=\"background-color:#daf1e8\"><div class=\"wp-block-group__inner-container\">\n<p class=\"has-medium-font-size\">?<strong>\uc774\ud3fc\uc0ac\uc778\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 \uc5d1\uc140 \uc218\uc2dd \ubc0f \ud568\uc218<\/strong><\/p>\n\n\n\n<p>\uc774\ud3fc\uc0ac\uc778\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 \ubaa8\ub4e0 \uc5d1\uc140 \uc218\uc2dd\uacfc \ud568\uc218\ub294 \ubaa8\ub450 \uc704 \uc608\uc81c\uc640 \ub3d9\uc77c\ud55c \ubc29\ubc95\uc73c\ub85c \uc801\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ud3fc\uc0ac\uc778\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 \uc5d1\uc140 \uc218\uc2dd\uacfc \ud568\uc218\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<ul><li>\uc0ac\uce59\uc5f0\uc0b0<\/li><li>\uc5f0\uc0b0\uc758 \uc6b0\uc120\uc21c\uc704<\/li><li>\ubd80\ud638<\/li><li>\uc140 \ucc38\uc870<\/li><li>\ub17c\ub9ac\ud568\uc218: IF, AND, OR, IFS<\/li><li>\uc218\ud559\/\uc0bc\uac01\ud568\uc218: ABS, MOD, PI, RADIANS, ROUND, ROUNDDOWN, ROUNDUP, SUM, TRUNC, SIN, COS, TAN<\/li><li>\ud1b5\uacc4\ud568\uc218: AVERAGE, COUNT, COUNTA, MAX, MIN<\/li><li>\ubb38\uc790\uc5f4\uc870\uc791\ud568\uc218: LEFT, MID, RIGHT, LEN, LOWER, UPPER, SEARCH<\/li><li>\uac80\uc0c9\/\ud589\ub82c\ud568\uc218: MATCH, HLOOKUP, VLOOKUP<\/li><\/ul>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\uc5d1\uc140 \uc218\uc2dd\uacfc \ud568\uc218\ub97c \ud65c\uc6a9\ud558\uba74 \ubcf5\uc7a1\ud55c \uacc4\uc0b0\uc744 \ub2e8\uc21c\ud654\ud558\uace0 \ubc18\ubcf5 \uc791\uc5c5\uc744 \uc790\ub3d9\ud654\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 \uc0ac\ub0b4 \ubaa8\ub4e0 \ubd80\uc11c\/\ud300\uc5d0\uc11c \ub370\uc774\ud130 \uad00\ub9ac \ubc0f \ubd84\uc11d \uc2dc \uc5d1\uc140\uc744 \ub9ce\uc774 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc804\uc790\ubb38\uc11c\ub97c \ub9cc\ub4e4\ub54c\ub3c4 \uc5d1\uc140 \uc218\uc2dd\uacfc \ud568\uc218\ub97c \uadf8\ub300\ub85c \uc801\uc6a9\ud560 \uc218 \uc788\ub2e4\uba74 \uad49\uc7a5\ud788 \ud6a8\uc728\uc801\uc774\uaca0\uc8e0? \uc774\ud3fc\uc0ac\uc778\uc5d0\uc11c\ub294 \uc218\uc2dd\uacfc \ud568\uc218\uac00 \uc801\uc6a9\ub41c \uc5d1\uc140 \ud30c\uc77c\uc744 \uadf8\ub300\ub85c \uc804\uc790\ubb38\uc11c \ud15c\ud50c\ub9bf\uc73c\ub85c \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc740 \uc774\ud3fc\uc0ac\uc778\uc5d0\uc11c\ub9cc \uc720\uc77c\ud558\uac8c \uc81c\uacf5\ud558\ub294 \uae30\ub2a5\uc785\ub2c8\ub2e4. ? \uc774\ud3fc\uc0ac\uc778\uc758 [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":14572,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[269],"tags":[],"_links":{"self":[{"href":"https:\/\/www.eformsign.com\/kr\/blog\/wp-json\/wp\/v2\/posts\/14495"}],"collection":[{"href":"https:\/\/www.eformsign.com\/kr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.eformsign.com\/kr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.eformsign.com\/kr\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.eformsign.com\/kr\/blog\/wp-json\/wp\/v2\/comments?post=14495"}],"version-history":[{"count":32,"href":"https:\/\/www.eformsign.com\/kr\/blog\/wp-json\/wp\/v2\/posts\/14495\/revisions"}],"predecessor-version":[{"id":14573,"href":"https:\/\/www.eformsign.com\/kr\/blog\/wp-json\/wp\/v2\/posts\/14495\/revisions\/14573"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.eformsign.com\/kr\/blog\/wp-json\/wp\/v2\/media\/14572"}],"wp:attachment":[{"href":"https:\/\/www.eformsign.com\/kr\/blog\/wp-json\/wp\/v2\/media?parent=14495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.eformsign.com\/kr\/blog\/wp-json\/wp\/v2\/categories?post=14495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.eformsign.com\/kr\/blog\/wp-json\/wp\/v2\/tags?post=14495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}