{"id":382,"date":"2020-07-15T13:17:50","date_gmt":"2020-07-15T06:17:50","guid":{"rendered":"https:\/\/hoctin.vn\/?p=382"},"modified":"2020-09-04T14:44:02","modified_gmt":"2020-09-04T07:44:02","slug":"ham-if-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/ham-if-trong-excel\/","title":{"rendered":"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m IF Trong Excel V\u00e0 V\u00ed D\u1ee5 C\u1ee5 Th\u1ec3"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"382\" class=\"elementor elementor-382\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c6acb66 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c6acb66\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a67f04e\" data-id=\"a67f04e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2958709 elementor-widget elementor-widget-text-editor\" data-id=\"2958709\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m IF l\u00e0 m\u1ed9t trong <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">10 h\u00e0m Excel \u0111\u01b0\u1ee3c d\u00f9ng nhi\u1ec1u nh\u1ea5t. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd chia s\u1ebb v\u1edbi b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 th\u1ef1c hi\u1ec7n so s\u00e1nh l\u00f4-gic v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 b\u1ea1n mong mu\u1ed1n.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">H\u00e0m IF trong Excel gi\u00fap b\u1ea1n ki\u1ec3m tra xem m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u00f3 \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng hay kh\u00f4ng. N\u1ebfu c\u00f3, bi\u1ec3u th\u1ee9c logic l\u00e0 TRUE, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb \/ tham chi\u1ebfu \u0111\u00e3 ch\u1ec9 \u0111\u1ecbnh v\u00e0 n\u1ebfu kh\u00f4ng (FALSE) th\u00ec n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb \/ tham chi\u1ebfu \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh kh\u00e1c.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-58bd4dc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"58bd4dc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6eb9353\" data-id=\"6eb9353\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1500944 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"1500944\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;&quot;,&quot;library&quot;:&quot;&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h4 class=\"elementor-toc__header-title\">M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-loading eicon-animation-spin\" aria-hidden=\"true\"><\/i>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-273be93 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"273be93\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bddb57e\" data-id=\"bddb57e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-67de23f elementor-widget elementor-widget-heading\" data-id=\"67de23f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-9f465b01-7fff-ea54-2a01-cf20c7e14a46\"><h1 dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:20pt;margin-bottom:6pt;\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1, C\u00fa Ph\u00e1p H\u00e0m IF Trong Excel<\/span><\/h1><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c644643 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c644643\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-13acf96\" data-id=\"13acf96\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a9d290f elementor-widget elementor-widget-text-editor\" data-id=\"a9d290f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e2u l\u1ec7nh h\u00e0m IF trong Excel:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-style: italic; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"><b>=IF(logical_test, [value_if_true], [value_if_false])<\/b><\/span><\/p><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">Trong \u0111\u00f3:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-133dd2d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"133dd2d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0f4cf3d\" data-id=\"0f4cf3d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-afef136 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"afef136\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">logical_test<\/span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra.<\/span><\/span><br><span id=\"docs-internal-guid-58b3da28-7fff-4d4e-29f6-437ad4c7523b\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">N\u00f3 c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t bi\u1ec3u th\u1ee9c logic tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u00e1nh gi\u00e1 \u0111\u00fang (TRUE) ho\u1eb7c sai (FALSE) ho\u1eb7c l\u00e0 tham chi\u1ebfu m\u1ed9t \u00f4 hay k\u1ebft qu\u1ea3 c\u1ee7a m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c kh\u00e1c.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">[value_if_true]<\/span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: l\u00e0 gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 khi logic_test \u0111\u01b0\u1ee3c th\u1ecfa m\u00e3n (TRUE).<\/span><\/span><br><span id=\"docs-internal-guid-1205564d-7fff-c5a5-12cf-74b08596cf58\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"><i><b>N\u1ebfu kh\u00f4ng \u0111i\u1ec1n Value_if_true h\u00e0m IF s\u1ebd m\u1eb7c \u0111\u1ecbnh tr\u1ea3 v\u1ec1 0 n\u1ebfu logical_test \u0111\u00fang <\/b><\/i>v\u00e0 FALSE n\u1ebfu sai.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-5488a4bc-7fff-f33f-0ed7-f0149b286c90\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">[value_if_false]: <\/span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 khi logic_test kh\u00f4ng \u0111\u01b0\u1ee3c th\u1ecfa m\u00e3n (FALSE). Kh\u00f4ng b\u1eaft bu\u1ed9c ph\u1ea3i \u0111i\u1ec1n trong c\u00f4ng th\u1ee9c.<\/span><\/span><br><span id=\"docs-internal-guid-f5106c59-7fff-6cda-7820-6f4bda57fe0d\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">N\u1ebfu c\u00e2u \u0111i\u1ec1u ki\u1ec7n logical_test \u0111\u00fang, k\u1ebft qu\u1ea3 h\u00e0m tr\u1ea3 v\u1ec1 Value_if_true, n\u1ebfu sai m\u1eb7c \u0111\u1ecbnh tr\u1ea3 v\u1ec1 FALSE.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c1b658a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c1b658a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-da9d8a4\" data-id=\"da9d8a4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-615796f elementor-widget elementor-widget-text-editor\" data-id=\"615796f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-f6887061-7fff-b746-7a44-a3c1dcc83646\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Value_if_true v\u00e0 value_if_false n\u1ebfu l\u00e0 v\u0103n b\u1ea3n th\u00ec lu\u00f4n ph\u1ea3i \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p [ \u201c ].<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-70e5279 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"70e5279\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f3f41bc\" data-id=\"f3f41bc\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-442d038 elementor-widget elementor-widget-heading\" data-id=\"442d038\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\"><h1 dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:20pt;margin-bottom:6pt;\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2, L\u01b0u \u00dd V\u1edbi \u0110\u1ed1i S\u1ed1 C\u1ee7a H\u00e0m IF Trong Excel<\/span><\/h1><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-baa6121 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"baa6121\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b158fc9\" data-id=\"b158fc9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-40b4e29 elementor-widget elementor-widget-heading\" data-id=\"40b4e29\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"><font color=\"#000000\" face=\"Arial\"><span style=\"font-size: 16pt;\">2.1, C\u00f3 Th\u1ec3 Thay \u0110\u1ed5i Bi\u1ec3u Th\u1ee9c Logic V\u00e0 \u0110\u1ed3ng Th\u1eddi \u0110\u1ed5i V\u1ecb Tr\u00ed <\/span><span style=\"font-size: 21.3333px;\">Value_if_true V\u00e0 <\/span><\/font><\/span><font color=\"#000000\" face=\"Arial\"><span style=\"font-size: 21.3333px;\">Value_if_False<\/span><\/font><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9ad45ad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9ad45ad\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e7b97e7\" data-id=\"e7b97e7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-55e0ea5 elementor-widget elementor-widget-text-editor\" data-id=\"55e0ea5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u1edbi c\u00e1c c\u00e2u l\u1ec7nh \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh, c\u00f3 th\u1ec3 thay \u0111\u1ed5i chi\u1ec1u c\u1ee7a bi\u1ec3u th\u1ee9c logic \u0111\u1ed3ng th\u1eddi \u0111\u1ed5i v\u1ecb tr\u00ed value_if_true v\u00e0 value_if_false.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">V\u00ed d\u1ee5: x\u00e9t t\u1ed5ng \u0111i\u1ec3m c\u1ee7a th\u00ed sinh: t\u1eeb 21 \u0111i\u1ec3m tr\u1edf l\u00ean l\u00e0 \u0111\u1ea1t, d\u01b0\u1edbi 21 \u0111i\u1ec3m l\u00e0 kh\u00f4ng \u0111\u1ea1t, c\u00f4ng th\u1ee9c t\u1ea1i \u00f4 A6 v\u00e0 A7 c\u00f3 th\u1ec3 l\u00e0:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">= IF(B2&gt;=21,&#8221;\u0110\u1ea1t&#8221;,&#8221;Kh\u00f4ng \u0110\u1ea1t&#8221;)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">= IF(B2&lt;21,&#8221;Kh\u00f4ng \u0110\u1ea1t&#8221;,&#8221;\u0110\u1ea1t&#8221;)<\/span><\/p><p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u1ea3 hai c\u00f4ng th\u1ee9c excel n\u00e0y \u0111i\u1ec1u tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0110\u1ea1t:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8513016 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8513016\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1bd390d\" data-id=\"1bd390d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0a8dd32 elementor-widget elementor-widget-image\" data-id=\"0a8dd32\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Vi_du_ham_if_trong_excel_doi_cho_bieu_thuc_logic.png\" title=\"Vi_du_ham_if_trong_excel_doi_cho_bieu_thuc_logic\" alt=\"V\u1edbi c\u00e1c c\u00e2u l\u1ec7nh \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh c\u1ee7a h\u00e0m IF trong excel, c\u00f3 th\u1ec3 thay \u0111\u1ed5i chi\u1ec1u c\u1ee7a bi\u1ec3u th\u1ee9c logic \u0111\u1ed3ng th\u1eddi \u0111\u1ed5i v\u1ecb tr\u00ed value_if_true v\u00e0 value_if_false\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-995e851 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"995e851\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1f5db55\" data-id=\"1f5db55\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cdf76a9 elementor-widget elementor-widget-text-editor\" data-id=\"cdf76a9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Nh\u01b0 v\u00ed d\u1ee5 \u1edf tr\u00ean, ch\u00fang ta th\u1ea5y r\u1eb1ng Value_if_true v\u00e0 Value_if_false c\u1ee7a h\u00e0m IF \u0111ang \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh l\u00e0 v\u0103n b\u1ea3n v\u00e0 \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">N\u1ebfu b\u1ea1n mu\u1ed1n gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m IF trong Excel l\u00e0 TRUE ho\u1eb7c FALSE th\u00ec c\u00f3 th\u1ec3 vi\u1ebft h\u00e0m nh\u01b0 sau:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">= IF(B2&gt;=21,TRUE,FALSE)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">= IF(B2&lt;21,FALSE,TRUE) &#8211; Tr\u01b0\u1eddng h\u1ee3p \u0111\u1ea3o bi\u1ec3u th\u1ee9c logic n\u00e0y tr\u00f4ng c\u00f4ng th\u1ee9c h\u00e0m g\u00e2y xo\u1eafn n\u00e3o m\u1ed9t ch\u00fat, nh\u01b0ng kh\u00f4ng sao, khi nh\u00ecn v\u00ed d\u1ee5 tr\u1ef1c ti\u1ebfp th\u00ec k\u1ebft qu\u1ea3 h\u00e0m nh\u01b0 sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0b5a51b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0b5a51b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8901309\" data-id=\"8901309\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0df8811 elementor-widget elementor-widget-image\" data-id=\"0df8811\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Vi_du_ham_if_trong_excel_doi_cho_bieu_thuc_logic_true_false-1.png\" title=\"Vi_du_ham_if_trong_excel_doi_cho_bieu_thuc_logic_true_false\" alt=\"\u0110\u1ed1i S\u1ed1 C\u1ee7a H\u00e0m IF Trong Excel C\u00f3 Th\u1ec3 Thay \u0110\u1ed5i Bi\u1ec3u Th\u1ee9c Logic V\u00e0 Gi\u00e1 Tr\u1ecb \u0110\u1ed1i S\u1ed1\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5073081 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5073081\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-72e35bb\" data-id=\"72e35bb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c432c1c elementor-widget elementor-widget-heading\" data-id=\"c432c1c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-5897f730-7fff-c978-0c84-7fb406d6ba75\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.2, Tr\u01b0\u1eddng H\u1ee3p \u0110\u1ed1i S\u1ed1 C\u1ee7a H\u00e0m IF Trong Excel D\u1ea1ng M\u1ea3ng<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c85ba4f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c85ba4f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-754c7cf\" data-id=\"754c7cf\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0dc8156 elementor-widget elementor-widget-text-editor\" data-id=\"0dc8156\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">N\u1ebfu b\u1ea5t k\u1ef3 \u0111\u1ed1i s\u1ed1 n\u00e0o cho IF \u0111\u01b0\u1ee3c cung c\u1ea5p d\u01b0\u1edbi d\u1ea1ng m\u1ea3ng, h\u00e0m IF s\u1ebd \u0111\u00e1nh gi\u00e1 m\u1ecdi ph\u1ea7n t\u1eed c\u1ee7a m\u1ea3ng. L\u01b0u \u00fd v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng, b\u1ea1n c\u1ea7n \u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl+ Shift+ Enter \u0111\u1ec3 c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n m\u1ed9t m\u1ea3ng v\u1edbi h\u00e0m IF trong Excel:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">T\u00ednh t\u1ed5ng m\u1ed9t m\u1ea3ng m\u00e0 trong m\u1ea3ng \u0111\u00f3: n\u1ebfu m\u1ed7i ph\u1ea7n t\u1eed trong m\u1ea3ng nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 2 th\u00ec ph\u1ea7n t\u1eed \u0111\u00f3 \u0111\u01b0\u1ee3c g\u00e1n gi\u00e1 tr\u1ecb b\u1eb1ng 0, n\u1ebfu ph\u1ea7n t\u1eed \u0111\u00f3 l\u1edbn h\u01a1n 2 th\u00ec \u0111\u01b0\u1ee3c g\u00e1n gi\u00e1 tr\u1ecb b\u1eb1ng 1.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">=SUM(IF(A3:A9&lt;=2,0,1))<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8c116fe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8c116fe\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5cb3efb\" data-id=\"5cb3efb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7616ff4 elementor-widget elementor-widget-image\" data-id=\"7616ff4\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Vi_du_ham_if_trong_excel_doi_so_dang_mang.png\" title=\"Vi_du_ham_if_trong_excel_doi_so_dang_mang\" alt=\"b\u1ea5t k\u1ef3 \u0111\u1ed1i s\u1ed1 n\u00e0o cho h\u00e0m IF trong excel \u0111\u01b0\u1ee3c cung c\u1ea5p d\u01b0\u1edbi d\u1ea1ng m\u1ea3ng, h\u00e0m IF s\u1ebd \u0111\u00e1nh gi\u00e1 m\u1ecdi ph\u1ea7n t\u1eed c\u1ee7a m\u1ea3ng\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-70672f1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"70672f1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5aa6172\" data-id=\"5aa6172\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3a80d02 elementor-widget elementor-widget-heading\" data-id=\"3a80d02\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3, Quy T\u1eafc C\u01a1 B\u1ea3n Khi S\u1eed D\u1ee5ng H\u00e0m If Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dbb5dd7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dbb5dd7\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-352e6fa\" data-id=\"352e6fa\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-35f457b elementor-widget elementor-widget-heading\" data-id=\"35f457b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-77352500-7fff-fbf8-0f7f-82db8a976c72\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3.1, S\u1eed D\u1ee5ng C\u00e1c To\u00e1n T\u1eed So S\u00e1nh<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-964c869 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"964c869\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-69f0032\" data-id=\"69f0032\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-95e20cd elementor-widget elementor-widget-text-editor\" data-id=\"95e20cd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u1edbi c\u00e1c to\u00e1n t\u1eed trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 so s\u00e1nh hai gi\u00e1 tr\u1ecb ho\u1eb7c \u0111\u1eb7t h\u00e0m so s\u00e1nh gi\u00e1 tr\u1ecb trong Excel.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"color: #444444; font-size: 11.5pt; white-space: pre-wrap;\">Khi hai gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c so s\u00e1nh b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c to\u00e1n t\u1eed n\u00e0y, k\u1ebft qu\u1ea3 l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb logic TRUE ho\u1eb7c FALSE.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-63d7f67 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"63d7f67\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6da7f52\" data-id=\"6da7f52\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-79cc64e elementor-widget elementor-widget-text-editor\" data-id=\"79cc64e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<div dir=\"ltr\" style=\"margin-left: 36pt;\" align=\"left\"><table style=\"border: none; border-collapse: collapse; width: 451.27559055118115pt; table-layout: fixed;\"><colgroup> <col \/> <col width=\"241\" \/> <col width=\"127\" \/><\/colgroup><tbody><tr style=\"height: 0pt;\"><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">To\u00e1n t\u1eed so s\u00e1nh<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">M\u00f4 t\u1ea3<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Bi\u1ec3u th\u1ee9c logic<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">D\u1ea5u b\u1eb1ng<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">A1=B1<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&gt;<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">D\u1ea5u l\u01a1\u0301n h\u01a1n<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">A1&gt;B1<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&lt;<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">D\u1ea5u nh\u1ecf h\u01a1n<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">A1&lt;B1<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&gt;=<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">D\u1ea5u l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">A1&gt;=B1<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&lt;=<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">D\u1ea5u nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">A1&lt;=B1<\/span><\/p><\/td><\/tr><tr style=\"height: 0pt;\"><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&lt;&gt;<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Kh\u00e1c<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">A1&lt;&gt;B1<\/span><\/p><\/td><\/tr><\/tbody><\/table><\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-634f90e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"634f90e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-762bb6d\" data-id=\"762bb6d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6567b8e elementor-widget elementor-widget-heading\" data-id=\"6567b8e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-2f90a888-7fff-9432-7d38-ffec71672e28\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3.2, Bi\u1ec3u Th\u1ee9c Logic C\u1ee7a H\u00e0m IF Trong Excel Kh\u00f4ng Ph\u00e2n Bi\u1ec7t Ch\u1eef Hoa Hay Ch\u1eef Th\u01b0\u1eddng<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-631fcae elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"631fcae\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3eb3187\" data-id=\"3eb3187\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fb00a94 elementor-widget elementor-widget-text-editor\" data-id=\"fb00a94\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Gi\u1ed1ng nh\u01b0 ph\u1ea7n l\u1edbn c\u00e1c ch\u1ee9c n\u0103ng v\u00e0 h\u00e0m kh\u00e1c c\u1ee7a Excel, c\u00e1c bi\u1ec3u th\u1ee9c logic c\u00f3 ch\u1ee9a k\u00fd t\u1ef1 kh\u00f4ng th\u1ec3 ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng trong c\u00f4ng th\u1ee9c h\u00e0m IF.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Nh\u01b0 v\u00ed d\u1ee5 \u0111\u01b0\u1edbi \u0111\u00e2y: Tr\u1ea1ng th\u00e1i nghi\u1ec7m thu xong t\u1ea1i c\u1ed9t C, khi s\u1eed d\u1ee5ng h\u00e0m IF t\u1ea1i c\u1ed9t D \u0111\u1ec3 ki\u1ec3m tra tr\u1ea1ng th\u00e1i c\u00f3 \u0111\u00fang l\u00e0 \u201cNghi\u1ec7m thu xong\u201d hay ch\u01b0a, h\u00e0m IF kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e85b4c5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e85b4c5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f9b46fd\" data-id=\"f9b46fd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dbd9eb9 elementor-widget elementor-widget-image\" data-id=\"dbd9eb9\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Vi_du_ham_if_trong_excel_khong_phan_biet_viet_hoa_viet_thuong.png\" title=\"Vi_du_ham_if_trong_excel_khong_phan_biet_viet_hoa_viet_thuong\" alt=\"Bi\u1ec3u Th\u1ee9c Logic C\u1ee7a H\u00e0m IF Trong Excel Kh\u00f4ng Ph\u00e2n Bi\u1ec7t Ch\u1eef Hoa Hay Ch\u1eef Th\u01b0\u1eddng\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-55b36b8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"55b36b8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9d1e98d\" data-id=\"9d1e98d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f2af967 elementor-widget elementor-widget-text-editor\" data-id=\"f2af967\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-46644ca9-7fff-c981-6ef3-ac3c85ad99d5\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n ph\u00e2n bi\u1ec7t ki\u1ec3u ch\u1eef hoa hay th\u01b0\u1eddng, ph\u1ea3i d\u00f9ng h\u00e0m IF k\u1ebft h\u1ee3p h\u00e0m <\/span><span style=\"font-size: 11.5pt; color: #444444; font-weight: bold; font-style: italic; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">EXACT<\/span><span style=\"font-size: 11.5pt; color: #444444; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> nh\u01b0 sau:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fa77f32 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fa77f32\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8332d71\" data-id=\"8332d71\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ab5e91a elementor-widget elementor-widget-image\" data-id=\"ab5e91a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Vi_du_ham_if_trong_excel_ket_hop_ham_exact_de_phan_biet_viet_hoa_viet_thuong.png\" title=\"Vi_du_ham_if_trong_excel_ket_hop_ham_exact_de_phan_biet_viet_hoa_viet_thuong\" alt=\"Bi\u1ec3u Th\u1ee9c Logic C\u1ee7a H\u00e0m IF Trong Excel Kh\u00f4ng Ph\u00e2n Bi\u1ec7t Ch\u1eef Hoa Hay Ch\u1eef Th\u01b0\u1eddng S\u1eed d\u1ee5ng h\u00e0m Exact \u0111\u1ec3 ph\u00e2n bi\u1ec7t ch\u00ednh x\u00e1c\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dbd1347 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dbd1347\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6d689ff\" data-id=\"6d689ff\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e1f3faa elementor-widget elementor-widget-heading\" data-id=\"e1f3faa\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3.3, H\u00e0m IF Kh\u00f4ng Th\u1ec3 Ph\u00e2n Bi\u1ec7t \u0110\u01b0\u1ee3c Ng\u00e0y Th\u00e1ng V\u00e0 Di\u1ec5n Gi\u1ea3i N\u00f3 Nh\u01b0 M\u1ed9t Chu\u1ed7i K\u00fd T\u1ef1<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1adca78 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1adca78\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d76cd8a\" data-id=\"d76cd8a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5975b92 elementor-widget elementor-widget-text-editor\" data-id=\"5975b92\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m IF trong Excel kh\u00f4ng coi ng\u00e0y th\u00e1ng nh\u01b0 m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 n\u00ean b\u1ea1n kh\u00f4ng th\u1ec3 di\u1ec5n t\u1ea3 m\u1ed9t bi\u1ec3u th\u1ee9c logic so s\u00e1nh ng\u00e0y th\u00e1ng \u0111\u01a1n gi\u1ea3n nh\u01b0 &gt;\u201d15\/07\/2002\u201d hay =15\/07\/2002.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"color: #444444; font-size: 11.5pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"color: #444444; font-size: 11.5pt; white-space: pre-wrap;\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c bi\u1ec3u th\u1ee9c logic so s\u00e1nh ng\u00e0y th\u00e1ng nh\u01b0 tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m DATEVALUE chuy\u00ea\u0309n \u0111\u00f4\u0309i nga\u0300y \u0111\u01b0\u01a1\u0323c l\u01b0u tr\u01b0\u0303 \u01a1\u0309 da\u0323ng v\u0103n ba\u0309n sang d\u1ea1ng s\u00f4\u0301 chuy\u1ec3n \u0111\u1ed5i ma\u0300 Excel c\u00f4ng nh\u00e2\u0323n la\u0300 nga\u0300y tha\u0301ng. <\/span><span style=\"font-size: 11.5pt; color: #444444; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Vi\u0301 du\u0323, c\u00f4ng th\u01b0\u0301c <\/span><span style=\"font-size: 11.5pt; color: #444444; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">=DATEVALUE(&#8220;15\/7\/2002&#8221;)<\/span><span style=\"font-size: 11.5pt; color: #444444; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> tra\u0309 v\u00ea\u0300 37452, s\u1ed1 chuy\u1ec3n \u0111\u1ed5i c\u1ee7a ng\u00e0y 15\/07\/2002.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y s\u1eed d\u1ee5ng h\u00e0m IF k\u1ebft h\u1ee3p h\u00e0m DATEVALUE \u0111\u1ec3 t\u00ecm ra m\u00e1y m\u00f3c \u0111\u01b0\u1ee3c mua m\u1edbi trong n\u0103m 2020:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto, sans-serif; color: #444444; background-color: #ffffff; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"><b>=IF(C7&gt;=DATEVALUE(&#8220;01\/01\/2020&#8243;),&#8221;Yes&#8221;,&#8221;No&#8221;)<\/b><\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\">\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #444444; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">N\u1ebfu ng\u00e0y th\u00e1ng \u1edf \u00f4 C7 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 01\/01\/2020 (\u0110\u00e3 \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i sang \u0111\u1ecbnh d\u1ea1ng h\u00e0m Excel c\u00f3 th\u1ec3 di\u1ec5n gi\u1ea3i \u0111\u01b0\u1ee3c b\u1eb1ng h\u00e0m DATEVALUE) th\u00ec tr\u1ea3 v\u1ec1 \u201cYes\u201d, n\u1ebfu kh\u00f4ng th\u00ec \u201cNo\u201d:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2f6f585 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2f6f585\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-194f507\" data-id=\"194f507\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b93a551 elementor-widget elementor-widget-image\" data-id=\"b93a551\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Vi_du_ham_if_trong_excel_ket_hop_datevalue_de_so_sanh_ngay_thang.png\" title=\"Vi_du_ham_if_trong_excel_ket_hop_datevalue_de_so_sanh_ngay_thang\" alt=\"H\u00e0m if trong excel k\u1ebft h\u1ee3p datevalue \u0111\u1ec3 so s\u00e1nh ng\u00e0y th\u00e1ng\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-86017f9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"86017f9\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4b827a3\" data-id=\"4b827a3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2881abc elementor-widget elementor-widget-heading\" data-id=\"2881abc\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">4, M\u1ed9t S\u1ed1 C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m IF Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-755ddcb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"755ddcb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-adc4bd8\" data-id=\"adc4bd8\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e440c27 elementor-widget elementor-widget-heading\" data-id=\"e440c27\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-1aa2784e-7fff-c8ad-7671-cd7f39eb95d9\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">4.1, C\u00e1ch D\u00f9ng H\u00e0m IF Trong Excel \u0110\u1ec3 Ki\u1ec3m Tra \u0110i\u1ec1u Ki\u1ec7n S\u1ed1 \u0110\u01a1n Gi\u1ea3n<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7dbadc6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7dbadc6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7337fdd\" data-id=\"7337fdd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-71a288f elementor-widget elementor-widget-text-editor\" data-id=\"71a288f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-eb6988d6-7fff-2c6a-414e-0a224fa105f8\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">H\u00ecnh minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y th\u1ec3 hi\u1ec7n k\u1ebft qu\u1ea3 c\u1ee7a vi\u1ec7c so s\u00e1nh kh\u00e1c 0 v\u00e0 so s\u00e1nh l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 100.000.000 VN\u0110.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8ed2fb1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8ed2fb1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-622eed3\" data-id=\"622eed3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9d18c2e elementor-widget elementor-widget-image\" data-id=\"9d18c2e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Vi_du_ham_if_trong_excel_so_sanh_don_gian.png\" title=\"Vi_du_ham_if_trong_excel_so_sanh_don_gian\" alt=\"C\u00e1ch D\u00f9ng H\u00e0m IF Trong Excel \u0110\u1ec3 Ki\u1ec3m Tra \u0110i\u1ec1u Ki\u1ec7n S\u1ed1 \u0110\u01a1n Gi\u1ea3n\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-797a26f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"797a26f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-29cc5e5\" data-id=\"29cc5e5\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-daae9b1 elementor-widget elementor-widget-heading\" data-id=\"daae9b1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-0eef8f20-7fff-1623-1e25-268fb2b077a9\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">4.2, S\u1eed D\u1ee5ng H\u00e0m IF L\u1ed3ng Nhau \u0110\u1ec3 Ki\u1ec3m Tra Nhi\u1ec1u \u0110i\u1ec1u Ki\u1ec7n<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6f2d9d3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6f2d9d3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c9f178f\" data-id=\"c9f178f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-14d4fb6 elementor-widget elementor-widget-text-editor\" data-id=\"14d4fb6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nhi\u1ec1u h\u00e0m IF l\u1ed3ng nhau \u0111\u1ec3 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, hoctin.vn ki\u1ec3m tra ba \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 \u0111\u01b0a ra x\u1ebfp lo\u1ea1i c\u1ee7a h\u1ecdc sinh d\u1ef1a tr\u00ean \u0111i\u1ec3m t\u1ed5ng k\u1ebft m\u00f4n:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">=IF(B3&lt;4.5,&#8221;H\u1ecdc l\u1ea1i&#8221;,IF(B3&lt;7,&#8221;Trung b\u00ecnh&#8221;,IF(B3&lt;8,&#8221;Kh\u00e1&#8221;,&#8221;Gi\u1ecfi&#8221;)))<\/span><\/b><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f941524 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f941524\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bc71fd4\" data-id=\"bc71fd4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-88c4259 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"88c4259\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">\u0110i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean ki\u1ec3m tra xem c\u00f3 \u0111i\u1ec3m n\u00e0o nh\u1ecf h\u01a1n 4.5, n\u1ebfu c\u00f3, tr\u1ea3 v\u1ec1 \u201cH\u1ecdc l\u1ea1i\u201d.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Trong tr\u01b0\u1eddng h\u1ee3p \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean l\u00e0 FALSE, c\u00f3 ngh\u0129a l\u00e0 h\u1ecdc sinh \u0111\u1ea1t \u0111i\u1ec3m tr\u00ean ho\u1eb7c b\u1eb1ng 4.5, m\u1ed9t m\u1ec7nh \u0111\u1ec1 h\u00e0m IF kh\u00e1c s\u1ebd ki\u1ec3m tra m\u1ed9t \u0111i\u1ec1u ki\u1ec7n kh\u00e1c.<\/span><\/span><br><span id=\"docs-internal-guid-1a61d6c1-7fff-3d77-e651-c97582b41f29\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">N\u00f3 ki\u1ec3m tra xem c\u00e1c \u0111i\u1ec3m c\u00f3 nh\u1ecf h\u01a1n 7. N\u1ebfu \u0111i\u1ec1u n\u00e0y l\u00e0 \u0111\u00fang, n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 \u201cTrung b\u00ecnh\u201d, v\u00ec k\u1ebft h\u1ee3p v\u1edbi \u0111i\u1ec1u ki\u1ec7n m\u1ed9t th\u00ec \u0111i\u1ec3m c\u1ee7a h\u1ecdc sinh n\u00e0y \u0111ang l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 4.5 v\u00e0 nh\u1ecf h\u01a1n 7.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">T\u01b0\u01a1ng t\u1ef1 v\u1edbi \u0111i\u1ec1u ki\u1ec7n th\u1ee9 3, n\u1ebfu \u0111i\u1ec1u ki\u1ec7n 2 sai th\u00ec \u0111i\u1ec3m \u0111ang l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 7.<\/span><\/span><br><span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">H\u00e0m IF th\u1ee9 3 ki\u1ec3m tra n\u1ebfu \u0111i\u1ec3m nh\u1ecf h\u01a1n 8. N\u1ebfu \u0111i\u1ec1u n\u00e0y \u0111\u00fang, h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 \u201cKh\u00e1\u201d v\u00ec \u0111i\u1ec3m c\u1ee7a h\u1ecdc sinh n\u00e0y l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 7 v\u00e0 nh\u1ecf h\u01a1n 8; n\u1ebfu kh\u00f4ng s\u1ebd tr\u1ea3 v\u1ec1 \u201cGi\u1ecfi\u201d.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2f903cd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2f903cd\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4872521\" data-id=\"4872521\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0c5180d elementor-widget elementor-widget-image\" data-id=\"0c5180d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Vi_du_nhieu_ham_if_long_trong_excel.png\" title=\"Vi_du_nhieu_ham_if_long_trong_excel\" alt=\"S\u1eed D\u1ee5ng H\u00e0m IF L\u1ed3ng Nhau \u0110\u1ec3 Ki\u1ec3m Tra Nhi\u1ec1u \u0110i\u1ec1u Ki\u1ec7n\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-777ebf3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"777ebf3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-35d9117\" data-id=\"35d9117\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7b3a8e7 elementor-widget elementor-widget-text-editor\" data-id=\"7b3a8e7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">D\u00f9 Excel cho ph\u00e9p b\u1ea1n l\u1ed3ng \u0111\u1ebfn 64 h\u00e0m IF kh\u00e1c nhau th\u00ec b\u1ea1n c\u0169ng kh\u00f4ng n\u00ean l\u00e0m nh\u01b0 v\u1eady. V\u00ec vi\u1ebft h\u00e0m ph\u1ee9c t\u1ea1p v\u00e0 d\u1ec5 nh\u1ea7m l\u1eabn.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u0110\u1ec3 kh\u00f4ng ph\u1ea3i d\u00f9ng h\u00e0m IF l\u1ed3ng nhau trong Excel, b\u1ea1n c\u00f3 th\u1ec3 thay b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng VLOOKUP ho\u1eb7c thay th\u1ebf nhi\u1ec1u c\u00e2u l\u1ec7nh IF l\u1ed3ng nhau b\u1eb1ng h\u00e0m IFS.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-13b308b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"13b308b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4a53c04\" data-id=\"4a53c04\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e253997 elementor-widget elementor-widget-heading\" data-id=\"e253997\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-a296f442-7fff-1a69-c33f-97fb1836691f\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">4.3, T\u00ednh To\u00e1n C\u00f3 \u0110i\u1ec1u Ki\u1ec7n B\u1eb1ng H\u00e0m IF Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-211e331 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"211e331\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d1fb7c2\" data-id=\"d1fb7c2\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-47938d6 elementor-widget elementor-widget-text-editor\" data-id=\"47938d6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 cho h\u00e0m IF hi\u1ec3n th\u1ecb m\u1ed9t bi\u1ec3u th\u1ee9c, ph\u00e9p to\u00e1n.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5: =IF(B3&lt;100,B3*C3,B3*D3)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">C\u00f4ng th\u1ee9c so s\u00e1nh gi\u00e1 tr\u1ecb s\u1ed1 s\u1ea3n ph\u1ea9m \u1edf \u00f4 B3 v\u1edbi 100, v\u00e0 n\u1ebfu B3 l\u1edbn h\u01a1n 100 th\u00ec k\u1ebft qu\u1ea3 t\u1ed5ng ti\u1ec1n s\u1ebd l\u00e0 vi\u1ec7c nh\u00e2n s\u1ed1 s\u1ea3n ph\u1ea9m trong \u00f4 B3 v\u1edbi gi\u00e1 s\u1ec9 \u1edf D3, n\u1ebfu kh\u00f4ng s\u1ebd nh\u00e2n B3 v\u1edbi gi\u00e1 l\u1ebb \u1edf C3.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-48451db elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"48451db\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-dae5a3a\" data-id=\"dae5a3a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a6738c6 elementor-widget elementor-widget-image\" data-id=\"a6738c6\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Vi_du_ham_if_trong_excel_tinh_toan_co_dieu_kien.png\" title=\"Vi_du_ham_if_trong_excel_tinh_toan_co_dieu_kien\" alt=\"T\u00ednh To\u00e1n C\u00f3 \u0110i\u1ec1u Ki\u1ec7n B\u1eb1ng H\u00e0m IF Trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-deab271 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"deab271\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b0778bf\" data-id=\"b0778bf\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-97298bf elementor-widget elementor-widget-heading\" data-id=\"97298bf\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-86f7986c-7fff-2d6b-1915-a36778d3e2b1\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">4.4, K\u1ebft H\u1ee3p C\u00e1c H\u00e0m Logic (AND \/ OR) V\u1edbi H\u00e0m IF<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d721cfe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d721cfe\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e843195\" data-id=\"e843195\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-df82c5c elementor-widget elementor-widget-text-editor\" data-id=\"df82c5c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">S\u1eed d\u1ee5ng h\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi h\u00e0m AND v\u00e0 h\u00e0m OR trong Excel \u0111\u1ec3 x\u00e9t nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau:<\/span><\/p>\n<p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">Nh\u01b0 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cf044ad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cf044ad\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-032c3dc\" data-id=\"032c3dc\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a0a0fcd elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"a0a0fcd\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px; text-align: justify;\">H\u00e0m AND tr\u1ea3 v\u1ec1 TRUE n\u1ebfu c\u1ea3 hai \u0111i\u1ec3m l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 7, n\u1ebfu kh\u00f4ng, n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 FALSE. N\u1ebfu TRUE, h\u00e0m IF tr\u1ea3 v\u1ec1 \u201cPass\u201d, n\u1ebfu FALSE, h\u00e0m IF tr\u1ea3 v\u1ec1 \u201cFail\u201d.<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-minus\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px; text-align: justify;\">H\u00e0m OR tr\u1ea3 v\u1ec1 TRUE n\u1ebfu \u00edt nh\u1ea5t m\u1ed9t \u0111i\u1ec3m l\u1edbn h\u01a1n 8.5, n\u1ebfu kh\u00f4ng, n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 FALSE. N\u1ebfu TRUE, h\u00e0m IF tr\u1ea3 v\u1ec1 \u201c\u0110i\u1ec3m cao\u201d, n\u1ebfu FALSE, h\u00e0m IF tr\u1ea3 v\u1ec1 \u201cNo\u201d.<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c61b3fe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c61b3fe\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-46b112b\" data-id=\"46b112b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6a72d5d elementor-widget elementor-widget-image\" data-id=\"6a72d5d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Vi_du_ham_if_trong_excel_ket_hop_ham_and_or.png\" title=\"Vi_du_ham_if_trong_excel_ket_hop_ham_and_or\" alt=\"S\u1eed d\u1ee5ng h\u00e0m IF trong Excel k\u1ebft h\u1ee3p v\u1edbi h\u00e0m AND v\u00e0 h\u00e0m OR \u0111\u1ec3 x\u00e9t nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7194e42 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7194e42\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-da9a7f2\" data-id=\"da9a7f2\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ea4a248 elementor-widget elementor-widget-heading\" data-id=\"ea4a248\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">4.5,&nbsp;Chuy\u1ec3n \u0110\u1ed5i C\u00e1c L\u1ed7i Th\u00e0nh 0 B\u1eb1ng H\u00e0m IFERROR\/ IFNA<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b083390 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b083390\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9f06b58\" data-id=\"9f06b58\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d98fa9e elementor-widget elementor-widget-text-editor\" data-id=\"d98fa9e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Hoctin.vn \u0111\u00e3 c\u00f3 b\u00e0i vi\u1ebft v\u1ec1 s\u1eed d\u1ee5ng <a href=\"https:\/\/hoctin.vn\/ham-if-ket-hop-vlookup\/\" target=\"_blank\" rel=\"noopener\">h\u00e0m IF k\u1ebft h\u1ee3p VLOOKUP trong Excel<\/a>, trong \u0111\u00f3 c\u00f3 h\u01b0\u1edbng d\u1eabn k\u1ebft h\u1ee3p h\u00e0m IF\/IFERROR\/IFNA v\u00e0 VLOOKUP \u0111\u1ec3 tr\u00e1nh l\u1ed7i N\/A khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ngo\u00e0i ra, c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi c\u00e1c bi\u1ec3u th\u1ee9c c\u00f3 l\u1ed7i b\u1ea5t k\u1ef3 nh\u01b0 sau:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y t\u00ednh t\u1ef7 l\u1ec7 bi\u1ebfn \u0111\u1ed9ng c\u1ee7a doanh thu 2 n\u0103m li\u00ean ti\u1ebfp c\u1ee7a c\u00e1c c\u1eeda h\u00e0ng khu v\u1ef1c, khu v\u1ef1c 2 m\u1edbi m\u1edf n\u0103m N+1, kh\u00f4ng c\u00f3 doanh thu n\u0103m \u0111\u1ea7u n\u00ean bi\u1ebfn \u0111\u1ed9ng l\u00e0 ph\u00e9p chia cho 0, g\u1eb7p l\u1ed7i #DIV\/0! nh\u01b0 sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1d86b8b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1d86b8b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4948c71\" data-id=\"4948c71\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-051f48a elementor-widget elementor-widget-image\" data-id=\"051f48a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Loi_do_chia_so_0_can_dung_ham_if_sua.png\" title=\"Loi_do_chia_so_0_can_dung_ham_if_sua\" alt=\"Chuy\u1ec3n \u0110\u1ed5i C\u00e1c L\u1ed7i #DIV\/0 Th\u00e0nh 0 B\u1eb1ng H\u00e0m IFERROR\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8b57f8e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8b57f8e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-511bfb0\" data-id=\"511bfb0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d3a4201 elementor-widget elementor-widget-text-editor\" data-id=\"d3a4201\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-8f6c8185-7fff-cd88-7960-c7cd00b0349e\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">C\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IFERROR \u0111\u1ec3 s\u1eeda l\u1ed7i tr\u00ean: n\u1ebfu c\u00f3 l\u1ed7i th\u00ec tr\u1ea3 v\u1ec1 \u201cNo PY\u201d (Kh\u00f4ng c\u00f3 doanh thu n\u0103m tr\u01b0\u1edbc): <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">=IFERROR(Value,value_if_error)<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-327cbd6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"327cbd6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-47d0b74\" data-id=\"47d0b74\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dac0e15 elementor-widget elementor-widget-image\" data-id=\"dac0e15\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Vi_du_ham_if_trong_excel_sua_loi.png\" title=\"Vi_du_ham_if_trong_excel_sua_loi\" alt=\"Chuy\u1ec3n \u0110\u1ed5i C\u00e1c L\u1ed7i Th\u00e0nh 0 B\u1eb1ng H\u00e0m IFERROR\/ IFNA\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0ab5263 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0ab5263\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-06d19e4\" data-id=\"06d19e4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-affd494 elementor-widget elementor-widget-heading\" data-id=\"affd494\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-a8fff1dd-7fff-8a19-e1ee-df52ef6c45cd\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">4.6, S\u1eed D\u1ee5ng H\u00e0m IF Trong Excel \u0110\u1ec3 Ki\u1ec3m Tra M\u1ed9t \u00d4 C\u00f3 Tr\u1ed1ng Hay Kh\u00f4ng V\u1edbi ISBLANK<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-102e497 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"102e497\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-32f65d1\" data-id=\"32f65d1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6904c49 elementor-widget elementor-widget-text-editor\" data-id=\"6904c49\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; font-style: inherit; text-align: justify;\">\u0110\u1ec3 c\u00f4ng th\u1ee9c Excel ch\u1ec9 th\u1ef1c hi\u1ec7n khi \u00f4 kh\u00f4ng tr\u1ed1ng, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c d\u1ef1a tr\u00ean h\u00e0m IF:<\/span><\/p><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; font-style: inherit; text-align: justify; white-space: pre-wrap;\">=IF(B5&lt;&gt;&#8221;&#8221;,&#8221;L\u1eafp xong&#8221;,&#8221;&#8221;)<\/span><\/p><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Bi\u1ec3u th\u1ee9c B5&lt;&gt;&#8221;&#8221; l\u00e0 c\u00f4ng th\u1ee9c logic: N\u1ebfu \u00f4 B5 kh\u00f4ng tr\u1ed1ng (r\u1ed7ng), khi \u0111\u00f3 h\u00e0m IF tr\u1ea3 v\u1ec1 \u201cL\u1eafp xong\u201d n\u1ebfu kh\u00f4ng s\u1ebd kh\u00f4ng tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb n\u00e0o (Tr\u1ea3 v\u1ec1 m\u1ed9t \u00f4 tr\u1ed1ng) nh\u01b0 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p><p>\u00a0<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3d9eff0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3d9eff0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-be56bbb\" data-id=\"be56bbb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ec73d6d elementor-widget elementor-widget-image\" data-id=\"ec73d6d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Vi_du_ham_if_trong_excel_kiem_tra_o_trong.png\" title=\"Vi_du_ham_if_trong_excel_kiem_tra_o_trong\" alt=\"S\u1eed D\u1ee5ng H\u00e0m IF Trong Excel \u0110\u1ec3 Ki\u1ec3m Tra M\u1ed9t \u00d4 C\u00f3 Tr\u1ed1ng Hay Kh\u00f4ng\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cc35619 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cc35619\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9bd54d8\" data-id=\"9bd54d8\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4a1a323 elementor-widget elementor-widget-text-editor\" data-id=\"4a1a323\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-d3b045a1-7fff-a917-36de-356a7859bbbb\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 thay th\u1ebf bi\u1ec3u th\u1ee9c logic B5&lt;&gt;&#8221;&#8221; b\u1eb1ng h\u00e0m ISBLANK c\u00f3 c\u00fa ph\u00e1p =ISBLANK(value) nh\u01b0 sau:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cb4d643 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cb4d643\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3b74d97\" data-id=\"3b74d97\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ef06f63 elementor-widget elementor-widget-image\" data-id=\"ef06f63\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Vi_du_ham_if_trong_excel_kiem_tra_o_trong_ISBLANK.png\" title=\"Vi_du_ham_if_trong_excel_kiem_tra_o_trong_ISBLANK\" alt=\"S\u1eed D\u1ee5ng H\u00e0m IF Trong Excel \u0110\u1ec3 Ki\u1ec3m Tra M\u1ed9t \u00d4 C\u00f3 Tr\u1ed1ng Hay Kh\u00f4ng V\u1edbi ISBLANK\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e3be8fb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e3be8fb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4b23e0f\" data-id=\"4b23e0f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-02100b5 elementor-widget elementor-widget-text-editor\" data-id=\"02100b5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #333333; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng b\u00e0i t\u1eadp excel c\u01a1 b\u1ea3n v\u1ec1 h\u00e0m IF trong Excel c\u0169ng nh\u01b0 \u1ee9ng d\u1ee5ng h\u00e0m n\u00e0y trong th\u1ef1c t\u1ebf. C\u00f9ng \u0111\u00f3n \u0111\u1ecdc <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF n\u00e2ng cao trong series b\u00e0i vi\u1ebft c\u1ee7a hoctin.vn.<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><b id=\"docs-internal-guid-38b68028-7fff-105e-474c-b12b3a012920\" style=\"font-weight: normal;\">&nbsp;<\/b><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11.5pt; font-family: Roboto,sans-serif; color: #333333; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ch\u00fac c\u00e1c \u00e1p d\u1ee5ng th\u00e0nh c\u00f4ng v\u00e0 v\u1eadn d\u1ee5ng t\u1ed1t trong c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp.<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><b style=\"font-weight: normal;\">&nbsp;<\/b><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ngo\u00e0i ra, \u0111\u1ec3 \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 Excel, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel, h\u00e3y c\u00f9ng \u0111\u00f3n \u0111\u1ecdc series b\u00e0i vi\u1ebft \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m excel:<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-indent: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&nbsp;<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-indent: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-sumif-trong-excel\/\" target=\"_blank\">H\u00e0m SUMIF<\/a><br><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\">\n<\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-indent: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-countif-co-ban\/\" target=\"_blank\">H\u00e0m COUNTIF<\/a><br><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>H\u00e0m IF l\u00e0 m\u1ed9t trong 10 h\u00e0m Excel \u0111\u01b0\u1ee3c d\u00f9ng nhi\u1ec1u nh\u1ea5t. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd chia s\u1ebb v\u1edbi b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 th\u1ef1c hi\u1ec7n so s\u00e1nh l\u00f4-gic v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 b\u1ea1n mong mu\u1ed1n. \u00a0 H\u00e0m IF trong Excel gi\u00fap b\u1ea1n ki\u1ec3m tra xem m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u00f3 \u0111\u01b0\u1ee3c \u0111\u00e1p &#8230; <a title=\"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m IF Trong Excel V\u00e0 V\u00ed D\u1ee5 C\u1ee5 Th\u1ec3\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/ham-if-trong-excel\/\">Read more <span class=\"screen-reader-text\">C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m IF Trong Excel V\u00e0 V\u00ed D\u1ee5 C\u1ee5 Th\u1ec3<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":470,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[27],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/382"}],"collection":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/comments?post=382"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/382\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/470"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}