{"id":273458,"date":"2023-10-19T19:34:16","date_gmt":"2023-10-19T12:34:16","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=273458"},"modified":"2023-10-19T19:34:16","modified_gmt":"2023-10-19T12:34:16","slug":"ham-tru-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft"},"content":{"rendered":"<p>C\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m tr\u1eeb trong Excel<\/strong> l\u00e0 \u0111i\u1ec1u m\u00e0 r\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m b\u1edfi \u0111\u00e2y l\u00e0 ph\u00e9p t\u00ednh \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i trong \u0111\u1eddi s\u1ed1ng h\u00e0ng ng\u00e0y. D\u00f9 th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng, tuy nhi\u00ean, kh\u00f4ng \u00edt ng\u01b0\u1eddi d\u00f9ng c\u1ea3m th\u1ea5y b\u1ed1i r\u1ed1i khi th\u1ef1c hi\u1ec7n ch\u00fang tr\u00ean ph\u1ea7n m\u1ec1m Excel. Trong b\u00e0i vi\u1ebft ng\u00e0y h\u00f4m nay, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch th\u1ee9c s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t v\u1ec1 h\u00e0m tr\u1eeb \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng, t\u1eeb \u0111\u00f3 c\u00f3 th\u1ec3 ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c th\u1eddi gian c\u0169ng nh\u01b0 c\u00f4ng s\u1ee9c trong kh\u00e2u t\u00ednh to\u00e1n.<\/p>\n<h2>T\u1ed5ng quan v\u1ec1 h\u00e0m tr\u1eeb trong Excel<\/h2>\n<p>Tr\u01b0\u1edbc khi \u0111i t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb, ch\u00fang ta s\u1ebd c\u00f9ng \u0111i\u1ec3m qua m\u1ed9t s\u1ed1 kh\u00e1i ni\u1ec7m v\u1ec1 Excel, h\u00e0m tr\u1eeb (h\u00e0m t\u00ednh hi\u1ec7u) trong Excel v\u00e0 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m tr\u1eeb.<\/p>\n<h3>Excel l\u00e0 g\u00ec?<\/h3>\n<p data-sourcepos=\"1:1-1:223\">Excel \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh n\u1eb1m trong b\u1ed9 Microsoft Office. Ph\u1ea7n m\u1ec1m n\u00e0y gi\u00fap ng\u01b0\u1eddi d\u00f9ng ghi l\u1ea1i, tr\u00ecnh b\u00e0y th\u00f4ng tin d\u01b0\u1edbi d\u1ea1ng b\u1ea3ng, th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n v\u00e0 x\u00e2y d\u1ef1ng c\u00e1c s\u1ed1 li\u1ec7u th\u1ed1ng k\u00ea tr\u1ef1c quan c\u00f3 trong b\u1ea3ng t\u1eeb Excel.<\/p>\n<p data-sourcepos=\"1:1-1:223\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-273828 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-1.jpg\" alt=\"ham-tru-trong-Excel-1 \" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-sourcepos=\"3:1-3:279\">Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i trong nhi\u1ec1u l\u0129nh v\u1ef1c, bao g\u1ed3m kinh doanh, t\u00e0i ch\u00ednh, k\u1ebf to\u00e1n, khoa h\u1ecdc, k\u1ef9 thu\u1eadt,&#8230; Ph\u1ea7n m\u1ec1m n\u00e0y cung c\u1ea5p nhi\u1ec1u t\u00ednh n\u0103ng v\u00e0 c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 gi\u00fap ng\u01b0\u1eddi d\u00f9ng qu\u1ea3n l\u00fd d\u1eef li\u1ec7u, th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p, t\u1ea1o c\u00e1c bi\u1ec3u \u0111\u1ed3 v\u00e0 \u0111\u1ed3 th\u1ecb tr\u1ef1c quan,&#8230;<\/p>\n<h3>H\u00e0m tr\u1eeb trong Excel c\u00f3 ngh\u0129a l\u00e0 g\u00ec?<\/h3>\n<p>Trong b\u1ea3ng Excel, \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p tr\u1eeb gi\u1eefa hai ho\u1eb7c nhi\u1ec1u s\u1ed1, ch\u00fang ta s\u1ebd d\u00f9ng d\u1ea5u &#8220;-&#8221; trong to\u00e1n h\u1ecdc ho\u1eb7c s\u1eed d\u1ee5ng h\u00e0m SUM. S\u1edf d\u0129 nh\u01b0 v\u1eady b\u1edfi kh\u00f4ng c\u00f3 h\u00e0m tr\u1eeb hay c\u00f2n g\u1ecdi l\u00e0 h\u00e0m t\u00ednh hi\u1ec7u trong Excel. H\u00e0m tr\u1eeb c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p kh\u00e1c nhau, ch\u1eb3ng h\u1ea1n nh\u01b0:<\/p>\n<ul data-sourcepos=\"29:1-33:0\">\n<li data-sourcepos=\"29:1-29:54\">T\u00ednh to\u00e1n s\u1ed1 ti\u1ec1n c\u00f2n l\u1ea1i sau khi tr\u1eeb m\u1ed9t kho\u1ea3n ti\u1ec1n.<\/li>\n<li data-sourcepos=\"31:1-31:52\">T\u00ednh to\u00e1n th\u1eddi gian ch\u00eanh l\u1ec7ch gi\u1eefa hai ng\u00e0y th\u00e1ng.<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter wp-image-273832 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-2.jpg\" alt=\"ham-tru-trong-Excel-2 \" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>Vi\u1ec7c s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o h\u00e0m tr\u1eeb gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c khi t\u00ednh to\u00e1n, \u0111\u1eb7c bi\u1ec7t l\u00e0 trong nh\u1eefng b\u1ea3ng t\u00ednh ph\u1ee9c t\u1ea1p. Trong ph\u1ea7n ti\u1ebfp theo c\u1ee7a b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang t\u00f4i s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n trong Excel.<\/p>\n<h3>C\u00e1c c\u00fa ph\u00e1p c\u1ee7a h\u00e0m tr\u1eeb<\/h3>\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n h\u00e0m tr\u1eeb trong \u1ee9ng d\u1ee5ng Excel, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng 4 c\u00fa ph\u00e1p sau \u0111\u00e2y:<\/p>\n<p><strong>Th\u1ee9 nh\u1ea5t:<\/strong> = (S\u1ed1 th\u1ee9 1 &#8211; S\u1ed1 2)<\/p>\n<p><strong>Th\u1ee9 hai:<\/strong> =(S\u1ed1 th\u1ee9 2 &#8211; S\u1ed1 th\u1ee9 2 &#8211; S\u1ed1 th\u1ee9 3 &#8211; \u2026- S\u1ed1 th\u1ee9 n)<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter wp-image-273833 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-3.jpg\" alt=\"ham-tru-trong-Excel-3 \" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>Th\u1ee9 ba:<\/strong> = SUM(S\u1ed1 th\u1ee9 1, &#8211; S\u1ed1 th\u1ee9 2,\u2026)<\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong> V\u00ec h\u00e0m SUM l\u00e0 h\u00e0m t\u00ednh t\u1ed5ng n\u00ean t\u1eeb s\u1ed1 th\u1ee9 hai tr\u1edf \u0111i, tr\u01b0\u1edbc m\u1ed7i gi\u00e1 tr\u1ecb b\u1ea1n ph\u1ea3i th\u00eam d\u1ea5u \u201c-\u201c tr\u01b0\u1edbc n\u00f3 \u0111\u1ec3 t\u00ednh hi\u1ec7u nh\u00e9!<\/p>\n<p><strong>Th\u1ee9 t\u01b0:<\/strong> = S\u1ed1 th\u1ee9 1 &#8211; SUM(S\u1ed1 th\u1ee9 2:S\u1ed1 th\u1ee9 n)<\/p>\n<h2>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t<\/h2>\n<p>\u1ede trong ph\u1ea7n n\u00e0y, ch\u00fang ta s\u1ebd c\u00f9ng \u0111i t\u00ecm hi\u1ec3u c\u00e1c c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 t\u00ednh tr\u1eeb trong Excel.<\/p>\n<h3 id=\"ftoc-3-1-su-dung-toan-tru\" class=\"wp-block-heading ftwp-heading ftwp-heading-target\">S\u1eed d\u1ee5ng to\u00e1n tr\u1eeb<\/h3>\n<p>C\u00f3 hai c\u00e1ch \u0111\u1ec3 b\u1ea1n th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh b\u1eb1ng ph\u01b0\u01a1ng ph\u00e1p s\u1eed d\u1ee5ng to\u00e1n tr\u1eeb. Tuy nhi\u00ean, c\u1ea7n l\u01b0u \u00fd r\u1eb1ng tr\u01b0\u1edbc khi nh\u1eadp s\u1ed1 ho\u1eb7c nh\u1eadp \u00f4 t\u00ednh, b\u1ea1n c\u1ea7n ph\u1ea3i nh\u1edb \u0111\u1eb7t d\u1ea5u &#8220;=&#8221; \u0111\u1ea7u ti\u00ean nh\u00e9!<\/p>\n<p><strong>C\u00e1ch 1:<\/strong> \u0110\u1ea7u ti\u00ean, b\u1ea1n \u0111\u1eb7t d\u1ea5u b\u1eb1ng \u1edf \u00f4 m\u00e0 m\u00ecnh mu\u1ed1n s\u1eed d\u1ee5ng ph\u00e9p tr\u1eeb, sau \u0111\u00f3, l\u1ea7n l\u01b0\u1ee3t nh\u1eadp c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 m\u00ecnh th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh hi\u1ec7u. Gi\u1eefa m\u1ed7i s\u1ed1, b\u1ea1n c\u1ea7n ph\u1ea3i nh\u1eadp d\u1ea5u tr\u1eeb &#8220;-&#8220;. Cu\u1ed1i c\u00f9ng, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3.<\/p>\n<p>V\u00ed d\u1ee5: B\u1ea1n mu\u1ed1n t\u00ednh hi\u1ec7u c\u1ee7a ph\u00e9p t\u00ednh 20-8. T\u1ea1i \u00f4 A1, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp theo c\u00fa ph\u00e1p sau:<strong> &#8220;=20-8&#8221;<\/strong>, sau \u0111\u00f3, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n Enter l\u00e0 k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 b\u1eb1ng 12.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-273834 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-4.jpg\" alt=\"ham-tru-trong-Excel-4 \" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>C\u00e1ch 2: <\/strong>C\u0169ng v\u1edbi ph\u00e9p t\u00ednh &#8220;=20-8&#8221;, b\u1ea1n s\u1ebd nh\u1eadp s\u1ed1 20 v\u00e0o \u00f4 A1 v\u00e0 s\u1ed1 10 v\u00e0o \u00f4 B1 nh\u01b0 \u1edf d\u01b0\u1edbi h\u00ecnh. Sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh hi\u1ec7u \u1edf b\u1ea5t k\u00ec \u00f4 n\u00e0o m\u00e0 m\u00ecnh mong mu\u1ed1n, \u1edf \u0111\u00e2y ch\u00fang ta s\u1ebd t\u00ednh \u1edf trong \u00f4 C1. \u0110\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3, b\u1ea1n v\u1eabn nh\u1eadp d\u1ea5u b\u1eb1ng \u0111\u1ea7u ti\u00ean, sau \u0111\u00f3 nh\u1ea5p v\u00e0o \u00f4 A1, ch\u1ecdn d\u1ea5u tr\u1eeb r\u1ed3i nh\u1eadp v\u00e0o \u00f4 B1 nh\u01b0 c\u00fa ph\u00e1p <strong>&#8220;=A1-B1&#8221;<\/strong>. Cu\u1ed1i c\u00f9ng b\u1ea1n s\u1ebd nh\u1ea5n Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-273835 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-5.jpg\" alt=\"ham-tru-trong-Excel-5 \" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3>Tr\u1eeb nhi\u1ec1u \u00f4<\/h3>\n<p>Khi t\u00ednh h\u00e0m tr\u1eeb trong Excel, b\u00ean c\u1ea1nh vi\u1ec7c t\u00ednh hi\u1ec7u cho hai ch\u1eef s\u1ed1 \u0111\u01a1n gi\u1ea3n, ch\u00fang ta c\u0169ng s\u1ebd th\u01b0\u1eddng xuy\u00ean g\u1eb7p ph\u1ea3i t\u00ecnh hu\u1ed1ng c\u1ea7n ph\u1ea3i tr\u1eeb nhi\u1ec1u s\u1ed1 c\u00f9ng m\u1ed9t l\u00fac. T\u01b0\u01a1ng t\u1ef1 nh\u01b0 nh\u1eefng h\u01b0\u1edbng d\u1eabn \u1edf tr\u00ean, ng\u01b0\u1eddi d\u00f9ng c\u0169ng c\u00f3 2 c\u00e1ch \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p tr\u1eeb cho hai s\u1ed1 tr\u1edf l\u00ean trong c\u00f9ng m\u1ed9t ph\u00e9p to\u00e1n.<\/p>\n<p>Ng\u01b0\u1eddi d\u00f9ng c\u1ea7n nh\u1eadp t\u1eebng s\u1ed1 li\u1ec7u v\u00e0o t\u1eebng \u00f4, sau \u0111\u00f3 ch\u1ecdn l\u1ea5y m\u1ed9t \u00f4 b\u1ea5t k\u00ec \u0111\u1ec3 cho ra k\u1ebft qu\u1ea3. V\u00ed d\u1ee5, b\u1ea1n ch\u1ecdn \u00f4 F2 l\u00e0m k\u1ebft qu\u1ea3 th\u00ec \u0111\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n nh\u1ea5n d\u1ea5u b\u1eb1ng r\u1ed3i l\u1ea7n l\u01b0\u1ee3t nh\u1ea5p v\u00e0o c\u00e1c \u00f4 A2, B2, C2, D2, E2. Gi\u1eefa m\u1ed7i k\u00ed t\u1ef1, b\u1ea1n c\u1ea7n nh\u1eadp d\u1ea5u tr\u1eeb \u0111\u1ec3 bi\u1ec3u th\u1ecb cho h\u00e0m t\u00ednh hi\u1ec7u. C\u00f4ng th\u1ee9c s\u1ebd l\u00e0: <strong>&#8220;=A2-B2-C2-D2-E2&#8221;.<\/strong> Cu\u1ed1i c\u00f9ng, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n Enter l\u00e0 s\u1ebd ra k\u1ebft qu\u1ea3.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-273836 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-6.jpg\" alt=\"ham-tru-trong-Excel-6 \" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 id=\"hmenuid5\">S\u1eed d\u1ee5ng H\u00e0m SUM<\/h3>\n<p>\u1ede trong ph\u1ea7n tr\u00ean, Ho\u00e0ng H\u00e0 Mobile \u0111\u00e3 h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel c\u01a1 b\u1ea3n nh\u1ea5t. Tuy nhi\u00ean, trong tr\u01b0\u1eddng h\u1ee3p ph\u00e9p tr\u1eeb c\u00f3 nhi\u1ec1u s\u1ed1 tr\u1edf l\u00ean, b\u1ea1n s\u1ebd c\u1ea3m th\u1ea5y r\u1ea5t m\u1ea5t th\u1eddi gian khi ph\u1ea3i nh\u1eadp t\u1eebng con s\u1ed1 m\u1ed9t ho\u1eb7c b\u1ea5m ch\u1ecdn l\u1ea7n l\u01b0\u1ee3t t\u1eebng \u00f4. N\u1ebfu kh\u00f4ng c\u1ea9n th\u1eadn, b\u1ea1n c\u0169ng s\u1ebd g\u1eb7p sai s\u00f3t trong qu\u00e1 tr\u00ecnh nh\u1eadp. Ch\u00ednh v\u00ec v\u1eady, ngo\u00e0i c\u00e1c ph\u01b0\u01a1ng ph\u00e1p k\u1ec3 tr\u00ean, ch\u00fang t\u00f4i s\u1ebd ch\u1ec9 ra th\u00eam m\u1ed9t c\u00e1ch c\u0169ng r\u1ea5t d\u1ec5 d\u00e0ng v\u00e0 nhanh ch\u00f3ng n\u1eefa \u0111\u00f3 ch\u00ednh l\u00e0 s\u1eed d\u1ee5ng h\u00e0m SUM \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh hi\u1ec7u.<\/p>\n<p>V\u1eady s\u1eed d\u1ee5ng h\u00e0m SUM nh\u01b0 th\u1ebf n\u00e0o, h\u00e3y c\u00f9ng v\u1edbi ch\u00fang t\u00f4i theo d\u00f5i nh\u1eefng v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n nh\u00e9!<\/p>\n<p><strong>C\u00e1ch 1:\u00a0<\/strong>D\u00f9ng m\u1ed9t s\u1ed1 tr\u1eeb cho h\u00e0m SUM. T\u1ee9c l\u00e0 \u0111\u1ea7u ti\u00ean, b\u1ea1n s\u1ebd nh\u1eadp c\u00e1c s\u1ed1 mu\u1ed1n tr\u1eeb v\u00e0o c\u00e1c \u00f4 A1, B1, C1, D1, E1. T\u1ea1i \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n cho ra k\u1ebft qu\u1ea3, \u1edf \u0111\u00e2y ch\u00fang t\u00f4i ch\u1ecdn l\u00e0 A3, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp theo c\u00fa ph\u00e1p <strong>&#8220;=A1-SUM(B1:E1)&#8221;<\/strong>. \u1ede \u0111\u00e2y SUM(B1:E1) l\u00e0 t\u1ed5ng c\u1ee7a c\u00e1c \u00f4 B1, C1, D1, E1. Nh\u01b0 v\u1eady ch\u1ec9 c\u1ea7n l\u1ea5y s\u1ed1 \u0111\u1ea7u ti\u00ean tr\u1eeb \u0111i t\u1ed5ng c\u00e1c s\u1ed1 \u1edf sau l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p t\u00ednh n\u00e0y r\u1ed3i \u0111\u00f3.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-273844 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-8.jpg\" alt=\"ham-tru-trong-Excel-8 \" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>C\u00e1ch 2: <\/strong>D\u00f9ng h\u00e0m SUM \u0111\u1ec3 tr\u1eeb. \u0110\u00e2y l\u00e0 c\u00e1ch m\u00e0 r\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng hay s\u1eed d\u1ee5ng b\u1edfi s\u1ef1 nhanh g\u1ecdn c\u1ee7a n\u00f3. B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00e1c gi\u00e1 tr\u1ecb v\u00e0o c\u00e1c \u00f4 m\u00e0 m\u00ecnh mu\u1ed1n t\u00ednh, \u1edf \u0111\u00e2y, ch\u00fang t\u00f4i s\u1ebd nh\u1eadp v\u00e0o c\u00e1c \u00f4 A1, B1, C1, D1, E1. Cu\u1ed1i c\u00f9ng, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp theo c\u00fa ph\u00e1p &#8220;<strong>=SUM(A1;-B1;-C1;-D1;-E1)&#8221; <\/strong>r\u1ed3i nh\u1ea5n Enter l\u00e0 ra k\u1ebft qu\u1ea3.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-273848 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-9.jpg\" alt=\"ham-tru-trong-Excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3>T\u00ednh tr\u1eeb theo t\u1ec9 l\u1ec7 %<\/h3>\n<p>B\u00ean c\u1ea1nh vi\u1ec7c t\u00ednh to\u00e1n v\u1edbi c\u00e1c ph\u00e9p tr\u1eeb c\u01a1 b\u1ea3n, ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00e9p tr\u1eeb % trong Excel. \u0110\u1ec3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh n\u00e0y, ng\u01b0\u1eddi d\u00f9ng c\u0169ng ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng d\u1ea5u &#8220;-&#8221; ho\u1eb7c h\u00e0m SUM \u0111\u1ec3 t\u00ednh v\u1edbi nh\u1eefng s\u1ed1 li\u1ec7u \u0111\u00e3 c\u00f3 s\u1eb5n ph\u1ea7n tr\u0103m. \u0110\u1ed1i v\u1edbi nh\u1eefng gi\u00e1 tr\u1ecb ch\u01b0a c\u00f3 ph\u1ea7n tr\u0103m, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam k\u00ed hi\u1ec7u % \u1edf ngay tr\u00ean b\u00e0n ph\u00edm. Sau \u0111\u00e2y l\u00e0 nh\u1eefng h\u01b0\u1edbng d\u1eabn chi ti\u1ebft \u0111\u1ec3 t\u00ednh ph\u00e9p tr\u1eeb theo t\u1ec9 l\u1ec7 %.<\/p>\n<p>V\u00ed d\u1ee5: \u0110\u1ec1 b\u00e0i y\u00eau c\u1ea7u t\u00ednh s\u1ed1 % h\u1ecdc sinh h\u1ea1nh ki\u1ec3m trung b\u00ecnh bi\u1ebft h\u1ecdc sinh h\u1ea1nh ki\u1ec3m t\u1ed1t chi\u1ebfm 60%, h\u1ecdc sinh h\u1ea1nh ki\u1ec3m kh\u00e1 chi\u1ebfm 35%.<\/p>\n<p><strong>C\u00e1ch 1:<\/strong> \u0110\u1ec3 t\u00ednh h\u1ecdc sinh h\u1ea1nh ki\u1ec3m trung b\u00ecnh, ta ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng d\u1ea5u tr\u1eeb r\u1ed3i t\u00ednh nh\u01b0 b\u00ecnh th\u01b0\u1eddng. \u1ede \u0111\u00e2y, trong \u00f4 B4, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp theo c\u00fa ph\u00e1p nh\u01b0 sau: <strong>&#8220;=B1-B2-B3&#8221;<\/strong> r\u1ed3i sau \u0111\u00f3 ch\u1ec9 c\u1ea7n nh\u1ea5n Enter l\u00e0 \u0111\u00e3 s\u1ebd bi\u1ebft \u0111\u01b0\u1ee3c h\u1ecdc sinh h\u1ea1nh ki\u1ec3m trung b\u00ecnh chi\u1ebfm bao nhi\u00eau % trong t\u1ed5ng s\u1ed1 100%.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-273849 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-10.jpg\" alt=\"ham-tru-trong-Excel-10 \" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>C\u00e1ch 2:<\/strong> C\u0169ng \u0111\u1ec3 t\u00ednh h\u1ecdc sinh h\u1ea1nh ki\u1ec3m trung b\u00ecnh chi\u1ebfm bao nhi\u00eau %, b\u1ea1n ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m SUM \u0111\u1ec3 t\u00ednh. \u0110\u1ed1i v\u1edbi h\u00e0m SUM, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n 1 trong 2 c\u00fa ph\u00e1p d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec1u \u0111\u01b0\u1ee3c.<\/p>\n<p>C\u00fa ph\u00e1p 1: &#8220;<strong>=B1-SUM(B2:B3)&#8221; <\/strong>r\u1ed3i nh\u1ea5n Enter. \u0110\u00e2y ch\u00ednh l\u00e0 c\u00f4ng th\u1ee9c d\u00f9ng m\u1ed9t s\u1ed1 tr\u1eeb cho h\u00e0m SUM \u0111\u00e3 nh\u1eafc \u0111\u1ebfn \u1edf tr\u00ean.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-273853 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-11.jpg\" alt=\"ham-tru-trong-Excel-11 \" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>C\u00fa ph\u00e1p 2: <strong>\u201c=SUM(B1;-B2;-B3)\u201d<\/strong> r\u1ed3i nh\u1ea5n Enter. \u0110\u00e2y ch\u00ednh l\u00e0 c\u00f4ng th\u1ee9c d\u00f9ng h\u00e0m SUM \u0111\u1ec3 tr\u1eeb.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-273854 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-12.jpg\" alt=\"ham-tru-trong-Excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>C\u1ea3 hai c\u00fa ph\u00e1p tr\u00ean \u0111\u1ec1u \u0111\u00fang, do \u0111\u00f3, t\u00f9y v\u00e0o t\u1eebng tr\u01b0\u1eddng h\u1ee3p kh\u00e1c nhau, b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn s\u1eed d\u1ee5ng sao cho ph\u00f9 h\u1ee3p v\u00e0 nhanh g\u1ecdn nh\u1ea5t.<\/p>\n<h3>Tr\u1eeb ng\u00e0y th\u00e1ng<\/h3>\n<p>B\u00ean c\u1ea1nh vi\u1ec7c tr\u1eeb c\u00e1c gi\u00e1 tr\u1ecb th\u00f4ng th\u01b0\u1eddng, tr\u1eeb t\u1ec9 l\u1ec7 ph\u1ea7n tr\u0103m, nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u0169ng c\u00f3 th\u1eafc m\u1eafc li\u1ec7u h\u00e0m tr\u1eeb trong Excel c\u00f3 \u00e1p d\u1ee5ng cho ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c kh\u00f4ng. Ngay trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n c\u00e1ch tr\u1eeb ng\u00e0y th\u00e1ng c\u1ef1c \u0111\u01a1n gi\u1ea3n, tuy nhi\u00ean, \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh n\u00e0y, b\u1ea1n c\u1ea7n ph\u1ea3i \u0111\u1ea3m b\u1ea3o c\u00e1c gi\u00e1 tr\u1ecb n\u00e0y \u0111\u00e3 \u0111\u01b0\u1ee3c chuy\u1ec3n sang \u0111\u1ecbnh d\u1ea1ng Date. K\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p t\u00ednh n\u00e0y s\u1ebd l\u00e0 s\u1ed1 ng\u00e0y ch\u00eanh l\u1ec7ch gi\u1eefa hai gi\u00e1 tr\u1ecb.<\/p>\n<p>V\u00ed d\u1ee5: \u0110\u1ec1 b\u00e0i y\u00eau c\u1ea7u tr\u1eeb hai ng\u00e0y 18\/08\/2021 v\u00e0 08\/08\/2021.<\/p>\n<p>\u0110\u1ea7u ti\u00ean, b\u1ea1n s\u1ebd c\u1ea7n nh\u1eadp c\u00e1c gi\u00e1 tr\u1ecb v\u00e0o c\u00e1c \u00f4 t\u00f9y ch\u1ecdn. \u1ede \u0111\u00e2y ch\u00fang t\u00f4i nh\u1eadp gi\u00e1 tr\u1ecb 18\/08\/2021 v\u00e0o \u00f4 A1 v\u00e0 08\/08\/2021 v\u00e0o \u00f4 B1.\u00a0Ti\u1ebfp theo, b\u1ea1n s\u1ebd ch\u1ecdn th\u00eam m\u1ed9t \u00f4 \u0111\u1ec3 cho ra k\u1ebft qu\u1ea3. V\u00ed d\u1ee5 nh\u01b0 trong h\u00ecnh \u1ea3nh d\u01b0\u1edbi, ch\u00fang t\u00f4i ch\u1ecdn \u00f4 A2. T\u1ea1i \u0111\u00e2y, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp theo c\u00fa ph\u00e1p: <strong>&#8220;=B1-A1&#8221; <\/strong>r\u1ed3i nh\u1ea5n Enter l\u00e0 \u0111\u00e3 ra k\u1ebft qu\u1ea3 r\u1ed3i \u0111\u00f3.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-273856 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-13.jpg\" alt=\"ham-tru-trong-Excel-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>Nh\u01b0 v\u1eady, tr\u00ean \u0111\u00e2y l\u00e0 to\u00e0n b\u1ed9 nh\u1eefng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t m\u00e0 Ho\u00e0ng H\u00e0 Mobile \u0111\u00e3 t\u00ecm hi\u1ec3u v\u00e0 t\u1ed5ng h\u1ee3p \u0111\u01b0\u1ee3c. \u1ede ph\u1ea7n ti\u1ebfp theo s\u1ebd l\u00e0 m\u1ed9t s\u1ed1 \u0111i\u1ec3m m\u00e0 b\u1ea1n c\u1ea7n l\u01b0u t\u00e2m \u0111\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u1ed1t nh\u1ea5t khi s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong ph\u1ea7n m\u1ec1m Excel.<\/p>\n<h3>M\u1ed9t s\u1ed1 \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel<\/h3>\n<p>C\u00f3 m\u1ed9t s\u1ed1 ng\u01b0\u1eddi d\u00f9ng khi th\u1ef1c hi\u1ec7n ph\u00e9p tr\u1eeb ng\u00e0y th\u00e1ng l\u1ea1i th\u01b0\u1eddng nh\u1eadn v\u1ec1 k\u1ebft qu\u1ea3 #Value. L\u00ed do c\u1ee7a tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 do ng\u00e0y th\u00e1ng m\u00e0 b\u1ea1n nh\u1eadp \u0111ang kh\u00e1c v\u1edbi \u0111\u1ecbnh d\u1ea1ng tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n. Ch\u00ednh v\u00ec v\u1eady, \u0111\u1ec3 c\u00f3 th\u1ec3 cho ra k\u1ebft qu\u1ea3, b\u1ea1n c\u1ea7n ki\u1ec3m tra c\u1ea9n th\u1eadn tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh nh\u00e9!<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-tru-trong-Excel-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-273857 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-14.jpg\" alt=\"ham-tru-trong-Excel-14 \" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-Excel-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture>B\u00ean c\u1ea1nh \u0111\u00f3, k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p t\u00ednh tr\u1eeb c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng theo \u00fd mu\u1ed1n c\u1ee7a b\u1ea1n m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng s\u1ed1 (s\u1ed1 th\u1eadp ph\u00e2n, d\u1ea5u ph\u1ea9y ng\u0103n c\u00e1ch h\u00e0ng ngh\u00ecn,&#8230;).<\/p>\n<h2>T\u1ed5ng k\u1ebft<\/h2>\n<p>Nh\u01b0 v\u1eady, trong b\u00e0i vi\u1ebft tr\u00ean, Ho\u00e0ng H\u00e0 Mobile \u0111\u00e3 \u0111\u01b0a ra c\u00e1c h\u01b0\u1edbng d\u1eabn chi ti\u1ebft v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel. C\u00e1c ph\u00e9p t\u00ednh tr\u1eeb l\u00e0 ph\u00e9p t\u00ednh c\u01a1 b\u1ea3n v\u00e0 th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u, tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i ai trong ch\u00fang ta c\u0169ng bi\u1ebft \u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang trong Excel. Ch\u00ednh v\u00ec v\u1eady, ch\u00fang t\u00f4i hy v\u1ecdng r\u1eb1ng th\u00f4ng qua b\u00e0i vi\u1ebft n\u00e0y, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng v\u00e0 th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng. Ngo\u00e0i ra, n\u1ebfu mu\u1ed1n bi\u1ebft th\u00eam c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 h\u00e0m SUM, <a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-or\/\">h\u00e0m OR<\/a> ho\u1eb7c c\u1eadp nh\u1eadt th\u00eam c\u00e1c th\u00f4ng tin kh\u00e1c v\u1ec1 \u0111\u1eddi s\u1ed1ng c\u00f4ng ngh\u1ec7, th\u1ee7 thu\u1eadt \u0111i\u1ec7n tho\u1ea1i, m\u00e1y t\u00ednh, b\u1ea1n c\u00f3 th\u1ec3 truy c\u1eadp v\u00e0o trang web c\u1ee7a <strong>Ho\u00e0ng H\u00e0 Mobile<\/strong> \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam nh\u00e9!<\/p>\n<p><strong>Xem th\u00eam:<\/strong><\/p>\n<div class=\"elementor-element elementor-element-e5d010f elementor-widget elementor-widget-theme-post-title elementor-page-title elementor-widget-heading\" data-id=\"e5d010f\" data-element_type=\"widget\" data-widget_type=\"theme-post-title.default\">\n<div class=\"elementor-widget-container\">\n<ul>\n<li><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-or\/\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m OR trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft<\/a><\/li>\n<li><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-trung-binh-trong-excel\/\">H\u00e0m AVERAGE trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m trung b\u00ecnh c\u1ed9ng<\/a><\/li>\n<li><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel l\u00e0 \u0111i\u1ec1u m\u00e0 r\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m b\u1edfi \u0111\u00e2y l\u00e0 ph\u00e9p t\u00ednh \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i trong \u0111\u1eddi s\u1ed1ng h\u00e0ng ng\u00e0y. D\u00f9 th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng, tuy nhi\u00ean, kh\u00f4ng \u00edt ng\u01b0\u1eddi d\u00f9ng c\u1ea3m th\u1ea5y b\u1ed1i r\u1ed1i khi th\u1ef1c hi\u1ec7n ch\u00fang tr\u00ean ph\u1ea7n m\u1ec1m Excel. Trong b\u00e0i [&hellip;]<\/p>\n","protected":false},"author":70,"featured_media":274523,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-273458","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>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft<\/title>\n<meta name=\"description\" content=\"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft.\" \/>\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\/ham-tru-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft\" \/>\n<meta property=\"og:description\" content=\"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/\" \/>\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=\"2023-10-19T12:34:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-excel-thumb.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=\"Ho\u00e0ng T\u00ecnh\" \/>\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=\"Ho\u00e0ng T\u00ecnh\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 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\/ham-tru-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/\"},\"author\":{\"name\":\"Ho\u00e0ng T\u00ecnh\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/985f7044676f9c0955d7e5749c279b5d\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft\",\"datePublished\":\"2023-10-19T12:34:16+00:00\",\"dateModified\":\"2023-10-19T12:34:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/\"},\"wordCount\":3068,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-excel-thumb.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-excel-thumb.jpg\",\"datePublished\":\"2023-10-19T12:34:16+00:00\",\"dateModified\":\"2023-10-19T12:34:16+00:00\",\"description\":\"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-excel-thumb.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-excel-thumb.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-tru-trong-excel-thumb\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft\"}]},{\"@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\/985f7044676f9c0955d7e5749c279b5d\",\"name\":\"Ho\u00e0ng T\u00ecnh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/43d0cc0d9bb533a78c213eee628b7035?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/43d0cc0d9bb533a78c213eee628b7035?s=96&d=mm&r=g\",\"caption\":\"Ho\u00e0ng T\u00ecnh\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/hoang-tinh\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft","description":"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft.","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\/ham-tru-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft","og_description":"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-10-19T12:34:16+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-excel-thumb.jpg","type":"image\/jpeg"}],"author":"Ho\u00e0ng T\u00ecnh","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Ho\u00e0ng T\u00ecnh","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/"},"author":{"name":"Ho\u00e0ng T\u00ecnh","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/985f7044676f9c0955d7e5749c279b5d"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft","datePublished":"2023-10-19T12:34:16+00:00","dateModified":"2023-10-19T12:34:16+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/"},"wordCount":3068,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-excel-thumb.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-excel-thumb.jpg","datePublished":"2023-10-19T12:34:16+00:00","dateModified":"2023-10-19T12:34:16+00:00","description":"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-excel-thumb.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-tru-trong-excel-thumb.jpg","width":1200,"height":628,"caption":"ham-tru-trong-excel-thumb"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tru-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft"}]},{"@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\/985f7044676f9c0955d7e5749c279b5d","name":"Ho\u00e0ng T\u00ecnh","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/43d0cc0d9bb533a78c213eee628b7035?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/43d0cc0d9bb533a78c213eee628b7035?s=96&d=mm&r=g","caption":"Ho\u00e0ng T\u00ecnh"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/hoang-tinh\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/273458","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\/70"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=273458"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/273458\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/274523"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=273458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=273458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=273458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}