{"id":545,"date":"2022-09-30T00:15:02","date_gmt":"2022-09-29T15:15:02","guid":{"rendered":"https:\/\/chaerang.net\/?p=545"},"modified":"2022-09-30T00:15:02","modified_gmt":"2022-09-29T15:15:02","slug":"itq%ec%97%91%ec%85%80-%ec%a0%9c1%ec%9e%91%ec%97%85-%ed%91%9c%ec%84%9c%ec%8b%9d-%ec%9e%91%ec%84%b1-%eb%b0%8f-%ea%b0%92%ea%b3%84%ec%82%b0-4-countif%ed%95%a8%ec%88%98-round%ed%95%a8%ec%88%98-sumi","status":"publish","type":"post","link":"https:\/\/chaerang.net\/?p=545","title":{"rendered":"ITQ\uc5d1\uc140 – \uc81c1\uc791\uc5c5 \ud45c\uc11c\uc2dd \uc791\uc131 \ubc0f \uac12\uacc4\uc0b0 – (4) COUNTIF\ud568\uc218, ROUND\ud568\uc218, SUMIF\ud568\uc218"},"content":{"rendered":"\n

\uc548\ub155\ud558\uc138\uc694? \uc6c3\ub294 \uc0ac\uc790\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc5b4\uc81c\uc5d0 \uc774\uc5b4 \uc624\ub298\ub3c4 \ube44\uac00 \ub0b4\ub9ac\ub2e4\uac00 \ub9d0\ub2e4\uac00 \ud558\ub124\uc694. <\/p>\n\n\n\n

\uc544\uc774\uac00 \uc544\uce68\ubd80\ud130 \ub2a6\uc7a5\uc744 \ubd80\ub9ac\ub354\ub2c8 \uacb0\uad6d\uc5d4 \ucc28\ub97c \ubab0\uace0 \ub4f1\uad50\ub97c \ud588\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc624\ub79c\ub9cc\uc5d0 \uc544\uce68\ubd80\ud130 \uc6b4\uc804\uc744 \ud588\ub124\uc694.. <\/p>\n\n\n\n

\ub0b4\uc77c\uc740 \ub354 \uc77c\ucc0d \uc77c\uc5b4\ub098\ub77c\uace0 \ub2e5\ub2ec\uc744 \ud574\ubd10\uc57c\uaca0\ub124\uc694. \uc77c\ucc0d\uc880 \uc790\ub77c\ub2c8\uae4c \u3161\u3161;;;;<\/p>\n\n\n\n

\uadf8\ub7fc ITQ\uc5d1\uc140 \uacf5\ubd80 \uc2dc\uc791\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc9c0\uae08 \uc6b0\ub9ac\uac00 \uacf5\ubd80\ud558\uace0\uc788\ub294 \uac83\uc740 ITQ\uc5d1\uc140 \uae30\ucd9c \ubb38\uc81c\uc911\uc5d0 2021109\ud68c\ucc28 A\ud615 \ubb38\uc81c<\/strong>\uc785\ub2c8\ub2e4. <\/p>\n\n\n\n

 \uc870\uac74\uc744 \uc0b4\ud3b4\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

3) \uc544\uc774\ubc18\ucc2c\uc758 \uac1c\uc218 : \ubd84\ub958\uac00 \uc544\uc774\ubc18\ucc2c\uc778 \ubc18\ucc2c\uc758 \uac1c\uc218\ub97c \uad6c\ud558\uc2dc\uc624 COUNTIF\ud568\uc218<\/p>\n\n\n\n

\ub77c\uace0 \ub418\uc5b4\uc788\ub294\ub370\uc694. \uadf8\ub7fc COUNTIF\ud568\uc218\uc5d0 \uad00\ud574 \uc54c\uc544\uc57c\uaca0\uc8e0 ^^<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

\uc774\ub807\uac8c \ud574\uacb0\ud560 \uc218 \uac00 \uc788\ub294\ub370\uc694! \uc124\uba85\uc774 \uc26c\uc6e0\ub098 \uc5b4\ub824\uc6e0\ub098 \ubaa8\ub974\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc5ec\uae30\uc11c \uc911\uc694\ud55c \uae30\ub2a5\uc774 \ud558\ub098 \uc788\ub294\ub370\uc694 \ub9cc\uc57d!!! <\/p>\n\n\n\n

\ubb38\uc81c\uac00 \ubc18\ucc2c\uba85\uc5d0\uc11c \ubcf6\uc74c\uc758 \uac1c\uc218\ub97c \uc138\uc5b4\uc918?<\/strong> \ub77c\uace0 \ubb38\uc81c\uac00 \ub098\uc654\ub2e4\uba74!!! \uc5b4\ub5bb\uac8c \ud574\uacb0\ud558\uc2dc\uaca0\uc5b4\uc694?<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

\uc5b4 \ubb38\uc81c\ub97c \ubcf4\ub2c8 \ubcf6\uc74c\uc55e\uc5d0 \uae00\uc790\uac00 \uba78\uce58\ub3c4 \uc788\uace0 \uac10\uc790\ud584\ub3c4 \uc788\ub294\ub370 \ub2f5\uc774 2\uac00 \ub098\uc640\uc57c\ud558\ub294\uac74 \uc54c\uaca0\ub294\ub370 \uc5b4\ub5bb\uac8c \ud558\uc9c0?<\/p>\n\n\n\n

\ub77c\uace0 \uc758\ubb38\uc774 \uc0dd\uacbc\uc744 \uac83\uc785\ub2c8\ub2e4. <\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

\uac04\ub2e8\ud558\uac8c * \uc744 \uc774\uc6a9\ud558\uba74\ub429\ub2c8\ub2e4.<\/strong> \ud0a4\ubcf4\ub4dc \uc790\ud310\uc758 \uc22b\uc790 8\ubc88\uc5d0 \uc788\ub294 * <\/p>\n\n\n\n

\uc774\uc544\uc774\ub294 \ubaa8\ub4e0 \uae00\uc790<\/strong>\ub97c \ub73b\ud569\ub2c8\ub2e4. \uba87\uae00\uc790\ub4e0 \uc0c1\uad00\uc5c6\uc774 \uc5ec\ub7ec\uae00\uc790<\/strong>\ub97c \ub73b\ud558\ub294\uac70\uc8e0.<\/p>\n\n\n\n

\uadf8\ub798\uc11c *\uc744 \ubd99\uc774\uace0 \ub4a4\uc5d0 \ubcf6\uc74c\uc774\ub77c\ub294 \uae00\uc790\ub97c \uc368\uc900\uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uac04\ub2e8\ud558\uc8e0 ^^ \uc54c\uba74\uc27d\uace0 \ubaa8\ub974\uba74 \ud55c\uc5c6\uc774 \uc5b4\ub824\uc6b4 \uc544\uc774\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\ud568\uc218\uac00 \uc810\uc810 \uc7ac\ubbf8\uc788\uc5b4\uc9c0\uace0 \uc54c\uba74 \uc54c\uc218\ub85d \uac04\ub2e8\ud574 \uc9c0\uace0\uc788\uc8e0?<\/p>\n\n\n\n

\uadf8\ub7fc \ub2e4\uc74c\uc870\uac74\uc744 \uc0b4\ud3b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

4) \ubc11\ubc18\ucc2c \ud310\ub9e4\ub300\uae08(\ub2e8\uc704:\uc6d0)\uc758 \ud569\uacc4: \ubc18\uc62c\ub9bc\ud558\uc5ec \ucc9c\uc6d0\ub2e8\uc704\uae4c\uc9c0 \uad6c\ud558\uc2dc\uc624.<\/p>\n\n\n\n

    (ROUND\ud568\uc218, SUMIF\ud568\uc218) \uacb0\uacfc\uc758 \uc608\ub97c \ub4e4\uba74 1,723,500–>1,724,000 \uc774 \ub418\uc5b4\uc57c\ud55c\ub2e4.<\/p>\n\n\n\n

