{"id":12069,"date":"2025-01-15T06:54:18","date_gmt":"2025-01-15T06:54:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-switch-thay-the-cho-if-long-trong-excel-2016\/"},"modified":"2025-01-15T06:54:18","modified_gmt":"2025-01-15T06:54:18","slug":"ham-switch-thay-the-cho-if-long-trong-excel-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-switch-thay-the-cho-if-long-trong-excel-2016\/","title":{"rendered":"H\u00e0m SWITCH thay th\u1ebf cho IF l\u1ed3ng trong Excel 2016"},"content":{"rendered":"
\n

\u0110\u00e3 bao gi\u1edd b\u1ea1n ph\u1ea3i \u0111i\u00ean \u0111\u1ea7u v\u00e0 m\u1ea5t th\u1eddi gian \u0111\u1ec3 s\u1eeda nh\u1eefng h\u00e0m IF<\/a><\/strong> l\u1ed3ng nhau r\u1ea5t kh\u00f3 v\u00e0 t\u1ed1n th\u1eddi gian \u0111\u1ec3 vi\u1ebft cho \u0111\u00fang ngay l\u1ea7n \u0111\u1ea7u ti\u00ean? Sau bao nhi\u00eau n\u0103m ch\u1edd \u0111\u1ee3i, Microsoft cu\u1ed1i c\u00f9ng c\u0169ng \u0111\u00e3 th\u00eam h\u00e0m SWITCH v\u00e0o trong Excel 2016, Office 365, Excel Online v\u00e0 Excel tr\u00ean c\u00e1c n\u1ec1n t\u1ea3ng iOS, Android.<\/em><\/p>\n

H\u00e0m Switch trong Excel \u2013 c\u00fa ph\u00e1p<\/h2>\n

=SWITCH(<gi\u00e1 tr\u1ecb \/ \u00f4 tham chi\u1ebfu>, <gi\u00e1 tr\u1ecb 1>, <k\u1ebft qu\u1ea3 1>, [ \u2026 ] )<\/strong><\/p>\n

Gi\u1edbi h\u1ea1n c\u1ee7a h\u00e0m trong Excel l\u00e0 254 tham s\u1ed1, v\u1eady v\u1edbi gi\u1edbi h\u1ea1n n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 x\u1eed l\u00fd t\u1edbi 126 c\u1eb7p <gi\u00e1 tr\u1ecb \u2013 k\u1ebft qu\u1ea3><\/p>\n

V\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m Switch trong Excel: Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 b\u1ea3ng sau \u0111\u00e2y:<\/p>\n

\"ham-switch-trong-excel\"<\/a>
ham-switch-trong-excel<\/figcaption><\/figure>\n
\n

Xem th\u00eam:\u00a0h\u01b0\u1edbng d\u1eabn h\u1ecdc excel 2016\u00a0<\/a><\/p>\n<\/blockquote>\n

H\u00e0m Switch \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong \u00f4 D2 nh\u01b0 sau:<\/p>\n

=SWITCH(A2,\u201dC\u201d,\u201dContemporary\u201d,\u201dD\u201d,\u201dDiscontinue\u201d,\u201dT\u201d,\u201dTemporary\u201d)<\/strong><\/p>\n

V\u1edbi s\u1ef1 ra \u0111\u1eddi c\u1ee7a h\u00e0m Switch n\u00e0y trong Excel, c\u00f4ng vi\u1ec7c c\u1ee7a ch\u00fang ta s\u1ebd nh\u1eb9 nh\u00e0ng h\u01a1n khi \u00edt ph\u1ea3i vi\u1ebft c\u00e1c h\u00e0m IF l\u1ed3ng h\u01a1n.<\/p>\n

Tham kh\u1ea3o c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh h\u1ecdc c\u1ee7a H\u1ecdc Excel Online ngay b\u00e2y gi\u1edd:<\/strong><\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n\n\n\n\n\n\n\n\n\n
H\u1ecdc Excel, C\u00f3 Vi\u1ec7c Ngay<\/td>\nhttps:\/\/www.hocexcel.online\/ex101<\/a><\/td>\n<\/tr>\n
Luy\u1ec7n h\u00e0m v\u00e0 c\u00f4ng c\u1ee5 Excel<\/td>\nhttps:\/\/blog.hocexcel.online\/ex102<\/a><\/td>\n<\/tr>\n
H\u00e3y \u0111\u1ec3 VBA gi\u00fap b\u1ea1n<\/td>\nhttps:\/\/blog.hocexcel.online\/vba101<\/a><\/td>\n<\/tr>\n
Pro VBA n\u00e2ng cao<\/td>\nhttps:\/\/blog.hocexcel.online\/vba201<\/a><\/td>\n<\/tr>\n
Hi\u1ec3u v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1edbi Excel<\/td>\nhttps:\/\/blog.hocexcel.online\/dv101<\/a><\/td>\n<\/tr>\n
H\u00e3y l\u00e0m k\u1ebf to\u00e1n kho v\u1edbi VBA<\/td>\nhttps:\/\/blog.hocexcel.online\/im101<\/a><\/td>\n<\/tr>\n
Qu\u1ea3n l\u00fd kho h\u00e0ng pro trong Excel<\/td>\nhttps:\/\/blog.hocexcel.online\/im201<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12070,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12069","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12069","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=12069"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12069\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12070"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12069"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12069"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12069"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}