{"id":24071,"date":"2022-04-14T21:34:05","date_gmt":"2022-04-14T14:34:05","guid":{"rendered":"https:\/\/nic.a2ztech.vn\/12-ham-excel-trong-tinh-luong-huu-ich-cho-chuyen-vien-cb\/"},"modified":"2022-12-29T16:40:46","modified_gmt":"2022-12-29T09:40:46","slug":"12-ham-excel-trong-tinh-luong-huu-ich-cho-chuyen-vien-cb","status":"publish","type":"post","link":"https:\/\/nicvn.com\/vi\/12-ham-excel-trong-tinh-luong-huu-ich-cho-chuyen-vien-cb","title":{"rendered":"[C\u1eadp nh\u1eadt] 12 h\u00e0m Excel trong t\u00ednh l\u01b0\u01a1ng h\u1eefu \u00edch cho chuy\u00ean vi\u00ean C&B"},"content":{"rendered":"
\n
\n

T\u1eeb l\u00e2u, Excel \u0111\u00e3 tr\u1edf th\u00e0nh m\u1ed9t trong nh\u1eefng k\u1ef9 n\u0103ng tin h\u1ecdc quan tr\u1ecdng c\u1ee7a m\u1ecdi ng\u00e0nh ngh\u1ec1. V\u1edbi nh\u1eefng ng\u01b0\u1eddi l\u00e0m nh\u00e2n s\u1ef1, \u0111\u1eb7c bi\u1ec7t \u0111\u1ed1i v\u1edbi b\u1ed9 ph\u1eadn C&B<\/a> (ph\u1ee5 tr\u00e1ch ch\u1ebf \u0111\u1ed9 ti\u1ec1n l\u01b0\u01a1ng v\u00e0 ph\u00fac l\u1ee3i) c\u00f4ng c\u1ee5 n\u00e0y nh\u01b0 m\u1ed9t th\u1ee9 v\u0169 kh\u00ed s\u1eafc b\u00e9n h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c cho c\u00f4ng t\u00e1c t\u00ednh to\u00e1n l\u01b0\u01a1ng th\u01b0\u1edfng, c\u00e1c ch\u1ebf \u0111\u1ed9 BHXH, thu\u1ebf TNCN. H\u00e3y b\u1ecf t\u00fai 12 h\u00e0m excel trong t\u00ednh l\u01b0\u01a1ng<\/a> h\u1eefu \u00edch sau cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n<\/b>:<\/em><\/p>\n

M\u1ed9t s\u1ed1 H\u00e0m excel m\u00e0 chuy\u00ean vi\u00ean C&B ph\u1ea3i bi\u1ebft<\/span><\/h2>\n

1. H\u00e0m IF<\/b><\/span><\/h3>\n

S\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh xem m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u00f3 \u0111\u00fang hay kh\u00f4ng. N\u1ebfu \u0111i\u1ec1u ki\u1ec7n l\u00e0 \u0111\u00fang, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb; n\u1ebfu kh\u00f4ng, n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c<\/p>\n

C\u00f4ng th\u1ee9c: IF(\u0111i\u1ec1u ki\u1ec7n, gi\u00e1 tr\u1ecb A, gi\u00e1 tr\u1ecb B).<\/strong><\/p><\/blockquote>\n

N\u1ebfu th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea1t \u0111\u01b0\u1ee3c th\u00ec gi\u00e1 tr\u1ecb s\u1ebd l\u00e0 A, c\u00f2n n\u1ebfu kh\u00f4ng th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n th\u00ec gi\u00e1 tr\u1ecb l\u00e0 B.<\/p>\n

2. H\u00e0m IF(OR)<\/b><\/span><\/h3>\n

H\u00e0m OR<\/strong> trong Excel l\u00e0 m\u1ed9t h\u00e0m logic m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 ki\u1ec3m tra xem m\u1ed9t danh s\u00e1ch c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u00f3 \u0111\u00fang hay kh\u00f4ng. N\u1ebfu b\u1ea5t k\u1ef3 \u0111i\u1ec1u ki\u1ec7n n\u00e0o trong danh s\u00e1ch l\u00e0 \u0111\u00fang, h\u00e0m OR s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb TRUE. N\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n trong danh s\u00e1ch \u0111\u1ec1u sai, h\u00e0m OR s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb FALSE.<\/p>\n

C\u00f4ng th\u1ee9c OR(logical1, [logical2], …)<\/strong><\/p><\/blockquote>\n

M\u1ed7i “logical” trong c\u00fa ph\u00e1p n\u00e0y l\u00e0 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra.<\/p>\n

S\u1eed d\u1ee5ng h\u00e0m OR v\u1edbi h\u00e0m IF \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c t\u00e1c v\u1ee5 ph\u1ee9c t\u1ea1p h\u01a1n.<\/p>\n

C\u00f4ng th\u1ee9c: =IF(OR(logical1, [logical2],…), gi\u00e1 tr\u1ecb A, gi\u00e1 tr\u1ecb B)<\/strong><\/p><\/blockquote>\n

N\u1ebfu th\u1ecfa m\u00e3n c\u00e1c logical1, logical2, ho\u1eb7c 3\u2026 th\u00ec gi\u00e1 tr\u1ecb s\u1ebd l\u00e0 A, kh\u00f4ng th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n l\u00e0 B.<\/p>\n

V\u00ed d\u1ee5<\/strong>, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh xem m\u1ed9t nh\u00e2n vi\u00ean c\u00f3 \u0111\u1ee7 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 nh\u1eadn th\u01b0\u1edfng hay kh\u00f4ng:<\/p>\n

=IF(OR(A2>200, B2>500), “\u0110\u1ee7 \u0111i\u1ec1u ki\u1ec7n”, “Kh\u00f4ng \u0111\u1ee7 \u0111i\u1ec1u ki\u1ec7n”)<\/p>\n

Trong c\u00f4ng th\u1ee9c tr\u00ean, A2 v\u00e0 B2 l\u00e0 c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra, v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb “\u0110\u1ee7 \u0111i\u1ec1u ki\u1ec7n” v\u00e0 “Kh\u00f4ng \u0111\u1ee7 \u0111i\u1ec1u ki\u1ec7n” l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 t\u00f9y theo k\u1ebft qu\u1ea3 c\u1ee7a \u0111i\u1ec1u ki\u1ec7n OR.<\/p>\n

3. H\u00e0m IF(AND)<\/b><\/span><\/h3>\n

H\u00e0m AND<\/strong> trong Excel c\u0169ng l\u00e0 m\u1ed9t h\u00e0m logic ki\u1ec3m tra \u0111\u1ed3ng th\u1eddi c\u00e1c \u0111i\u1ec1u ki\u1ec7n. N\u1ebfu t\u1ea5t c\u1ea3<\/strong> c\u00e1c \u0111i\u1ec1u ki\u1ec7n trong danh s\u00e1ch l\u00e0 \u0111\u00fang, h\u00e0m AND s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb TRUE. N\u1ebfu b\u1ea5t k\u1ef3<\/strong> \u0111i\u1ec1u ki\u1ec7n n\u00e0o trong danh s\u00e1ch l\u00e0 sai, h\u00e0m AND s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb FALSE.<\/p>\n

C\u00f4ng th\u1ee9c AND(logical1, [logical2], …).<\/strong><\/p><\/blockquote>\n

M\u1ed7i “logical” trong c\u00fa ph\u00e1p n\u00e0y l\u00e0 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra.<\/p>\n

Khi k\u1ebft h\u1ee3p h\u00e0m AND v\u1edbi h\u00e0m IF \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ed3ng th\u1eddi ph\u1ee9c t\u1ea1p h\u01a1n.<\/p>\n

C\u00f4ng th\u1ee9c: =IF(AND(logical1, [logical2],…), gi\u00e1 tr\u1ecb A, gi\u00e1 tr\u1ecb B)<\/strong><\/p><\/blockquote>\n

N\u1ebfu th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi c\u00e1c \u0111i\u1ec1u ki\u1ec7n 1, \u0111i\u1ec1u ki\u1ec7n 2, \u0111i\u1ec1u ki\u1ec7n 3\u2026th\u00ec gi\u00e1 tr\u1ecb l\u00e0 A, kh\u00f4ng th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n l\u00e0 B.<\/p>\n<\/div>\n

\"\"<\/div>\n
Excel trong t\u00ednh l\u01b0\u01a1ng l\u00e0 c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c cho chuy\u00ean vi\u00ean C&B<\/a><\/b><\/i><\/div>\n

4. H\u00e0m IFERROR<\/b><\/span><\/h3>\n

H\u00e0m IFERROR<\/strong> trong t\u00ednh l\u01b0\u01a1ng<\/strong> l\u00e0 m\u1ed9t h\u00e0m d\u00f9ng \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c l\u1ed7i xu\u1ea5t hi\u1ec7n trong c\u00f4ng th\u1ee9c. N\u00f3 cho ph\u00e9p b\u1ea1n x\u00e1c \u0111\u1ecbnh m\u1ed9t gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh \u0111\u1ec3 tr\u1ea3 v\u1ec1 n\u1ebfu c\u00f4ng th\u1ee9c b\u1ecb l\u1ed7i, ho\u1eb7c x\u1eed l\u00fd c\u00e1c l\u1ed7i theo c\u00e1ch kh\u00e1c nhau.<\/p>\n

C\u00f4ng th\u1ee9c IFERROR(c\u00f4ng th\u1ee9c, gi\u00e1 tr\u1ecb n\u1ebfu c\u00f4ng th\u1ee9c l\u1ed7i). <\/strong><\/p><\/blockquote>\n

Trong \u0111\u00f3, “c\u00f4ng th\u1ee9c” l\u00e0 c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra, v\u00e0 “gi\u00e1 tr\u1ecb n\u1ebfu c\u00f4ng th\u1ee9c l\u1ed7i” l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 tr\u01b0\u1eddng h\u1ee3p c\u00f4ng th\u1ee9c b\u1ecb l\u1ed7i.<\/p>\n

V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb “N\/A” n\u1ebfu c\u00f4ng th\u1ee9c t\u00ednh trung b\u00ecnh c\u1ed9ng b\u1ecb l\u1ed7i:<\/p>\n

=IFERROR(A2\/A10, “N\/A”)<\/p>\n

Trong c\u00f4ng th\u1ee9c tr\u00ean, A2\/A10 l\u00e0 c\u00f4ng th\u1ee9c ph\u00e9p chia, v\u00e0 “N\/A” l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 h\u00e0m IFERROR s\u1ebd tr\u1ea3 v\u1ec1 n\u1ebfu ph\u00e9p chia b\u1ecb l\u1ed7i. N\u1ebfu kh\u00f4ng c\u00f3 l\u1ed7i x\u1ea3y ra, h\u00e0m IFERROR s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 nh\u01b0 b\u00ecnh th\u01b0\u1eddng.<\/p>\n

Th\u00f4ng th\u01b0\u1eddng, \u0111a ph\u1ea7n m\u1ecdi ng\u01b0\u1eddi s\u1ebd chuy\u1ec3n c\u00f4ng th\u1ee9c l\u1ed7i v\u1ec1 0 ho\u1eb7c N\/A \u0111\u1ec3 d\u1ec5 x\u00e1c \u0111\u1ecbnh.<\/p>\n

5. H\u00e0m IF l\u1ed3ng nhau<\/b><\/span><\/h3>\n

V\u1edbi nh\u1eefng ph\u00e9p t\u00ednh nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF l\u1ed3ng nhau\u00a0<\/strong><\/p>\n

\u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF l\u1ed3ng nhau, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m IF trong m\u1ed9t c\u00f4ng th\u1ee9c IF kh\u00e1c.<\/p>\n

C\u00f4ng th\u1ee9c IF(\u0111i\u1ec1u ki\u1ec7n 1, gi\u00e1 tr\u1ecb A, IF(\u0111i\u1ec1u ki\u1ec7n 2, gi\u00e1 tr\u1ecb B, gi\u00e1 tr\u1ecb C)…)<\/p><\/blockquote>\n

Trong c\u00fa ph\u00e1p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n v\u00e0 gi\u00e1 tr\u1ecb kh\u00e1c nhau b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng nhi\u1ec1u h\u00e0m IF l\u1ed3ng nhau. N\u1ebfu th\u1ecfa m\u00e3 \u0111i\u1ec1u ki\u1ec7n 1, th\u00ec \u0111\u00f3 l\u00e0 gi\u00e1 tr\u1ecb A, n\u1ebfu th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n 2, th\u00ec \u0111\u00f3 l\u00e0 gi\u00e1 tr\u1ecb B\u2026Kh\u00f4ng l\u00e0 gi\u00e1 tr\u1ecb C(L\u01b0u \u00fd h\u00e0m s\u1eed d\u1ee5ng v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. V\u00ed d\u1ee5 nh\u01b0 c\u00f4ng th\u1ee9c t\u00ednh thu\u1ebf Thu nh\u1eadp c\u00e1 nh\u00e2n ho\u1eb7c \u0111i\u1ec1u ki\u1ec7n t\u00ednh b\u1ea3o hi\u1ec3m)<\/p>\n

6. H\u00e0m COUNT (\u0110\u00ea\u0301m s\u00f4\u0301 \u00f4 ch\u01b0\u0301a s\u00f4\u0301)<\/b><\/span><\/h3>\n
\n
\n
\n
\n
\n
\n

H\u00e0m COUNT<\/strong> trong Excel l\u00e0 m\u1ed9t h\u00e0m d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 trong m\u1ed9t kho\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a s\u1ed1. N\u00f3 cho ph\u00e9p b\u1ea1n x\u00e1c \u0111\u1ecbnh s\u1ed1 l\u01b0\u1ee3ng s\u1ed1 trong m\u1ed9t kho\u1ea3ng d\u1eef li\u1ec7u ho\u1eb7c trong m\u1ed9t danh s\u00e1ch c\u00e1c \u00f4 ri\u00eang l\u1ebb.<\/p>\n

C\u00f4ng th\u1ee9c COUNT(value1, [value2], …).<\/strong><\/p><\/blockquote>\n

Trong \u0111\u00f3, “value1”, “value2” vv l\u00e0 c\u00e1c \u00f4 ho\u1eb7c kho\u1ea3ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1.<\/p>\n

V\u00ed d\u1ee5<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng s\u1ed1 trong kho\u1ea3ng A1:A10:<\/p>\n

=COUNT(A1:A10)<\/p>\n

Ho\u1eb7c, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng s\u1ed1 trong m\u1ed9t danh s\u00e1ch c\u00e1c \u00f4 ri\u00eang l\u1ebb:<\/p>\n

=COUNT(A1, B2, C3, D4)<\/p>\n

Trong c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean, kho\u1ea3ng A1:A10 v\u00e0 c\u00e1c \u00f4 A1, B2, C3 v\u00e0 D4 l\u00e0 c\u00e1c \u00f4 ho\u1eb7c kho\u1ea3ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1, v\u00e0 h\u00e0m COUNT s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng s\u1ed1 trong kho\u1ea3ng ho\u1eb7c danh s\u00e1ch c\u00e1c \u00f4 \u0111\u00f3.<\/p>\n

L\u01b0u \u00fd r\u1eb1ng h\u00e0m COUNT ch\u1ec9 t\u00ednh c\u00e1c \u00f4 ch\u1ee9a s\u1ed1, v\u00e0 kh\u00f4ng t\u00ednh c\u00e1c \u00f4 ch\u1ee9a chu\u1ed7i k\u00fd t\u1ef1 ho\u1eb7c c\u00e1c \u00f4 b\u1ecb tr\u1ed1ng.<\/p><\/blockquote>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

7.\u00a0 H\u00e0m COUNTIF (\u0110\u00ea\u0301m ca\u0301c \u00f4 d\u01b0\u0323a tr\u00ean nhi\u00ea\u0300u ti\u00eau chi\u0301\/\u0111i\u1ec1u ki\u1ec7n)<\/b><\/span><\/h3>\n

H\u00e0m COUNTIF l\u00e0 m\u1ed9t h\u00e0m d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 trong m\u1ed9t kho\u1ea3ng d\u1eef li\u1ec7u th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh.<\/p>\n

C\u00f4ng th\u1ee9c COUNTIF(kho\u1ea3ng d\u1eef li\u1ec7u, ti\u00eau ch\u00ed \u0111\u1ebfm).<\/strong><\/p><\/blockquote>\n

Trong \u0111\u00f3, kho\u1ea3ng d\u1eef li\u1ec7u l\u00e0 h\u00e0ng ho\u1eb7c c\u1ed9t ho\u1eb7c ph\u1ea1m vi m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm. Ti\u00eau ch\u00ed \u0111\u1ebfm c\u00f3 th\u1ec3 l\u00e0 S\u00f4\u0301, bi\u00ea\u0309u th\u01b0\u0301c, tham chi\u00ea\u0301u \u00f4 hay chu\u00f4\u0303i v\u0103n ba\u0309n xa\u0301c \u0111i\u0323nh \u00f4 se\u0303 \u0111\u01b0\u01a1\u0323c \u0111\u00ea\u0301m.<\/p>\n

V\u00ed d\u1ee5<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng s\u1ed1 trong kho\u1ea3ng A1:A10 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 10.000.000:<\/p>\n

=COUNTIF(A1:A10, “>=10.000.000”)<\/p>\n

Trong c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean, kho\u1ea3ng A1:A10 l\u00e0 kho\u1ea3ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm, v\u00e0 h\u00e0m COUNTIF s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng \u00f4 trong kho\u1ea3ng ho\u1eb7c danh s\u00e1ch c\u00e1c \u00f4 \u0111\u00f3 m\u00e0 th\u1ecfa m\u00e3n<\/p>\n

8. H\u00e0m COUNTIFS (\u0110\u00ea\u0301m ca\u0301c \u00f4 d\u01b0\u0323a tr\u00ean nhi\u00ea\u0300u ti\u00eau chi\u0301\/nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n)<\/b><\/span><\/h3>\n

T\u01b0\u01a1ng t\u1ef1 h\u00e0m COUNTIF, h\u00e0m COUNTIFS l\u00e0 h\u00e0m \u0111\u1ebfm c\u00e1c \u00f4 d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n ho\u1eb7c ti\u00eau ch\u00ed kh\u00e1c nhau<\/p>\n

\n
C\u00f4ng th\u1ee9c: COUNTIFS(pha\u0323m vi ti\u00eau chi\u0301 1, ti\u00eau ch\u00ed 1, [pha\u0323m vi ti\u00eau chi\u0301 2, ti\u00eau ch\u00ed 2],\u2026)<\/strong><\/div>\n<\/blockquote>\n

9. H\u00e0m COUNTA (\u0111\u00ea\u0301m s\u00f4\u0301 \u00f4 kh\u00f4ng tr\u00f4\u0301ng trong m\u00f4\u0323t ph\u1ea1m vi)<\/b><\/span><\/h3>\n

H\u00e0m COUNTA <\/strong>l\u00e0 m\u1ed9t h\u00e0m d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 trong m\u1ed9t kho\u1ea3ng d\u1eef li\u1ec7u ho\u1eb7c trong m\u1ed9t danh s\u00e1ch c\u00e1c \u00f4 ri\u00eang l\u1ebb kh\u00f4ng b\u1ecb tr\u1ed1ng<\/strong>.<\/p>\n

C\u00f4ng th\u1ee9c: COUNTA(value1, [value2], …). <\/strong><\/p><\/blockquote>\n

Trong \u0111\u00f3:<\/p>\n

\u2022 value1 B\u1eaft bu\u1ed9c. \u0110\u00f4\u0301i s\u00f4\u0301 \u0111\u00e2\u0300u ti\u00ean \u0111a\u0323i di\u00ea\u0323n cho gia\u0301 tri\u0323 ma\u0300 ba\u0323n mu\u00f4\u0301n \u0111\u00ea\u0301m.<\/p>\n

\u2022 value2, \u2026 T\u00f9y ch\u1ecdn. Ca\u0301c \u0111\u00f4\u0301i s\u00f4\u0301 b\u00f4\u0309 sung \u0111a\u0323i di\u00ea\u0323n cho gia\u0301 tri\u0323 ma\u0300 ba\u0323n mu\u00f4\u0301n \u0111\u00ea\u0301m, t\u00f4\u0301i \u0111a 255 \u0111\u00f4\u0301i s\u00f4\u0301.<\/p>\n

L\u01b0u \u00fd r\u1eb1ng h\u00e0m COUNTA kh\u00f4ng ch\u1ec9 t\u00ednh c\u00e1c \u00f4 ch\u1ee9a s\u1ed1, m\u00e0 n\u00f3 c\u00f2n \u0111\u1ebfm c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a chu\u1ed7i k\u00fd t\u1ef1<\/p>\n

10. H\u00e0m Sum (T\u00ednh t\u1ed5ng c\u00e1c s\u1ed1)<\/b><\/span><\/h3>\n

Ch\u1eafc h\u1eb3n g\u1ea7n nh\u01b0 ai c\u0169ng bi\u1ebft \u0111\u1ebfn h\u00e0m SUM c\u1ee7a Excel, \u0111\u00e2y l\u00e0 h\u00e0m t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 b\u1ea5t k\u00ec ho\u1eb7c t\u00ednh t\u1ed5ng 1 kho\u1ea3ng s\u1ed1 trong danh s\u00e1ch<\/p>\n

C\u00f4ng th\u1ee9c: SUM(number1, [number2], …). <\/strong><\/p><\/blockquote>\n

Trong \u0111\u00f3, “number1”, “number2” vv l\u00e0 c\u00e1c \u00f4 ho\u1eb7c kho\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng.<\/p>\n

V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong kho\u1ea3ng A1:A10:<\/p>\n

=SUM(A1:A10)<\/p>\n

Ho\u1eb7c, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong m\u1ed9t danh s\u00e1ch c\u00e1c \u00f4 ri\u00eang l\u1ebb:<\/p>\n

=SUM(A1, B2, C3, D4)<\/p>\n

Trong c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean, kho\u1ea3ng A1:A10 v\u00e0 c\u00e1c \u00f4 A1, B2, C3 v\u00e0 D4 l\u00e0 c\u00e1c \u00f4 ho\u1eb7c kho\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng, v\u00e0 h\u00e0m SUM s\u1ebd tr\u1ea3 v\u1ec1 t\u1ed5ng c\u00e1c s\u1ed1 trong kho\u1ea3ng ho\u1eb7c danh s\u00e1ch c\u00e1c \u00f4 \u0111\u00f3.<\/p>\n

L\u01b0u \u00fd r\u1eb1ng h\u00e0m SUM ch\u1ec9 t\u00ednh c\u00e1c \u00f4 ch\u1ee9a s\u1ed1, v\u00e0 kh\u00f4ng t\u00ednh c\u00e1c \u00f4 ch\u1ee9a chu\u1ed7i k\u00fd t\u1ef1 ho\u1eb7c c\u00e1c \u00f4 b\u1ecb tr\u1ed1ng.<\/p><\/blockquote>\n

\"\"<\/div>\n
\u00a0C&B c\u1ea7n n\u1eafm v\u1eefng c\u00e1c c\u00f4ng th\u1ee9c excel t\u00ednh l\u01b0\u01a1ng c\u01a1 b\u1ea3n cho nghi\u1ec7p v\u1ee5 chuy\u00ean m\u00f4n<\/i><\/div>\n

11. H\u00e0m Sumif (T\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n)<\/b><\/span><\/h3>\n

H\u00e0m SUMIF d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong m\u1ed9t kho\u1ea3ng d\u1eef li\u1ec7u ho\u1eb7c trong m\u1ed9t danh s\u00e1ch c\u00e1c \u00f4 ri\u00eang l\u1ebb m\u00e0 th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh.<\/p>\n

C\u00f4ng th\u1ee9c SUMIF(pha\u0323m vi, ti\u00eau ch\u00ed, [V\u00f9ng d\u1eef li\u1ec7u c\u1ea7n t\u00ednh t\u1ed5ng]).<\/strong><\/p><\/blockquote>\n

Trong \u0111\u00f3, “ph\u1ea1m vi” l\u00e0 kho\u1ea3ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n, “ti\u00eau ch\u00ed” l\u00e0 \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra, v\u00e0 “V\u00f9ng d\u1eef li\u1ec7u c\u1ea7n t\u00ednh t\u1ed5ng” l\u00e0 kho\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng.<\/p>\n

12. H\u00e0m Sumifs (T\u00ednh t\u1ed5ng c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n)<\/b><\/span><\/h3>\n
\n
C\u00f4ng th\u1ee9c: =SUMIFS(V\u00f9ng d\u1eef li\u1ec7u c\u1ea7n t\u00ednh t\u1ed5ng, ti\u00eau ch\u00ed 1,criteria1,criteri a_range2,criteria2\u2026)<\/strong><\/div>\n<\/blockquote>\n
Sum_range l\u00e0 c\u00e1c \u00f4 c\u1ea7n t\u00ednh t\u1ed5ng, bao g\u1ed3m c\u00e1c caon s\u1ed1, t\u00ean v\u00f9ng, m\u00e3ng hay c\u00e1c tham chi\u1ebfu \u0111\u1ebfn c\u00e1c gi\u00e1 tr\u1ecb. C\u00e1c \u00f4 tr\u1ed1ng hay ch\u1ee9a chu\u1ed7i (Text) s\u1ebd b\u1ecb b\u1ecf qua.<\/div>\n
Criteria_range1, criteria_range2, \u2026 c\u00f3 th\u1ec3 khai b\u00e1o t\u1eeb 1 \u0111\u1ebfn 127 v\u00f9ng d\u00f9ng \u0111\u1ec3 li\u00ean k\u1ebft v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n cho v\u00f9ng.Criteria1, criteria2, \u2026 c\u00f3 th\u1ec3 c\u00f3 t\u1eeb 1 \u0111\u1ebfn 127 \u0111i\u1ec1u ki\u1ec7n \u1edf d\u1ea1ng c\u1ecdn s\u1ed1, bi\u1ec3u th\u1ee9c, tham chi\u1ebfu ho\u1eb7c chu\u1ed7i.<\/div>\n
<\/div>\n
C\u1ea7n n\u1eafm v\u1eefng c\u00e1c h\u00e0m Excel s\u1eed d\u1ee5ng trong t\u00ednh l\u01b0\u01a1ng \u0111\u1ec3 ph\u1ee5c v\u1ee5 t\u1ed1t nh\u1ea5t cho c\u00f4ng t\u00e1c t\u00ednh l\u01b0\u01a1ng<\/a><\/b><\/i> cho nh\u00e2n vi\u00ean trong doanh nghi\u1ec7p c\u1ee7a b\u1ea1n. 12 h\u00e0m Excel trong t\u00ednh l\u01b0\u01a1ng \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea \u1edf tr\u00ean l\u00e0 c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n nh\u01b0ng t\u00ednh \u1ee9ng d\u1ee5ng v\u00e0 t\u1ea7n su\u1ea5t s\u1eed d\u1ee5ng trong nghi\u1ec7p v\u1ee5 chuy\u00ean m\u00f4n c\u1ee7a chuy\u00ean vi\u00ean C&B<\/a><\/b><\/i> r\u1ea5t l\u1edbn. N\u1ebfu b\u1ea1n c\u1ea7n h\u1ed7 tr\u1ee3, h\u00e3y \u0111\u1ec3 l\u1ea1i c\u00e2u h\u1ecfi \u0111\u1ec3 \u0111\u01b0\u1ee3c NIC HR tr\u1ee3 gi\u00fap.<\/div>\n
\n

C\u0103n c\u1ee9 \u0111\u1ec3 l\u00e0m B\u1ea3ng t\u00ednh l\u01b0\u01a1ng excel<\/span><\/h2>\n

C\u00f3 th\u1ec3 n\u00f3i Excel ch\u00ednh l\u00e0 v\u0169 kh\u00ed b\u00ed m\u1eadt c\u1ee7a b\u1ea5t c\u1ee9 nh\u00e2n s\u1ef1 ti\u1ec1n l\u01b0\u01a1ng (chuy\u00ean vi\u00ean C&B) n\u00e0o. Cho d\u00f9 h\u1ec7 th\u1ed1ng c\u00f3 l\u1edbn \u0111\u1ebfn \u0111\u00e2u, ph\u1ea7n m\u1ec1m c\u00f3 th\u00f4ng minh th\u1ebf n\u00e0o th\u00ec v\u1eabn ph\u1ea3i s\u1eed d\u1ee5ng excel nh\u01b0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c. D\u1ef1a theo Th\u00f4ng t\u01b0 133 v\u00e0 Th\u00f4ng t\u01b0 200, doanh nghi\u1ec7p c\u00f3 th\u1ec3 t\u1ef1 thi\u1ebft k\u1ebf b\u1ea3ng thanh to\u00e1n ti\u1ec1n l\u01b0\u01a1ng<\/strong> ph\u00f9 h\u1ee3p v\u1edbi \u0111\u1eb7c th\u00f9 v\u00e0 thu\u1eadn ti\u1ec7n trong c\u00f4ng vi\u1ec7c. Tuy nhi\u00ean, m\u1eabu b\u1ea3ng l\u01b0\u01a1ng n\u00e0y lu\u00f4n ph\u1ea3i c\u0103n c\u1ee9 v\u00e0 \u0111\u1ea3m b\u1ea3o theo m\u1ed9t s\u1ed1 y\u1ebfu t\u1ed1 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n