{"id":123907,"date":"2024-08-29T17:21:51","date_gmt":"2024-08-29T10:21:51","guid":{"rendered":"https:\/\/amis.misa.vn\/?p=123907"},"modified":"2024-11-06T20:20:35","modified_gmt":"2024-11-06T13:20:35","slug":"cach-su-dung-ham-if-de-tinh-luong","status":"publish","type":"post","link":"https:\/\/amis.misa.vn\/123907\/cach-su-dung-ham-if-de-tinh-luong\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng th\u01b0\u1edfng trong Excel"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ph\u1ea7n m\u1ec1m Microsoft Excel ch\u1eafc h\u1eb3n kh\u00f4ng c\u00f2n xa l\u1ea1 \u0111\u1ed1i v\u1edbi d\u00e2n v\u0103n ph\u00f2ng, \u0111\u1eb7c bi\u1ec7t l\u00e0 v\u1edbi nh\u1eefng ng\u01b0\u1eddi l\u00e0m k\u1ebf to\u00e1n hay HR. Tuy nhi\u00ean c\u00e1ch d\u00f9ng h\u00e0m IF trong Excel kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft. H\u00e3y c\u00f9ng <strong><a href=\"https:\/\/amis.misa.vn\/amis-nhan-su\/\" target=\"_blank\" rel=\"nofollow noopener\">MISA AMIS HRM<\/a><\/strong> kh\u00e1m ph\u00e1 <strong>c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng<\/strong> th\u00f4ng qua b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/span><b><\/b><\/p>\n<h2 style=\"text-align: justify;\"><b>1. Gi\u1edbi thi\u1ec7u c\u00f4ng th\u1ee9c h\u00e0m IF trong Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m IF l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c d\u00f9ng trong tr\u01b0\u1eddng h\u1ee3p t\u00ednh to\u00e1n c\u00f3 \u0111i\u1ec1u ki\u1ec7n, bao g\u1ed3m c\u1ea3 vi\u1ec7c t\u00ednh l\u01b0\u01a1ng cho nh\u00e2n vi\u00ean. C\u00f3 th\u1ec3 n\u00f3i \u0111\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Microsoft Excel.<\/span><\/p>\n<figure id=\"attachment_123914\" aria-describedby=\"caption-attachment-123914\" style=\"width: 1920px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-123914\" src=\"\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-1.png\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng \" width=\"1920\" height=\"1080\" srcset=\"\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-1.png 1920w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-1-500x281.png 500w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-1-1024x576.png 1024w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-1-768x432.png 768w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-1-1536x864.png 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><figcaption id=\"caption-attachment-123914\" class=\"wp-caption-text\">T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m IF &#8211; h\u00e0m c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c h\u00e0m IF trong Excel: <\/span><b>=IF(Logical_test;Value_if_true;Value_if_false)<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 hi\u1ec3u nh\u01b0 sau:<\/span><span style=\"font-weight: 400;\">\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: justify;\"><b>Logical_test: <\/b><span style=\"font-weight: 400;\">\u0111i\u1ec1u ki\u1ec7n<\/span><\/li>\n<li style=\"text-align: justify;\"><b>Value_if_true: <\/b><span style=\"font-weight: 400;\">gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n<\/span><\/li>\n<li style=\"text-align: justify;\"><b>Value_if_false: <\/b><span style=\"font-weight: 400;\">gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu kh\u00f4ng th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>\u200bL\u01b0u \u00fd:<\/strong> N\u1ebfu b\u1ecf tr\u1ed1ng Value_if_true v\u00e0 Value_if_false, n\u1ebfu th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n th\u00ec gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 0 v\u00e0 n\u1ebfu kh\u00f4ng th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n\u00a0 th\u00ec gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 FALSE.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>V\u00ed d\u1ee5:<\/strong> T\u00ednh l\u01b0\u01a1ng c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean v\u1edbi \u0111i\u1ec1u ki\u1ec7n:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu doanh s\u1ed1 \u0111\u1ea1t t\u1eeb 100 tri\u1ec7u tr\u1edf l\u00ean, th\u00ec l\u01b0\u01a1ng = l\u01b0\u01a1ng c\u01a1 b\u1ea3n + 10% doanh s\u1ed1.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu doanh s\u1ed1 d\u01b0\u1edbi 100 tri\u1ec7u, th\u00ec l\u01b0\u01a1ng = l\u01b0\u01a1ng c\u01a1 b\u1ea3n + 5% doanh s\u1ed1.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch d\u00f9ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1ea1i \u00f4 D3, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c: <\/span><span style=\"font-weight: 400;\">=IF(C3&gt;100000000;B3+10%*C3;B3+5%*C3)<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-123915\" src=\"\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-2.png\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng \" width=\"727\" height=\"250\" srcset=\"\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-2.png 727w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-2-500x172.png 500w\" sizes=\"(max-width: 727px) 100vw, 727px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u1ea5n Enter c\u00f4ng th\u1ee9c, Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 17.000.000 VN\u0110.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-123916\" src=\"\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-3.png\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng \" width=\"504\" height=\"247\" srcset=\"\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-3.png 504w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-3-500x245.png 500w\" sizes=\"(max-width: 504px) 100vw, 504px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 xu\u1ed1ng c\u00e1c h\u00e0ng b\u00ean d\u01b0\u1edbi, k\u1ebft qu\u1ea3 b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-123917\" src=\"\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-4.png\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng \" width=\"545\" height=\"277\" srcset=\"\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-4.png 545w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-4-500x254.png 500w\" sizes=\"(max-width: 545px) 100vw, 545px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><b>2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng th\u01b0\u1edfng trong Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc khi vi\u1ebft c\u00f4ng th\u1ee9c ta c\u1ea7n di\u1ec5n \u0111\u1ea1t b\u1eb1ng l\u1eddi th\u1eadt logic nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">N\u1ebfu doanh s\u1ed1 d\u01b0\u1edbi 100 tri\u1ec7u th\u00ec % doanh s\u1ed1 = <\/span> <span style=\"font-weight: 400;\">0% (kh\u00f4ng \u0111\u01b0\u1ee3c th\u01b0\u1edfng)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">N\u1ebfu doanh s\u1ed1 t\u1eeb 100 tri\u1ec7u \u0111\u1ebfn d\u01b0\u1edbi 150 tri\u1ec7u th\u00ec % doanh s\u1ed1 = 1% (l\u1ea5y 1% nh\u00e2n v\u1edbi doanh s\u1ed1 \u0111\u1ec3 ra s\u1ed1 th\u01b0\u1edfng)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">N\u1ebfu doanh s\u1ed1 t\u1eeb 150 tri\u1ec7u \u0111\u1ebfn d\u01b0\u1edbi 200 tri\u1ec7u th\u00ec % doanh s\u1ed1 = 1,5% (l\u1ea5y 1,5% nh\u00e2n v\u1edbi doanh s\u1ed1 \u0111\u1ec3 ra s\u1ed1 th\u01b0\u1edfng)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">C\u00f2n l\u1ea1i n\u1ebfu doanh s\u1ed1 t\u1eeb 200 tri\u1ec7u tr\u1edf l\u00ean th\u00ec % doanh s\u1ed1 = 2% (l\u1ea5y 2% nh\u00e2n v\u1edbi doanh s\u1ed1 \u0111\u1ec3 ra s\u1ed1 th\u01b0\u1edfng)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ta c\u1ea7n t\u1edbi 3 h\u00e0m IF l\u1ed3ng nhau. T\u1ea1i \u00f4 J7 ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c nh\u01b0 sau:\u00a0 IF(I7&lt;$B$17,$C$16,IF(I7&lt;$B$18,$C$17,IF(I7&lt;$B$19,$C$18,$C$19)))*I7<\/span><\/p>\n<h3 style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-123918\" src=\"\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-5.png\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng \" width=\"1040\" height=\"390\" srcset=\"\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-5.png 1040w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-5-500x188.png 500w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-5-1024x384.png 1024w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-5-768x288.png 768w\" sizes=\"(max-width: 1040px) 100vw, 1040px\" \/><b><\/b><b><\/b><\/h3>\n<p><strong>&gt;&gt;&gt; Tham kh\u1ea3o: H\u01b0\u1edbng d\u1eabn <a href=\"https:\/\/amis.misa.vn\/123734\/cach-su-dung-ham-vlookup-de-tinh-luong\/\" target=\"_blank\" rel=\"noopener\">c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng<\/a> trong Excel d\u1ec5 hi\u1ec3u, \u0111\u01a1n gi\u1ea3n<\/strong><\/p>\n<h3 style=\"text-align: justify;\"><b>3. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF t\u00ednh ph\u1ee5 c\u1ea5p<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u00ednh ph\u1ee5 c\u1ea5p ch\u1ee9c v\u1ee5 c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m IF.\u00a0 \u0110i\u1ec1u ki\u1ec7n ph\u1ee5 c\u1ea5p ch\u1ee9c v\u1ee5 l\u00e0: Nh\u00e2n vi\u00ean (NV) th\u00eam 100, K\u1ebf to\u00e1n (KT) th\u00eam 150, Tr\u01b0\u1edfng ph\u00f2ng (TP) th\u00eam 300, Ph\u00f3 gi\u00e1m \u0111\u1ed1c (PG\u0110) th\u00eam 350, Gi\u00e1m \u0111\u1ed1c (G\u0110) th\u00eam 500. Thay v\u00ec tra theo danh m\u1ee5c ch\u1ee9c v\u1ee5 r\u1ed3i \u0111i\u1ec1n l\u1ea7n l\u01b0\u1ee3t, b\u1ea1n ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m IF v\u1edbi c\u00fa ph\u00e1p nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><i><span style=\"font-weight: 400;\">=IF(D46=&#8221;NV&#8221;,100,IF(D46=&#8221;KT&#8221;,150,IF(D46=&#8221;TP&#8221;,300,IF(D46=&#8221;PG\u0110&#8221;,350,IF(D46=&#8221;G\u0110&#8221;,500)))))\u00a0<\/span><\/i><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u00e9o h\u00e0m IF xu\u1ed1ng c\u00e1c \u00f4 ti\u1ebfp theo \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3:<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-123919\" src=\"\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-6.png\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng \" width=\"1499\" height=\"412\" srcset=\"\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-6.png 1499w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-6-500x137.png 500w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-6-1024x281.png 1024w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-6-768x211.png 768w\" sizes=\"(max-width: 1499px) 100vw, 1499px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u01b0\u01a1ng s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh theo c\u00f4ng th\u1ee9c: <strong>L\u01b0\u01a1ng = L\u01b0\u01a1ng c\u0103n b\u1ea3n * ng\u00e0y c\u00f4ng <\/strong><\/span><span style=\"font-weight: 400;\">=<\/span> <span style=\"font-weight: 400;\">E46<\/span><span style=\"font-weight: 400;\">*<\/span><span style=\"font-weight: 400;\">F46<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-123920\" src=\"\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-7.png\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng \" width=\"1026\" height=\"355\" srcset=\"\/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-7.png 1026w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-7-500x173.png 500w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-7-1024x354.png 1024w, \/wp-content\/uploads\/2024\/02\/cach-su-dung-ham-if-de-tinh-luong-7-768x266.png 768w\" sizes=\"(max-width: 1026px) 100vw, 1026px\" \/><\/p>\n<p><strong>&gt;&gt;&gt; Tham kh\u1ea3o: Top 10 <a href=\"https:\/\/amis.misa.vn\/15047\/phan-mem-tinh-luong\/\" target=\"_blank\" rel=\"noopener\">ph\u1ea7n m\u1ec1m t\u00ednh l\u01b0\u01a1ng<\/a> hi\u1ec7u qu\u1ea3, \u0111\u01b0\u1ee3c c\u00e1c doanh nghi\u1ec7p s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5t, gi\u00fap t\u1ef1 \u0111\u1ed9ng t\u00ednh l\u01b0\u01a1ng theo s\u1ea3n l\u01b0\u1ee3ng, theo l\u01b0\u01a1ng 3P, l\u01b0\u01a1ng ph\u1ee5 c\u1ea5p&#8230;.<\/strong><\/p>\n<h2 style=\"text-align: justify;\"><b>4. Nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi t\u00ednh l\u01b0\u01a1ng b\u1eb1ng h\u00e0m IF<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng h\u00e0m IF trong Excel, c\u00f3 m\u1ed9t s\u1ed1 l\u1ed7i ph\u1ed5 bi\u1ebfn m\u00e0 ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng g\u1eb7p ph\u1ea3i. C\u00f9ng \u0111i\u1ec3m danh nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00e1ch x\u1eed l\u00fd:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Sai ho\u1eb7c thi\u1ebfu c\u1ea5u tr\u00fac h\u00e0m IF: <\/b><span style=\"font-weight: 400;\">Ng\u01b0\u1eddi d\u00f9ng c\u1ea7n hi\u1ec3u \u0111\u00fang c\u1ea5u tr\u00fac h\u00e0m v\u00e0 g\u00f5 \u0111\u00fang h\u00e0m IF trong Excel \u0111\u1ec3 tr\u00e1nh nh\u1eefng sai s\u00f3t. N\u1ebfu g\u00f5 h\u00e0m xong Excel b\u00e1o l\u1ed7i, h\u00e3y th\u1eed click v\u00e0o \u00f4 \u0111\u00f3 \u0111\u1ec3 xem g\u1ee3i \u00fd t\u1eeb ph\u1ea7n m\u1ec1m.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>C\u00f3 m\u1ed9t v\u00e0 ch\u1ec9 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n v\u1ec1 h\u00e0m IF: <\/b><span style=\"font-weight: 400;\">N\u1ebfu ch\u1ec9 c\u00f3 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m IF th\u00ec k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u01a1n gi\u1ea3n thay v\u00ec gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Kh\u00f4ng s\u1eed d\u1ee5ng h\u00e0m ROUND:<\/b><span style=\"font-weight: 400;\"> Khi t\u00ednh to\u00e1n l\u01b0\u01a1ng, \u0111\u1ec3 tr\u00e1nh d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 sai bu\u1ed9c ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m ROUND \u0111\u1ec3 l\u00e0m tr\u00f2n k\u1ebft qu\u1ea3.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>S\u1eed d\u1ee5ng h\u00e0m IF v\u1edbi qu\u00e1 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u1ed3ng nhau:<\/b><span style=\"font-weight: 400;\"> \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 g\u00e2y ra hi\u1ec7u su\u1ea5t ch\u1eadm, kh\u00f3 qu\u1ea3n l\u00fd v\u00e0 d\u1eabn \u0111\u1ebfn l\u1ed7i.<\/span><\/p>\n<p style=\"text-align: justify;\">\u0110\u1ec3 gi\u1ea3m thao t\u00e1c th\u1ee7 c\u00f4ng v\u00e0 tr\u00e1nh nh\u1eefng sai s\u00f3t khi s\u1eed d\u1ee5ng Excel, b\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n sang s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m t\u00ednh l\u01b0\u01a1ng t\u1ef1 \u0111\u1ed9ng. Ch\u1ec9 c\u1ea7n thi\u1ebft l\u1eadp d\u1eef li\u1ec7u v\u00e0 c\u00f4ng th\u1ee9c ban \u0111\u1ea7u, h\u00e0ng th\u00e1ng ph\u1ea7n m\u1ec1m s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt b\u1ea3ng l\u01b0\u01a1ng.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/amis.misa.vn\/register\/?appcode=Payroll&amp;s_pd=amis-web&amp;source=Blog&amp;medium=banner&amp;campaign=seo&amp;content=cach-su-dung-ham-if-de-tinh-luong&amp;term=hrm_dkhuyen_\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-99265 size-full\" src=\"\/wp-content\/uploads\/2021\/04\/phan-mem-tinh-luong-amis-tien-luong-CTA.png\" alt=\"\" width=\"740\" height=\"214\" srcset=\"\/wp-content\/uploads\/2021\/04\/phan-mem-tinh-luong-amis-tien-luong-CTA.png 740w, \/wp-content\/uploads\/2021\/04\/phan-mem-tinh-luong-amis-tien-luong-CTA-500x145.png 500w\" sizes=\"(max-width: 740px) 100vw, 740px\" \/><\/a><\/p>\n<h2 style=\"text-align: justify;\"><b>6. K\u1ebft lu\u1eadn<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi nh\u1eefng n\u1ed9i dung tr\u00ean, hy v\u1ecdng b\u1ea1n \u0111\u1ecdc \u0111\u00e3 hi\u1ec3u c\u01a1 b\u1ea3n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng, th\u01b0\u1edfng, ph\u1ee5 c\u1ea5p cho nh\u00e2n vi\u00ean. H\u00e0m IF n\u00ean \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 ROUND, RANK, AND, OR\u2026 \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng thu\u1eadn ti\u1ec7n h\u01a1n.<\/span><\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_123907\" class=\"pvc_stats total_only  \" data-element-id=\"123907\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.0\" viewBox=\"0 0 502 315\" preserveAspectRatio=\"xMidYMid meet\"><g transform=\"translate(0,332) scale(0.1,-0.1)\" fill=\"\" stroke=\"none\"><path d=\"M2394 3279 l-29 -30 -3 -207 c-2 -182 0 -211 15 -242 39 -76 157 -76 196 0 15 31 17 60 15 243 l-3 209 -33 29 c-26 23 -41 29 -80 29 -41 0 -53 -5 -78 -31z\"\/><path d=\"M3085 3251 c-45 -19 -58 -50 -96 -229 -47 -217 -49 -260 -13 -295 52 -53 146 -42 177 20 16 31 87 366 87 410 0 70 -86 122 -155 94z\"\/><path d=\"M1751 3234 c-13 -9 -29 -31 -37 -50 -12 -29 -10 -49 21 -204 19 -94 39 -189 45 -210 14 -50 54 -80 110 -80 34 0 48 6 76 34 21 21 34 44 34 59 0 14 -18 113 -40 219 -37 178 -43 195 -70 221 -36 32 -101 37 -139 11z\"\/><path d=\"M1163 3073 c-36 -7 -73 -59 -73 -102 0 -56 133 -378 171 -413 34 -32 83 -37 129 -13 70 36 67 87 -16 290 -86 209 -89 214 -129 231 -35 14 -42 15 -82 7z\"\/><path d=\"M3689 3066 c-15 -9 -33 -30 -42 -48 -48 -103 -147 -355 -147 -375 0 -98 131 -148 192 -74 13 15 57 108 97 206 80 196 84 226 37 273 -30 30 -99 39 -137 18z\"\/><path d=\"M583 2784 c-38 -19 -67 -74 -58 -113 9 -42 211 -354 242 -373 16 -10 45 -18 66 -18 51 0 107 52 107 100 0 39 -1 41 -124 234 -80 126 -108 162 -133 173 -41 17 -61 16 -100 -3z\"\/><path d=\"M4250 2784 c-14 -9 -74 -91 -133 -183 -95 -150 -107 -173 -107 -213 0 -55 33 -94 87 -104 67 -13 90 8 211 198 130 202 137 225 78 284 -27 27 -42 34 -72 34 -22 0 -50 -8 -64 -16z\"\/><path d=\"M2275 2693 c-553 -48 -1095 -270 -1585 -649 -135 -104 -459 -423 -483 -476 -23 -49 -22 -139 2 -186 73 -142 361 -457 571 -626 285 -228 642 -407 990 -497 242 -63 336 -73 660 -74 310 0 370 5 595 52 535 111 1045 392 1455 803 122 121 250 273 275 326 19 41 19 137 0 174 -41 79 -309 363 -465 492 -447 370 -946 591 -1479 653 -113 14 -422 18 -536 8z m395 -428 c171 -34 330 -124 456 -258 112 -119 167 -219 211 -378 27 -96 24 -300 -5 -401 -72 -255 -236 -447 -474 -557 -132 -62 -201 -76 -368 -76 -167 0 -236 14 -368 76 -213 98 -373 271 -451 485 -162 444 86 934 547 1084 153 49 292 57 452 25z m909 -232 c222 -123 408 -262 593 -441 76 -74 138 -139 138 -144 0 -16 -233 -242 -330 -319 -155 -123 -309 -223 -461 -299 l-81 -41 32 46 c18 26 49 83 70 128 143 306 141 649 -6 957 -25 52 -61 116 -79 142 l-34 47 45 -20 c26 -10 76 -36 113 -56z m-2057 25 c-40 -58 -105 -190 -130 -263 -110 -324 -59 -707 132 -981 25 -35 42 -64 37 -64 -19 0 -241 119 -326 174 -188 122 -406 314 -532 468 l-58 71 108 103 c185 178 428 349 672 473 66 33 121 60 123 61 2 0 -10 -19 -26 -42z\"\/><path d=\"M2375 1950 c-198 -44 -350 -190 -395 -379 -18 -76 -8 -221 19 -290 114 -284 457 -406 731 -260 98 52 188 154 231 260 27 69 37 214 19 290 -38 163 -166 304 -326 360 -67 23 -215 33 -279 19z\"\/><\/g><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n<div style='text-align:center' class='yasr-auto-insert-visitor'><\/div>","protected":false},"excerpt":{"rendered":"<p>Ph\u1ea7n m\u1ec1m Microsoft Excel ch\u1eafc h\u1eb3n kh\u00f4ng c\u00f2n xa l\u1ea1 \u0111\u1ed1i v\u1edbi d\u00e2n v\u0103n ph\u00f2ng, \u0111\u1eb7c bi\u1ec7t l\u00e0 v\u1edbi nh\u1eefng ng\u01b0\u1eddi l\u00e0m k\u1ebf to\u00e1n hay HR. Tuy nhi\u00ean c\u00e1ch d\u00f9ng h\u00e0m IF trong Excel kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft. H\u00e3y c\u00f9ng MISA AMIS HRM kh\u00e1m ph\u00e1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng th\u00f4ng [&hellip;]<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_123907\" class=\"pvc_stats total_only  \" data-element-id=\"123907\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.0\" viewBox=\"0 0 502 315\" preserveAspectRatio=\"xMidYMid meet\"><g transform=\"translate(0,332) scale(0.1,-0.1)\" fill=\"\" stroke=\"none\"><path d=\"M2394 3279 l-29 -30 -3 -207 c-2 -182 0 -211 15 -242 39 -76 157 -76 196 0 15 31 17 60 15 243 l-3 209 -33 29 c-26 23 -41 29 -80 29 -41 0 -53 -5 -78 -31z\"\/><path d=\"M3085 3251 c-45 -19 -58 -50 -96 -229 -47 -217 -49 -260 -13 -295 52 -53 146 -42 177 20 16 31 87 366 87 410 0 70 -86 122 -155 94z\"\/><path d=\"M1751 3234 c-13 -9 -29 -31 -37 -50 -12 -29 -10 -49 21 -204 19 -94 39 -189 45 -210 14 -50 54 -80 110 -80 34 0 48 6 76 34 21 21 34 44 34 59 0 14 -18 113 -40 219 -37 178 -43 195 -70 221 -36 32 -101 37 -139 11z\"\/><path d=\"M1163 3073 c-36 -7 -73 -59 -73 -102 0 -56 133 -378 171 -413 34 -32 83 -37 129 -13 70 36 67 87 -16 290 -86 209 -89 214 -129 231 -35 14 -42 15 -82 7z\"\/><path d=\"M3689 3066 c-15 -9 -33 -30 -42 -48 -48 -103 -147 -355 -147 -375 0 -98 131 -148 192 -74 13 15 57 108 97 206 80 196 84 226 37 273 -30 30 -99 39 -137 18z\"\/><path d=\"M583 2784 c-38 -19 -67 -74 -58 -113 9 -42 211 -354 242 -373 16 -10 45 -18 66 -18 51 0 107 52 107 100 0 39 -1 41 -124 234 -80 126 -108 162 -133 173 -41 17 -61 16 -100 -3z\"\/><path d=\"M4250 2784 c-14 -9 -74 -91 -133 -183 -95 -150 -107 -173 -107 -213 0 -55 33 -94 87 -104 67 -13 90 8 211 198 130 202 137 225 78 284 -27 27 -42 34 -72 34 -22 0 -50 -8 -64 -16z\"\/><path d=\"M2275 2693 c-553 -48 -1095 -270 -1585 -649 -135 -104 -459 -423 -483 -476 -23 -49 -22 -139 2 -186 73 -142 361 -457 571 -626 285 -228 642 -407 990 -497 242 -63 336 -73 660 -74 310 0 370 5 595 52 535 111 1045 392 1455 803 122 121 250 273 275 326 19 41 19 137 0 174 -41 79 -309 363 -465 492 -447 370 -946 591 -1479 653 -113 14 -422 18 -536 8z m395 -428 c171 -34 330 -124 456 -258 112 -119 167 -219 211 -378 27 -96 24 -300 -5 -401 -72 -255 -236 -447 -474 -557 -132 -62 -201 -76 -368 -76 -167 0 -236 14 -368 76 -213 98 -373 271 -451 485 -162 444 86 934 547 1084 153 49 292 57 452 25z m909 -232 c222 -123 408 -262 593 -441 76 -74 138 -139 138 -144 0 -16 -233 -242 -330 -319 -155 -123 -309 -223 -461 -299 l-81 -41 32 46 c18 26 49 83 70 128 143 306 141 649 -6 957 -25 52 -61 116 -79 142 l-34 47 45 -20 c26 -10 76 -36 113 -56z m-2057 25 c-40 -58 -105 -190 -130 -263 -110 -324 -59 -707 132 -981 25 -35 42 -64 37 -64 -19 0 -241 119 -326 174 -188 122 -406 314 -532 468 l-58 71 108 103 c185 178 428 349 672 473 66 33 121 60 123 61 2 0 -10 -19 -26 -42z\"\/><path d=\"M2375 1950 c-198 -44 -350 -190 -395 -379 -18 -76 -8 -221 19 -290 114 -284 457 -406 731 -260 98 52 188 154 231 260 27 69 37 214 19 290 -38 163 -166 304 -326 360 -67 23 -215 33 -279 19z\"\/><\/g><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":143,"featured_media":164335,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"yasr_overall_rating":0,"yasr_post_is_review":"","yasr_auto_insert_disabled":"","yasr_review_type":"","footnotes":""},"categories":[2290],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng th\u01b0\u1edfng trong Excel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng th\u01b0\u1edfng trong Excel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/amis.misa.vn\/123907\/cach-su-dung-ham-if-de-tinh-luong\/","url":"https:\/\/amis.misa.vn\/123907\/cach-su-dung-ham-if-de-tinh-luong\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng th\u01b0\u1edfng trong Excel","isPartOf":{"@id":"https:\/\/amis.misa.vn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/amis.misa.vn\/123907\/cach-su-dung-ham-if-de-tinh-luong\/#primaryimage"},"image":{"@id":"https:\/\/amis.misa.vn\/123907\/cach-su-dung-ham-if-de-tinh-luong\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2024\/08\/cach-su-dung-ham-if-de-tinh-luong.jpg","datePublished":"2024-08-29T10:21:51+00:00","dateModified":"2024-11-06T13:20:35+00:00","author":{"@id":"https:\/\/amis.misa.vn\/#\/schema\/person\/6dc806a31a02f53277bf3c8e7c95af3f"},"description":"T\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng, th\u01b0\u1edfng v\u00e0 m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m IF trong Excel","breadcrumb":{"@id":"https:\/\/amis.misa.vn\/123907\/cach-su-dung-ham-if-de-tinh-luong\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/amis.misa.vn\/123907\/cach-su-dung-ham-if-de-tinh-luong\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/amis.misa.vn\/123907\/cach-su-dung-ham-if-de-tinh-luong\/#primaryimage","url":"\/wp-content\/uploads\/2024\/08\/cach-su-dung-ham-if-de-tinh-luong.jpg","contentUrl":"\/wp-content\/uploads\/2024\/08\/cach-su-dung-ham-if-de-tinh-luong.jpg","width":940,"height":528,"caption":"c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m if \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng"},{"@type":"BreadcrumbList","@id":"https:\/\/amis.misa.vn\/123907\/cach-su-dung-ham-if-de-tinh-luong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/m.amis.vn\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng th\u01b0\u1edfng trong Excel"}]},{"@type":"Person","@id":"https:\/\/amis.misa.vn\/#\/schema\/person\/6dc806a31a02f53277bf3c8e7c95af3f","name":"HRM.A0474.dkhuyen","url":"https:\/\/amis.misa.vn\/"}]}},"yasr_visitor_votes":{"stars_attributes":{"read_only":false,"span_bottom":false},"number_of_votes":0,"sum_votes":0},"_links":{"self":[{"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/posts\/123907"}],"collection":[{"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/users\/143"}],"replies":[{"embeddable":true,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/comments?post=123907"}],"version-history":[{"count":4,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/posts\/123907\/revisions"}],"predecessor-version":[{"id":176145,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/posts\/123907\/revisions\/176145"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/media\/164335"}],"wp:attachment":[{"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/media?parent=123907"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/categories?post=123907"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/amis.misa.vn\/wp-json\/wp\/v2\/tags?post=123907"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}