\uc790 \uadf8\ub7ec\uba74 \uc77c\ub2e8 ROUND\ud568\uc218\uc5d0 \uad00\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\ud55c\ub9c8\ub514\ub85c \ubc18\uc62c\ub9bc \ud568\uc218\uc778\ub370\uc694. \uc774\uc544\uc774\ub3c4 \uc885\ub958\uac00 \uc5ec\ub7ec\uac00\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4. ROUNDUP\ud568\uc218, ROUNDDOWN\ud568\uc218, ROUND\ud568\uc218 \uc774\ub807\uac8c 3\uc885\ub958\uc778\ub370\uc694. ROUNDUP\ud568\uc218\ub294 \uc62c\ub9bc\ud574\ub77c! ROUNDDOWN\ud568\uc218\ub294 \ub0b4\ub9bc\/\ubc84\ub9bc\ud574\ub77c! ROUND\ud568\uc218\ub294 \ubc18\uc62c\ub9bc\ud574\ub77c!<\/strong> \uc774\ub7f0 \ud568\uc218 \uc785\ub2c8\ub2e4. \ub098\uc62c\ub54c \ub9c8\ub2e4 \uc124\uba85\uc744 \ud560\uac83\uc774\ubbc0\ub85c!!! \uc774\ubc88\uc5d4 \uadf8\ub0e5 ROUND\ud568\uc218\ub9cc \ub2e4\ub8e8\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

