{"id":273074,"date":"2023-10-17T20:20:48","date_gmt":"2023-10-17T13:20:48","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=273074"},"modified":"2023-10-17T20:20:48","modified_gmt":"2023-10-17T13:20:48","slug":"ham-or","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-or\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m OR trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft"},"content":{"rendered":"

Hi\u1ec7n nay, Microsoft Excel \u0111\u00e3 tr\u1edf th\u00e0nh m\u1ed9t c\u00f4ng c\u1ee5 ph\u1ed5 bi\u1ebfn trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 t\u00ednh to\u00e1n. \u0110\u1ec3 t\u1eadn d\u1ee5ng h\u1ebft kh\u1ea3 n\u0103ng c\u1ee7a Excel, vi\u1ec7c hi\u1ec3u r\u00f5 v\u1ec1 c\u00e1c h\u00e0m v\u00e0 c\u00f4ng c\u1ee5 c\u00f3 s\u1eb5n l\u00e0 v\u00f4 c\u00f9ng quan tr\u1ecdng. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd t\u1eadp trung v\u00e0o h\u00e0m logic r\u1ea5t h\u1eefu \u00edch, \u0111\u00f3 l\u00e0 <\/span>h\u00e0m OR<\/b>. H\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile t\u00ecm hi\u1ec3u v\u1ec1 c\u00f4ng th\u1ee9c h\u00e0m v\u00e0 c\u00e1ch \u00e1p d\u1ee5ng n\u00f3 v\u00e0o c\u00e1c t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf ngay trong b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n nh\u00e9.<\/span><\/p>\n

\u0110\u1ecbnh ngh\u0129a h\u00e0m OR trong Excel l\u00e0 g\u00ec?<\/b><\/h2>\n

\u0110\u00e2y l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 ki\u1ec3m tra m\u1ed9t lo\u1ea1t c\u00e1c \u0111i\u1ec1u ki\u1ec7n logic v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 TRUE n\u1ebfu \u00edt nh\u1ea5t m\u1ed9t trong c\u00e1c \u0111i\u1ec1u ki\u1ec7n n\u00e0y \u0111\u00fang. Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu \u0111i\u1ec1u ki\u1ec7n ban \u0111\u1ea7u l\u00e0 sai th\u00ec ng\u01b0\u1eddi d\u00f9ng s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 FALSE. V\u00e0 l\u01b0u \u00fd, h\u00e0m s\u1ebd kh\u00f4ng tr\u1ea3 hai k\u1ebft qu\u1ea3 \u0111\u1ed3ng th\u1eddi c\u00f9ng m\u1ed9t l\u00fac b\u1ea1n nh\u00e9.<\/span><\/p>\n

\"ham-or-1\"<\/picture><\/p>\n

B\u00ean c\u1ea1nh \u0111\u00f3, h\u00e0m n\u00e0y c\u00f2n gi\u00fap b\u1ea1n s\u00e1ng t\u1ea1o ra c\u00e1c c\u00f4ng th\u1ee9c to\u00e1n h\u1ecdc ph\u1ee9c t\u1ea1p d\u1ef1a tr\u00ean nhi\u1ec1u t\u00ecnh hu\u1ed1ng kh\u00e1c nhau. B\u1edfi v\u00ec \u0111\u1ed1i s\u1ed1 cung c\u1ea5p cho h\u00e0m c\u00f3 th\u1ec3 n\u1eb1m \u1edf nhi\u1ec1u d\u1ea1ng. C\u00e1c \u0111\u1ed1i s\u1ed1 \u0111\u00f3 bao g\u1ed3m ch\u1eef, s\u1ed1, tham chi\u1ebfu \u00f4, c\u00f4ng th\u1ee9c v\u00e0 th\u1eadm ch\u00ed l\u00e0 ki\u1ec3u d\u1eef li\u1ec7u boolean. Nh\u01b0 v\u1eady, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng h\u00e0m \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 d\u1eef li\u1ec7u c\u00f3 \u0111\u00e1p \u1ee9ng \u0111\u1ee7 nguy\u00ean t\u1eafc hay kh\u00f4ng. Ho\u1eb7c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 so s\u00e1nh gi\u1eefa c\u00e1c chu\u1ed7i data.<\/span><\/p>\n

Ch\u00ednh v\u00ec c\u00e1c \u0111i\u1ec1u tr\u00ean \u0111\u00e3 l\u00e0m cho h\u00e0m logic OR tr\u1edf th\u00e0nh m\u1ed9t c\u00f4ng c\u1ee5 quan tr\u1ecdng cho c\u00e1c nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng chuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u l\u1edbn, v\u00ed d\u1ee5 nh\u01b0 k\u1ebf to\u00e1n. Ho\u1eb7c b\u1ea5t k\u1ef3 ai c\u1ea7n ph\u1ea3i th\u1ef1c hi\u1ec7n ki\u1ec3m tra ti\u00eau chu\u1ea9n \u0111\u00e1nh gi\u00e1 v\u00e0 ra quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean d\u1eef li\u1ec7u trong Excel th\u00ec c\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng h\u00e0m n\u00e0y. \u0110\u1ed3ng th\u1eddi, v\u1edbi s\u1ef1 hi\u1ec3u bi\u1ebft v\u1ec1 h\u00e0m logic OR, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng m\u00ecnh \u0111ang t\u1eadn d\u1ee5ng h\u1ebft ti\u1ec1m n\u0103ng c\u1ee7a ph\u1ea7n m\u1ec1m \u0111\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u1ed1t nh\u1ea5t.<\/span><\/p>\n

L\u1ee3i \u00edch c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m OR m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft<\/b><\/h2>\n

Nh\u01b0 \u1edf ph\u1ea7n kh\u00e1i ni\u1ec7m, ch\u00fang ta \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c m\u1ee5c \u0111\u00edch c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m logic (OR) l\u00e0 nh\u01b0 th\u1ebf n\u00e0o. Ti\u1ebfp theo \u0111\u00e2y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd gi\u00fap b\u1ea1n bi\u1ebft th\u00eam c\u00e1c l\u00fd do t\u1ea1i sao b\u1ea1n n\u00ean s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u. \u0110\u1eebng b\u1ecf qua ph\u1ea7n n\u1ed9i dung h\u1eefu \u00edch n\u00e0y b\u1ea1n \u0111\u1ecdc nh\u00e9.<\/span><\/p>\n

Gi\u00fap x\u1eed l\u00fd d\u1eef li\u1ec7u linh ho\u1ea1t<\/b><\/h3>\n

T\u1ea5t nhi\u00ean, h\u00e0m logic OR s\u1ebd mang t\u00ednh linh ho\u1ea1t cao v\u00ec n\u00f3 cho ph\u00e9p b\u1ea1n ki\u1ec3m tra nhi\u1ec1u y\u00eau c\u1ea7u c\u00f9ng m\u1ed9t l\u00fac v\u00e0 t\u1ed5ng h\u1ee3p k\u1ebft qu\u1ea3 theo c\u00e1ch m\u00e0 b\u1ea1n thi\u1ebft l\u1eadp. Nh\u1edd \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c c\u00e1c d\u1eef li\u1ec7u theo ti\u00eau ch\u00ed \u0111\u00fang ho\u1eb7c sai m\u1ed9t c\u00e1ch chu\u1ea9n nh\u1ea5t. \u0110\u1eb7c bi\u1ec7t, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh k\u1ebft qu\u1ea3 \u0111\u1ea7u ra theo nhu c\u1ea7u c\u1ee7a m\u00ecnh. V\u00ed d\u1ee5, thay v\u00ec TRUE ho\u1eb7c FALSE, b\u1ea1n c\u00f3 th\u1ec3 y\u00eau c\u1ea7u n\u00f3 tr\u1ea3 v\u1ec1 m\u1ed9t v\u0103n b\u1ea3n c\u1ee5 th\u1ec3 ho\u1eb7c s\u1ed1 li\u1ec7u n\u00e0o \u0111\u00f3. T\u1eeb \u0111\u00e2y t\u1ea1o \u0111i\u1ec1u ki\u1ec7n cho ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0\u1ee3c ch\u1ec9nh s\u1eeda c\u00e1c d\u1eef li\u1ec7u tr\u1edf n\u00ean d\u1ec5 \u0111\u1ecdc v\u00e0 ph\u00e2n t\u00edch.<\/span><\/p>\n

\"ham-or-2\"<\/picture><\/p>\n

B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m OR v\u1edbi nhi\u1ec1u h\u00e0m kh\u00e1c trong Excel nh\u01b0 IF, AND hay NOT. \u0110\u1ec3 t\u1eeb \u0111\u00e2y gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u1ea1o d\u1ef1ng c\u00e1c \u0111\u1ecbnh th\u1ee9c logic mang t\u00ednh khoa h\u1ecdc h\u01a1n. C\u0169ng nh\u01b0 b\u1ea1n s\u1ebd t\u1ea1o \u0111\u01b0\u1ee3c c\u00e1c ti\u00eau ch\u00ed \u0111a d\u1ea1ng v\u00e0 n\u00e2ng cao \u0111\u1ec3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u. Kh\u00f4ng nh\u1eefng th\u1ebf, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 linh ho\u1ea1t s\u1eed d\u1ee5ng h\u00e0m trong nhi\u1ec1u ng\u1eef c\u1ea3nh kh\u00e1c nhau. T\u1eeb ki\u1ec3m tra t\u00ednh h\u1ee3p l\u1ec7 c\u1ee7a d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o \u0111\u1ebfn ki\u1ebfn t\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c ph\u00e2n t\u00edch d\u1eef li\u1ec7u trong c\u00e1c b\u1ea3ng t\u00ednh. Do \u0111\u00f3, n\u00f3 th\u00edch h\u1ee3p cho r\u1ea5t nhi\u1ec1u c\u00f4ng vi\u1ec7c m\u00e0 c\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ebfn Excel.<\/span><\/p>\n

T\u1ed1i \u01b0u h\u00f3a quy tr\u00ecnh l\u00e0m vi\u1ec7c<\/b><\/h3>\n

Nh\u00ecn v\u00e0o t\u00ednh linh ho\u1ea1t c\u1ee7a h\u00e0m logic OR, ch\u00fang ta c\u0169ng \u0111\u00e3 th\u1ea5y n\u00f3 r\u1ea5t h\u1eefu \u00edch trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c. Kh\u00f4ng nh\u1eefng th\u1ebf, h\u00e0m n\u00e0y c\u00f2n cho ph\u00e9p b\u1ea1n tinh ch\u1ec9nh l\u1ea1i c\u00e1c bi\u1ec3u th\u1ee9c n\u00e2ng cao tr\u1edf n\u00ean d\u1ec5 d\u00e0ng v\u00e0 ng\u1eafn g\u1ecdn h\u01a1n. Thay v\u00ec ph\u1ea3i vi\u1ebft nhi\u1ec1u c\u00f4ng th\u1ee9c IF ho\u1eb7c AND ri\u00eang l\u1ebb, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <\/span>h\u00e0m OR<\/b> \u0111\u1ec3 k\u1ebft h\u1ee3p t\u1ea5t c\u1ea3 ch\u00fang l\u1ea1i m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/span><\/p>\n

\"ham-or-3\"<\/picture><\/p>\n

Nh\u1ea5t l\u00e0 \u0111\u1ed1i v\u1edbi c\u00e1c b\u1ea3ng t\u00ednh l\u1edbn, vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh OR gi\u00fap gi\u1ea3m thi\u1ec3u s\u1ef1 r\u1eafc r\u1ed1i v\u00e0 m\u1ee9c \u0111\u1ed9 nh\u1ea7m l\u1eabn. T\u1ea1i \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 ph\u00e2n lo\u1ea1i v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc ki\u1ec3m tra trong nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau. \u0110\u1ed3ng th\u1eddi, b\u1ea1n s\u1ebd \u0111\u1ea3m b\u1ea3o \u0111\u01b0\u1ee3c r\u1eb1ng quy\u1ebft \u0111\u1ecbnh c\u1ee7a m\u00ecnh d\u1ef1a tr\u00ean c\u00e1c ti\u00eau ch\u00ed \u0111\u00f3 l\u00e0 \u0111\u00e1ng tin c\u1eady v\u00e0 \u00edt c\u00f3 kh\u1ea3 n\u0103ng sai s\u00f3t.<\/span><\/p>\n

Nh\u00ecn chung, thay v\u00ec s\u1eed d\u1ee5ng c\u00e1c th\u1ee7 thu\u1eadt Excel th\u1ee7 c\u00f4ng. B\u1ea1n c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng h\u00e0m \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a t\u1ea5t c\u1ea3 thao t\u00e1c, c\u0169ng nh\u01b0 gi\u00fap c\u00f4ng vi\u1ec7c \u0111\u01b0\u1ee3c gi\u1ea3i quy\u1ebft tr\u01a1n tru h\u01a1n. Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u1ecdc s\u1ebd ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c c\u1ee7a m\u00ecnh.<\/span><\/p>\n

T\u1ea1o d\u1eef li\u1ec7u chuy\u00ean nghi\u1ec7p<\/b><\/h3>\n

Tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng d\u1eef li\u1ec7u trong c\u00e1c b\u00e1o c\u00e1o ho\u1eb7c bi\u1ec3u \u0111\u1ed3, vi\u1ec7c ki\u1ec3m tra t\u00ednh h\u1ee3p l\u1ec7 c\u1ee7a d\u1eef li\u1ec7u l\u00e0 quan tr\u1ecdng. Theo \u0111\u00f3, h\u00e0m OR c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1ecdc v\u00e0 ch\u1ecdn ra t\u1eadp d\u1eef li\u1ec7u d\u1ef1a tr\u00ean m\u1ed9t ti\u00eau ch\u00ed c\u1ee5 th\u1ec3 n\u00e0o \u0111\u00f3. Nh\u01b0 v\u1eady, b\u1ea1n s\u1ebd c\u00f3 c\u01a1 h\u1ed9i t\u1ea1o ra c\u00e1c b\u00e1o c\u00e1o d\u1ef1a tr\u00ean d\u1eef li\u1ec7u c\u1ea7n thi\u1ebft v\u00e0 lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u kh\u00f4ng c\u1ea7n thi\u1ebft.<\/span><\/p>\n

\"ham-or-4\"<\/picture><\/p>\n

\u0110\u1eb7c bi\u1ec7t \u1edf m\u00f4i tr\u01b0\u1eddng doanh nghi\u1ec7p, h\u00e0m logic trong Excel c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00e2y d\u1ef1ng m\u1ed9t v\u00e0i ti\u00eau chu\u1ea9n. B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o c\u00e1c quy t\u1eafc t\u1ed5ng h\u1ee3p cho c\u00e1c d\u1eef li\u1ec7u, d\u1ef1a tr\u00ean nhi\u1ec1u m\u1ee5c \u0111\u00edch kinh doanh. C\u00f3 nh\u01b0 th\u1ebf, m\u1ecdi ng\u01b0\u1eddi m\u1edbi c\u00f3 th\u1ec3 t\u1ea1o ra c\u00e1c b\u1ea3ng b\u00e1o c\u00e1o chuy\u00ean nghi\u1ec7p, c\u0169ng nh\u01b0 \u0111\u01b0\u1ee3c ng\u01b0\u1eddi \u0111\u1ecdc \u0111\u00e1nh gi\u00e1 cao.<\/span><\/p>\n

H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m OR trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft<\/b><\/h2>\n

Ngay sau khi ch\u00fang ta hi\u1ec3u v\u1ec1 l\u1ee3i \u00edch, Ho\u00e0ng H\u00e0 Mobile s\u1ebd gi\u00fap b\u1ea1n th\u1ef1c h\u00e0nh \u00e1p d\u1ee5ng h\u00e0m logic (OR) nh\u00e9. \u1ede h\u01b0\u1edbng d\u1eabn n\u00e0y, ch\u00fang t\u00f4i c\u00f3 b\u1ed5 sung th\u00eam t\u00ecnh hu\u1ed1ng c\u1ee5 th\u1ec3 \u0111\u1ec3 b\u1ea1n d\u1ec5 d\u00e0ng h\u00ecnh dung h\u01a1n v\u1ec1 c\u00f4ng th\u1ee9c h\u00e0m. V\u00e0 \u0111\u1eb7c bi\u1ec7t, ch\u00fang t\u00f4i c\u00f2n c\u00f3 h\u00ecnh \u1ea3nh minh h\u1ecda \u1edf t\u1eebng b\u01b0\u1edbc n\u1eefa \u0111\u1ea5y nh\u00e9.<\/span><\/p>\n

C\u00f4ng th\u1ee9c h\u00e0m<\/b><\/h3>\n

\u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c c\u00e1c ph\u00e9p t\u00ednh logic trong Excel, ch\u00fang ta c\u00f3 ch\u00fa ph\u00e1p h\u00e0m “<\/span>=OR(logical1, [logical2],…)<\/b>“<\/span><\/p>\n

Trong \u0111\u00f3, logical 1 ch\u00ednh l\u00e0 \u0111i\u1ec1u ki\u1ec7n th\u1ee9 nh\u1ea5t m\u00e0 h\u00e0m Excel s\u1ebd ki\u1ec3m tra v\u00e0 y\u1ebfu t\u1ed1 b\u1eaft bu\u1ed9c. T\u01b0\u01a1ng \u1ee9ng, logical 2 s\u1ebd l\u00e0 \u0111i\u1ec1u ki\u1ec7n th\u1ee9 hai v\u00e0 n\u00f3 c\u00f3 th\u1ec3 thay \u0111\u1ed5i \u0111\u01b0\u1ee3c theo m\u1ee5c ti\u00eau c\u1ee7a ng\u01b0\u1eddi d\u00f9ng. N\u1ebfu b\u1ea1n mu\u1ed1n c\u00f4ng th\u1ee9c h\u00e0m c\u00f3 th\u00eam nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c th\u00ec c\u00f3 th\u1ec3 b\u1ed5 sung v\u00e0o logical 3, logical 4 hay t\u00f9y bi\u1ebfn nh\u00e9.<\/span><\/p>\n

\"ham-or-5\"<\/picture><\/p>\n

B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u1ea7n l\u01b0u \u00fd th\u00eam l\u00e0 m\u1ed7i \u0111i\u1ec1u ki\u1ec7n ph\u1ea3i tu\u00e2n th\u1ee7 \u0111\u01b0\u1ee3c quy lu\u1eadt v\u1ec1 to\u00e1n t\u1eed logic hay c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 ph\u00e9p to\u00e1n so s\u00e1nh. C\u1ee5 th\u1ec3, \u1edf m\u1ed7i \u0111i\u1ec1u ki\u1ec7n b\u1ea1n ph\u1ea3i b\u1ed5 sung th\u00eam c\u00e1c ph\u00e9p to\u00e1n nh\u01b0 = (b\u1eb1ng), < (nh\u1ecf h\u01a1n), > (l\u1edbn h\u01a1n), <= (nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng), => ( l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng), <> (kh\u00e1c).<\/span><\/p>\n

H\u01b0\u1edbng d\u1eabn c\u00e1ch \u00e1p d\u1ee5ng h\u00e0m \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1<\/b><\/h3>\n

\u0110\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin, Ho\u00e0ng H\u00e0 Mobile \u0111\u00e3 x\u00e2y d\u1ef1ng cho b\u1ea1n m\u1ed9t v\u00ed d\u1ee5 minh h\u1ecda v\u1edbi \u0111i\u1ec1u ki\u1ec7n l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1. Tuy nhi\u00ean tr\u01b0\u1edbc khi b\u1eaft \u0111\u1ea7u \u00e1p d\u1ee5ng th\u00ec b\u1ea1n h\u00e3y xem k\u1ef9 t\u00ecnh hu\u1ed1ng c\u1ee7a ch\u00fang t\u00f4i. \u0110\u1ec3 t\u1eeb \u0111\u00f3 x\u00e2y d\u1ef1ng \u0111i\u1ec1u ki\u1ec7n ri\u00eang cho b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh nh\u00e9.<\/span><\/p>\n

V\u00ed d\u1ee5: Nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 ph\u1ea3i ki\u1ec3m tra \u0111\u01b0\u1ee3c b\u1ea3ng d\u1eef li\u1ec7u l\u00e0m sao \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c \u0111i\u1ec1u ki\u1ec7n \u201cTRUE\u201d l\u00e0 s\u1ed1 ph\u1ea3i nh\u1ecf h\u01a1n 20 ho\u1eb7c l\u1edbn h\u01a1n 8. V\u00e0 \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c \u0111\u00e1p \u00e1n ch\u00ednh x\u00e1c, ch\u00fang ta c\u1ea7n ph\u1ea3i th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c nh\u01b0 b\u00ean d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n

\"ham-or-6\"<\/picture><\/p>\n

\u0110\u1ea7u ti\u00ean, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n nh\u1ea5p ch\u1ecdn v\u00e0o \u00f4 F5 ho\u1eb7c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1. Sau \u0111\u00f3, b\u1ea1n \u0111\u1ecdc s\u1ebd ti\u1ebfn h\u00e0nh nh\u1eadp c\u00fa ph\u00e1p h\u00e0m \u201c=OR(E5<20,E5>8)\u201d.\u00a0<\/span><\/p>\n

Cu\u1ed1i c\u00f9ng l\u00e0 b\u1ea1n s\u1ebd nh\u1ea5n OK \u0111\u1ec3 h\u00e0m th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n v\u00e0 ghi nh\u1eadn \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb TRUE. Ch\u1eafc h\u1eb3n \u1edf \u0111\u00e2y s\u1ebd c\u00f3 nhi\u1ec1u b\u1ea1n th\u1eafc m\u1eafc t\u1ea1i sao s\u1ed1 50 l\u1ea1i tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 TRUE. B\u1edfi v\u00ec h\u00e0m \u0111\u00e3 th\u1ecfa theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n m\u00e0 ch\u00fang ta \u0111\u00e3 \u0111\u1eb7t ra t\u1eeb ban \u0111\u1ea7u, \u0111\u00f3 l\u00e0 E5>8 b\u1ea1n nh\u00e9.<\/span><\/p>\n

H\u01b0\u1edbng d\u1eabn c\u00e1ch \u00e1p d\u1ee5ng h\u00e0m \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n l\u00e0 gi\u00e1 tr\u1ecb ch\u1eef<\/b><\/h3>\n

Nh\u01b0 c\u00e1c th\u00f4ng tin ch\u00fang t\u00f4i c\u00f3 chia s\u1ebb, \u0111i\u1ec1u ki\u1ec7n c\u1ee7a <\/span>h\u00e0m OR<\/b> r\u1ea5t \u0111a d\u1ea1ng. B\u1ea1n kh\u00f4ng ch\u1ec9 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c s\u1ed1, m\u00e0 ngay sau \u0111\u00e2y ch\u00fang t\u00f4i s\u1ebd c\u00f2n h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch thi\u1ebft l\u1eadp nguy\u00ean t\u1eafc h\u00e0m d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n. V\u00e0 \u0111\u01b0\u01a1ng nhi\u00ean, ch\u00fang ta c\u0169ng s\u1ebd c\u00f9ng nhau gi\u1ea3i quy\u1ebft b\u00e0i to\u00e1n n\u00e2ng cao h\u01a1n ngay sau \u0111\u00e2y nh\u00e9.<\/span><\/p>\n

V\u00ed d\u1ee5: Ng\u01b0\u1eddi d\u00f9ng c\u1ea7n ph\u1ea3i ki\u1ec3m tra m\u1ed9t l\u00fac 2 \u0111i\u1ec1u ki\u1ec7n, v\u1edbi \u0111i\u1ec1u ki\u1ec7n 1 l\u00e0 s\u1ed1 ph\u1ea3i l\u1edbn h\u01a1n 70. V\u00e0 \u0111i\u1ec1u ki\u1ec7n 2 l\u00e0 ch\u1eef ph\u1ea3i l\u00e0 Ho\u00e0ng H\u00e0 Mobile. \u0110\u1ec3 gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c b\u00e0i to\u00e1n n\u00e2ng cao c\u00f3 c\u1ea3 s\u1ed1 v\u00e0 ch\u1eef nh\u01b0 th\u1ebf n\u00e0y. B\u1ea1n \u0111\u1ecdc c\u0169ng kh\u00f4ng c\u1ea7n ph\u1ea3i qu\u00e1 lo l\u1eafng v\u00ec ch\u00fang ta \u0111\u00e3 c\u00f3 c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n r\u1ed3i. Do v\u1eady, b\u1ea1n ch\u1ec9 c\u1ea7n \u00e1p d\u1ee5ng theo c\u00f4ng th\u1ee9c l\u00e0 \u0111\u01b0\u1ee3c.<\/span><\/p>\n

\"ham-or-7\"<\/picture><\/p>\n

T\u1ea1i \u00f4 F5 ho\u1eb7c b\u1ea5t k\u1ef3 \u00f4 n\u00e0o b\u1ea1n mu\u1ed1n nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 th\u00ec h\u00e3y \u0111i\u1ec1n v\u00e0o c\u00fa ph\u00e1p nh\u01b0 sau: =OR(E5>70,E6=”Ho\u00e0ng H\u00e0 Mobile”). \u0110\u1ec3 k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb, b\u1ea1n c\u1ea7n nh\u1ea5n th\u00eam n\u00fat Enter l\u00e0 ho\u00e0n t\u1ea5t r\u1ed3i nh\u00e9.<\/span><\/p>\n

\u1ede \u0111\u00e2y, ch\u00fang ta ghi nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng l\u00e0 FALSE, b\u1edfi v\u00ec gi\u00e1 tr\u1ecb 50 kh\u00f4ng tu\u00e2n th\u1ee7 theo \u0111i\u1ec1u ki\u1ec7n n\u00e0o c\u1ea3. Trong khi \u0111\u00f3, \u00f4 F6 l\u1ea1i ghi nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 TRUE. B\u1edfi v\u00ec, b\u1ea3ng t\u00ednh \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c ti\u00eau ch\u00ed v\u1ec1 \u0111i\u1ec1u ki\u1ec7n th\u1ee9 2 l\u00e0 gi\u00e1 tr\u1ecb b\u1eb1ng \u201cHo\u00e0ng H\u00e0 Mobile\u201d.<\/span><\/p>\n

H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m OR k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF r\u1ea5t \u0111\u01a1n gi\u1ea3n<\/b><\/h2>\n

Nh\u1eb1m gi\u00fap cho b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 gi\u1ea3i \u0111\u01b0\u1ee3c nhi\u1ec1u b\u00e0i to\u00e1n chuy\u00ean nghi\u1ec7p v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n l\u1ed3ng gh\u00e9p v\u00e0o nhau. T\u1ea1i th\u1ee7 thu\u1eadt Excel n\u00e0y, ch\u00fang t\u00f4i s\u1ebd chia s\u1ebb \u0111\u1ebfn b\u1ea1n c\u00e1ch k\u1ebft h\u1ee3p hai h\u00e0m IF v\u00e0 OR. \u0110\u1ea3m b\u1ea3o qua ph\u1ea7n n\u1ed9i dung n\u00e0y, b\u1ea1n s\u1ebd th\u1ea5y \u0111\u01b0\u1ee3c \u0111i\u1ec1u tuy\u1ec7t v\u1eddi nh\u1ea5t khi v\u1eadn d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m v\u00e0o b\u00e0i to\u00e1n c\u1ee7a m\u00ecnh \u0111\u1ea5y nh\u00e9.<\/span><\/p>\n

C\u00f4ng th\u1ee9c h\u00e0m<\/b><\/h3>\n

\u0110\u1ec3 th\u1ef1c hi\u1ec7n ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n v\u00e0 th\u1ef1c hi\u1ec7n h\u00e0nh \u0111\u1ed9ng d\u1ef1a tr\u00ean k\u1ebft qu\u1ea3 c\u1ee7a ki\u1ec3m tra. Ch\u00fang ta c\u00f3 c\u00fa ph\u00e1p h\u00e0m IF l\u1ed3ng h\u00e0m logic OR nh\u01b0 sau: \u201c<\/span>=IF(Logical_test, [value_if_true], [value_if_false])<\/b>\u201d<\/span><\/p>\n

\"ham-or-8\"<\/picture><\/p>\n

Trong \u0111\u00f3, h\u00e0m n\u1ebfu nh\u01b0 IF s\u1ebd ki\u1ec3m tra th\u00f4ng tin t\u1ea1i danh m\u1ee5c Logical_test v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 TRUE n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang. Ng\u01b0\u1ee3c l\u1ea1i, h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 FALSE n\u1ebfu gi\u00e1 tr\u1ecb ban \u0111\u1ea7u nh\u1eadp v\u00e0o l\u00e0 sai.\u00a0<\/span><\/p>\n

H\u01b0\u1edbng d\u1eabn c\u00e1ch \u00e1p d\u1ee5ng hai h\u00e0m IF v\u00e0 OR<\/b><\/h3>\n

H\u00e3y t\u01b0\u1edfng t\u01b0\u1ee3ng r\u1eb1ng, ng\u01b0\u1eddi d\u00f9ng \u0111ang c\u1ea7n ph\u1ea3i \u0111\u00e1nh gi\u00e1 n\u0103ng l\u1ef1c nh\u00e2n vi\u00ean d\u1ef1a tr\u00ean doanh s\u1ed1 b\u00e1n ra b\u1eb1ng \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea1t ho\u1eb7c kh\u00f4ng \u0111\u1ea1t. Nh\u01b0 h\u00ecnh \u1ea3nh m\u00f4 t\u1ea3 b\u00ean d\u01b0\u1edbi \u0111\u00e2y, ch\u00fang ta s\u1ebd c\u00f3 \u0111\u1ebfn 2 m\u1eb7t h\u00e0ng l\u00e0 A v\u00e0 B.\u00a0<\/span><\/p>\n

\"ham-or-9\"<\/picture><\/p>\n

\u0110\u1ec3 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c h\u00e0m l\u1ed3ng h\u00e0m, IF l\u1ed3ng OR th\u00ec t\u1ea1i \u00f4 \u0111\u00e1nh gi\u00e1 E3, b\u1ea1n c\u1ea7n nh\u1eadp v\u00e0o c\u00fa ph\u00e1p \u201c=IF(OR(C3>=100,D3>=90),”\u0110\u1ea1t”,”Kh\u00f4ng \u0111\u1ea1t”)\u201d. V\u00e0 nh\u01b0 h\u00ecnh sau \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3 m\u00e0 ch\u00fang ta ghi nh\u1eadn \u0111\u01b0\u1ee3c sau khi \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c.<\/span><\/p>\n

\"ham-or-10\"<\/picture><\/p>\n

K\u1ebft lu\u1eadn<\/b><\/h2>\n

T\u00f3m l\u1ea1i, v\u1edbi nh\u1eefng th\u00f4ng tin tr\u00ean ch\u00fang ta \u0111\u00e3 hi\u1ec3u \u0111\u01b0\u1ee3c t\u1ea7m quan tr\u1ecdng c\u1ee7a vi\u1ec7c t\u1eadn d\u1ee5ng h\u00e0m trong Excel. \u0110\u1ed3ng th\u1eddi, b\u1ea1n \u0111\u1ecdc c\u0169ng \u0111\u00e3 bi\u1ebft c\u00e1ch \u00e1p d\u1ee5ng h\u00e0m OR<\/strong> v\u1edbi nhi\u1ec1u t\u00ecnh hu\u1ed1ng kh\u00e1c nhau, c\u00f3 c\u1ea3 vi\u1ec7c k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m IF. \u0110\u1ebfn \u0111\u00e2y, Ho\u00e0ng H\u00e0 Mobile hy v\u1ecdng b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c th\u00e0nh c\u00f4ng nh\u00e9!<\/span><\/p>\n

Xem th\u00eam:<\/b><\/p>\n