{"id":19359,"date":"2023-12-05T13:22:31","date_gmt":"2023-12-05T13:22:31","guid":{"rendered":"https:\/\/masterskills.org\/blog\/ham-round-la-gi-huong-dan-don-gian-hoa-cach-su-dung-ham-round.html"},"modified":"2023-12-22T04:49:34","modified_gmt":"2023-12-21T21:49:34","slug":"ham-round-la-gi-huong-dan-don-gian-hoa-cach-su-dung-ham-round","status":"publish","type":"post","link":"https:\/\/masterskills.org\/blog\/ham-round-la-gi-huong-dan-don-gian-hoa-cach-su-dung-ham-round.html","title":{"rendered":"H\u00e0m Round l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn \u0111\u01a1n gi\u1ea3n h\u00f3a c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND"},"content":{"rendered":"
\n

H\u00e0m ROUND l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn \u0111\u01a1n gi\u1ea3n h\u00f3a c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND<\/span><\/h1>\n

Trong th\u1ebf gi\u1edbi s\u1ed1 h\u1ecdc v\u00e0 t\u00ednh to\u00e1n, vi\u1ec7c l\u00e0m tr\u00f2n s\u1ed1 l\u00e0 m\u1ed9t kh\u00eda c\u1ea1nh quan tr\u1ecdng. V\u00e0 \u0111\u1ec3 gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c n\u00e0y m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 ch\u00ednh x\u00e1c, Excel cung c\u1ea5p h\u00e0m ROUND – m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 theo c\u00e1c quy t\u1eafc nh\u1ea5t \u0111\u1ecbnh. Tr\u00ean b\u1ea5t k\u1ef3 phi\u00ean b\u1ea3n Excel n\u00e0o, h\u00e0m ROUND \u0111\u1ec1u c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u00e0 \u1ee9ng d\u1ee5ng trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p kh\u00e1c nhau. H\u00e3y c\u00f9ng Masterskillskh\u00e1m ph\u00e1 trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n

\u00a0<\/p>\n

\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m ROUND trong Excel l\u00e0 g\u00ec?<\/span><\/h2>\n
    \n<\/ul>\n

    : <\/span>H\u01b0\u1edbng D\u1eabn C\u00e1ch D\u00f9ng H\u00e0m Sumifs Chi Ti\u1ebft C\u1ef1c \u0110\u01a1n Gi\u1ea3n V\u00e0 D\u1ec5 Hi\u1ec3u<\/span><\/p>\n

    C\u00f4ng th\u1ee9c d\u00f9ng h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 trong Excel<\/span><\/h3>\n

    Trong ph\u1ea7n m\u1ec1m Excel, khi b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c <\/span>\u201c=ROUND(s\u1ed1_c\u1ea7n_l\u00e0m_tr\u00f2n, s\u1ed1_ch\u1eef_s\u1ed1_th\u1eadp_ph\u00e2n)\u201d<\/strong> th\u00ec b\u1ea1n \u0111ang th\u1ef1c hi\u1ec7n h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 cho excel. Trong \u0111\u00f3, \u201cs\u1ed1_c\u1ea7n_l\u00e0m_tr\u00f2n\u201d l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n, \u201cs\u1ed1_ch\u1eef_s\u1ed1_th\u1eadp_ph\u00e2n\u201d l\u00e0 s\u1ed1 l\u01b0\u1ee3ng ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n b\u1ea1n mu\u1ed1n gi\u1eef l\u1ea1i sau d\u1ea5u ph\u1ea9y.<\/span><\/p>\n

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

    C\u00f4ng th\u1ee9c h\u00e0m ROUND trong Excel l\u00e0 g\u00ec? (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

    V\u00ed d\u1ee5 chi ti\u1ebft v\u1ec1 thao t\u00e1c th\u1ef1c hi\u1ec7n h\u00e0m ROUND<\/span><\/h3>\n

    B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ROUND \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 3.45 \u0111\u1ebfn 1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c ROUND(3.45, 1), k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 3.5.<\/span><\/p>\n

    Vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n. B\u1ea1n ch\u1ec9 c\u1ea7n cung c\u1ea5p s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n v\u00e0 s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n c\u1ea7n gi\u1eef, h\u00e0m s\u1ebd t\u1ef1 \u0111\u1ed9ng l\u00e0m tr\u00f2n s\u1ed1 theo quy t\u1eafc \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh s\u1eb5n, cu\u1ed1i c\u00f9ng s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 m\u00e0 b\u1ea1n mong mu\u1ed1n.<\/span><\/p>\n

    M\u1ed9t s\u1ed1 h\u00e0m ph\u1ed5 bi\u1ebfn li\u00ean quan \u0111\u1ebfn h\u00e0m l\u00e0m tr\u00f2n s\u1ed1<\/span><\/h2>\n

    H\u00e0m ROUNDUP l\u00e0 g\u00ec? C\u00f4ng th\u1ee9c v\u00e0 v\u00ed d\u1ee5 chi ti\u1ebft<\/span><\/h3>\n

    H\u00e0m ROUNDUP trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 l\u00ean (l\u00e0m tr\u00f2n t\u0103ng) \u0111\u1ebfn m\u1ed9t s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n x\u00e1c \u0111\u1ecbnh. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 n\u00f3 s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 l\u00ean \u0111\u1ebfn gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t g\u1ea7n nh\u1ea5t.<\/span><\/p>\n

    C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m ROUNDUP nh\u01b0 sau: <\/span>\u201c=ROUNDUP(s\u1ed1_c\u1ea7n_l\u00e0m_tr\u00f2n, s\u1ed1_ch\u1eef_s\u1ed1_th\u1eadp_ph\u00e2n)\u201d<\/strong>.<\/span><\/p>\n

    V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n s\u1ed1 3.45 l\u00ean \u0111\u1ebfn 1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ROUNDUP nh\u01b0 sau: =ROUNDUP(3.45, 1). K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 3.5.<\/span><\/p>\n

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

    H\u00e0m ROUNDUP s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

    : <\/span>Nh\u1eefng \u0110i\u1ec1u B\u1ea1n N\u00ean Bi\u1ebft V\u1ec1 H\u00e0m Vlookup V\u00e0 C\u00e1ch S\u1eed D\u1ee5ng Chi Ti\u1ebft<\/span><\/p>\n

    H\u00e0m ROUNDDOWN l\u00e0 g\u00ec? C\u00f4ng th\u1ee9c v\u00e0 v\u00ed d\u1ee5 chi ti\u1ebft<\/span><\/h3>\n

    H\u00e0m ROUNDDOWN trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 xu\u1ed1ng (l\u00e0m tr\u00f2n gi\u1ea3m) \u0111\u1ebfn m\u1ed9t s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n x\u00e1c \u0111\u1ecbnh. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 n\u00f3 s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 xu\u1ed1ng \u0111\u1ebfn gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t g\u1ea7n nh\u1ea5t.<\/span><\/p>\n

    C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m ROUNDDOWN nh\u01b0 sau <\/span>\u201c=ROUNDDOWN(s\u1ed1_c\u1ea7n_l\u00e0m_tr\u00f2n, s\u1ed1_ch\u1eef_s\u1ed1_th\u1eadp_ph\u00e2n)\u201d<\/strong>.<\/span><\/p>\n

    V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n s\u1ed1 3.75 xu\u1ed1ng \u0111\u1ebfn 1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ROUNDDOWN trong Excel nh\u01b0 sau: =ROUNDDOWN(3.75, 1). K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 3.7.<\/span><\/p>\n

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

    H\u00e0m ROUNDOWN \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

    H\u00e0m MROUND l\u00e0 g\u00ec? C\u00f4ng th\u1ee9c v\u00e0 v\u00ed d\u1ee5 chi ti\u1ebft <\/span><\/h3>\n

    H\u00e0m MROUND trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn m\u1ed9t gi\u00e1 tr\u1ecb x\u00e1c \u0111\u1ecbnh, g\u1ecdi l\u00e0 “\u0111\u01a1n v\u1ecb tr\u00f2n”. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 n\u00f3 s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 \u0111\u1ebfn gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t l\u00e0 b\u1ed9i s\u1ed1 c\u1ee7a \u0111\u01a1n v\u1ecb tr\u00f2n. <\/span><\/p>\n

    C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m MROUND \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n trong Excel nh\u01b0 sau <\/span>\u201c=MROUND(s\u1ed1_c\u1ea7n_l\u00e0m_tr\u00f2n, \u0111\u01a1n_v\u1ecb_tr\u00f2n)\u201d<\/strong>.<\/span><\/p>\n

    V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n s\u1ed1 17 \u0111\u1ebfn b\u1ed9i s\u1ed1 c\u1ee7a 5, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m MROUND nh\u01b0 sau: =MROUND(17, 5). K\u1ebft qu\u1ea3 s\u1ebd l\u00e0 15, v\u00ec 15 l\u00e0 b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a 5 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 17.<\/span><\/p>\n

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

    V\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MROUND (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

    : <\/span><\/p>\n

    T\u1ea3i m\u1eabu CV xin vi\u1ec7c File PDF+Word \u0111\u01a1n gi\u1ea3n, mi\u1ec5n ph\u00ed<\/span><\/p>\n

    CV tr\u1ee3 gi\u1ea3ng ti\u1ebfng Anh: C\u00e1ch vi\u1ebft CV v\u00e0 Email xin vi\u1ec7c chuy\u00ean nghi\u1ec7p<\/span><\/p>\n

    C\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c khi d\u00f9ng h\u00e0m ROUND trong Excel.<\/span><\/h2>\n
      \n<\/ul>\n

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

      B\u1ea1n c\u1ea7n l\u01b0u \u00fd m\u1ed9t v\u00e0i l\u1ed7i khi s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

      \nTh\u00f4ng qua b\u00e0i vi\u1ebft tr\u00ean, <\/span>Masterskills<\/span> \u0111\u00e3 gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n c\u00e1c th\u00f4ng tin v\u1ec1 h\u00e0m ROUND. T\u1eeb vi\u1ec7c l\u00e0m tr\u00f2n gi\u00e1 tr\u1ecb t\u00e0i ch\u00ednh \u0111\u1ebfn l\u00e0m tr\u00f2n \u0111i\u1ec3m s\u1ed1, h\u00e0m ROUND l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu trong Excel. V\u1edbi h\u00e0m n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c \u0111\u1ed9 ch\u00ednh x\u00e1c v\u00e0 ki\u1ec3m so\u00e1t c\u1ea7n thi\u1ebft trong c\u00e1c ph\u00e9p t\u00ednh s\u1ed1 h\u1ecdc v\u00e0 b\u00e1o c\u00e1o. \u0110\u1eebng \u0111\u1ec3 s\u1ed1 li\u1ec7u c\u1ee7a b\u1ea1n b\u1ecb sai s\u00f3t v\u00ec l\u00e0m tr\u00f2n kh\u00f4ng ch\u00ednh x\u00e1c. H\u00e3y s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel v\u00e0 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a d\u1eef li\u1ec7u s\u1ed1 h\u1ecdc c\u1ee7a b\u1ea1n.<\/span><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

      H\u00e0m ROUND l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn \u0111\u01a1n gi\u1ea3n h\u00f3a c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND Trong th\u1ebf gi\u1edbi s\u1ed1 h\u1ecdc v\u00e0 t\u00ednh to\u00e1n, vi\u1ec7c l\u00e0m tr\u00f2n s\u1ed1 l\u00e0 m\u1ed9t kh\u00eda c\u1ea1nh quan tr\u1ecdng. V\u00e0 \u0111\u1ec3 gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c n\u00e0y m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 ch\u00ednh x\u00e1c, Excel cung c\u1ea5p h\u00e0m ROUND – m\u1ed9t c\u00f4ng c\u1ee5 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[431],"tags":[],"_links":{"self":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts\/19359"}],"collection":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/comments?post=19359"}],"version-history":[{"count":0,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts\/19359\/revisions"}],"wp:attachment":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/media?parent=19359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/categories?post=19359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/tags?post=19359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}