{"id":8029,"date":"2024-12-21T19:31:20","date_gmt":"2024-12-21T19:31:20","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-su-dung-ham-choose-trong-excel\/"},"modified":"2024-12-21T19:31:20","modified_gmt":"2024-12-21T19:31:20","slug":"huong-dan-su-dung-ham-choose-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-su-dung-ham-choose-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m CHOOSE trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>H\u00e0m CHOOSE l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel \u1edf kha kh\u00e1 tr\u01b0\u1eddng h\u1ee3p. N\u00f3 r\u1ea5t \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng nhi\u1ec1u, trong \u0111\u00f3 c\u00f3 s\u1ef1 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m t\u00ednh t\u1ed5ng SUM.\u00a0<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">H\u00e0m<strong> CHOOSE \u00a0<\/strong>gi\u00fap\u00a0t\u00ecm ki\u1ebfm 1 gi\u00e1 tr\u1ecb trong 1 chu\u1ed7i gi\u00e1 tr\u1ecb. N\u00f3 l\u00e0 1 trong nh\u1eefng h\u00e0m ph\u1ed5 bi\u1ebfn \u0111\u01b0\u1ee3c d\u00f9ng nhi\u1ec1u trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n v\u00e0 t\u00ecm ki\u1ebfm trong Excel.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6767178798f81\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-choose-trong-excel.html#Cu_phap_CHOOSEindex_num_value1_value2%E2%80%A6\" title=\"C\u00fa ph\u00e1p:\u00a0=CHOOSE(index_num, value1, [value2]\u2026).\">C\u00fa ph\u00e1p:\u00a0=CHOOSE(index_num, value1, [value2]\u2026).<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-choose-trong-excel.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-choose-trong-excel.html#Ham_CHOOSE_ket_hop_voi_ham_SUM\" title=\"H\u00e0m CHOOSE k\u1ebft h\u1ee3p v\u1edbi h\u00e0m SUM\">H\u00e0m CHOOSE k\u1ebft h\u1ee3p v\u1edbi h\u00e0m SUM<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-choose-trong-excel.html#Dua_vao_bang_so_lieu_ket_hop_ham_CHOOSE_voi_ham_SUM_de_tinh\" title=\"D\u1ef1a v\u00e0o b\u1ea3ng s\u1ed1 li\u1ec7u, k\u1ebft h\u1ee3p h\u00e0m CHOOSE v\u1edbi h\u00e0m SUM \u0111\u1ec3 t\u00ednh:\">D\u1ef1a v\u00e0o b\u1ea3ng s\u1ed1 li\u1ec7u, k\u1ebft h\u1ee3p h\u00e0m CHOOSE v\u1edbi h\u00e0m SUM \u0111\u1ec3 t\u00ednh:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cu_phap_CHOOSEindex_num_value1_value2%E2%80%A6\"><\/span><strong>C\u00fa ph\u00e1p:<\/strong>\u00a0=<strong>CHOOSE(index_num, value1, [value2]\u2026)<\/strong>.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\"><em>Trong \u0111\u00f3<\/em>:<\/p>\n<p style=\"text-align: justify\">\u2013 <strong>index_num<\/strong>: V\u1ecb tr\u00ed c\u1ee7a d\u1eef li\u1ec7u tr\u1ea3 v\u1ec1. Gi\u00e1 tr\u1ecb <strong>index_num<\/strong> ph\u1ea3i l\u00e0 s\u1ed1 nguy\u00ean ho\u1eb7c l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a 1 c\u00f4ng th\u1ee9c nh\u01b0ng ph\u1ea3i l\u00e0 gi\u00e1 tr\u1ecb nguy\u00ean. Gi\u1edbi h\u1ea1n <strong>index_num<\/strong> trong kho\u1ea3ng t\u1eeb 1 \u0111\u1ebfn 29. \u00a0N\u1ebfu <strong>index_num =1<\/strong> =&gt; Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 l\u00e0 <strong>value 1<\/strong>, <strong>index_num =2<\/strong> =&gt; gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 l\u00e0 <strong>value2<\/strong>\u2026<\/p>\n<p style=\"text-align: justify\">\u2013 <strong>value1<\/strong>: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 th\u1ee9 1.<\/p>\n<p style=\"text-align: justify\">\u2013 <strong>value2<\/strong>: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 th\u1ee9 2.<\/p>\n<p style=\"text-align: justify\">C\u00e1c gi\u00e1 tr\u1ecb <strong>value<\/strong> n\u1eb1m trong kho\u1ea3ng t\u1eeb 1 \u0111\u1ebfn 29.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-724.gif\" title=\"ex101_92019-nho-724\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong><em>Ch\u00fa \u00fd: <\/em><\/strong>N\u1ebfu gi\u00e1 tr\u1ecb <strong>index_num<\/strong> kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1 nguy\u00ean h\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i <strong>#Value!<\/strong><\/p>\n<blockquote>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">C\u00e1c h\u00e0m th\u00f4ng d\u1ee5ng trong excel <\/a><\/p>\n<\/blockquote>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span><strong>V\u00ed d\u1ee5<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>1\/ Nh\u1eadp: <strong>=CHOOSE(2;100;\u201dExcel\u201d;100) =&gt;\u00a0<\/strong>Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 l\u00e0 <strong>Excel<\/strong><\/p>\n<p>2\/ Nh\u1eadp:\u00a0<strong>=CHOOSE(1;100;200;\u201dH\u1ecdc Excel\u201d) =&gt;\u00a0<\/strong>Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 l\u00e0 <strong>100<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3978 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-choose.png\" width=\"600\" height=\"489\" title=\"ham-choose\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Ham_CHOOSE_ket_hop_voi_ham_SUM\"><\/span>H\u00e0m CHOOSE k\u1ebft h\u1ee3p v\u1edbi <a href=\"https:\/\/blog.hocexcel.online\/ham-sumif-trong-excel-ham-tinh-tong-theo-mot-dieu-kien-cho-truoc.html\">h\u00e0m SUM<\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<h4><span class=\"ez-toc-section\" id=\"Dua_vao_bang_so_lieu_ket_hop_ham_CHOOSE_voi_ham_SUM_de_tinh\"><\/span>D\u1ef1a v\u00e0o b\u1ea3ng s\u1ed1 li\u1ec7u, k\u1ebft h\u1ee3p h\u00e0m CHOOSE v\u1edbi h\u00e0m SUM \u0111\u1ec3 t\u00ednh:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>C\u00f4ng th\u1ee9c:\u00a0<strong>=SUM(CHOOSE(2;C4:C9;E4:E9)),\u00a0<\/strong>thu \u0111\u01b0\u1ee3c\u00a0t\u1ed5ng s\u1ed1 ti\u1ec1n ph\u1ea3i thanh to\u00e1n:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3982 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-choose-1.png\" width=\"600\" height=\"425\" title=\"ham-choose-1\"><\/p>\n<ul>\n<li>C\u00f4ng th\u1ee9c: <strong>=SUM(CHOOSE(1;D4:D9;E4:E9)),\u00a0<\/strong>thu \u0111\u01b0\u1ee3c\u00a0t\u1ed5ng s\u1ed1l\u01b0\u1ee3ng m\u1eb7t h\u00e0ng trong b\u1ea3ng:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3983 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-choose-2.png\" width=\"600\" height=\"424\" title=\"ham-choose-2\"><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-724.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8030,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8029","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8029","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8029"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8029\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8030"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}