{"id":4777,"date":"2024-12-08T09:12:30","date_gmt":"2024-12-08T09:12:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-lap-cong-thuc-thong-bao-khi-xuat-kho-bi-am-tren-excel\/"},"modified":"2024-12-08T09:12:30","modified_gmt":"2024-12-08T09:12:30","slug":"huong-dan-lap-cong-thuc-thong-bao-khi-xuat-kho-bi-am-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-lap-cong-thuc-thong-bao-khi-xuat-kho-bi-am-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn l\u1eadp c\u00f4ng th\u1ee9c th\u00f4ng b\u00e1o khi xu\u1ea5t kho b\u1ecb \u00e2m tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong c\u00f4ng vi\u1ec7c qu\u1ea3n l\u00fd kho, vi\u1ec7c theo d\u00f5i tr\u00ean s\u1ed5 s\u00e1ch l\u00e0m sao\u00a0\u0111\u1ec3 s\u00e1t v\u1edbi th\u1ef1c t\u1ebf trong kho l\u00e0 r\u1ea5t quan tr\u1ecdng. M\u1ed9t trong nh\u1eefng v\u1ea5n\u00a0\u0111\u1ec1 th\u01b0\u1eddng g\u1eb7p ph\u1ea3i\u00a0\u0111\u00f3 l\u00e0 th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 tr\u00ean s\u1ed5 s\u00e1ch,\u00a0\u0111\u1eb7c bi\u1ec7t l\u00e0 s\u1ed5 s\u00e1ch kho tr\u00ean\u00a0Excel kh\u00f4ng b\u1ecb xu\u1ea5t\u00a0\u00e2m.\u00a0 Trong b\u00e0i vi\u1ebft n\u00e0y H\u1ecdc\u00a0Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch l\u1eadp c\u00f4ng th\u1ee9c th\u00f4ng b\u00e1o khi xu\u1ea5t kho b\u1ecb\u00a0\u00e2m tr\u00ean\u00a0Excel.<\/p>\n<p>V\u00ed d\u1ee5 v\u1ec1 1 m\u1eabu qu\u1ea3n l\u00fd kho tr\u00ean\u00a0Excel nh\u01b0 sau:<\/p>\n<p>Ch\u00fang ta c\u00f3 2 b\u1ea3ng k\u00ea, g\u1ed3m b\u1ea3ng k\u00ea nh\u1eadp v\u00e0 b\u1ea3ng k\u00ea xu\u1ea5t:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18450\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xuat-am-kho-de-bai.png\" width=\"1154\" height=\"280\" title=\"xuat-am-kho-de-bai\"><\/p>\n<p>Y\u00eau c\u1ea7u: khi l\u1eadp phi\u1ebfu xu\u1ea5t kho ph\u1ea3i theo d\u00f5i\u00a0\u0111\u01b0\u1ee3c\u00a0 vi\u1ec7c xu\u1ea5t\u00a0\u00e2m kho.<\/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-675562fe1211f\" 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-lap-cong-thuc-thong-bao-khi-xuat-kho-bi-am-tren-excel.html#The_nao_la_xuat_am_kho\" title=\"Th\u1ebf n\u00e0o l\u00e0 xu\u1ea5t\u00a0\u00e2m kho\">Th\u1ebf n\u00e0o l\u00e0 xu\u1ea5t\u00a0\u00e2m kho<\/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-lap-cong-thuc-thong-bao-khi-xuat-kho-bi-am-tren-excel.html#Lap_cong_thuc_tinh_ton_kho_trong_phieu_xuat_kho\" title=\"L\u1eadp c\u00f4ng th\u1ee9c t\u00ednh t\u1ed3n kho trong phi\u1ebfu xu\u1ea5t kho\">L\u1eadp c\u00f4ng th\u1ee9c t\u00ednh t\u1ed3n kho trong phi\u1ebfu xu\u1ea5t kho<\/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-lap-cong-thuc-thong-bao-khi-xuat-kho-bi-am-tren-excel.html#a_Tong_nhap_kho\" title=\"a. T\u1ed5ng nh\u1eadp kho\">a. T\u1ed5ng nh\u1eadp kho<\/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-lap-cong-thuc-thong-bao-khi-xuat-kho-bi-am-tren-excel.html#b_Tong_xuat_kho\" title=\"b. T\u1ed5ng xu\u1ea5t kho\">b. T\u1ed5ng xu\u1ea5t kho<\/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-lap-cong-thuc-thong-bao-khi-xuat-kho-bi-am-tren-excel.html#Thiet_lap_canh_bao_khi_xuat_am_kho\" title=\"Thi\u1ebft l\u1eadp c\u1ea3nh b\u00e1o khi xu\u1ea5t\u00a0\u00e2m kho\">Thi\u1ebft l\u1eadp c\u1ea3nh b\u00e1o khi xu\u1ea5t\u00a0\u00e2m kho<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-cong-thuc-thong-bao-khi-xuat-kho-bi-am-tren-excel.html#a_Su_dung_Conditional_formatting\" title=\"a. S\u1eed d\u1ee5ng Conditional formatting:\">a. S\u1eed d\u1ee5ng Conditional formatting:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-cong-thuc-thong-bao-khi-xuat-kho-bi-am-tren-excel.html#b_Su_dung_Data_validation\" title=\"b. S\u1eed d\u1ee5ng Data validation\">b. S\u1eed d\u1ee5ng Data validation<\/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-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-cong-thuc-thong-bao-khi-xuat-kho-bi-am-tren-excel.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=\"The_nao_la_xuat_am_kho\"><\/span>Th\u1ebf n\u00e0o l\u00e0 xu\u1ea5t\u00a0\u00e2m kho<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u1eafc l\u1ea1i 1 ch\u00fat v\u1ec1 kh\u00e1i ni\u1ec7m xu\u1ea5t\u00a0\u00e2m kho\u00a0\u0111\u1ec3 c\u00e1c b\u1ea1n hi\u1ec3u r\u00f5 v\u1ea5n\u00a0\u0111\u1ec1 n\u00e0y h\u01a1n nh\u00e9:<\/p>\n<p>Xu\u1ea5t\u00a0\u00e2m kho l\u00e0 vi\u1ec7c s\u1ed1 l\u01b0\u1ee3ng xu\u1ea5t kho tr\u00ean s\u1ed5 s\u00e1ch v\u01b0\u1ee3t qu\u00e1 s\u1ed1\u00a0l\u01b0\u1ee3ng h\u00e0ng h\u00f3a th\u1ef1c t\u1ebf t\u1ed3n kho. Vi\u1ec7c n\u00e0y d\u1eabn t\u1edbi sau khi xu\u1ea5t s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng c\u00f2n t\u1ed3n tr\u00ean s\u1ed5 s\u00e1ch s\u1ebd b\u1ecb\u00a0\u00e2m (S\u1ed1 t\u1ed3n sau khi xu\u1ea5t kho = T\u1ed5ng s\u1ed1 xu\u1ea5t kho \u2013 T\u1ed5ng s\u1ed1 t\u1ed3n kho tr\u01b0\u1edbc khi xu\u1ea5t)<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-390.gif\" title=\"ex101_92019-nho-390\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-390.gif\" title=\"ex101_92019-nho-390\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Vi\u1ec7c t\u1ed3n kho b\u1ecb\u00a0\u00e2m l\u00e0 tr\u00e1i v\u1edbi th\u1ef1c t\u1ebf. B\u1edfi th\u1ef1c t\u1ebf kh\u00f4ng c\u00f3 vi\u1ec7c xu\u1ea5t\u00a0\u00e2m.\u00a0V\u00e0 l\u1ed7i xu\u1ea5t\u00a0\u00e2m l\u00e0 l\u1ed7i kh\u00e1 nghi\u00eam tr\u1ecdng trong c\u00f4ng vi\u1ec7c qu\u1ea3n l\u00fd kho.<\/p>\n<p>Do\u00a0\u0111\u00f3 vi\u1ec7c theo d\u00f5i xu\u1ea5t\u00a0\u00e2m kho\u00a0\u0111\u01b0\u1ee3c th\u1ef1c\u00a0 hi\u1ec7n theo 2 c\u00e1ch:<\/p>\n<ul>\n<li>C\u00e1ch 1: Qu\u1ea3n l\u00fd\u00a0\u00e2m kho trong B\u1ea3ng k\u00ea<\/li>\n<li>C\u00e1ch 2: Qu\u1ea3n l\u00fd\u00a0\u00e2m kho ngay khi l\u1eadp phi\u1ebfu xu\u1ea5t kho<\/li>\n<\/ul>\n<p>\u0110\u1ec3 t\u1ed1t nh\u1ea5t cho c\u00f4ng vi\u1ec7c th\u00ec ch\u00fang ta n\u00ean qu\u1ea3n l\u00fd theo c\u00e1ch 2 l\u00e0 qu\u1ea3n l\u00fd\u00a0\u00e2m kho ngay khi l\u1eadp phi\u1ebfu xu\u1ea5t kho<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lap_cong_thuc_tinh_ton_kho_trong_phieu_xuat_kho\"><\/span>L\u1eadp c\u00f4ng th\u1ee9c t\u00ednh t\u1ed3n kho trong phi\u1ebfu xu\u1ea5t kho<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Vi\u1ec7c x\u00e1c\u00a0\u0111\u1ecbnh t\u1ed3n kho trong phi\u1ebfu xu\u1ea5t kho s\u1ebd gi\u00fap ch\u00fang ta x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng c\u00f3\u00a0\u0111\u1ec3 xu\u1ea5t, t\u1eeb\u00a0\u0111\u00f3 s\u1ebd c\u1ea3nh b\u00e1o, ph\u00e1t hi\u1ec7n\u00a0\u0111\u01b0\u1ee3c khi n\u00e0o xu\u1ea5t\u00a0\u00e2m.<\/p>\n<p>Vi\u1ec7c t\u00ednh t\u1ed3n kho ph\u1ee5 thu\u1ed9c v\u00e0o:<\/p>\n<ul>\n<li>\u0110i\u1ec1u ki\u1ec7n th\u1eddi gian: l\u00e0 th\u1eddi\u00a0\u0111i\u1ec3m l\u1eadp phi\u1ebfu xu\u1ea5t kho. Ch\u1ec9 t\u00ednh v\u1edbi nh\u1eefng m\u1eb7t h\u00e0ng nh\u1eadp \u2013 xu\u1ea5t kho\u00a0\u0111\u1ebfn th\u1eddi\u00a0\u0111i\u1ec3m\u00a0\u0111\u00f3 m\u00e0 th\u00f4i. Kh\u00f4ng t\u00ednh nh\u1eefng m\u1eb7t h\u00e0ng nh\u1eadp, xu\u1ea5t sau th\u1eddi\u00a0\u0111i\u1ec3m\u00a0\u0111\u00f3<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n t\u00ean m\u1eb7t h\u00e0ng: t\u00f9y t\u1eebng m\u1eb7t h\u00e0ng\u00a0\u0111\u01b0\u1ee3c l\u1ef1a ch\u1ecdn\u00a0\u0111\u1ec3 t\u00ednh cho m\u1eb7t h\u00e0ng\u00a0\u0111\u00f3.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady\u00a0\u1edf\u00a0\u0111\u00e2y ch\u00fang ta c\u1ea7n t\u00ednh theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n (h\u01a1n 1\u00a0\u0111i\u1ec1u ki\u1ec7n) =&gt; S\u1eed d\u1ee5ng h\u00e0m Sumifs<\/p>\n<p>Nguy\u00ean t\u1eafc t\u00ednh t\u1ed3n kho = T\u1ed5ng nh\u1eadp \u2013 T\u1ed5ng xu\u1ea5t<\/p>\n<p><strong>X\u00e9t v\u1edbi m\u1eb7t h\u00e0ng A, v\u1ecb tr\u00ed\u00a0\u00f4 J3<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"a_Tong_nhap_kho\"><\/span><em><strong>a. T\u1ed5ng nh\u1eadp kho<\/strong><\/em><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"padding-left: 30px\">SUMIFS($C$3:$C$10,$B$3:$B$10,$I3,$A$3:$A$10,\u201d&lt;=\u201d&amp;$K$1)<\/p>\n<p>Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c:<\/p>\n<ul>\n<li>$C$3:$C$10: v\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng l\u00e0 c\u1ed9t s\u1ed1\u00a0l\u01b0\u1ee3ng trong b\u1ea3ng k\u00ea nh\u1eadp. L\u01b0u\u00a0\u00fd\u00a0\u0111\u1ed9 r\u1ed9ng c\u00e1c v\u00f9ng ph\u1ea3i b\u1eb1ng nhau. C\u00e1c v\u00f9ng\u00a0\u0111\u1ec1u c\u1ea7n c\u1ed1\u00a0\u0111\u1ecbnh<\/li>\n<li>$B$3:$B$10: v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 1, x\u00e9t v\u1edbi t\u00ean h\u00e0ng n\u00ean ch\u1ecdn c\u1ed9t t\u00ean h\u00e0ng.<\/li>\n<li>$I3:\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 1 l\u00e0 t\u00ean h\u00e0ng t\u1ea1i\u00a0\u00f4 I3,\u00a0\u0111i\u1ec1u ki\u1ec7n n\u00e0y n\u1eb1m trong v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 1. C\u1ed1\u00a0\u0111\u1ecbnh c\u1ed9t I\u00a0\u0111\u1ec3 khi sao ch\u00e9p c\u00f4ng th\u1ee9c sang c\u1ed9t kh\u00e1c kh\u00f4ng b\u1ecb sai l\u1ec7ch tham chi\u1ebfu t\u1edbi\u00a0\u0111i\u1ec1u ki\u1ec7n n\u00e0y.<\/li>\n<li>$A$3:$A$10: v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1ee9 2 l\u00e0 th\u1eddi gian, ng\u00e0y. X\u00e9t cho\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 ng\u00e0y l\u1eadp phi\u1ebfu<\/li>\n<li>\u201c&lt;=\u201d&amp;$K$1: l\u00e0 x\u00e9t t\u1eeb ng\u00e0y 15\/5 tr\u1edf v\u1ec1 tr\u01b0\u1edbc, do\u00a0\u0111\u00f3 ph\u1ea3i k\u1ebft h\u1ee3p v\u1edbi d\u1ea5u nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"b_Tong_xuat_kho\"><\/span><em><strong>b. T\u1ed5ng xu\u1ea5t kho<\/strong><\/em><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"padding-left: 30px\">SUMIFS($G$3:$G$10,$F$3:$F$10,$I3,$E$3:$E$10,\u201d&lt;=\u201d&amp;$K$1)<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 t\u00ednh t\u1ed5ng Nh\u1eadp kho nh\u01b0ng x\u00e9t cho B\u1ea3ng Xu\u1ea5t kho<\/p>\n<p>S\u1ed1 t\u1ed3n kho J3=SUMIFS($C$3:$C$10,$B$3:$B$10,$I3,$A$3:$A$10,\u201d&lt;=\u201d&amp;$K$1)-SUMIFS($G$3:$G$10,$F$3:$F$10,$I3,$E$3:$E$10,\u201d&lt;=\u201d&amp;$K$1)<\/p>\n<p>\u00c1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c m\u1eb7t h\u00e0ng kh\u00e1c.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Thiet_lap_canh_bao_khi_xuat_am_kho\"><\/span>Thi\u1ebft l\u1eadp c\u1ea3nh b\u00e1o khi xu\u1ea5t\u00a0\u00e2m kho<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 c\u1ea3nh b\u00e1o xu\u1ea5t\u00a0\u00e2m kho, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng 2 c\u00f4ng c\u1ee5 l\u00e0:<\/p>\n<p><strong>Conditional formatting<\/strong>: t\u1ef1\u00a0\u0111\u1ed9ng\u00a0\u0111\u1ecbnh d\u1ea1ng khi ph\u00e1t hi\u1ec7n vi\u1ec7c xu\u1ea5t\u00a0\u00e2m, gi\u00fap b\u1ea1n nh\u1eadn bi\u1ebft b\u1eb1ng m\u00e0u s\u1eafc,\u00a0\u0111\u1ecbnh d\u1ea1ng trong\u00a0\u00f4<\/p>\n<p><strong>Data validation<\/strong>: t\u1ef1\u00a0\u0111\u1ed9ng\u00a0\u0111\u01b0a ra c\u1ea3nh b\u00e1o khi xu\u1ea5t\u00a0\u00e2m, cho ph\u00e9p ho\u1eb7c t\u1eeb ch\u1ed1i vi\u1ec7c xu\u1ea5t\u00a0\u00e2m d\u1ef1a v\u00e0o quy\u1ebft\u00a0\u0111\u1ecbnh c\u1ee7a ng\u01b0\u1eddi d\u00f9ng.<\/p>\n<p>Th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"a_Su_dung_Conditional_formatting\"><\/span>a. S\u1eed d\u1ee5ng Conditional formatting:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1o th\u00eam 1 c\u1ed9t T\u1ed3n sau khi xu\u1ea5t = T\u1ed3n tr\u01b0\u1edbc khi xu\u1ea5t \u2013 S\u1ed1 l\u01b0\u1ee3ng xu\u1ea5t<\/p>\n<p>Ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng Phi\u1ebfu xu\u1ea5t r\u1ed3i ch\u1ecdn Conditional formattiing.<\/p>\n<p>Trong Conditional formatting x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18452\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xuat-am-kho-cf.png\" width=\"997\" height=\"462\" title=\"xuat-am-kho-cf\"><\/p>\n<p><strong>\u00dd\u00a0ngh\u0129a<\/strong>: X\u00e9t t\u1eebng gi\u00e1 tr\u1ecb\u00a0\u1edf c\u1ed9t L, b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb\u00a0\u00f4 L3. N\u1ebfu Gi\u00e1 tr\u1ecb n\u00e0o nh\u1ecf h\u01a1n 0 th\u00ec s\u1ebd\u00a0\u0111\u1ecbnh d\u1ea1ng t\u00f4 m\u00e0u v\u00e0ng<\/p>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18453\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-xuat-am-kho-cf.png\" width=\"531\" height=\"173\" title=\"ket-qua-xuat-am-kho-cf\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y khi m\u1eb7t h\u00e0ng B xu\u1ea5t 10 th\u00ec kho s\u1ebd b\u1ecb\u00a0\u00e2m<\/p>\n<h3><span class=\"ez-toc-section\" id=\"b_Su_dung_Data_validation\"><\/span>b. S\u1eed d\u1ee5ng Data validation<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1ch n\u00e0y kh\u00f4ng c\u1ea7n t\u1edbi c\u1ed9t ph\u1ee5, ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng tr\u1ef1c ti\u1ebfp Data validation trong c\u1ed9t S\u1ed1 l\u01b0\u1ee3ng xu\u1ea5t nh\u01b0 sau:<\/p>\n<p>Trong C\u1ed9t K v\u00f9ng s\u1ed1 l\u01b0\u1ee3ng xu\u1ea5t: K3:K7 ch\u1ecdn Data \/ Data validation<\/p>\n<p>Trong c\u1eeda s\u1ed5 Data validation ch\u1ecdn<\/p>\n<ul>\n<li>Allow =\u00a0Whole number (ch\u1ec9 nh\u1eadp d\u1ea1ng s\u1ed1),<\/li>\n<li>Data = Less than\u00a0or equal to (nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng),<\/li>\n<li>Maximum =J3 (gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t b\u1eb1ng J3. Khi ch\u1ecdn v\u00f9ng K3:K7 th\u00ec Data validation s\u1ebd hi\u1ec3u t\u01b0\u01a1ng\u00a0\u1ee9ng: t\u1ea1i K3 th\u00ec &lt;=J3, K4&lt;=J4\u2026 K7&lt;=J7<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18454\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xuat-am-kho-data-validation-thiet-lap.png\" width=\"897\" height=\"421\" title=\"xuat-am-kho-data-validation-thiet-lap\"><\/p>\n<p>Khi\u00a0\u0111\u00f3 n\u1ebfu t\u1ea1i c\u1ed9t K nh\u1eadp gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n c\u1ed9t J th\u00ec s\u1ebd xu\u1ea5t hi\u1ec7n th\u00f4ng b\u00e1o c\u1ee7a Data validation v\u1ec1 vi\u1ec7c nh\u1eadp qu\u00e1 gi\u1edbi h\u1ea1n cho ph\u00e9p.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp c\u00e1c ch\u1ebf\u00a0\u0111\u1ed9 c\u1ea3nh b\u1ea3o c\u1ee7a Data validation trong m\u1ee5c\u00a0Error\u00a0Arlet\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 b\u00e1o l\u1ed7i c\u1ee5 th\u1ec3, cho ph\u00e9p nh\u1eadp s\u1ed1 l\u01b0\u1ee3ng l\u1edbn h\u01a1n s\u1ed1 t\u1ed3n (g\u00e2y ra xu\u1ea5t\u00a0\u00e2m) hay kh\u00f4ng.<\/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>Ch\u1ec9 v\u1edbi 2 k\u1ef9 thu\u1eadt c\u01a1 b\u1ea3n trong\u00a0Excel b\u1ea1n\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 ki\u1ec3m so\u00e1t vi\u1ec7c xu\u1ea5t\u00a0\u00e2m kho r\u1ed3i.<\/p>\n<p>Tuy nhi\u00ean\u00a0\u0111\u1ec3 l\u00e0m\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111i\u1ec1u\u00a0\u0111\u00f3 th\u00ec c\u00e1c b\u1ea1n c\u1ea7n\u00a0\u0111\u1eb7c bi\u1ec7t\u00a0 l\u01b0u\u00a0\u00fd v\u1ec1 c\u1ea5u tr\u00fac c\u1ee7a c\u00e1c b\u1ea3ng k\u00ea Nh\u1eadp, b\u1ea3ng k\u00ea Xu\u1ea5t v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Sumifs. C\u00f4ng th\u1ee9c SUMIFS\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t\u00a0\u0111a d\u1ea1ng trong k\u1ebf to\u00e1n.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 file m\u1eabu t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9: <a href=\"http:\/\/bit.ly\/2sGfXR0\">http:\/\/bit.ly\/2sGfXR0<\/a><\/p>\n<p>Ngo\u00e0i ra\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 n\u00e2ng cao ki\u1ebfn th\u1ee9c v\u1ec1\u00a0Excel v\u00e0\u00a0\u1ee9ng d\u1ee5ng\u00a0Excel v\u00e0o qu\u1ea3n l\u00fd d\u1ef1\u00a0\u00e1n, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2sGaBVT\">EX101 \u2013\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc\u00a0Excel Online. Kh\u00f3a h\u1ecdc s\u1ebd gi\u00fap b\u1ea1n n\u1eafm v\u1eefng c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong Excel,\u00a0\u00a0\u1ee9ng d\u1ee5ng Conditional formatting trong vi\u1ec7c t\u1ea1o gantt chart qu\u1ea3n l\u00fd ti\u1ebfn \u0111\u1ed9 d\u1ef1 \u00e1n. Chi ti\u1ebft kh\u00f3a h\u1ecdc xem t\u1ea1i:<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-390.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4778,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4777","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\/4777","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=4777"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4777\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4778"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4777"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4777"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4777"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}