ROUND \ud568\uc218\ub294 \uc18c\uc218\uc810 \uc790\ub9ac\ub97c \ubc18\uc62c\ub9bc<\/strong>\ud558\ub294 \ud568\uc218\uc778\ub370\uc694 ^^<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

\uc5b4? 0\uacfc -1\uc758 \ucc28\uc774\uc810\uc740 \ubb54\uac00\uc694? \ub77c\uace0 \ubb3c\uc73c\uc2e4\ud150\ub370\uc694 0\uc740 \uae30\ubcf8\uac12\uc774\ub77c\uace0 \ubcf4\uc2dc\uba74\ub429\ub2c8\ub2e4.<\/strong><\/p>\n\n\n\n

=ROUND(4789.6587, ) << \uc774\ub7f0\uc2dd\uc73c\ub85c \uc544\ubb34\uac83\ub3c4 \uc785\ub825\ud558\uc9c0 \uc54a\uc558\uc744\ub54c\uc758 \uac12\uc774\ub77c\uace0 \ubcf4\uc2dc\uba74\ub429\ub2c8\ub2e4.<\/strong><\/p>\n\n\n\n

\ubb38\uc81c\uc5d0\uc11c \uacb0\uacfc\uc758 \uc608\ub97c \ub4e4\uba74 1,723,500–>1,724,000 \uc774 \ub418\uc5b4\uc57c\ud55c\ub2e4. \uadf8\ub7ec\ub2c8 \uc6b0\ub9ac\ub294 \ud568\uc218\uc758 num_digits \uc790\ub9ac\uc5d0 -3 \uc744<\/strong> \ub123\uc73c\uba74 \ub418\uaca0\uad70\uc694!!! \uc774\ub807\uac8c \ud574\uacb0\uc744 \ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uac04\ub2e8\ud558\uc8e0~<\/p>\n\n\n\n

\uc774\ubc88\uc5d0\ub294 SUMIF \ud568\uc218\uc5d0 \uad00\ud574 \uc124\uba85\uc744 \ud574\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

\ud55c\ub9c8\ub514\ub85c SUMIF\ud568\uc218\ub294 \uc870\uac74\uc5d0 \ub9de\ub294 \ud569\uc744 \uad6c\ud574\uc918 \ub77c\ub294 \uc758\ubbf8\uc785\ub2c8\ub2e4. \uadf8\ub798\uc11c \ud3b8\ub9ac\ud558\uac8c \uc0ac\uc6a9\ud560 \uc218\uac00 \uc788\uc8e0 ^^<\/p>\n\n\n\n

\uc81c\uac00 \uc27d\uac8c \uc124\uba85\uc744 \ud588\ub098 \ubaa8\ub974\uaca0\ub124\uc694. ^^ <\/p>\n\n\n\n

