![\"Ham-int-trong-excel-1\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-int-trong-excel-16.jpg.webp)
<\/picture>2.C\u00f4ng th\u1ee9c h\u00e0m INT<\/h2>\n
Trong Excel c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m l\u00e0: = INT (A)<\/p>\n
Trong \u0111\u00f3:<\/p>\n
A l\u00e0 c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1 b\u1ea5t k\u00ec, m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t h\u00e0m trong Excel<\/p>\n
L\u01b0u \u00fd:<\/p>\n
- \n
- K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 s\u1ed1 nguy\u00ean<\/li>\n
- Ph\u1ea7n nguy\u00ean c\u00f3 gi\u00e1 tr\u1ecb nh\u1ecf g\u1ea7n nh\u1ea5t ti\u1ebfp theo<\/li>\n<\/ul>\n
![\"Ham-int-trong-excel-2\"](\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-int-trong-excel-17.jpg\")
<\/picture>C\u00f4ng th\u1ee9c h\u00e0m INT<\/figcaption><\/figure>\n 3. C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 c\u1ee7a h\u00e0m INT<\/h2>\n
H\u00e0m INT trong Excel s\u1ebd th\u1ef1c hi\u1ec7n l\u00e0m tr\u00f2n xu\u1ed1ng v\u1edbi s\u1ed1 d\u01b0\u01a1ng v\u00e0 s\u1ed1 \u00e2m tuy nhi\u00ean v\u1edbi s\u1ed1 nguy\u00ean \u00e2m c\u00e1c b\u1ea1n n\u00ean ch\u00fa \u00fd \u0111\u1ec3 tr\u00e1nh nh\u1ea7m l\u1eabn<\/p>\n
C\u1ee5 th\u1ec3:<\/p>\n
– Number l\u00e0 2 -> INT(2) = 2<\/p>\n
– Number l\u00e0 2.8 -> INT(2.8) = 2<\/p>\n
– Number l\u00e0 -2.5 -> INT(-2.5) = -3<\/p>\n
![\"Ham-int-trong-excel-3\"](\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-int-trong-excel-18.png\")
<\/picture>C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 c\u1ee7a h\u00e0m INT<\/figcaption><\/figure>\n 4. B\u1ea3y v\u1eadn d\u1ee5ng h\u00e0m INT trong Excel<\/h2>\n
C\u0169ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 r\u1ea5t nhi\u1ec1u c\u00e1c h\u00e0m kh\u00e1c c\u00f3 trong Excel, INT c\u00f3 nhi\u1ec1u c\u00e1ch \u1ee9ng d\u1ee5ng kh\u00e1c nhau. \u0110\u1ec3 c\u00f3 th\u1ec3 th\u00e0nh th\u1ea1o v\u00e0 \u00e1p d\u1ee5ng ch\u00ednh x\u00e1c trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o 7 c\u00e1ch s\u1eed d\u1ee5ng ngay sau \u0111\u00e2y.<\/p>\n
4.1 S\u1eed d\u1ee5ng h\u00e0m INT trong Excel l\u1ea5y ph\u1ea7n nguy\u00ean s\u1ed1 d\u01b0\u01a1ng<\/h3>\n
Sau khi \u0111\u00e3 bi\u1ebft h\u00e0m INT trong Excel l\u00e0 g\u00ec. Vi\u1ec7c \u00e1p d\u1ee5ng ch\u00fang t\u01b0\u01a1ng \u0111\u1ed1i \u0111\u01a1n gi\u1ea3n v\u1edbi s\u1ed1 nguy\u00ean d\u01b0\u01a1ng. C\u00e1c b\u1ea1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n \u0111\u00fang theo c\u00f4ng th\u1ee9c ban \u0111\u1ea7u. Gi\u00e1 tr\u1ecb \u0111\u1ea7u v\u00e0o c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 d\u01b0\u01a1ng, c\u00e1c \u00f4 ho\u1eb7c c\u00e1c h\u00e0m (sau khi x\u1eed l\u00fd l\u00e0 s\u1ed1 d\u01b0\u01a1ng) k\u1ebft qu\u1ea3 \u0111\u1ea7u ra lu\u00f4n l\u00e0 m\u1ed9t s\u1ed1 nguy\u00ean d\u01b0\u01a1ng nh\u1ecf h\u01a1n so v\u1edbi s\u1ed1 li\u1ec7u ban \u0111\u1ea7u.<\/p>\n
![\"Ham-int-trong-excel-4\"](\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-INT-trong-Excel-1-e1688562546204.png\")
<\/picture>S\u1eed d\u1ee5ng h\u00e0m INT trong Excel l\u1ea5y ph\u1ea7n nguy\u00ean s\u1ed1 d\u01b0\u01a1ng<\/figcaption><\/figure>\n 4.2 C\u00e1ch l\u1ea5y ph\u1ea7n nguy\u00ean v\u1edbi s\u1ed1 \u00e2m<\/h3>\n
Kh\u00e1c v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb nguy\u00ean d\u01b0\u01a1ng, k\u1ebft qu\u1ea3 khi th\u1ef1c hi\u1ec7n v\u1edbi s\u1ed1 \u00e2m th\u01b0\u1eddng kh\u00f4ng \u0111\u01b0a ra d\u1eef li\u1ec7u nh\u01b0 mong mu\u1ed1n. Tuy nhi\u1ec3n \u0111\u1ec3 kh\u1eafc ph\u1ee5c \u0111i\u1ec1u n\u00e0y, c\u00e1c b\u1ea1n c\u1ea7n m\u1ed9t ch\u00fat thay \u0111\u1ed5i trong vi\u1ec7c thi\u1ebft l\u1eadp \u0111\u1eb3ng th\u1ee9c t\u00ednh to\u00e1n.<\/p>\n
C\u00f4ng th\u1ee9c \u0111\u1ed1i v\u1edbi s\u1ed1 \u00e2m c\u1ee7a h\u00e0m INT trong excel:\u00a0 = INT(Number*- 1)*- 1<\/p>\n
Khi nh\u00e2n m\u1ed9t s\u1ed1 \u00e2m v\u1edbi – 1 ch\u00fang ta s\u1ebd \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 d\u01b0\u01a1ng. H\u00e0m INT s\u1ebd th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh v\u00e0 cho ra k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 nguy\u00ean d\u01b0\u01a1ng nh\u1ecf h\u01a1n. Ti\u1ebfp \u0111\u00f3, nh\u00e2n ti\u1ebfp v\u1edbi – 1 \u0111\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c s\u1ed1 \u00e2m.\u00a0\u0110\u00e2y c\u00f3 th\u1ec3 coi nh\u01b0 m\u1ed9t d\u1ea1ng c\u1ee7a ph\u00e9p to\u00e1n \u0111\u1ed1i x\u1ee9ng.<\/p>\n
V\u00ed d\u1ee5:<\/p>\n
– Number l\u00e0 -2.8 -> INT(-2.8*-1)*-1 = 2<\/p>\n
– Number l\u00e0 -19.3 -> INT(-19.3*-1)*-1 = 19<\/p>\n
![\"Ham-int-trong-excel-5\"](\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-INT-trong-Excel-2-e1688562562599.png\")
<\/picture>C\u00e1ch l\u1ea5y ph\u1ea7n nguy\u00ean v\u1edbi s\u1ed1 \u00e2m<\/figcaption><\/figure>\n 4.3 C\u00e1ch d\u00f9ng h\u00e0m INT t\u00ednh s\u1ed1 ng\u00e0y v\u00e0 tu\u1ea7n trong Excel<\/h3>\n
Ngo\u00e0i nh\u1eefng c\u00e1ch l\u00e0m tr\u00f2n \u0111\u1ec3 l\u1ea5y ph\u1ea7n nguy\u00ean c\u01a1 b\u1ea3n, h\u00e0m INT c\u00f2n h\u1ed7 tr\u1ee3 gi\u00fap t\u00ednh to\u00e1n s\u1ed1 tu\u1ea7n v\u00e0 ng\u00e0y. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t mang \u0111\u1ebfn nhi\u1ec1u l\u1ee3i \u00edch trong vi\u1ec7c t\u00ednh to\u00e1n th\u1eddi gian b\u1ea3o h\u00e0nh, mua h\u00e0ng c\u1ee7a c\u00e1c doanh nghi\u1ec7p th\u01b0\u01a1ng m\u1ea1i, t\u00ednh to\u00e1n s\u1ed1 ng\u00e0y \u1edf v\u00e0 s\u1ed1 ng\u00e0y \u0111i c\u00e1c nghi\u1ec7p v\u1ee5 kh\u00e1ch s\u1ea1n, … hay t\u00ednh to\u00e1n s\u1ed1 ng\u00e0y c\u00f4ng khi \u0111i l\u00e0m v\u1edbi c\u00e1c nghi\u1ec7p v\u1ee5 k\u1ebf to\u00e1n.<\/p>\n
\u0110\u1ed1i v\u1edbi c\u00f4ng th\u1ee9c t\u00ednh ng\u00e0y<\/strong>: S\u1ed1 Ng\u00e0y = INT(B1\u2013A1)<\/p>\n
– Trong \u0111\u00f3:<\/p>\n
A1 l\u00e0 m\u1ed1c th\u1eddi gian \u0111\u1ea7u<\/p>\n
B1 l\u00e0 m\u1ed1c th\u1eddi gian sau \u0111\u00f3<\/p>\n
V\u00ed d\u1ee5:<\/p>\n
A1=01\/01\/2023, B1=14\/02\/2023 th\u00ec =INT((B1-A1) c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 44<\/p>\n
A1=07\/01\/2023, B1=25\/02\/2023 th\u00ec =INT((B1-A1) c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 49<\/p>\n
![\"Ham-int-trong-excel-6\"](\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-INT-trong-Excel-3-e1688562614354.png\")
<\/picture>C\u00e1ch d\u00f9ng h\u00e0m INT t\u00ednh s\u1ed1 ng\u00e0y<\/figcaption><\/figure>\n \u0110\u1ed1i v\u1edbi c\u00e1ch t\u00ednh tu\u1ea7n<\/strong>, ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n th\u00eam ph\u00e9p chia ngay sau \u0111\u00f3<\/p>\n
C\u1ee5 th\u1ec3 S\u1ed1 Tu\u1ea7n =INT(B1-A1)\/7<\/p>\n
– Trong \u0111\u00f3:<\/p>\n
A1 l\u00e0 m\u1ed1c th\u1eddi gian \u0111\u1ea7u<\/p>\n
B1 l\u00e0 m\u1ed1c th\u1eddi gian sau \u0111\u00f3<\/p>\n
V\u00ed d\u1ee5:<\/p>\n
A1=01\/01\/2023, B1=14\/02\/2023 th\u00ec =INT((B1-A1)\/7) c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 6.29<\/p>\n
A1=07\/01\/2023, B1=25\/02\/2023 th\u00ec =INT((B1-A1)\/7) c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 7<\/p>\n
![\"Ham-int-trong-excel-7\"](\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-INT-trong-Excel-4-e1688562631510.png\")
<\/picture>C\u00e1ch d\u00f9ng h\u00e0m INT t\u00ednh s\u1ed1 tu\u1ea7n<\/figcaption><\/figure>\n L\u01b0u \u00fd:<\/strong><\/p>\n
Tuy nhi\u00ean vi\u1ec7c t\u00ednh theo tu\u1ea7n c\u00f3 m\u1ed9t v\u00e0i h\u1ea1n ch\u1ebf, n\u1ebfu s\u1ed1 ng\u00e0y kh\u00f4ng th\u1ec3 chia h\u1ebft cho 7 th\u00ec s\u1ebd d\u01b0 ra. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t kh\u00f4ng th\u1ec3 b\u1ecf qua \u0111\u1ed1i v\u1edbi c\u00e1c nh\u00e0 ngh\u1ec9, kh\u00e1ch s\u1ea1n, \u2026. C\u00f3 th\u1ebf g\u00e2y ra t\u1ed5n th\u1ea5t l\u1edbn v\u1ec1 m\u1eb7t doanh thu. \u0110\u1ec3 kh\u00e1c ph\u1ee5c \u0111i\u1ec1u n\u00e0y, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t d\u1ea1ng h\u00e0m kh\u00e1c \u0111\u1ec3 thay th\u1ebf l\u00e0 h\u00e0m MOD()<\/p>\n
C\u00f4ng th\u1ee9c: =MOD(ng\u00e0y \u0111i – ng\u00e0y \u0111\u1ebfn,7)<\/p>\n
– K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 ng\u00e0y l\u1ebb<\/p>\n
![\"Ham-int-trong-excel-8\"](\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-INT-trong-Excel-5-e1688562649346.png\")
<\/picture>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD()<\/figcaption><\/figure>\n 4.5 T\u00ednh s\u1ed1 ph\u1ea7n d\u01b0 trong excel<\/h2>\n
\u0110\u00f4i khi trong vi\u1ec7c x\u1eed l\u00fd v\u00e0 t\u00ednh to\u00e1n, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n bi\u1ebft s\u1ed1 d\u01b0 c\u1ee7a ph\u00e9p chia c\u1ee5 th\u1ec3 l\u00e0 bao nhi\u00eau. Nh\u1eefng d\u1eef li\u1ec7u n\u00e0y th\u01b0\u01a1ng \u0111\u01b0\u1ee3c l\u01b0u t\u00e2m trong nghi\u1ec7p v\u1ee5 t\u1ed3n kho, ph\u00e2n ph\u1ed1i s\u1ea3n ph\u1ea9m \u0111\u1ebfn c\u00e1c c\u01a1 s\u1edf, \u2026 \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a trong r\u1ea5t nhi\u1ec1u ng\u00e0nh v\u00e0 l\u0129nh v\u1ef1c kh\u00e1c nhau<\/p>\n
\u0110\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 n\u00e0y, c\u00e1c b\u1ea1n c\u1ea7n ph\u1ea3i c\u00f3 m\u1ed9t h\u1eb1ng \u0111\u1eb3ng th\u1ee9c ho\u00e0n to\u00e0n kh\u00e1c, c\u1ee5 th\u1ec3: Ph\u1ea7n d\u01b0 = A1 – B1*INT(A1\/B1)<\/p>\n
Trong \u0111\u00f3:<\/p>\n
- \n
- A1 l\u00e0 s\u1ed1 b\u1ecb chia<\/li>\n
- B1 l\u00e0 s\u1ed1 chia<\/li>\n<\/ul>\n
V\u00ed d\u1ee5:<\/p>\n
– A1 = 22, B1 = 5. S\u1ed1 d\u01b0 tr\u1ea3 v\u1ec1 l\u00e0 22 – 5*INT(22\/5) = 2<\/p>\n
– A1 = 5, B1 = 2. S\u1ed1 d\u01b0 tr\u1ea3 v\u1ec1 l\u00e0 5 – 2*INT(5\/2) = 1<\/p>\n
![\"Ham-int-trong-excel-9\"](\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-INT-trong-Excel-6-e1688562663184.png\")
<\/picture>T\u00ednh s\u1ed1 ph\u1ea7n d\u01b0 trong excel<\/figcaption><\/figure>\n 4.6 T\u00e1ch ng\u00e0y v\u00e0 gi\u1edd trong excel<\/h2>\n
Khi b\u1ea1n \u0111\u1ed1i m\u1eb7t v\u1edbi ki\u1ec3u d\u1eef li\u1ec7u ng\u00e0y v\u00e0 gi\u1edd c\u00f9ng l\u00fac nh\u01b0 sau 8\/12\/2001 12:24. R\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n c\u00e1ch th\u1ee9c t\u1ed1n nhi\u1ec1u c\u00f4ng s\u1ee9c v\u00e0 s\u1ee9c l\u1ef1c nh\u1ea5t \u0111\u00f3 l\u00e0 ng\u1ed3i copy and paste m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng ti\u1ebfp \u0111\u00f3 th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c tr\u1eeb. Tuy nhi\u00ean n\u1ebfu b\u1ea1n bi\u1ebft c\u00e1ch \u00e1p d\u1ee5ng h\u00e0m INT trong excel th\u00ec m\u1ecdi vi\u1ec7c tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u.<\/p>\n
\u0110\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 S\u1ed1 Ng\u00e0y, c\u00f4ng th\u1ee9c s\u1ebd l\u00e0 S\u1ed1 Ng\u00e0y = INT(d\u1ea1ng d\u1eef li\u1ec7u ng\u00e0y gi\u1edd)<\/p>\n
V\u00ed d\u1ee5:<\/p>\n
– \u1ed4 ch\u1ee9a gi\u00e1 tr\u1ecb l\u00e0 09\/12\/2023 09 : 12. K\u1ebft qu\u1ea3 l\u00e0 09\/12\/2023<\/p>\n
– \u1ed4 ch\u1ee9a gi\u00e1 tr\u1ecb l\u00e0 10\/06\/2023 06 : 12. K\u1ebft qu\u1ea3 l\u00e0 10\/06\/2023<\/p>\n
L\u01b0u \u00fd: \u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u tr\u1ea3 v\u1ec1 c\u1ee7a \u00f4 ch\u1ee9a h\u00e0m l\u00e0 Date<\/p>\n
![\"Ham-int-trong-excel-10\"](\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-INT-trong-Excel-7-e1688562678379.png\")
<\/picture>T\u00e1ch ng\u00e0y trong excel<\/figcaption><\/figure>\n C\u00f2n v\u1edbi k\u1ebft qu\u1ea3 \u0111\u1ea7u ra l\u00e0 Gi\u1edd, c\u00f4ng th\u1ee9c nh\u01b0 sau S\u1ed1 Gi\u1edd = d\u1ea1ng d\u1eef li\u1ec7u ng\u00e0y gi\u1edd – INT(d\u1ea1ng d\u1eef li\u1ec7u ng\u00e0y gi\u1edd)<\/p>\n
V\u00ed d\u1ee5:<\/p>\n
– \u1ed4 ch\u1ee9a gi\u00e1 tr\u1ecb l\u00e0 09\/12\/2023 09 : 12. K\u1ebft qu\u1ea3 l\u00e0 09 : 12<\/p>\n
– \u1ed4 ch\u1ee9a gi\u00e1 tr\u1ecb l\u00e0 10\/06\/2023 06 : 12. K\u1ebft qu\u1ea3 l\u00e0 06 : 12<\/p>\n
L\u01b0u \u00fd: \u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u tr\u1ea3 v\u1ec1 c\u1ee7a \u00f4 ch\u1ee9a h\u00e0m l\u00e0 Time<\/p>\n
![\"Ham-int-trong-excel-11\"](\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-INT-trong-Excel-8-e1688562697858.png\")
<\/picture>T\u00e1ch gi\u1edd trong excel<\/figcaption><\/figure>\n 4.7 C\u00e1ch t\u00ednh tu\u1ed5i b\u1eb1ng h\u00e0m INT trong Excel<\/h2>\n
\u0110\u1ec3 t\u00ednh tu\u1ed5i th\u1ef1c s\u1ef1 kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t c\u00f4ng vi\u1ec7c kh\u00f3, ng\u01b0\u1eddi d\u00f9ng khi ch\u1ec9 c\u1ea7n l\u1ea5y n\u0103m hi\u1ec7n t\u1ea1i tr\u1eeb \u0111i n\u0103m sinh. D\u00f9 v\u1eady khi ph\u1ea3i th\u1ef1c hi\u1ec7n m\u1ed9t file d\u1eef li\u1ec7u h\u00e0ng tr\u0103m d\u00f2ng th\u01b0\u1eddng c\u00f3 kh\u1ea3 n\u0103ng cao\u00a0 g\u00e2y ra sai s\u00f3t. N\u1ebfu b\u1ea1n l\u00e0m trong c\u01a1 quan v\u1ec1 th\u1ed1ng k\u1ebf hay c\u00e1c cu\u1ed9c kh\u1ea3o s\u00e1t th\u00ec vi\u1ec7c n\u00e0y c\u1ef1c k\u00ec quan tr\u1ecdng \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o ch\u00ednh x\u00e1c gi\u00fap \u0111\u01b0a ra c\u00e1c quy\u1ebft \u0111\u1ecbnh mang t\u00ednh quy\u1ebft \u0111\u1ecbnh.<\/p>\n
B\u00ean c\u1ea1nh \u0111\u00f3, c\u00e1c d\u1ea1ng bi\u1ec3u di\u1ec5n d\u1eef li\u1ec7u d\u1ea1ng th\u00f4 theo \u0111\u1ecbnh d\u1ea1ng ng\u00e0y\/th\u00e1ng\/n\u0103m th\u01b0\u1eddng r\u1ea5t kh\u00f3 \u0111\u1ec3 x\u1eed l\u00fd. Tuy nhi\u00ean m\u1ecdi vi\u1ec7c s\u1ebd \u0111\u01a1n gi\u1ea3n h\u01a1n khi b\u1ea1n bi\u1ebft c\u00e1ch \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c v\u1edbi h\u00e0m INT trong excel.<\/p>\n
C\u1ee5 th\u1ec3 c\u00f4ng th\u1ee9c nh\u01b0 sau: =INT(YEARFRAC(ng\u00e0y b\u1eaft \u0111\u1ea7u, ng\u00e0y k\u1ebft th\u00fac))<\/p>\n
V\u00ed d\u1ee5:<\/p>\n
– Ng\u00e0y b\u1eaft \u0111\u1ea7u l\u00e0 06\/16\/1982. K\u1ebft qu\u1ea3 INT(YEARFRAC(16\/06\/1982, TODAY())) = 41<\/p>\n
![\"Ham-int-trong-excel-12\"](\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-INT-trong-Excel-9.png\")
<\/picture>C\u00e1ch t\u00ednh tu\u1ed5i b\u1eb1ng h\u00e0m INT trong Excel<\/figcaption><\/figure>\n 5. C\u00e1c l\u1ed7i khi s\u1eed d\u1ee5ng h\u00e0m INT Excel<\/h2>\n
Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng h\u00e0m INT, c\u00e1c b\u1ea1n s\u1ebd g\u1eb7p ph\u1ea3i m\u1ed9t v\u00e0i l\u1ed7i nh\u01b0ng l\u1ea1i kh\u00f4ng bi\u1ebft ch\u00fang l\u00e0 g\u00ec v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c ra sao. Sau \u0111\u00e2y l\u00e0 3 l\u1ed7i sau:<\/p>\n
- \n
- #NAME? – L\u1ed7i n\u00e0y di\u1ec5n ra khi Excel kh\u00f4ng nh\u1eadn d\u1ea1ng \u0111\u01b0\u1ee3c ch\u1eef trong c\u00f4ng th\u1ee9c. B\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e3 nh\u1eadp sai v\u0103n b\u1ea3n trong c\u00fa ph\u00e1p c\u1ee7a h\u00e0m.<\/li>\n
- #VALUE! – N\u1ebfu nh\u1eadp sai ki\u1ec3u \u0111\u1ed1i s\u1ed1 trong c\u00fa ph\u00e1p c\u1ee7a h\u00e0m, b\u1ea1n s\u1ebd g\u1eb7p l\u1ed7i n\u00e0y trong Microsoft Excel.<\/li>\n
- \u00a0#REF! – Microsoft Excel s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i n\u00e0y n\u1ebfu c\u00f4ng th\u1ee9c tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 kh\u00f4ng h\u1ee3p l\u1ec7.<\/li>\n<\/ul>\n
![\"Ham-int-trong-excel-13\"](\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-INT-trong-Excel-10-e1688562720896.png\")
<\/picture>C\u00e1c l\u1ed7i khi s\u1eed d\u1ee5ng h\u00e0m INT Excel<\/figcaption><\/figure>\n 6. So s\u00e1nh h\u00e0m INT v\u00e0 h\u00e0m QUOTIENT<\/h2>\n
T\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m INT, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m QUOTIENT \u0111\u1ec3 l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a m\u1ed9t s\u1ed1 tuy nhi\u00ean hai h\u00e0m n\u00e0y c\u0169ng c\u00f3 \u0111i\u1ec3m kh\u00e1c bi\u1ec7t t\u01b0\u01a1ng \u0111\u1ed1i l\u1edbn. H\u00e0m QUOTIENT c\u00f3 c\u00f4ng d\u1ee5ng kh\u00e1 \u0111\u1eb7c bi\u1ec7t, ch\u00fang s\u1ebd ch\u1ec9 ch\u1ecdn ph\u1ea7n nguy\u00ean c\u1ee7a s\u1ed1 th\u1eadp ph\u00e2n d\u00f9 l\u00e0 s\u1ed1 d\u01b0\u01a1ng hay \u00e2m.<\/p>\n
C\u00f4ng th\u1ee9c c\u1ee5 th\u1ec3: = QUOTIENT(s\u1ed1 b\u1ecb chia; s\u1ed1 chia)<\/p>\n
\u0110\u1ec3 c\u00f3 th\u1ec3 hi\u1ec3u r\u00f5 \u0111\u01b0\u1ee3c s\u1ef1 kh\u00e1c bi\u1ec7t n\u00e0y, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i b\u1ea3ng so s\u00e1nh d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n
V\u1edbi k\u1ebft qu\u1ea3 l\u00e0 c\u00e1c ph\u00e9p chia v\u1edbi s\u1ed1 d\u01b0\u01a1ng, h\u00e0m INT() v\u00e0 QUOTIENT() l\u00e0 gi\u1ed1ng nhau, tuy nhi\u00ean v\u1edbi s\u1ed1 th\u1eadp ph\u00e2n \u00e2m th\u00ec k\u1ebft qu\u1ea3 cho th\u1ea5y QUOTIENT() c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n. L\u00fd gi\u1ea3i l\u00e0 v\u00ec h\u00e0m n\u00e0y ch\u1ec9 l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia c\u00f2n h\u00e0m INT() l\u1ea1i l\u1ea5y s\u1ed1 nguy\u00ean \u00e2m nh\u1ecf h\u01a1n.<\/p>\n
![\"Ham-int-trong-excel-14\"](\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/ham-INT-trong-Excel-11-e1688562733928.png\")
<\/picture>So s\u00e1nh h\u00e0m INT v\u00e0 h\u00e0m QUOTIENT<\/figcaption><\/figure>\n T\u00f3m l\u1ea1i, hi\u1ec3u r\u00f5 s\u1ef1 kh\u00e1c bi\u1ec7t c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng linh ho\u1ea1t v\u00e0 ch\u00ednh x\u00e1c hai h\u00e0m tr\u00ean trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c.<\/p>\n
7. M\u1ed9t v\u00e0i h\u00e0m kh\u00e1c li\u00ean quan\u00a0<\/strong><\/h2>\n
Sau \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i h\u00e0m Excel c\u0169ng c\u00f3 t\u00e1c d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m INT m\u00e0 b\u1ea1n n\u00ean bi\u1ebft \u0111\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng ch\u00fang m\u1ed9t c\u00e1ch linh ho\u1ea1t gi\u00fap t\u0103ng n\u0103ng su\u1ea5t v\u00e0 c\u00e1c ph\u01b0\u01a1ng \u00e1n trong vi\u1ec7c tr\u1ea3i khai v\u00e0 gi\u1ea3i quy\u1ebft v\u1edbi c\u00e1c s\u1ed1 li\u1ec7u.<\/p>\n
7.1 ROUND<\/strong><\/p>\n
H\u00e0m ROUND gi\u00fap l\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 \u0111\u1ebfn m\u1ed9t s\u1ed1 v\u1ecb tr\u00ed th\u1eadp ph\u00e2n \u0111\u00e3 ch\u1ec9 \u0111\u1ecbnh. H\u00e0m n\u00e0y c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n l\u00ean ho\u1eb7c xu\u1ed1ng, t\u00f9y thu\u1ed9c v\u00e0o gi\u00e1 tr\u1ecb c\u1ee7a ph\u1ea7n th\u1eadp ph\u00e2n.<\/p>\n
=ROUND(s\u1ed1, num_ch\u1eef s\u1ed1)<\/p>\n
7.2 ROUNDUP<\/strong><\/p>\n
H\u00e0m ROUNDUP l\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 l\u00ean \u0111\u1ebfn m\u1ed9t s\u1ed1 v\u1ecb tr\u00ed th\u1eadp ph\u00e2n \u0111\u00e3 ch\u1ec9 \u0111\u1ecbnh.<\/p>\n
=ROUNDUP(s\u1ed1, num_ch\u1eef s\u1ed1)<\/p>\n
7.3 ROUNDDOWN<\/strong><\/p>\n
H\u00e0m ROUNDDOWN l\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 xu\u1ed1ng m\u1ed9t s\u1ed1 v\u1ecb tr\u00ed th\u1eadp ph\u00e2n \u0111\u00e3 ch\u1ec9 \u0111\u1ecbnh.<\/p>\n
=ROUNDDOWN(s\u1ed1, num_ch\u1eef s\u1ed1)<\/p>\n
7.4 CEILING<\/strong><\/p>\n
H\u00e0m CEILING l\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 l\u00ean t\u1edbi b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u00e3 ch\u1ec9 \u0111\u1ecbnh.<\/p>\n
=CEILING(s\u1ed1, \u00fd ngh\u0129a)<\/p>\n
7.5 FLOOR<\/strong><\/p>\n
H\u00e0m FLOOR l\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 xu\u1ed1ng b\u1ed9i s\u1ed1 g\u1ea7n nh\u1ea5t c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u00e3 ch\u1ec9 \u0111\u1ecbnh.<\/p>\n
=FLOOR(s\u1ed1, \u00fd ngh\u0129a)<\/p>\n
T\u1ea1m k\u1ebft <\/strong><\/h2>\n
Nh\u01b0 v\u1eady b\u00e0i vi\u1ebft tr\u00ean ch\u00fang t\u00f4i \u0111\u00e3 cung c\u1ea5p t\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m INT trong excel bao g\u1ed3m nh\u1eefng l\u00fd gi\u1ea3i, c\u00f4ng th\u1ee9c, nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 7 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INT n\u00e2ng cao. B\u00ean c\u1ea1nh \u0111\u00f3, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 nh\u00ecn h\u00ecnh \u1ea3nh v\u00e0 c\u00f4ng th\u1ee9c t\u00ednh minh h\u1ecda trong b\u00e0i vi\u1ebft s\u1ebd gi\u00fap d\u1ec5 d\u00e0ng h\u00ecnh dung v\u00e0 v\u00e0 th\u00e0nh th\u1ea1o ch\u00fang m\u1ed9t c\u00e1ch nhanh ch\u00f3ng h\u01a1n.<\/p>\n
Hy v\u1ecdng b\u00e0i vi\u1ebft tr\u00ean \u0111em \u0111\u1ebfn nh\u1eefng tin t\u1ee9c h\u1eefu \u00edch gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c n\u0103ng su\u1ea5t v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n. Ngo\u00e0i ra, n\u1ebfu c\u00f2n b\u1ea5t c\u1ee9 th\u1eafc m\u1eafc n\u00e0o, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 li\u00ean h\u1ec7 Fanpage<\/a> <\/strong>ho\u1eb7c \u0111\u1ec3 l\u1ea1i th\u00f4ng tin \u1edf ph\u1ea7n b\u00ecnh lu\u1eadn \u0111\u1ec3 \u0111\u01b0\u1ee3c \u0111\u1ed9i ng\u0169 nh\u00e2n vi\u00ean Ho\u00e0ng H\u00e0 Mobile t\u01b0 v\u1ea5n v\u00e0 h\u1ed7 tr\u1ee3 th\u00eam<\/p>\n
![\"Ham-int-trong-excel-2\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-int-trong-excel-17.jpg.webp)
<\/picture>![\"Ham-int-trong-excel-3\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-int-trong-excel-18.png.webp)
<\/picture>![\"Ham-int-trong-excel-4\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-INT-trong-Excel-1-e1688562546204.png.webp)
<\/picture>![\"Ham-int-trong-excel-5\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-INT-trong-Excel-2-e1688562562599.png.webp)
<\/picture>![\"Ham-int-trong-excel-6\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-INT-trong-Excel-3-e1688562614354.png.webp)
<\/picture>![\"Ham-int-trong-excel-7\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-INT-trong-Excel-4-e1688562631510.png.webp)
<\/picture>![\"Ham-int-trong-excel-8\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-INT-trong-Excel-5-e1688562649346.png.webp)
<\/picture>![\"Ham-int-trong-excel-9\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-INT-trong-Excel-6-e1688562663184.png.webp)
<\/picture>![\"Ham-int-trong-excel-10\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-INT-trong-Excel-7-e1688562678379.png.webp)
<\/picture>![\"Ham-int-trong-excel-11\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-INT-trong-Excel-8-e1688562697858.png.webp)
<\/picture>![\"Ham-int-trong-excel-12\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-INT-trong-Excel-9.png.webp)
<\/picture>![\"Ham-int-trong-excel-13\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-INT-trong-Excel-10-e1688562720896.png.webp)
<\/picture>![\"Ham-int-trong-excel-14\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/ham-INT-trong-Excel-11-e1688562733928.png.webp)
<\/picture>