{"id":472727,"date":"2025-07-13T10:28:28","date_gmt":"2025-07-13T03:28:28","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=472727"},"modified":"2025-07-13T10:28:28","modified_gmt":"2025-07-13T03:28:28","slug":"cach-lam-tron-so-thap-phan","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/","title":{"rendered":"5 c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01a1n gi\u1ea3n trong Google Sheets"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n l\u00e0 thao t\u00e1c quan tr\u1ecdng khi x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00ean b\u1ea3ng t\u00ednh, \u0111\u1eb7c bi\u1ec7t trong Google Sheets. Vi\u1ec7c l\u00e0m tr\u00f2n kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea3ng t\u00ednh d\u1ec5 \u0111\u1ecdc m\u00e0 c\u00f2n h\u1ed7 tr\u1ee3 t\u00ednh to\u00e1n ch\u00ednh x\u00e1c v\u00e0 tr\u00ecnh b\u00e0y chuy\u00ean nghi\u1ec7p h\u01a1n. Trong Google Sheets, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng nhi\u1ec1u c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u01b0 s\u1eed d\u1ee5ng h\u00e0m ROUND, ROUNDDOWN, ROUNDUP ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 5 c\u00f4ng th\u1ee9c l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n d\u1ec5 \u00e1p d\u1ee5ng nh\u1ea5t, gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh Google Sheets.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00fd thuy\u1ebft c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n s\u1ed1 l\u00e0 m\u1ed9t k\u1ef9 n\u0103ng to\u00e1n h\u1ecdc c\u01a1 b\u1ea3n nh\u1eb1m r\u00fat g\u1ecdn s\u1ed1 v\u1ec1 d\u1ea1ng ng\u1eafn g\u1ecdn, d\u1ec5 t\u00ednh to\u00e1n nh\u01b0ng v\u1eabn \u0111\u1ea3m b\u1ea3o \u0111\u1ed9 ch\u00ednh x\u00e1c t\u01b0\u01a1ng \u0111\u1ed1i. Trong th\u1ef1c t\u1ebf v\u00e0 h\u1ecdc t\u1eadp, ch\u00fang ta th\u01b0\u1eddng l\u00e0m tr\u00f2n \u0111\u1ebfn h\u00e0ng \u0111\u01a1n v\u1ecb, h\u00e0ng ch\u1ee5c ho\u1eb7c ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n tu\u1ef3 theo y\u00eau c\u1ea7u.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Quy \u01b0\u1edbc l\u00e0m tr\u00f2n s\u1ed1<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi l\u00e0m tr\u00f2n s\u1ed1, ta th\u01b0\u1eddng d\u1ef1a v\u00e0o ch\u1eef s\u1ed1 \u0111\u1ea7u ti\u00ean b\u1ecb b\u1ecf \u0111i \u0111\u1ec3 quy\u1ebft \u0111\u1ecbnh gi\u1eef nguy\u00ean hay thay \u0111\u1ed5i ch\u1eef s\u1ed1 cu\u1ed1i c\u00f9ng c\u1ee7a ph\u1ea7n c\u00f2n l\u1ea1i:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">+ N\u1ebfu ch\u1eef s\u1ed1 \u0111\u1ea7u ti\u00ean b\u1ecf \u0111i nh\u1ecf h\u01a1n 5:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ta gi\u1eef nguy\u00ean ph\u1ea7n c\u00f2n l\u1ea1i v\u00e0 b\u1ecf \u0111i c\u00e1c ch\u1eef s\u1ed1 sau \u0111\u00f3.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: L\u00e0m tr\u00f2n s\u1ed1 23,446 \u0111\u1ebfn ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 nh\u1ea5t:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u2192 Ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 hai l\u00e0 4 (nh\u1ecf h\u01a1n 5) \u2192 K\u1ebft qu\u1ea3 l\u00e0 23,4.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-472806 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-2.jpg\" alt=\"cach-lam-tron-so-thap-phan-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">+ N\u1ebfu ch\u1eef s\u1ed1 \u0111\u1ea7u ti\u00ean b\u1ecf \u0111i l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ta c\u1ed9ng th\u00eam 1 v\u00e0o ch\u1eef s\u1ed1 cu\u1ed1i c\u00f9ng c\u1ee7a ph\u1ea7n c\u00f2n l\u1ea1i.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: L\u00e0m tr\u00f2n s\u1ed1 6,36591 \u0111\u1ebfn ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 hai:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u2192 Ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 ba l\u00e0 5 (b\u1eb1ng 5) \u2192 C\u1ed9ng 1 v\u00e0o ch\u1eef s\u1ed1 th\u1ee9 hai \u2192 K\u1ebft qu\u1ea3 l\u00e0 6,37.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Quy t\u1eafc n\u00e0y \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng cho c\u1ea3 ph\u1ea7n nguy\u00ean v\u00e0 ph\u1ea7n th\u1eadp ph\u00e2n, gi\u00fap l\u00e0m tr\u00f2n s\u1ed1 ch\u00ednh x\u00e1c v\u00e0 nh\u1ea5t qu\u00e1n trong m\u1ecdi tr\u01b0\u1eddng h\u1ee3p.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n 84,149 \u0111\u1ebfn ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 nh\u1ea5t:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u2192 Ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 hai l\u00e0 4 \u2192 K\u1ebft qu\u1ea3 l\u00e0 84,1.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n 542 \u0111\u1ebfn h\u00e0ng ch\u1ee5c:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u2192 Ch\u1eef s\u1ed1 h\u00e0ng \u0111\u01a1n v\u1ecb l\u00e0 2 (nh\u1ecf h\u01a1n 5) \u2192 K\u1ebft qu\u1ea3 l\u00e0 540.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-472807 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-3.jpg\" alt=\"cach-lam-tron-so-thap-phan-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n 0,0861 \u0111\u1ebfn ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 hai:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u2192 Ch\u1eef s\u1ed1 th\u1ee9 ba l\u00e0 6 (l\u1edbn h\u01a1n 5) \u2192 C\u1ed9ng 1 v\u00e0o ch\u1eef s\u1ed1 th\u1ee9 hai \u2192 K\u1ebft qu\u1ea3 l\u00e0 0,09.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n 1573 \u0111\u1ebfn h\u00e0ng tr\u0103m:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u2192 Ch\u1eef s\u1ed1 h\u00e0ng ch\u1ee5c l\u00e0 7 (l\u1edbn h\u01a1n 5) \u2192 C\u1ed9ng 1 v\u00e0o h\u00e0ng tr\u0103m \u2192 K\u1ebft qu\u1ea3 l\u00e0 1600.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">5 c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01a1n gi\u1ea3n trong Google Sheets<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 5 c\u00f4ng th\u1ee9c l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01a1n gi\u1ea3n, d\u1ec5 \u00e1p d\u1ee5ng trong Google Sheets m\u00e0 b\u1ea1n n\u00ean bi\u1ebft. M\u1ed7i c\u00e1ch s\u1ebd ph\u00f9 h\u1ee3p v\u1edbi m\u1ed9t m\u1ee5c \u0111\u00edch kh\u00e1c nhau, t\u1eeb l\u00e0m tr\u00f2n l\u00ean, l\u00e0m tr\u00f2n xu\u1ed1ng \u0111\u1ebfn l\u00e0m tr\u00f2n theo b\u1ed9i s\u1ed1 \u2013 gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng h\u00e0m ROUND<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m ROUND l\u00e0 c\u00f4ng c\u1ee5 ph\u1ed5 bi\u1ebfn trong Google Sheets d\u00f9ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n theo quy t\u1eafc to\u00e1n h\u1ecdc ti\u00eau chu\u1ea9n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nguy\u00ean t\u1eafc l\u00e0m tr\u00f2n:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu ph\u1ea7n \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n (ch\u1eef s\u1ed1 \u0111\u1ea7u ti\u00ean b\u1ecb b\u1ecf \u0111i) nh\u1ecf h\u01a1n 5 \u2192 l\u00e0m tr\u00f2n xu\u1ed1ng, gi\u1eef nguy\u00ean ph\u1ea7n c\u00f2n l\u1ea1i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu ph\u1ea7n \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5 \u2192 l\u00e0m tr\u00f2n l\u00ean, c\u1ed9ng th\u00eam 1 v\u00e0o ch\u1eef s\u1ed1 cu\u1ed1i c\u00f9ng c\u1ee7a ph\u1ea7n c\u00f2n l\u1ea1i.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-472808 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-4.jpg\" alt=\"cach-lam-tron-so-thap-phan-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n s\u1ed1 89,45363 \u0111\u1ebfn ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 3, ta \u0111\u01b0\u1ee3c:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u2192 89,454 (v\u00ec ch\u1eef s\u1ed1 th\u1ee9 t\u01b0 l\u00e0 6 \u2265 5, n\u00ean l\u00e0m tr\u00f2n l\u00ean).<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=ROUND(A2; 3)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u00dd ngh\u0129a c\u1ee7a c\u00f4ng th\u1ee9c:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">A2: L\u00e0 \u00f4 ch\u1ee9a s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">3: Ch\u1ec9 \u0111\u1ecbnh l\u00e0m tr\u00f2n \u0111\u1ebfn ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 3.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m ROUND r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c v\u00e0 hi\u1ec3n th\u1ecb g\u1ecdn g\u00e0ng trong c\u00e1c b\u00e1o c\u00e1o, b\u1ea3ng t\u00ednh t\u00e0i ch\u00ednh ho\u1eb7c t\u00ednh to\u00e1n s\u1ed1 li\u1ec7u khoa h\u1ecdc.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n b\u1eb1ng h\u00e0m MROUND<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m MROUND trong Google Sheets \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 \u0111\u1ebfn b\u1ed9i s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t c\u1ee7a m\u1ed9t s\u1ed1 kh\u00e1c. \u0110\u00e2y l\u00e0 c\u00e1ch l\u00e0m tr\u00f2n r\u1ea5t ti\u1ec7n l\u1ee3i khi b\u1ea1n c\u1ea7n c\u00e1c k\u1ebft qu\u1ea3 chu\u1ea9n h\u00f3a theo b\u01b0\u1edbc nh\u1ea3y nh\u1ea5t \u0111\u1ecbnh nh\u01b0 5, 10, 100 ho\u1eb7c theo y\u00eau c\u1ea7u c\u1ee5 th\u1ec3 trong t\u00ednh to\u00e1n gi\u00e1 tr\u1ecb chi ph\u00ed, \u0111\u1ecbnh l\u01b0\u1ee3ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nguy\u00ean t\u1eafc l\u00e0m tr\u00f2n: <\/span><span style=\"font-weight: 400;\">H\u00e0m s\u1ebd l\u00e0m tr\u00f2n l\u00ean ho\u1eb7c xu\u1ed1ng t\u00f9y theo b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a m\u1ed9t s\u1ed1 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-472809 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-5.jpg\" alt=\"cach-lam-tron-so-thap-phan-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n s\u1ed1 89,45363 \u0111\u1ebfn b\u1ed9i s\u1ed1 c\u1ee7a 2, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 90 (v\u00ec 90 g\u1ea7n 89,45363 h\u01a1n so v\u1edbi 88).<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=MROUND(A2; 2)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u00dd ngh\u0129a c\u00f4ng th\u1ee9c:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">A2: L\u00e0 \u00f4 ch\u1ee9a s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">2: L\u00e0 s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n \u0111\u1ebfn b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a n\u00f3.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m MROUND c\u1ef1c k\u1ef3 h\u1eefu \u00edch trong th\u1ef1c t\u1ebf, \u0111\u1eb7c bi\u1ec7t trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p nh\u01b0 l\u00e0m tr\u00f2n ti\u1ec1n \u0111\u1ebfn \u0111\u01a1n v\u1ecb ngh\u00ecn, l\u00e0m tr\u00f2n s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng h\u00f3a theo ki\u1ec7n, ho\u1eb7c chu\u1ea9n h\u00f3a \u0111\u01a1n gi\u00e1 theo khung \u0111\u1ecbnh m\u1ee9c.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n b\u1eb1ng h\u00e0m ROUNDUP<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m ROUNDUP l\u00e0 h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 lu\u00f4n h\u01b0\u1edbng l\u00ean tr\u00ean, b\u1ea5t k\u1ec3 ch\u1eef s\u1ed1 b\u1ecb b\u1ecf \u0111i nh\u1ecf h\u01a1n hay l\u1edbn h\u01a1n 5. Kh\u00e1c v\u1edbi h\u00e0m ROUND \u2013 c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n l\u00ean ho\u1eb7c xu\u1ed1ng t\u00f9y gi\u00e1 tr\u1ecb \u2013 ROUNDUP lu\u00f4n t\u0103ng gi\u00e1 tr\u1ecb l\u00e0m tr\u00f2n l\u00ean m\u1ee9c cao h\u01a1n g\u1ea7n nh\u1ea5t theo s\u1ed1 ch\u1eef s\u1ed1 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nguy\u00ean t\u1eafc l\u00e0m tr\u00f2n: <\/span><span style=\"font-weight: 400;\">Ch\u1ec9 c\u1ea7n c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n, h\u00e0m ROUNDUP s\u1ebd l\u00e0m tr\u00f2n l\u00ean \u0111\u1ebfn v\u1ecb tr\u00ed x\u00e1c \u0111\u1ecbnh, k\u1ec3 c\u1ea3 khi ph\u1ea7n th\u1eadp ph\u00e2n nh\u1ecf h\u01a1n 5.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-472810 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-6.jpg\" alt=\"cach-lam-tron-so-thap-phan-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n s\u1ed1 89,45363 \u0111\u1ebfn ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 nh\u1ea5t, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 89,5.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=ROUNDUP(A2; 1)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u00dd ngh\u0129a c\u00f4ng th\u1ee9c:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">A2: \u00d4 ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n l\u00e0m tr\u00f2n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">1: L\u00e0m tr\u00f2n l\u00ean \u0111\u1ebfn ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 nh\u1ea5t.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m ROUNDUP r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n k\u1ebft qu\u1ea3 lu\u00f4n cao h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb g\u1ed1c.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n b\u1eb1ng h\u00e0m ROUNDDOWN<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m ROUNDDOWN \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u00e0m tr\u00f2n xu\u1ed1ng theo s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n ho\u1eb7c h\u00e0ng \u0111\u01a1n v\u1ecb b\u1ea1n ch\u1ec9 \u0111\u1ecbnh. \u0110\u00e2y l\u00e0 h\u00e0m \u0111\u1ed1i l\u1eadp v\u1edbi ROUNDUP v\u00e0 c\u00f3 nguy\u00ean t\u1eafc ho\u1ea1t \u0111\u1ed9ng g\u1ea7n gi\u1ed1ng h\u00e0m ROUND nh\u01b0ng lu\u00f4n l\u00e0m tr\u00f2n gi\u1ea3m gi\u00e1 tr\u1ecb.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nguy\u00ean t\u1eafc l\u00e0m tr\u00f2n: <\/span><span style=\"font-weight: 400;\">Kh\u00f4ng x\u00e9t \u0111\u1ebfn gi\u00e1 tr\u1ecb ch\u1eef s\u1ed1 b\u1ecb b\u1ecf \u0111i, h\u00e0m lu\u00f4n l\u00e0m tr\u00f2n xu\u1ed1ng, t\u1ee9c tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb ban \u0111\u1ea7u.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-472811 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-7.jpg\" alt=\"cach-lam-tron-so-thap-phan-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n s\u1ed1 89,45363 \u0111\u1ebfn ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 nh\u1ea5t, k\u1ebft qu\u1ea3 l\u00e0 89,4.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=ROUNDDOWN(A2; 1)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u00dd ngh\u0129a c\u00f4ng th\u1ee9c:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">A2: \u00d4 ch\u1ee9a s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">1: L\u00e0m tr\u00f2n xu\u1ed1ng \u0111\u1ebfn ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n th\u1ee9 nh\u1ea5t.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m ROUNDDOWN r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n k\u1ebft qu\u1ea3 an to\u00e0n h\u01a1n, ch\u1eb3ng h\u1ea1n trong k\u1ebf to\u00e1n, ph\u00e2n b\u1ed5 chi ph\u00ed ho\u1eb7c \u0111\u1ecbnh m\u1ee9c s\u1ea3n xu\u1ea5t.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n b\u1eb1ng h\u00e0m ODD v\u00e0 EVEN<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m ODD v\u00e0 EVEN trong Google Sheets \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 l\u00ean \u0111\u1ebfn s\u1ed1 nguy\u00ean l\u1ebb ho\u1eb7c ch\u1eb5n g\u1ea7n nh\u1ea5t, t\u00f9y theo m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng. Kh\u00e1c v\u1edbi c\u00e1c h\u00e0m ROUND, ROUNDUP hay ROUNDDOWN \u2013 v\u1ed1n c\u00f3 th\u1ec3 x\u1eed l\u00fd s\u1ed1 th\u1eadp ph\u00e2n, ODD v\u00e0 EVEN ch\u1ec9 \u00e1p d\u1ee5ng v\u1edbi s\u1ed1 nguy\u00ean ho\u1eb7c l\u00e0m tr\u00f2n l\u00ean s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nguy\u00ean t\u1eafc l\u00e0m tr\u00f2n:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"font-weight: 400;\">ODD: L\u00e0m tr\u00f2n s\u1ed1 l\u00ean \u0111\u1ebfn s\u1ed1 nguy\u00ean l\u1ebb g\u1ea7n nh\u1ea5t l\u1edbn h\u01a1n s\u1ed1 g\u1ed1c.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">EVEN: L\u00e0m tr\u00f2n s\u1ed1 l\u00ean \u0111\u1ebfn s\u1ed1 nguy\u00ean ch\u1eb5n g\u1ea7n nh\u1ea5t l\u1edbn h\u01a1n s\u1ed1 g\u1ed1c.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-472812 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-8.jpg\" alt=\"cach-lam-tron-so-thap-phan-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m tr\u00f2n s\u1ed1 89,45363 b\u1eb1ng h\u00e0m ODD, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 91 (v\u00ec 91 l\u00e0 s\u1ed1 l\u1ebb g\u1ea7n nh\u1ea5t l\u1edbn h\u01a1n 89,45363).<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=ODD(A2) ho\u1eb7c =EVEN(A2)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u00dd ngh\u0129a c\u00f4ng th\u1ee9c:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"font-weight: 400;\">A2: L\u00e0 \u00f4 ch\u1ee9a s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">D\u00f9ng ODD n\u1ebfu b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n l\u00ean s\u1ed1 l\u1ebb g\u1ea7n nh\u1ea5t, ho\u1eb7c EVEN n\u1ebfu mu\u1ed1n l\u00e0m tr\u00f2n l\u00ean s\u1ed1 ch\u1eb5n g\u1ea7n nh\u1ea5t.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c h\u00e0m n\u00e0y h\u1eefu \u00edch khi x\u1eed l\u00fd d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1eb7c bi\u1ec7t nh\u01b0 chia nh\u00f3m, ph\u00e2n lo\u1ea1i theo s\u1ed1 l\u1ebb\/ch\u1eb5n, ho\u1eb7c khi c\u1ea7n \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 n\u1eb1m trong m\u1ee9c s\u1ed1 nguy\u00ean x\u00e1c \u0111\u1ecbnh.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Th\u1eafc m\u1eafc th\u01b0\u1eddng g\u1eb7p\u00a0<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi \u00e1p d\u1ee5ng c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n trong Google Sheets, nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng g\u1eb7p ph\u1ea3i nh\u1eefng th\u1eafc m\u1eafc li\u00ean quan \u0111\u1ebfn hi\u1ec3n th\u1ecb, \u0111\u1ed9 ch\u00ednh x\u00e1c v\u00e0 l\u1ef1a ch\u1ecdn h\u00e0m ph\u00f9 h\u1ee3p. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 ba c\u00e2u h\u1ecfi ph\u1ed5 bi\u1ebfn gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u00e0 tr\u00e1nh sai s\u00f3t khi thao t\u00e1c v\u1edbi c\u00e1c h\u00e0m l\u00e0m tr\u00f2n.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m sao \u0111\u1ec3 ch\u1ec9 hi\u1ec3n th\u1ecb s\u1ed1 th\u1eadp ph\u00e2n sau khi l\u00e0m tr\u00f2n m\u00e0 kh\u00f4ng thay \u0111\u1ed5i gi\u00e1 tr\u1ecb th\u1ef1c trong \u00f4 t\u00ednh?\u00a0<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong Google Sheets, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 hi\u1ec3n th\u1ecb m\u00e0 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn gi\u00e1 tr\u1ecb th\u1ef1c c\u1ee7a \u00f4 t\u00ednh b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 thay v\u00ec s\u1eed d\u1ee5ng h\u00e0m l\u00e0m tr\u00f2n. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n gi\u1eef nguy\u00ean s\u1ed1 li\u1ec7u \u0111\u1ec3 t\u00ednh to\u00e1n ch\u00ednh x\u00e1c nh\u01b0ng v\u1eabn mu\u1ed1n b\u1ea3ng t\u00ednh g\u1ecdn g\u00e0ng, d\u1ec5 nh\u00ecn.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-472813 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-9.jpg\" alt=\"cach-lam-tron-so-thap-phan-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n, b\u1ea1n ch\u1ecdn \u00f4 ho\u1eb7c c\u1ed9t c\u1ea7n hi\u1ec3n th\u1ecb, sau \u0111\u00f3 v\u00e0o: <\/span><span style=\"font-weight: 400;\">Format &gt; Number &gt; Number \u2192 B\u1ea5m bi\u1ec3u t\u01b0\u1ee3ng t\u0103ng\/gi\u1ea3m s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n (Increase\/Decrease decimal places) tr\u00ean thanh c\u00f4ng c\u1ee5.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch l\u00e0m n\u00e0y kh\u00f4ng thay \u0111\u1ed5i gi\u00e1 tr\u1ecb th\u1eadt c\u1ee7a \u00f4, ngh\u0129a l\u00e0 d\u00f9 b\u1ea1n ch\u1ec9 nh\u00ecn th\u1ea5y 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n, Google Sheets v\u1eabn ghi nh\u1edb \u0111\u1ea7y \u0111\u1ee7 s\u1ed1 ban \u0111\u1ea7u \u0111\u1ec3 d\u00f9ng cho c\u00e1c ph\u00e9p t\u00ednh ti\u1ebfp theo. \u0110\u00e2y l\u00e0 l\u1ef1a ch\u1ecdn l\u00fd t\u01b0\u1edfng khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u t\u00e0i ch\u00ednh, th\u1ed1ng k\u00ea ho\u1eb7c b\u00e1o c\u00e1o chuy\u00ean m\u00f4n \u0111\u00f2i h\u1ecfi \u0111\u1ed9 ch\u00ednh x\u00e1c cao.\u00a0<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1ea1i sao c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c ROUND nh\u01b0ng k\u1ebft qu\u1ea3 l\u00e0m tr\u00f2n l\u1ea1i kh\u00e1c nhau gi\u1eefa c\u00e1c \u00f4?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">D\u00f9 s\u1eed d\u1ee5ng c\u00f9ng c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n theo c\u00f4ng th\u1ee9c =ROUND(A2; s\u1ed1 ch\u1eef s\u1ed1), k\u1ebft qu\u1ea3 l\u00e0m tr\u00f2n trong c\u00e1c \u00f4 kh\u00e1c nhau v\u1eabn c\u00f3 th\u1ec3 kh\u00e1c nhau do gi\u00e1 tr\u1ecb ban \u0111\u1ea7u kh\u00e1c nhau v\u00e0 ch\u1eef s\u1ed1 b\u1ecb lo\u1ea1i b\u1ecf kh\u00e1c nhau.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m ROUND l\u00e0m tr\u00f2n theo nguy\u00ean t\u1eafc:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu ch\u1eef s\u1ed1 \u0111\u1ea7u ti\u00ean b\u1ecb b\u1ecf nh\u1ecf h\u01a1n 5 \u2192 l\u00e0m tr\u00f2n xu\u1ed1ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu ch\u1eef s\u1ed1 \u0111\u1ea7u ti\u00ean b\u1ecb b\u1ecf l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5 \u2192 l\u00e0m tr\u00f2n l\u00ean.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-472814 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-10.jpg\" alt=\"cach-lam-tron-so-thap-phan-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=ROUND(3,144;2) \u2192 3,14 (v\u00ec ch\u1eef s\u1ed1 th\u1ee9 3 l\u00e0 4 &lt; 5).<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=ROUND(3,145;2) \u2192 3,15 (v\u00ec ch\u1eef s\u1ed1 th\u1ee9 3 l\u00e0 5 \u2265 5).<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i ra, m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p kh\u00e1c c\u0169ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn k\u1ebft qu\u1ea3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1ed1 trong \u00f4 c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ednh to\u00e1n t\u1eeb c\u00f4ng th\u1ee9c kh\u00e1c \u2192 l\u00e0m tr\u00f2n c\u00f3 th\u1ec3 b\u1ecb l\u1ec7ch nh\u1eb9 do sai s\u1ed1 nh\u1ecb ph\u00e2n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o b\u1ecb l\u00e0m tr\u00f2n s\u1eb5n t\u1eeb tr\u01b0\u1edbc, ho\u1eb7c ch\u1ee9a gi\u00e1 tr\u1ecb kh\u00f4ng hi\u1ec3n th\u1ecb \u0111\u1ea7y \u0111\u1ee7.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ec v\u1eady, \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 \u0111\u1ed3ng nh\u1ea5t, b\u1ea1n n\u00ean ki\u1ec3m tra k\u1ef9 d\u1eef li\u1ec7u g\u1ed1c, s\u1ed1 ch\u1eef s\u1ed1 l\u00e0m tr\u00f2n v\u00e0 tr\u00e1nh l\u00e0m tr\u00f2n l\u1ed3ng nhi\u1ec1u b\u01b0\u1edbc g\u00e2y sai l\u1ec7ch.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi n\u00e0o n\u00ean d\u00f9ng h\u00e0m ROUNDUP, ROUNDDOWN thay v\u00ec ROUND th\u00f4ng th\u01b0\u1eddng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Vi\u1ec7c l\u1ef1a ch\u1ecdn gi\u1eefa ROUND, ROUNDUP hay ROUNDDOWN ph\u1ee5 thu\u1ed9c v\u00e0o m\u1ee5c ti\u00eau l\u00e0m tr\u00f2n c\u1ee7a b\u1ea1n:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">ROUND: C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n theo quy t\u1eafc th\u00f4ng th\u01b0\u1eddng \u2013 l\u00ean n\u1ebfu \u2265 5, xu\u1ed1ng n\u1ebfu &lt; 5. Th\u00edch h\u1ee3p cho c\u00e1c ph\u00e9p t\u00ednh trung b\u00ecnh, th\u1ed1ng k\u00ea, l\u00e0m tr\u00f2n hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u ph\u1ed5 th\u00f4ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">ROUNDUP: Lu\u00f4n l\u00e0m tr\u00f2n l\u00ean, b\u1ea5t k\u1ec3 ph\u1ea7n th\u1eadp ph\u00e2n nh\u1ecf hay l\u1edbn. Ph\u00f9 h\u1ee3p khi b\u1ea1n mu\u1ed1n k\u1ebft qu\u1ea3 kh\u00f4ng th\u1ea5p h\u01a1n gi\u00e1 tr\u1ecb g\u1ed1c, v\u00ed d\u1ee5 nh\u01b0 l\u00e0m tr\u00f2n s\u1ed1 l\u01b0\u1ee3ng \u0111\u01a1n h\u00e0ng, chi ph\u00ed t\u1ed1i thi\u1ec3u, ch\u1ec9 ti\u00eau s\u1ea3n xu\u1ea5t.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">ROUNDDOWN: Lu\u00f4n l\u00e0m tr\u00f2n xu\u1ed1ng. Th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng trong tr\u01b0\u1eddng h\u1ee3p c\u1ea7n b\u1ea3o to\u00e0n m\u1ee9c d\u01b0\u1edbi, ch\u1eb3ng h\u1ea1n nh\u01b0 gi\u1edbi h\u1ea1n ng\u00e2n s\u00e1ch, kh\u00f4ng v\u01b0\u1ee3t qu\u00e1 s\u1ed1 l\u01b0\u1ee3ng cho ph\u00e9p, ho\u1eb7c khi c\u1ea7n gi\u1eef an to\u00e0n trong d\u1eef li\u1ec7u nh\u1ea1y c\u1ea3m.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-472815 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-11.jpg\" alt=\"cach-lam-tron-so-thap-phan-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1ea1m K\u1ebft\u00a0<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 5 c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01a1n gi\u1ea3n trong Google Sheets gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u ch\u00ednh x\u00e1c, tr\u00ecnh b\u00e0y g\u1ecdn g\u00e0ng v\u00e0 ph\u00f9 h\u1ee3p v\u1edbi t\u1eebng m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng. T\u00f9y v\u00e0o y\u00eau c\u1ea7u l\u00e0m tr\u00f2n l\u00ean, xu\u1ed1ng hay \u0111\u1ebfn b\u1ed9i s\u1ed1 c\u1ee5 th\u1ec3, b\u1ea1n c\u00f3 th\u1ec3 linh ho\u1ea1t ch\u1ecdn h\u00e0m ROUND, ROUNDUP, ROUNDDOWN, MROUND, ODD ho\u1eb7c EVEN. Ngo\u00e0i ra, vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb c\u0169ng gi\u00fap t\u1ed1i \u01b0u b\u1ea3ng t\u00ednh m\u00e0 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn gi\u00e1 tr\u1ecb th\u1eadt. H\u00e3y \u00e1p d\u1ee5ng \u0111\u00fang c\u00e1ch \u0111\u1ec3 n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 trong Google Sheets.<\/span><\/p>\n<p style=\"text-align: justify;\"><strong>XEM TH\u00caM:\u00a0<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tinh-trong-excel\/\">3 c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh % trong Excel \u0111\u00fang chu\u1ea9n, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda<\/a><\/strong><\/li>\n<li style=\"text-align: justify;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/chuyen-word-sang-excel\/\">6 c\u00e1ch chuy\u1ec3n Word sang Excel nhanh ch\u00f3ng, gi\u1eef nguy\u00ean \u0111\u1ecbnh d\u1ea1ng<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n l\u00e0 thao t\u00e1c quan tr\u1ecdng khi x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00ean b\u1ea3ng t\u00ednh, \u0111\u1eb7c bi\u1ec7t trong Google Sheets. Vi\u1ec7c l\u00e0m tr\u00f2n kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea3ng t\u00ednh d\u1ec5 \u0111\u1ecdc m\u00e0 c\u00f2n h\u1ed7 tr\u1ee3 t\u00ednh to\u00e1n ch\u00ednh x\u00e1c v\u00e0 tr\u00ecnh b\u00e0y chuy\u00ean nghi\u1ec7p h\u01a1n. Trong Google Sheets, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m [&hellip;]<\/p>\n","protected":false},"author":73,"featured_media":472805,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-472727","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>5 c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01a1n gi\u1ea3n trong Google Sheets<\/title>\n<meta name=\"description\" content=\"C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n trong Google Sheets \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng ch\u00fang t\u00f4i t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01a1n gi\u1ea3n trong Google Sheets\" \/>\n<meta property=\"og:description\" content=\"C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n trong Google Sheets \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng ch\u00fang t\u00f4i t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-13T03:28:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"H\u1ed3ng Th\u01a1\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"H\u1ed3ng Th\u01a1\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/\"},\"author\":{\"name\":\"H\u1ed3ng Th\u01a1\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/6db3b2e6d8fb7f2e308c4625aeaa7dc2\"},\"headline\":\"5 c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01a1n gi\u1ea3n trong Google Sheets\",\"datePublished\":\"2025-07-13T03:28:28+00:00\",\"dateModified\":\"2025-07-13T03:28:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/\"},\"wordCount\":3277,\"commentCount\":61,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/\",\"name\":\"5 c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01a1n gi\u1ea3n trong Google Sheets\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan.jpg\",\"datePublished\":\"2025-07-13T03:28:28+00:00\",\"dateModified\":\"2025-07-13T03:28:28+00:00\",\"description\":\"C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n trong Google Sheets \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng ch\u00fang t\u00f4i t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan.jpg\",\"width\":1200,\"height\":628,\"caption\":\"cach-lam-tron-so-thap-phan\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"5 c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01a1n gi\u1ea3n trong Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/6db3b2e6d8fb7f2e308c4625aeaa7dc2\",\"name\":\"H\u1ed3ng Th\u01a1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g\",\"caption\":\"H\u1ed3ng Th\u01a1\"},\"description\":\"M\u00ecnh l\u00e0 Th\u01a1 - c\u00f4 g\u00e1i \u0111am m\u00ea vi\u1ebft l\u00e1ch, th\u00edch tr\u1ea3i nghi\u1ec7m nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 m\u1edbi!\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/hong-tho\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"5 c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01a1n gi\u1ea3n trong Google Sheets","description":"C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n trong Google Sheets \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng ch\u00fang t\u00f4i t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/","og_locale":"vi_VN","og_type":"article","og_title":"5 c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01a1n gi\u1ea3n trong Google Sheets","og_description":"C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n trong Google Sheets \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng ch\u00fang t\u00f4i t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-07-13T03:28:28+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan.jpg","type":"image\/jpeg"}],"author":"H\u1ed3ng Th\u01a1","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1ed3ng Th\u01a1","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"15 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/"},"author":{"name":"H\u1ed3ng Th\u01a1","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/6db3b2e6d8fb7f2e308c4625aeaa7dc2"},"headline":"5 c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01a1n gi\u1ea3n trong Google Sheets","datePublished":"2025-07-13T03:28:28+00:00","dateModified":"2025-07-13T03:28:28+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/"},"wordCount":3277,"commentCount":61,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/","name":"5 c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01a1n gi\u1ea3n trong Google Sheets","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan.jpg","datePublished":"2025-07-13T03:28:28+00:00","dateModified":"2025-07-13T03:28:28+00:00","description":"C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n trong Google Sheets \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng ch\u00fang t\u00f4i t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/07\/cach-lam-tron-so-thap-phan.jpg","width":1200,"height":628,"caption":"cach-lam-tron-so-thap-phan"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-lam-tron-so-thap-phan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"5 c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01a1n gi\u1ea3n trong Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/6db3b2e6d8fb7f2e308c4625aeaa7dc2","name":"H\u1ed3ng Th\u01a1","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g","caption":"H\u1ed3ng Th\u01a1"},"description":"M\u00ecnh l\u00e0 Th\u01a1 - c\u00f4 g\u00e1i \u0111am m\u00ea vi\u1ebft l\u00e1ch, th\u00edch tr\u1ea3i nghi\u1ec7m nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 m\u1edbi!","url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/hong-tho\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/472727","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/73"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=472727"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/472727\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/472805"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=472727"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=472727"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=472727"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}