{"id":24375,"date":"2021-05-11T11:56:18","date_gmt":"2021-05-11T04:56:18","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24375"},"modified":"2021-05-11T11:56:18","modified_gmt":"2021-05-11T04:56:18","slug":"ham-tru-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-tru-trong-excel\/","title":{"rendered":"H\u01b0\u1edfng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m tr\u1eeb trong Excel qua v\u00ed d\u1ee5 b\u00e0i t\u1eadp"},"content":{"rendered":"<p>C\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft, trong Excel kh\u00f4ng t\u1ed3n t\u1ea1i h\u00e0m tr\u1eeb, thay v\u00e0o \u0111\u00f3 c\u0169ng ta s\u1ebd s\u1eed d\u1ee5ng to\u00e1n t\u1eed \u201c-\u201d \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh tr\u1eeb. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y Ben Computer s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng ph\u00e9p tr\u1eeb, <strong>h\u00e0m tr\u1eeb trong Excel<\/strong>. B\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o ti\u1ebfp b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h2><strong>C\u00f4ng th\u1ee9c, c\u00fa ph\u00e1p h\u00e0m tr\u1eeb trong Excel<\/strong><\/h2>\n<p>Nh\u01b0 Ben Computer \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf tr\u00ean, trong Excel kh\u00f4ng t\u1ed3n t\u1ea1i, kh\u00f4ng c\u00f3 h\u00e0m tr\u1eeb. Thay v\u00e0o \u0111\u00f3 \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p tr\u1eeb \u0111\u01a1n gi\u1ea3n, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng to\u00e1n t\u1eed \u201c-\u201c.<\/p>\n<p>C\u00fa ph\u00e1p, c\u00f4ng th\u1ee9c <strong>h\u00e0m tr\u1eeb trong Excel<\/strong> c\u01a1 b\u1ea3n c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<blockquote><p><strong>=number1-number2<\/strong><\/p><\/blockquote>\n<figure id=\"attachment_24376\" aria-describedby=\"caption-attachment-24376\" style=\"width: 512px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"266\" class=\"wp-image-24376 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-tru-trong-excel.png\" alt=\"H\u00e0m tr\u1eeb trong Excel\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-tru-trong-excel.png 512w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-tru-trong-excel-300x156.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><figcaption id=\"caption-attachment-24376\" class=\"wp-caption-text\">H\u00e0m tr\u1eeb trong Excel<\/figcaption><\/figure>\n<p><strong>V\u00ed d\u1ee5 1<\/strong>: \u0111\u1ec3 tr\u1eeb gi\u00e1 tr\u1ecb 100 cho 10, ch\u00fang ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m Excel c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p><strong>=100-10<\/strong><\/p>\n<p>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 90.<\/p>\n<p>\u0110\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c <strong>h\u00e0m tr\u1eeb trong Excel<\/strong> v\u00e0o \u00f4 b\u1ea3ng t\u00ednh, b\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<ul>\n<li>Trong \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1, nh\u1eadp d\u1ea5u b\u1eb1ng<strong>\u00a0(=).<\/strong><\/li>\n<li>Nh\u1eadp gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean, sau \u0111\u00f3 l\u00e0 d\u1ea5u tr\u1eeb<strong>\u00a0(-)<\/strong>\u00a0r\u1ed3i nh\u1eadp gi\u00e1 tr\u1ecb th\u1ee9 2.<\/li>\n<li>Cu\u1ed1i c\u00f9ng nh\u1ea5n<strong>\u00a0Enter<\/strong>\u00a0\u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3.<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5 2:<\/strong><\/p>\n<p>\u0110\u1ec3 tr\u1eeb 100 cho nhi\u1ec1u gi\u00e1 tr\u1ecb kh\u00e1c, ch\u00fang ta s\u1eed d\u1ee5ng d\u1ea5u tr\u1eeb l\u00e0m d\u1ea5u ph\u00e2n t\u00e1ch.<\/p>\n<p>Nh\u01b0 v\u1eady c\u00f4ng th\u1ee9c h\u00e0m tr\u1eeb trong Excel c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p><strong>=100-10-20-30<\/strong><\/p>\n<p>\u0110\u1ec3 bi\u1ebft ph\u1ea7n n\u00e0o trong c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n, t\u00ednh tr\u01b0\u1edbc, ch\u00fang ta s\u1eed d\u1ee5ng d\u1ea5u ngo\u1eb7c \u0111\u01a1n, v\u00ed d\u1ee5:<\/p>\n<p><strong>=(100-10)\/(80-20)<\/strong><\/p>\n<p>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"252\" height=\"139\" class=\"aligncenter wp-image-17524 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-27.png\" alt=\"1 27 - C\u00e1ch d\u00f9ng h\u00e0m tr\u1eeb trong Excel - Ben Computer\" \/><\/p>\n<h2><strong>C\u00e1ch tr\u1eeb nhi\u1ec1u \u00f4 trong Excel<\/strong><\/h2>\n<p>C\u00f3 nhi\u1ec1u c\u00e1ch \u0111\u1ec3 tr\u1eeb nhi\u1ec1u \u00f4 trong Excel, ch\u1eb3ng h\u1ea1n s\u1eed d\u1ee5ng to\u00e1n t\u1eed (-) ho\u1eb7c s\u1eed d\u1ee5ng h\u00e0m SUM, \u2026 .<\/p>\n<h3><strong>C\u00e1ch 1: S\u1eed d\u1ee5ng to\u00e1n t\u1eed (-)<\/strong><\/h3>\n<p>Ch\u1ec9 c\u1ea7n nh\u1eadp s\u1ed1 tham chi\u1ebfu \u00f4 \u0111\u01b0\u1ee3c ph\u00e2n t\u00e1ch b\u1eb1ng d\u1ea5u tr\u1eeb nh\u01b0 ch\u00fang ta \u0111\u00e3 l\u00e0m khi tr\u1eeb nhi\u1ec1u s\u1ed1.<\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong>\u00a0\u0111\u1ec3 tr\u1eeb gi\u00e1 tr\u1ecb trong \u00f4 B2: B6 kh\u1ecfi \u00f4 B1, ch\u00fang ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m Excel nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><strong>= B1-B2-B3-B4-B5-B6<\/strong><\/p>\n<h3><strong>C\u00e1ch 2: S\u1eed d\u1ee5ng h\u00e0m SUM<\/strong><\/h3>\n<p>M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 tr\u1eeb nhi\u1ec1u \u00f4 trong Excel l\u00e0 s\u1eed d\u1ee5ng h\u00e0m SUM. Ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m SUM \u0111\u1ec3 c\u1ed9ng c\u00e1c chu\u1ed7i con (B2: B6), sau \u0111\u00f3 tr\u1eeb t\u1ed5ng gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t:<\/p>\n<p><strong>=B1-SUM(B2:B6)<\/strong><\/p>\n<h2><strong>Tr\u1eeb ng\u00e0y th\u00e1ng trong Excel<\/strong><\/h2>\n<h3><strong>C\u00e1ch 1: S\u1eed d\u1ee5ng to\u00e1n t\u1eed (-)<\/strong><\/h3>\n<p>\u0110\u1ec3 tr\u1eeb ng\u00e0y th\u00e1ng trong Excel, c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t l\u00e0 ch\u00fang ta s\u1eed d\u1ee5ng d\u1ea5u tr\u1eeb (-). Ho\u1eb7c m\u1ed9t c\u00e1ch kh\u00e1c l\u00e0 s\u1eed d\u1ee5ng h\u00e0m Date \u0111\u1ec3 t\u00ednh to\u00e1n c\u00e1c gi\u00e1 tr\u1ecb l\u00e0 ng\u00e0y th\u00e1ng.<\/p>\n<p>Cho v\u00ed d\u1ee5, gi\u1ea3 s\u1eed \u00f4 A1 ch\u00fang ta nh\u1eadp gi\u00e1 tr\u1ecb l\u00e0 1\/10\/2021<\/p>\n<p>\u00d4 A2 l\u00e0 1\/11\/2021.<\/p>\n<p>\u0110\u1ec3 t\u00ednh to\u00e1n gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng, ch\u00fang ta nh\u1eadp c\u00f4ng th\u1ee9c trong \u00f4 A3 l\u00e0 =A2-A1. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 s\u1ed1 ng\u00e0y = 30 ng\u00e0y.<\/p>\n<h3><strong>C\u00e1ch 2: S\u1eed d\u1ee5ng h\u00e0m Date Excel ho\u1eb7c h\u00e0m Datevalue<\/strong><\/h3>\n<p>Ngo\u00e0i s\u1eed d\u1ee5ng to\u00e1n t\u1eed (-) \u0111\u1ec3 tr\u1eeb ng\u00e0y th\u00e1ng, ng\u01b0\u1eddi d\u00f9ng c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Date ho\u1eb7c Datevalue \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p tr\u1eeb gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng tr\u1ef1c ti\u1ebfp.<\/p>\n<p>Cho v\u00ed d\u1ee5, gi\u1ea3 s\u1eed ch\u00fang ta nh\u1eadp ng\u00e0y trong \u00f4 D2 l\u00e0 15\/01\/2021 v\u00e0 \u00f4 D3 l\u00e0 20\/01\/2021. \u0110\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p tr\u1eeb gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng, trong \u00f4 D4 ch\u00fang ta nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n<p><strong>=Date (2021,1, 20) \u2013 Date(2021, 1, 15)<\/strong>\u00a0r\u1ed3i nh\u1ea5n Enter.<\/p>\n<p>H\u00e0m Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 tr\u1ef1c ti\u1ebfp.<\/p>\n<p>Ngo\u00e0i ra ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Datevalue \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m Date. C\u00f4ng th\u1ee9c, c\u00fa ph\u00e1p h\u00e0m Datevalue m\u00e0 ch\u00fang ta s\u1eed d\u1ee5ng c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><strong>=DATEVALUE(\u201c20\/01\/2021\u201d)-DATEVALUE(\u201c15\/01\/2021\u201d)<\/strong><\/p>\n<h2><strong>Tr\u1eeb ph\u1ea7n tr\u0103m trong Excel<\/strong><\/h2>\n<p>T\u01b0\u01a1ng t\u1ef1, \u0111\u1ec3 tr\u1eeb ph\u1ea7n tr\u0103m trong Excel, ch\u00fang ta c\u0169ng s\u1eed d\u1ee5ng d\u1ea5u tr\u1eeb (-) nh\u01b0 b\u00ecnh th\u01b0\u01a1ng.<\/p>\n<p>V\u00ed d\u1ee5, gi\u1ea3 s\u1eed \u00f4 A1 gi\u00e1 tr\u1ecb l\u00e0 20% v\u00e0 \u00f4 A2 l\u00e0 80%.<\/p>\n<p>C\u00f4ng th\u1ee9c tr\u1eeb ph\u1ea7n tr\u0103m trong \u00f4 A3 c\u00f3 d\u1ea1ng: =A2-A1. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 60%.<\/p>\n<p>Nh\u01b0 v\u1eady tr\u00ean \u0111\u00e2y Ben Computer v\u1eeba h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch d\u00f9ng <strong>h\u00e0m tr\u1eeb trong Excel<\/strong>. Ngo\u00e0i ra n\u1ebfu c\u00f2n th\u1eafc m\u1eafc ho\u1eb7c c\u00e2u h\u1ecfi n\u00e0o c\u1ea7n gi\u1ea3i \u0111\u00e1p th\u00eam, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 \u0111\u1ec3 l\u1ea1i \u00fd ki\u1ebfn c\u1ee7a m\u00ecnh trong ph\u1ea7n b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi b\u00e0i vi\u1ebft nh\u00e9. Ben s\u1ebd tr\u1ea3 l\u1eddi c\u00e2u h\u1ecfi c\u1ee7a b\u1ea1n s\u1edbm nh\u1ea5t c\u00f3 th\u1ec3.<\/p>\n<p>Xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft c\u00f9ng ch\u1ee7 \u0111\u1ec1:<\/p>\n<ul>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-countifs-trong-excel\/\">H\u00e0m Countifs trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-dsum-trong-excel\/\">H\u00e0m Dsum trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-average-trong-excel\/\">H\u00e0m Average trong Excel<\/a><\/li>\n<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-right-trong-excel\/\">H\u00e0m Right trong Excel<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>C\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft, trong Excel kh\u00f4ng t\u1ed3n t\u1ea1i h\u00e0m tr\u1eeb, thay v\u00e0o \u0111\u00f3 c\u0169ng ta s\u1ebd s\u1eed d\u1ee5ng to\u00e1n t\u1eed \u201c-\u201d \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh tr\u1eeb. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y Ben Computer s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng ph\u00e9p tr\u1eeb, h\u00e0m tr\u1eeb trong Excel. B\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o ti\u1ebfp [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":24376,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24375","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=24375"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24375\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24376"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}