{"id":44296,"date":"2022-04-12T18:44:38","date_gmt":"2022-04-12T11:44:38","guid":{"rendered":"https:\/\/divineshop.vn\/tin-tuc\/?p=44296"},"modified":"2022-04-12T18:44:38","modified_gmt":"2022-04-12T11:44:38","slug":"meo-su-dung-dau-khac-trong-excel-cuc-don-gian-ma-ban-khong-nen-bo-qua","status":"publish","type":"post","link":"https:\/\/divineshop.vn\/tin-tuc\/meo-su-dung-dau-khac-trong-excel-cuc-don-gian-ma-ban-khong-nen-bo-qua\/","title":{"rendered":"M\u1eb9o s\u1eed d\u1ee5ng d\u1ea5u kh\u00e1c trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n kh\u00f4ng n\u00ean b\u1ecf qua"},"content":{"rendered":"
\n

Ch\u1eafc ch\u1eafn, \u0111\u1ed1i v\u1edbi d\u00e2n v\u0103n ph\u00f2ng, h\u1ecdc sinh\/sinh vi\u00ean,\u2026 Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu v\u00e0 n\u1ebfu b\u1ea1n th\u01b0\u1eddng xuy\u00ean ph\u1ea3i s\u1eed d\u1ee5ng c\u00e1c ph\u00e9p so s\u00e1nh s\u1ed1 li\u1ec7u, d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh th\u00ec h\u00e0m d\u1ea5u kh\u00e1c trong Excel s\u1ebd gi\u00fap b\u1ea1n t\u1ed1i \u01b0u \u0111\u01b0\u1ee3c c\u00f4ng vi\u1ec7c v\u00e0 ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u th\u1eddi gian.\u00a0<\/strong><\/p>\n

B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Divine Shop s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch vi\u1ebft k\u00fd hi\u1ec7u kh\u00e1c trong Excel v\u00e0 s\u1eed d\u1ee5ng \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u c\u1ef1c \u0111\u01a1n gi\u1ea3n.<\/p>\n

\"M\u1eb9o<\/strong><\/p>\n

\n

<\/span><\/span>D\u1ea5u kh\u00e1c ngh\u0129a l\u00e0 g\u00ec? K\u00fd hi\u1ec7u kh\u00e1c trong Excel \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 th\u1ebf n\u00e0o?<\/strong><\/span><\/span><\/h2>\n

Trong v\u0103n phong th\u00f4ng th\u01b0\u1eddng, ch\u00fang ta th\u01b0\u1eddng d\u00f9ng d\u1ea5u kh\u00e1c trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p so s\u00e1nh gi\u1eefa hai s\u1ef1 v\u1eadt, hi\u1ec7n t\u01b0\u1ee3ng v\u1ec1 nh\u1eefng n\u00e9t t\u01b0\u01a1ng \u0111\u1ed3ng v\u00e0 kh\u00f4ng t\u01b0\u01a1ng \u0111\u1ed3ng. Do \u0111\u00f3, \u0111\u1ed1i v\u1edbi nh\u1eefng d\u1eef li\u1ec7u, s\u1ed1 li\u1ec7u ch\u00fang ta c\u0169ng d\u00f9ng d\u1ea5u kh\u00e1c \u0111\u1ec3 th\u1ec3 hi\u1ec7n ch\u00fang kh\u00f4ng b\u1eb1ng nhau. V\u00e0 d\u1ea5u kh\u00e1c th\u01b0\u1eddng \u0111\u01b0\u1ee3c vi\u1ebft v\u00e0 k\u00fd hi\u1ec7u: <\/span>\u2260<\/span><\/p>\n

\u0110\u1ed1i v\u1edbi Excel, c\u00e1ch vi\u1ebft d\u1ea5u kh\u00e1c s\u1ebd c\u00f3 m\u1ed9t ch\u00fat kh\u00e1c bi\u1ec7t \u0111\u00f3 l\u00e0 khi b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh v\u1edbi d\u1ea5u kh\u00e1c th\u00ec ch\u00fang s\u1ebd \u0111\u01b0\u1ee3c k\u00fd hi\u1ec7u b\u1eb1ng d\u1ea5u b\u00e9 h\u01a1n v\u00e0 l\u1edbn h\u01a1n: <\/span>. <\/b>V\u00e0 khi b\u1ea1n s\u1eed d\u1ee5ng d\u1ea5u kh\u00e1c trong Excel th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 <\/span>TRUE\/FALSE<\/b>.\u00a0<\/span><\/p>\n

V\u00ed d\u1ee5: A2B2 -> A2 Kh\u00e1c B2<\/span><\/em><\/p>\n

\"D\u1ea5u<\/p>\n

<\/span><\/span>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng d\u1ea5u kh\u00e1c trong h\u00e0m Excel 2013, 2016<\/b><\/span><\/span><\/h2>\n

\u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh so s\u00e1nh trong Excel, tr\u01b0\u1edbc h\u1ebft b\u1ea1n c\u1ea7n m\u1ed9t d\u1eef li\u1ec7u b\u1ea3ng t\u00ednh c\u00f3 s\u1eb5n sau \u0111\u00f3 kh\u1edfi \u0111\u1ed9ng Excel \u0111\u1ec3 b\u1eaft \u0111\u1ea7u thao t\u00e1c:\u00a0<\/span><\/p>\n

B\u01b0\u1edbc 1:<\/b> \u0110\u1ec3 ch\u00e8n k\u00fd t\u1ef1 d\u1ea5u kh\u00e1c trong Excel v\u00e0o \u00f4 t\u00ednh. B\u1ea1n h\u00e3y ch\u1ecdn <\/span>Insert > Symbols. \"H\u01b0\u1edbng<\/b><\/p>\n

B\u01b0\u1edbc 2: <\/b>T\u1ea1i h\u1ed9p tho\u1ea1i Symbols, h\u00e3y ch\u1ecdn v\u00e0o k\u00fd t\u1ef1 <\/span>\u2260<\/strong>. <\/span>Sau \u0111\u00f3, ch\u1ecdn<\/span> Insert <\/b>\u0111\u1ec3 ch\u00e8n v\u00e0o \u00f4. \"H\u01b0\u1edbng<\/span><\/p>\n

B\u01b0\u1edbc 3: <\/b>Ti\u1ebfp \u0111\u1ebfn, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m d\u1ea5u kh\u00e1c trong Excel \u0111\u1ec3 so s\u00e1nh gi\u00e1 tr\u1ecb \u1edf c\u00e1c c\u1ed9t v\u1edbi nhau. V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y s\u1ebd th\u1ef1c hi\u1ec7n so s\u00e1nh gi\u00e1 tr\u1ecb \u1edf hai c\u1ed9t A\/B v\u00e0 tr\u1ea3 k\u1ebft qu\u1ea3 \u201cKh\u00e1c v\u00e0 Gi\u1ed1ng\u201d.\u00a0<\/span>T\u1ea1i \u00f4 E3, b\u1ea1n h\u00e3y d\u00f9ng h\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi d\u1ea5u kh\u00e1c \u0111\u1ec3 th\u1ef1c hi\u1ec7n so s\u00e1nh: =IF(A3B3;\u201dKh\u00e1c\u201d;\u201dGi\u1ed1ng\u201d) \"H\u01b0\u1edbng<\/strong><\/span><\/p>\n

B\u01b0\u1edbc 4: <\/b>Ngo\u00e0i ra, n\u1ebfu b\u1ea1n ch\u1ec9 c\u1ea7n tr\u1ea3 k\u1ebft qu\u1ea3 t\u1ef1 \u0111\u1ed9ng theo h\u00e0m TRUE, FALSE<\/strong> th\u00ec ch\u1ec9 c\u1ea7n nh\u1eadp v\u00e0o \u00f4: =A3B3. Sau \u0111\u00f3 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c c\u00e1c k\u1ebft qu\u1ea3 l\u1ea7n l\u01b0\u1ee3t \u0111\u00fang ho\u1eb7c sai. \"H\u01b0\u1edbng<\/span><\/p>\n

<\/span><\/span>T\u1ea1m k\u1ebft\u00a0<\/b><\/span><\/span><\/h2>\n

B\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y, Divine Shop \u0111\u00e3 gi\u1edbi thi\u1ec7u cho b\u1ea1n v\u1ec1 d\u1ea5u kh\u00e1c v\u00e0 c\u00e1ch k\u00fd hi\u1ec7u d\u1ea5u kh\u00e1c trong Excel c\u0169ng nh\u01b0 nh\u1eefng \u1ee9ng d\u1ee5ng v\u00e0o c\u00e1c h\u00e0m so s\u00e1nh, gi\u00fap b\u1ea1n t\u1ed1i \u01b0u c\u00f4ng vi\u1ec7c v\u00e0 ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c nhi\u1ec1u th\u1eddi gian. Hy v\u1ecdng \u0111\u00e2y l\u00e0 ngu\u1ed3n tham kh\u1ea3o \u0111\u00e1ng tin c\u1eady d\u00e0nh cho b\u1ea1n. Ch\u00fac c\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng!<\/span><\/p>\n

\u00a0<\/p>\n<\/div>\n<\/div>\n\n\n

\n\n\n\n\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
<\/div><\/div>\n\n\n\n
\n\n\n\n\n\n\n\n
\"\"<\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"

Ch\u1eafc ch\u1eafn, \u0111\u1ed1i v\u1edbi d\u00e2n v\u0103n ph\u00f2ng, h\u1ecdc sinh\/sinh vi\u00ean,\u2026 Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu v\u00e0 n\u1ebfu b\u1ea1n th\u01b0\u1eddng xuy\u00ean ph\u1ea3i s\u1eed d\u1ee5ng c\u00e1c ph\u00e9p so s\u00e1nh s\u1ed1 li\u1ec7u, d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh th\u00ec h\u00e0m d\u1ea5u kh\u00e1c trong Excel s\u1ebd gi\u00fap b\u1ea1n t\u1ed1i \u01b0u \u0111\u01b0\u1ee3c c\u00f4ng vi\u1ec7c v\u00e0 ti\u1ebft […]<\/p>\n","protected":false},"author":12,"featured_media":44297,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[148],"tags":[255],"yoast_head":"\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\t\n\t\n\t\n