{"id":8829,"date":"2024-12-29T05:42:50","date_gmt":"2024-12-29T05:42:50","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-cach-viet-nhieu-ham-if-long-nhau-de-hieu-de-thuc-hien\/"},"modified":"2024-12-29T05:42:50","modified_gmt":"2024-12-29T05:42:50","slug":"huong-dan-cach-viet-nhieu-ham-if-long-nhau-de-hieu-de-thuc-hien","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-cach-viet-nhieu-ham-if-long-nhau-de-hieu-de-thuc-hien\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch vi\u1ebft nhi\u1ec1u h\u00e0m IF l\u1ed3ng nhau d\u1ec5 hi\u1ec3u d\u1ec5 th\u1ef1c hi\u1ec7n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong nh\u1eefng y\u00eau c\u1ea7u vi\u1ebft h\u00e0m\u00a0IF c\u00f3 nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n, ch\u00fang ta th\u01b0\u1eddng ph\u1ea3i l\u1ed3ng nhi\u1ec1u h\u00e0m\u00a0IF v\u00e0o v\u1edbi nhau. V\u1eady l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 ch\u00fang ta\u00a0c\u00f3 th\u1ec3 vi\u1ebft\u00a0\u0111\u00fang, d\u1ec5\u00a0\u0111\u1ecdc, d\u1ec5 hi\u1ec3u\u00a0\u0111\u01b0\u1ee3c nh\u1eefng h\u00e0m\u00a0IF l\u1ed3ng gh\u00e9p ph\u1ee9c t\u1ea1p\u00a0\u0111\u00f3? Sau\u00a0\u0111\u00e2y H\u1ecdc\u00a0Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n m\u1ed9t\u00a0c\u00e1ch vi\u1ebft nhi\u1ec1u h\u00e0m IF l\u1ed3ng nhau d\u1ec5 hi\u1ec3u d\u1ec5 th\u1ef1c hi\u1ec7n. C\u00f9ng t\u00ecm hi\u1ec3u n\u00e0o:<\/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-6770e15954b30\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-nhieu-ham-if-long-nhau-de-hieu-de-thuc-hien.html#Cach_viet_ham_IF_theo_nhieu_dieu_kien_long_nhau\" title=\"C\u00e1ch\u00a0vi\u1ebft h\u00e0m\u00a0IF theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n l\u1ed3ng nhau\">C\u00e1ch\u00a0vi\u1ebft h\u00e0m\u00a0IF theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n l\u1ed3ng nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-nhieu-ham-if-long-nhau-de-hieu-de-thuc-hien.html#Cach_viet_cong_thuc_trong_Excel_giup_de_doc_de_kiem_tra\" title=\"C\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c trong\u00a0Excel gi\u00fap d\u1ec5\u00a0\u0111\u1ecdc , d\u1ec5 ki\u1ec3m tra\">C\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c trong\u00a0Excel gi\u00fap d\u1ec5\u00a0\u0111\u1ecdc , d\u1ec5 ki\u1ec3m tra<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-nhieu-ham-if-long-nhau-de-hieu-de-thuc-hien.html#Ky_thuat_xuong_dong_trong_cong_thuc\" title=\"K\u1ef9 thu\u1eadt xu\u1ed1ng d\u00f2ng trong c\u00f4ng th\u1ee9c\">K\u1ef9 thu\u1eadt xu\u1ed1ng d\u00f2ng trong c\u00f4ng th\u1ee9c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-nhieu-ham-if-long-nhau-de-hieu-de-thuc-hien.html#Su_dung_dau_cach_khi_viet_cac_thanh_phan_trong_cong_thuc\" title=\"S\u1eed d\u1ee5ng d\u1ea5u c\u00e1ch khi vi\u1ebft c\u00e1c th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c\">S\u1eed d\u1ee5ng d\u1ea5u c\u00e1ch khi vi\u1ebft c\u00e1c th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-nhieu-ham-if-long-nhau-de-hieu-de-thuc-hien.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_viet_ham_IF_theo_nhieu_dieu_kien_long_nhau\"><\/span>C\u00e1ch\u00a0vi\u1ebft h\u00e0m\u00a0IF theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26653\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-if-nhieu-dieu-kien-de-bai-1024x279-2.png\" width=\"1024\" height=\"279\" title=\"ham-if-nhieu-dieu-kien-de-bai-1024x279-2\"><\/p>\n<p>Trong h\u00ecnh tr\u00ean, ch\u00fang ta c\u00f3 2 b\u1ea3ng g\u1ed3m:<\/p>\n<ul>\n<li>B\u1ea3ng k\u1ebft qu\u1ea3 ho\u1ea1t\u00a0\u0111\u1ed9ng: Y\u00eau c\u1ea7u t\u00ednh m\u1ee9c th\u01b0\u1edfng d\u1ef1a theo\u00a0\u0111i\u1ec3m KPIs, t\u1eeb\u00a0\u0111\u00f3 x\u00e1c\u00a0\u0111\u1ecbnh gi\u00e1 tr\u1ecb th\u01b0\u1edfng KPIs = M\u1ee9c l\u01b0\u01a1ng * M\u1ee9c th\u01b0\u1edfng<\/li>\n<li>B\u1ea3ng\u00a0\u0111i\u1ec3m KPIs x\u00e9t th\u01b0\u1edfng: l\u00e0 c\u00e1c m\u1ee9c th\u01b0\u1edfng d\u1ef1a v\u00e0o c\u00e1c m\u1ee9c\u00a0\u0111i\u1ec3m KPIs\u00a0\u0111\u01b0\u1ee3c quy\u00a0\u0111\u1ecbnh tr\u01b0\u1edbc.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh m\u1ee9c th\u01b0\u1edfng t\u1ea1i c\u1ed9t E trong b\u1ea3ng t\u00ednh tr\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft h\u00e0m\u00a0IF t\u1ea1i \u00f4 E3 nh\u01b0 sau:<\/p>\n<p><strong>\u0110i\u1ec1u ki\u1ec7n 1<\/strong>: D\u01b0\u1edbi 55\u00a0\u0111i\u1ec3m KPIs nh\u1eadn m\u1ee9c th\u01b0\u1edfng l\u00e0 0<\/p>\n<p style=\"padding-left: 30px\">IF(D3&lt;55, 0,\u00a0\u0110i\u1ec1u ki\u1ec7n kh\u00e1c)<\/p>\n<p><strong>\u0110i\u1ec1u ki\u1ec7n 2<\/strong>: T\u1eeb 55\u00a0\u0111i\u1ec3m t\u1edbi 60\u00a0\u0111i\u1ec3m KPIs nh\u1eadn m\u1ee9c th\u01b0\u1edfng l\u00e0 0.1 (1%)<\/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-826.gif\" title=\"ex101_92019-nho-826\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"padding-left: 30px\">IF(AND(D3&gt;=55, D3&lt;60), 0.1,\u00a0\u0110i\u1ec1u ki\u1ec7n kh\u00e1c)<\/p>\n<p><strong>L\u1ed3ng\u00a0\u0111i\u1ec1u ki\u1ec7n 1 v\u1edbi\u00a0\u0111i\u1ec1u ki\u1ec7n 2<\/strong> ta c\u00f3:<\/p>\n<p style=\"padding-left: 30px\">IF(D3&lt;55, 0,\u00a0IF(AND(D3&gt;=55, D3&lt;60), 0.1,\u00a0\u0110i\u1ec1u ki\u1ec7n kh\u00e1c))<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady, ch\u00fang ta vi\u1ebft ti\u1ebfp h\u00e0m\u00a0IF cho c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n ti\u1ebfp theo v\u00e0 l\u1ed3ng v\u00e0o c\u00f4ng th\u1ee9c tr\u00ean, k\u1ebft qu\u1ea3 l\u00e0:<\/p>\n<p style=\"padding-left: 30px\">E3= IF(D3&lt;55, 0, IF(AND(D3&gt;=55, D3&lt;=60), 0.1, IF(AND(D3&gt;60, D3&lt;=75), 0.15, IF(AND(D3&gt;75, D3&lt;=80), 0.2, IF(AND(D3&gt;80, D3&lt;=85), 0.25, IF(AND(D3&gt;85, D3&lt;=90), 0.3, IF(AND(D3&gt;90, D3&lt;=95), 0.35, 0.4)))))))<\/p>\n<p>C\u00f4ng th\u1ee9c r\u1ea5t d\u00e0i v\u00e0 kh\u00f3\u00a0\u0111\u1ecdc ph\u1ea3i kh\u00f4ng n\u00e0o? V\u1eady l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 c\u00f4ng th\u1ee9c tr\u00ean d\u1ec5\u00a0\u0111\u1ecdc h\u01a1n, d\u1ec5 hi\u1ec3u h\u01a1n kh\u00f4ng?<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_viet_cong_thuc_trong_Excel_giup_de_doc_de_kiem_tra\"><\/span>C\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c trong\u00a0Excel gi\u00fap d\u1ec5\u00a0\u0111\u1ecdc , d\u1ec5 ki\u1ec3m tra<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi nh\u00ecn tr\u00ean thanh c\u00f4ng th\u1ee9c c\u1ee7a\u00a0Excel, ch\u00fang ta th\u1ea5y c\u00f4ng th\u1ee9c l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26654\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/noi-dung-cong-thuc-tren-thanh-formula-1024x228-2.png\" width=\"1024\" height=\"228\" title=\"noi-dung-cong-thuc-tren-thanh-formula-1024x228-2\"><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3\u00a0\u00e1p d\u1ee5ng nh\u1eefng c\u00e1ch sau\u00a0\u0111\u1ec3 gi\u00fap c\u00f4ng th\u1ee9c\u00a0\u0111\u1ecdc d\u1ec5 h\u01a1n:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ky_thuat_xuong_dong_trong_cong_thuc\"><\/span>K\u1ef9 thu\u1eadt xu\u1ed1ng d\u00f2ng trong c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea1n c\u00f3 th\u1ec3 xu\u1ed1ng d\u00f2ng (ng\u1eaft d\u00f2ng)\u00a01 c\u00e1ch ch\u1ee7\u00a0\u0111\u1ed9ng khi vi\u1ebft c\u00f4ng th\u1ee9c trong\u00a0Excel.\u00a0\u0110i\u1ec1u n\u00e0y s\u1ebd gi\u00fap b\u1ea1n t\u00e1ch ri\u00eang c\u00e1c n\u1ed9i dung trong c\u00f4ng th\u1ee9c, gi\u00fap d\u1ec5\u00a0\u0111\u1ecdc, d\u1ec5 ki\u1ec3m tra h\u01a1n m\u00e0 kh\u00f4ng l\u00e0m\u00a0\u1ea3nh h\u01b0\u1edfng t\u1edbi k\u1ebft qu\u1ea3 c\u00f4ng th\u1ee9c.<\/p>\n<p>\u0110\u1ec3 xu\u1ed1ng d\u00f2ng trong c\u00f4ng th\u1ee9c, b\u1ea1n s\u1eed d\u1ee5ng ph\u00edm Alt + Enter t\u1ea1i v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n xu\u1ed1ng d\u00f2ng. V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26655\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xuong-dong-trong-formula-bar-1024x311-1.png\" width=\"1024\" height=\"311\" title=\"xuong-dong-trong-formula-bar-1024x311-1\"><\/p>\n<p>T\u1ea1i c\u00e1c v\u1ecb tr\u00ed d\u1ea5u ph\u1ea9y ph\u00eda tr\u01b0\u1edbc c\u00e1c h\u00e0m\u00a0IF l\u1ed3ng nhau, ch\u00fang ta s\u1ebd xu\u1ed1ng d\u00f2ng. Khi\u00a0\u0111\u00f3 tr\u00ean 1 d\u00f2ng ch\u1ec9 c\u00f3 1 h\u00e0m\u00a0IF.<\/p>\n<p>M\u1ed7i h\u00e0m\u00a0IF ch\u1ec9 c\u00f3 2 th\u00e0nh ph\u1ea7n: M\u1ec7nh\u00a0\u0111\u1ec1 so s\u00e1nh v\u00e0 K\u1ebft qu\u1ea3 khi m\u1ec7nh\u00a0\u0111\u1ec1\u00a0\u0111\u00fang.<\/p>\n<p>V\u1edbi k\u1ebft qu\u1ea3 khi m\u1ec7nh\u00a0\u0111\u1ec1 sai, ch\u00fang ta s\u1ebd xu\u1ed1ng d\u00f2ng\u00a0\u0111\u1ec3 vi\u1ebft ti\u1ebfp c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n kh\u00e1c.<\/p>\n<p>Ch\u1ec9 trong h\u00e0m\u00a0IF cu\u1ed1i c\u00f9ng (d\u00f2ng th\u1ee9 7) th\u00ec ch\u00fang ta m\u1edbi vi\u1ebft\u00a0\u0111\u1ee7 c\u00e1c th\u00e0nh ph\u1ea7n, v\u00ec kh\u00f4ng c\u00f2n l\u1ed3ng gh\u00e9p h\u00e0m\u00a0IF n\u00e0o n\u1eefa. T\u1ea1i v\u1ecb tr\u00ed n\u00e0y ch\u00fang ta c\u0169ng d\u1ec5\u00a0\u0111\u1ebfm\u00a0\u0111\u01b0\u1ee3c c\u00f3 7 h\u00e0m\u00a0IF, nh\u01b0 v\u1eady s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng 7 d\u1ea5u\u00a0\u0111\u00f3ng ngo\u1eb7c\u00a0\u0111\u01a1n khi k\u1ebft th\u00fac c\u00f4ng th\u1ee9c.<\/p>\n<p>B\u00e2y gi\u1edd c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta\u00a0\u0111\u00e3 tr\u1edf n\u00ean d\u1ec5 \u0111\u1ecdc, d\u1ec5 ki\u1ec3m tra\u00a0h\u01a1n r\u1ea5t nhi\u1ec1u r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<p><span style=\"color: #ff0000\"><strong>* L\u01b0u\u00a0\u00fd:<\/strong><\/span><\/p>\n<p>Ph\u1ea3i m\u1edf r\u1ed9ng khung ch\u1ee9a thanh c\u00f4ng th\u1ee9c\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 xem\u00a0\u0111\u01b0\u1ee3c h\u1ebft n\u1ed9i dung c\u00f4ng th\u1ee9c.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26656\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-keo-mo-rong-thanh-formula.png\" width=\"828\" height=\"210\" title=\"cach-keo-mo-rong-thanh-formula\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_dau_cach_khi_viet_cac_thanh_phan_trong_cong_thuc\"><\/span>S\u1eed d\u1ee5ng d\u1ea5u c\u00e1ch khi vi\u1ebft c\u00e1c th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t th\u1ee7 thu\u1eadt nh\u1ecf nh\u01b0ng kh\u00e1 h\u1eefu\u00a0\u00edch trong vi\u1ec7c gi\u00fap c\u00f4ng th\u1ee9c d\u1ec5\u00a0\u0111\u1ecdc h\u01a1n. V\u00ed d\u1ee5:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26657\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/su-dung-dau-cach-trong-cong-thuc.png\" width=\"589\" height=\"92\" title=\"su-dung-dau-cach-trong-cong-thuc\"><\/p>\n<p>Trong c\u00f4ng th\u1ee9c\u00a0\u1edf\u00a0\u00f4 A1 v\u00e0\u00a0\u00f4 A2\u00a0\u0111\u1ec1u l\u00e0 1 c\u00f4ng th\u1ee9c, nh\u01b0ng c\u00f4ng th\u1ee9c\u00a0\u1edf\u00a0\u00f4 A2 c\u00f3 s\u1eed d\u1ee5ng d\u1ea5u c\u00e1ch\u00a0\u0111\u1ec3 ng\u0103n c\u00e1ch c\u00e1c th\u00e0nh ph\u1ea7n sau d\u1ea5u ph\u1ea9y, c\u00f2n c\u00f4ng th\u1ee9c\u00a0\u00f4 A1 th\u00ec kh\u00f4ng.<\/p>\n<p>D\u1ec5 nh\u1eadn th\u1ea5y\u00a0Excel cho ph\u00e9p b\u1ea1n l\u00e0m\u00a0\u0111i\u1ec1u n\u00e0y (vi\u1ebft d\u1ea5u c\u00e1ch ngay sau d\u1ea5u ph\u1ea9y ng\u0103n c\u00e1ch h\u00e0m, r\u1ed3i vi\u1ebft ti\u1ebfp n\u1ed9i dung th\u00e0nh ph\u1ea7n\u00a0\u0111\u00f3) v\u00e0 kh\u00f4ng\u00a0\u1ea3nh h\u01b0\u1edfng g\u00ec t\u1edbi k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c.<\/p>\n<p>Khi c\u00e1c th\u00e0nh ph\u1ea7n\u00a0\u0111\u01b0\u1ee3c vi\u1ebft th\u00eam d\u1ea5u c\u00e1ch, b\u1ea1n s\u1ebd d\u1ec5 ph\u00e2n bi\u1ec7t h\u01a1n, d\u1ec5 nh\u1eadn bi\u1ebft c\u00e1c th\u00e0nh ph\u1ea7n, v\u1ecb tr\u00ed trong c\u00f4ng th\u1ee9c h\u01a1n.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nguy\u00ean t\u1eafc tr\u00ean\u00a0\u00e1p d\u1ee5ng chung cho c\u00e1c h\u00e0m kh\u00e1c trong\u00a0Excel. B\u1ea1n c\u00f3 th\u1ec3 ghi nh\u1edb theo n\u1ed9i dung sau:<\/p>\n<ul>\n<li>Khi vi\u1ebft h\u00e0m nhi\u1ec1u th\u00e0nh ph\u1ea7n, c\u00f3 th\u1ec3 d\u00f9ng d\u1ea5u c\u00e1ch ngay sau d\u1ea5u ph\u1ea9y ng\u0103n c\u00e1ch c\u00e1c th\u00e0nh ph\u1ea7n trong h\u00e0m\u00a0\u0111\u1ec3 d\u1ec5 nh\u1eadn bi\u1ebft c\u00e1c th\u00e0nh ph\u1ea7n trong h\u00e0m.<\/li>\n<li>Khi ph\u1ea3i l\u1ed3ng gh\u00e9p nhi\u1ec1u h\u00e0m trong c\u00f9ng 1 c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 ng\u1eaft d\u00f2ng t\u1ea1i v\u1ecb tr\u00ed c\u00f4ng th\u1ee9c\u00a0\u0111\u01b0\u1ee3c l\u1ed3ng\u00a0\u0111\u1ec3 d\u1ec5 hi\u1ec3u logic c\u1ee7a c\u00f4ng th\u1ee9c.<\/li>\n<\/ul>\n<p>Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c c\u00f9ng ch\u1ee7\u00a0\u0111\u1ec1:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-long-ghep-ham-voi-nhieu-dieu-kien-iferror-ifna-va-nhieu-hon-nua.html\">H\u00e0m IF, l\u1ed3ng gh\u00e9p h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, IFERROR, IFNA v\u00e0 nhi\u1ec1u h\u01a1n n\u1eefa<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat.html\">H\u00e0m IF l\u1ed3ng gh\u00e9p, k\u1ebft h\u1ee3p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t<\/a><\/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-826.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8830,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8829","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\/8829","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=8829"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8829\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8830"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8829"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}