\ud558\ub098\ub354 \ubb38\uc81c\ub97c \uc81c\uc2dc \ud574 \ubcf4\uc790\uba74 \uac80\uc0c9\ud0dc\uadf8\uac00 \uc5b4\ub9b0\uc774\uc778 \uac83\uc758 \ud310\ub9e4\uc218\ub7c9\uc758 \ud569\uacc4\ub97c \uad6c\ud574\ub77c!!<\/p>\n\n\n\n

\uadf8\ub7fc =sumif(E5:E12,”\uc5b4\ub9b0\uc774”,G5:G12) << \uc774\ub807\uac8c \ud574\uacb0 \ud560 \uc218\uac00 \uc788\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc774\ud574\uac00 \ub418\uc5c8\ub2e4\uba74!!!!<\/p>\n\n\n\n

\ub4dc\uc774\uc5b4 \ubb38\uc81c\ub97c \ud480\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. ROUND\ud568\uc218\uc640 SUMIF\ud568\uc218 \uc774\ud574\uac00 \ud655\uc2e4\ud788 \ub418\uc168\uc8e0? ^^<\/p>\n\n\n\n

\uc870\uac74 \ubb38\uc81c : >>\ubc11\ubc18\ucc2c \ud310\ub9e4\ub300\uae08(\ub2e8\uc704:\uc6d0)\uc758 \ud569\uacc4: \ubc18\uc62c\ub9bc\ud558\uc5ec \ucc9c\uc6d0\ub2e8\uc704\uae4c\uc9c0 \uad6c\ud558\uc2dc\uc624.<\/p>\n\n\n\n

    (ROUND\ud568\uc218, SUMIF\ud568\uc218) \uacb0\uacfc\uc758 \uc608\ub97c \ub4e4\uba74 1,723,500–>1,724,000 \uc774 \ub418\uc5b4\uc57c\ud55c\ub2e4.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

\uac04\ub2e8\ud558\uac8c \uacb0\ub860\uc774 \ub3c4\ucd9c \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uadf8\ub7f0\ub370 \ubb38\uc81c\ub294 \uacb0\uacfc\uc778\ub370\uc694. \uacb0\uacfc\uc5d0 \ucc9c\ub2e8\uc704 \uad6c\ubd84\uae30\ud638\uac00 \uc785\ub825 \ub418\uc5b4\uc788\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc608\ub97c \ub4e4\uba74 \uac12\uc5d0 \ucc9c\ub2e8\uc704 \uad6c\ubd84\uae30\ud638\uac00 \ub4e4\uc5b4\uac00\uc788\uc73c\ub2c8\uae4c\uc694 ^^<\/p>\n\n\n\n

\uadf8\ub7fc \uc6b0\ub9ac\ub3c4 \ub123\uc5b4\uc8fc\uba74\ub418\uc8e0!!<\/p>\n\n\n\n

\uacb0\uacfc \uac12\uc758 \uc140\uc744 \ud074\ub9ad\ud558\uace0 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd\uc744 \ub20c\ub7ec\uc11c \uc140\uc11c\uc2dd\uc5d0 \ub4e4\uc5b4\uac11\ub2c8\ub2e4.<\/p>\n\n\n\n

\uadf8\ub9ac\uace0 \uc140\uc11c\uc2dd\uc5d0\uc11c \uc0ac\uc6a9\uc790 \uc9c0\uc815\uc5d0\uc11c #,##0\uc744 \uc120\ud0dd\ud558\uc2dc\uba74 \ucc9c\ub2e8\uc704 \uad6c\ubd84\uae30\ud638\uac00 \uc774\uc058\uac8c \ub4e4\uc5b4\uac11\ub2c8\ub2e4. \ucc38 \uc27d\uc8e0 ^^<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

\uc790 \uadf8\ub7fc \uc624\ub298 \uc624\uc804 \uc218\uc5c5\uc740 \uc774\uac83\uc73c\ub85c \ub9c8\uce58\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uac04\ub2e8\ud558\ub2c8 \uc5ec\ub7ec\uac00\uc9c0\ub85c \uc790\uae30 \uc790\uc2e0\uc774 \ubb38\uc81c\ub97c \ub9cc\ub4e4\uc5b4 \ud480\uc5b4\ubcf4\ub294 \uac83\ub3c4 \uc78a\uc9c0 \uc54a\ub294 \uc88b\uc740 \ubc29\ubc95\uc774\ub77c\uace0 \uc0dd\uac01\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

\ud798\ub0b4\uc2dc\uace0 \uc624\ub298\ub3c4 \ud589\ubcf5\ud55c \ud558\ub8e8 \ubcf4\ub0b4\uc138\uc694~~ ^^<\/p>\n\n\n

#countif<\/a>, <\/span>#excel<\/a>, <\/span>#ITQ<\/a>, <\/span>#round<\/a>, <\/span>#sumif<\/a>, <\/span>#\uae30\ucd9c\ubb38\uc81c<\/a>, <\/span>#\uae30\ucd9c\ud480\uc774<\/a>, <\/span>#\uc5d1\uc140<\/a><\/div>","protected":false},"excerpt":{"rendered":"

\uc548\ub155\ud558\uc138\uc694? \uc6c3\ub294 \uc0ac\uc790\uc785\ub2c8\ub2e4. \uc5b4\uc81c\uc5d0 \uc774\uc5b4 \uc624\ub298\ub3c4 \ube44\uac00 \ub0b4\ub9ac\ub2e4\uac00 \ub9d0\ub2e4\uac00 \ud558\ub124\uc694.  \uc544\uc774\uac00 \uc544\uce68\ubd80\ud130 \ub2a6\uc7a5\uc744 \ubd80\ub9ac\ub354\ub2c8 \uacb0\uad6d\uc5d4 \ucc28\ub97c \ubab0\uace0 \ub4f1\uad50\ub97c \ud588\uc2b5\ub2c8\ub2e4. \uc624\ub79c\ub9cc\uc5d0 \uc544\uce68\ubd80\ud130 \uc6b4\uc804\uc744 \ud588\ub124\uc694..  \ub0b4\uc77c\uc740 \ub354 \uc77c\ucc0d \uc77c\uc5b4\ub098\ub77c\uace0 \ub2e5\ub2ec\uc744 \ud574\ubd10\uc57c\uaca0\ub124\uc694. \uc77c\ucc0d\uc880 \uc790\ub77c\ub2c8\uae4c \u3161\u3161;;;; \uadf8\ub7fc ITQ\uc5d1\uc140 \uacf5\ubd80 \uc2dc\uc791\ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc9c0\uae08 \uc6b0\ub9ac\uac00 \uacf5\ubd80\ud558\uace0\uc788\ub294 \uac83\uc740 ITQ\uc5d1\uc140 \uae30\ucd9c \ubb38\uc81c\uc911\uc5d0 2021109\ud68c\ucc28 A\ud615 \ubb38\uc81c\uc785\ub2c8\ub2e4.   \uc870\uac74\uc744 \uc0b4\ud3b4\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. 3) \uc544\uc774\ubc18\ucc2c\uc758 \uac1c\uc218 : \ubd84\ub958\uac00 \uc544\uc774\ubc18\ucc2c\uc778 \ubc18\ucc2c\uc758 \uac1c\uc218\ub97c \uad6c\ud558\uc2dc\uc624 COUNTIF\ud568\uc218 \ub77c\uace0 \ub418\uc5b4\uc788\ub294\ub370\uc694. \uadf8\ub7fc COUNTIF\ud568\uc218\uc5d0 \uad00\ud574 \uc54c\uc544\uc57c\uaca0\uc8e0 ^^ \uc774\ub807\uac8c \ud574\uacb0\ud560 \uc218 \uac00 \uc788\ub294\ub370\uc694! \uc124\uba85\uc774 \uc26c\uc6e0\ub098 \uc5b4\ub824\uc6e0\ub098 \ubaa8\ub974\uaca0\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uc911\uc694\ud55c \uae30\ub2a5\uc774 \ud558\ub098 \uc788\ub294\ub370\uc694 \ub9cc\uc57d!!!  \ubb38\uc81c\uac00 \ubc18\ucc2c\uba85\uc5d0\uc11c \ubcf6\uc74c\uc758 \uac1c\uc218\ub97c \uc138\uc5b4\uc918? \ub77c\uace0 \ubb38\uc81c\uac00 \ub098\uc654\ub2e4\uba74!!! \uc5b4\ub5bb\uac8c \ud574\uacb0\ud558\uc2dc\uaca0\uc5b4\uc694? \uc5b4 \ubb38\uc81c\ub97c \ubcf4\ub2c8 \ubcf6\uc74c\uc55e\uc5d0 \uae00\uc790\uac00 \uba78\uce58\ub3c4 \uc788\uace0 \uac10\uc790\ud584\ub3c4 \uc788\ub294\ub370 \ub2f5\uc774 2\uac00 \ub098\uc640\uc57c\ud558\ub294\uac74 \uc54c\uaca0\ub294\ub370 \uc5b4\ub5bb\uac8c \ud558\uc9c0? \ub77c\uace0 \uc758\ubb38\uc774 \uc0dd\uacbc\uc744 \uac83\uc785\ub2c8\ub2e4.  \uac04\ub2e8\ud558\uac8c * \uc744 \uc774\uc6a9\ud558\uba74\ub429\ub2c8\ub2e4. \ud0a4\ubcf4\ub4dc \uc790\ud310\uc758 \uc22b\uc790 8\ubc88\uc5d0 \uc788\ub294 *  \uc774\uc544\uc774\ub294 \ubaa8\ub4e0 \uae00\uc790\ub97c \ub73b\ud569\ub2c8\ub2e4. \uba87\uae00\uc790\ub4e0 \uc0c1\uad00\uc5c6\uc774 \uc5ec\ub7ec\uae00\uc790\ub97c \ub73b\ud558\ub294\uac70\uc8e0. \uadf8\ub798\uc11c *\uc744 \ubd99\uc774\uace0 \ub4a4\uc5d0 \ubcf6\uc74c\uc774\ub77c\ub294 \uae00\uc790\ub97c \uc368\uc900\uac83\uc785\ub2c8\ub2e4. \uac04\ub2e8\ud558\uc8e0 ^^ \uc54c\uba74\uc27d\uace0 \ubaa8\ub974\uba74 \ud55c\uc5c6\uc774 \uc5b4\ub824\uc6b4 \uc544\uc774\uc600\uc2b5\ub2c8\ub2e4. \ud568\uc218\uac00 \uc810\uc810 \uc7ac\ubbf8\uc788\uc5b4\uc9c0\uace0 \uc54c\uba74 \uc54c\uc218\ub85d \uac04\ub2e8\ud574 \uc9c0\uace0\uc788\uc8e0? \uadf8\ub7fc \ub2e4\uc74c\uc870\uac74\uc744 \uc0b4\ud3b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. 4) \ubc11\ubc18\ucc2c \ud310\ub9e4\ub300\uae08(\ub2e8\uc704:\uc6d0)\uc758 \ud569\uacc4: \ubc18\uc62c\ub9bc\ud558\uc5ec \ucc9c\uc6d0\ub2e8\uc704\uae4c\uc9c0 \uad6c\ud558\uc2dc\uc624.     (ROUND\ud568\uc218, SUMIF\ud568\uc218) \uacb0\uacfc\uc758 \uc608\ub97c \ub4e4\uba74 1,723,500–>1,724,000 \uc774 \ub418\uc5b4\uc57c\ud55c\ub2e4. \uc790 \uadf8\ub7ec\uba74 \uc77c\ub2e8 ROUND\ud568\uc218\uc5d0 \uad00\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud55c\ub9c8\ub514\ub85c \ubc18\uc62c\ub9bc \ud568\uc218\uc778\ub370\uc694. \uc774\uc544\uc774\ub3c4 \uc885\ub958\uac00 \uc5ec\ub7ec\uac00\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4. ROUNDUP\ud568\uc218, ROUNDDOWN\ud568\uc218, ROUND\ud568\uc218 \uc774\ub807\uac8c 3\uc885\ub958\uc778\ub370\uc694. ROUNDUP\ud568\uc218\ub294 \uc62c\ub9bc\ud574\ub77c! ROUNDDOWN\ud568\uc218\ub294 \ub0b4\ub9bc\/\ubc84\ub9bc\ud574\ub77c! ROUND\ud568\uc218\ub294 \ubc18\uc62c\ub9bc\ud574\ub77c! \uc774\ub7f0 \ud568\uc218 \uc785\ub2c8\ub2e4. \ub098\uc62c\ub54c \ub9c8\ub2e4 \uc124\uba85\uc744 \ud560\uac83\uc774\ubbc0\ub85c!!! \uc774\ubc88\uc5d4 \uadf8\ub0e5 ROUND\ud568\uc218\ub9cc \ub2e4\ub8e8\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. ROUND \ud568\uc218\ub294 \uc18c\uc218\uc810 \uc790\ub9ac\ub97c \ubc18\uc62c\ub9bc\ud558\ub294 \ud568\uc218\uc778\ub370\uc694 ^^ \uc5b4? 0\uacfc -1\uc758 \ucc28\uc774\uc810\uc740 \ubb54\uac00\uc694? \ub77c\uace0 \ubb3c\uc73c\uc2e4\ud150\ub370\uc694 0\uc740 \uae30\ubcf8\uac12\uc774\ub77c\uace0 \ubcf4\uc2dc\uba74\ub429\ub2c8\ub2e4. =ROUND(4789.6587, ) << \uc774\ub7f0\uc2dd\uc73c\ub85c \uc544\ubb34\uac83\ub3c4 \uc785\ub825\ud558\uc9c0 \uc54a\uc558\uc744\ub54c\uc758 \uac12\uc774\ub77c\uace0 \ubcf4\uc2dc\uba74\ub429\ub2c8\ub2e4. \ubb38\uc81c\uc5d0\uc11c \uacb0\uacfc\uc758 \uc608\ub97c \ub4e4\uba74 1,723,500–>1,724,000 \uc774 \ub418\uc5b4\uc57c\ud55c\ub2e4. \uadf8\ub7ec\ub2c8 \uc6b0\ub9ac\ub294 \ud568\uc218\uc758 num_digits \uc790\ub9ac\uc5d0 -3 \uc744 \ub123\uc73c\uba74 \ub418\uaca0\uad70\uc694!!! \uc774\ub807\uac8c \ud574\uacb0\uc744 \ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uac04\ub2e8\ud558\uc8e0~ \uc774\ubc88\uc5d0\ub294 SUMIF \ud568\uc218\uc5d0 \uad00\ud574 \uc124\uba85\uc744 \ud574\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. \ud55c\ub9c8\ub514\ub85c SUMIF\ud568\uc218\ub294 \uc870\uac74\uc5d0 \ub9de\ub294 \ud569\uc744 \uad6c\ud574\uc918 \ub77c\ub294 \uc758\ubbf8\uc785\ub2c8\ub2e4. \uadf8\ub798\uc11c \ud3b8\ub9ac\ud558\uac8c \uc0ac\uc6a9\ud560 \uc218\uac00 \uc788\uc8e0 ^^ \uc81c\uac00 \uc27d\uac8c \uc124\uba85\uc744 \ud588\ub098 \ubaa8\ub974\uaca0\ub124\uc694. ^^  \ud558\ub098\ub354 \ubb38\uc81c\ub97c \uc81c\uc2dc \ud574 \ubcf4\uc790\uba74 \uac80\uc0c9\ud0dc\uadf8\uac00 \uc5b4\ub9b0\uc774\uc778 \uac83\uc758 \ud310\ub9e4\uc218\ub7c9\uc758 \ud569\uacc4\ub97c \uad6c\ud574\ub77c!! \uadf8\ub7fc =sumif(E5:E12,”\uc5b4\ub9b0\uc774”,G5:G12) << \uc774\ub807\uac8c \ud574\uacb0 \ud560 \uc218\uac00 \uc788\uaca0\uc2b5\ub2c8\ub2e4. \uc774\ud574\uac00 \ub418\uc5c8\ub2e4\uba74!!!! \ub4dc\uc774\uc5b4 \ubb38\uc81c\ub97c \ud480\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. ROUND\ud568\uc218\uc640 SUMIF\ud568\uc218 \uc774\ud574\uac00 \ud655\uc2e4\ud788 \ub418\uc168\uc8e0? ^^ \uc870\uac74 \ubb38\uc81c : >>\ubc11\ubc18\ucc2c \ud310\ub9e4\ub300\uae08(\ub2e8\uc704:\uc6d0)\uc758 \ud569\uacc4: \ubc18\uc62c\ub9bc\ud558\uc5ec \ucc9c\uc6d0\ub2e8\uc704\uae4c\uc9c0 \uad6c\ud558\uc2dc\uc624.     (ROUND\ud568\uc218, SUMIF\ud568\uc218) \uacb0\uacfc\uc758 \uc608\ub97c \ub4e4\uba74 1,723,500–>1,724,000 \uc774 \ub418\uc5b4\uc57c\ud55c\ub2e4. \uac04\ub2e8\ud558\uac8c \uacb0\ub860\uc774 \ub3c4\ucd9c \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uadf8\ub7f0\ub370 \ubb38\uc81c\ub294 \uacb0\uacfc\uc778\ub370\uc694. \uacb0\uacfc\uc5d0 \ucc9c\ub2e8\uc704 \uad6c\ubd84\uae30\ud638\uac00 \uc785\ub825 \ub418\uc5b4\uc788\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uba74 \uac12\uc5d0 \ucc9c\ub2e8\uc704 \uad6c\ubd84\uae30\ud638\uac00 \ub4e4\uc5b4\uac00\uc788\uc73c\ub2c8\uae4c\uc694 ^^ \uadf8\ub7fc \uc6b0\ub9ac\ub3c4 \ub123\uc5b4\uc8fc\uba74\ub418\uc8e0!! \uacb0\uacfc \uac12\uc758 \uc140\uc744 \ud074\ub9ad\ud558\uace0 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd\uc744 \ub20c\ub7ec\uc11c \uc140\uc11c\uc2dd\uc5d0 \ub4e4\uc5b4\uac11\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc140\uc11c\uc2dd\uc5d0\uc11c \uc0ac\uc6a9\uc790 \uc9c0\uc815\uc5d0\uc11c #,##0\uc744 \uc120\ud0dd\ud558\uc2dc\uba74 \ucc9c\ub2e8\uc704 \uad6c\ubd84\uae30\ud638\uac00 \uc774\uc058\uac8c \ub4e4\uc5b4\uac11\ub2c8\ub2e4. \ucc38 \uc27d\uc8e0 ^^ \uc790 \uadf8\ub7fc \uc624\ub298 \uc624\uc804 \uc218\uc5c5\uc740 \uc774\uac83\uc73c\ub85c \ub9c8\uce58\uaca0\uc2b5\ub2c8\ub2e4. \uac04\ub2e8\ud558\ub2c8 \uc5ec\ub7ec\uac00\uc9c0\ub85c \uc790\uae30 \uc790\uc2e0\uc774 \ubb38\uc81c\ub97c \ub9cc\ub4e4\uc5b4 \ud480\uc5b4\ubcf4\ub294 \uac83\ub3c4 \uc78a\uc9c0 \uc54a\ub294 \uc88b\uc740 \ubc29\ubc95\uc774\ub77c\uace0 \uc0dd\uac01\ud569\ub2c8\ub2e4. \ud798\ub0b4\uc2dc\uace0 \uc624\ub298\ub3c4 \ud589\ubcf5\ud55c \ud558\ub8e8 \ubcf4\ub0b4\uc138\uc694~~ ^^<\/p>\n","protected":false},"author":2,"featured_media":546,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[5],"tags":[90,52,19,91,92,21,22,51],"class_list":["post-545","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-itq-","tag-countif","tag-excel","tag-itq","tag-round","tag-sumif","tag-21","tag-22","tag-51"],"_links":{"self":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/545","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=545"}],"version-history":[{"count":1,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/545\/revisions"}],"predecessor-version":[{"id":547,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/545\/revisions\/547"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/media\/546"}],"wp:attachment":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}