{"id":11169,"date":"2022-11-11T12:46:38","date_gmt":"2022-11-11T05:46:38","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11169"},"modified":"2022-12-13T14:32:20","modified_gmt":"2022-12-13T07:32:20","slug":"cach-su-dung-ham-if-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;11169&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel to\u00e1n h\u1ecdc \u0111\u1ed1i v\u1edbi h\u1ecdc sinh, sinh vi\u00ean nh\u01b0 th\u1ebf n\u00e0o? C\u00f3 th\u1ec3 n\u00f3i, \u0111\u00e2y l\u00e0 h\u00e0m y\u00eau c\u1ea7u Excel ki\u1ec3m tra m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3 v\u00e0 n\u1ebfu n\u00f3 \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c; c\u00f2n n\u1ebfu \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng \u0111\u00e1p \u1ee9ng y\u00eau c\u1ea7u th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c. H\u00e0m IF l\u00e0 m\u1ed9t h\u00e0m ph\u1ed5 bi\u1ebfn trong Excel n\u00f3 v\u1eeba \u0111\u01b0\u1ee3c coi l\u00e0 h\u00e0m c\u01a1 b\u1ea3n v\u1eeba \u0111\u01b0\u1ee3c coi l\u00e0 h\u00e0m n\u00e2ng cao. Ch\u00fang ta h\u00e3y c\u00f9ng theo d\u00f5i \u0111\u1ec3 t\u00edch l\u0169y nh\u1eefng kinh nghi\u1ec7m trong vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m IF trong Excel nh\u00e9!<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#Khai_niem_ham_IF_la_gi\" >Kh\u00e1i ni\u1ec7m h\u00e0m IF l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#Phan_loai_cac_cach_su_dung_ham_IF_trong_Excel\" >Ph\u00e2n lo\u1ea1i c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#Cach_su_dung_ham_IF_co_ban_trong_Excel\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF c\u01a1 b\u1ea3n trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#Cach_su_dung_ham_IF_nang_cao_trong_Excel\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF n\u00e2ng cao trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#Ham_IF_nang_cao_ket_hop_voi_ham_AND\" >H\u00e0m IF n\u00e2ng cao k\u1ebft h\u1ee3p v\u1edbi h\u00e0m AND<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#Ham_IF_nang_cao_ket_hop_voi_ham_OR_trong_dieu_kien_nao\" >H\u00e0m IF n\u00e2ng cao k\u1ebft h\u1ee3p v\u1edbi h\u00e0m OR trong \u0111i\u1ec1u ki\u1ec7n n\u00e0o?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#Ham_IF_nang_cao_ket_hop_voi_ca_hai_ham_AND_va_ham_OR\" >H\u00e0m IF n\u00e2ng cao k\u1ebft h\u1ee3p v\u1edbi c\u1ea3 hai h\u00e0m AND v\u00e0 h\u00e0m OR<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#Loi_thuong_gap_va_cach_khac_phuc_trong_cach_su_dung_ham_IF_trong_Excel\" >L\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c trong c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Khai_niem_ham_IF_la_gi\"><\/span>Kh\u00e1i ni\u1ec7m h\u00e0m IF l\u00e0 g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m Excel; b\u1ea1n s\u1ebd g\u1eb7p ph\u1ea3i tr\u01b0\u1eddng h\u1ee3p y\u00eau c\u1ea7u ch\u1ecdn l\u1ecdc k\u1ebft qu\u1ea3 theo m\u1ed9t ho\u1eb7c c\u00e1c \u0111i\u1ec1u ki\u1ec7n kh\u00e1c \u0111\u00e3 cho tr\u01b0\u1edbc. \u0110\u1ec3 c\u00f3 th\u1ec3 ho\u00e0n th\u00e0nh y\u00eau c\u1ea7u tr\u00ean v\u00e0 cho k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c; ch\u00fang ta n\u00ean s\u1eed d\u1ee5ng h\u00e0m IF. H\u00e0m IF l\u00e0 m\u1ed9t h\u00e0m to\u00e1n h\u1ecdc kh\u00e1 ph\u1ed5 bi\u1ebfn v\u00e0 quan tr\u1ecdng nh\u1ea5t cho c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng h\u1ecdc sinh, sinh vi\u00ean v\u00e0 gi\u00e1o vi\u00ean. .<\/p>\n<p><iframe loading=\"lazy\" title=\"H\u00e0m IF - t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/7gQe3B7JcRg?start=1&#038;feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p style=\"text-align: justify;\">H\u00e0m IF l\u00e0 m\u1ed9t h\u00e0m logic g\u1ed3m c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau; d\u00f9ng \u0111\u1ec3 y\u00eau c\u1ea7u thu\u1eadt to\u00e1n Excel ki\u1ec3m tra m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3 xem c\u00f3 \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c hay kh\u00f4ng. N\u1ebfu c\u00f3 th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb c\u00f2n kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb kh\u00e1c. N\u00f3i t\u00f3m l\u1ea1i, h\u00e0m IF trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u xem n\u00f3 c\u00f3 th\u1ecfa \u0111i\u1ec1u ki\u1ec7n; m\u00e0 \u0111\u1ed1i ph\u01b0\u01a1ng \u0111\u1eb7t ra hay kh\u00f4ng v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 theo logic \u0111\u00fang ho\u1eb7c sai.<\/p>\n<figure id=\"attachment_11179\" aria-describedby=\"caption-attachment-11179\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11179 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-if.jpg\" alt=\"Kh\u00e1i ni\u1ec7m h\u00e0m IF\" width=\"600\" height=\"336\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-if.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-if-400x224.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11179\" class=\"wp-caption-text\">Kh\u00e1i ni\u1ec7m h\u00e0m IF<\/figcaption><\/figure>\n<p style=\"text-align: justify;\">V\u00ed d\u1ee5 th\u1ef1c t\u1ebf:<\/p>\n<ul>\n<li style=\"text-align: justify;\">\u0110\u1ea1t nh\u00e2n vi\u00ean xu\u1ea5t s\u1eafc khi doanh s\u1ed1 b\u00e1n h\u00e0ng tr\u00ean 100 tri\u1ec7u \u0111\u1ed3ng; \u0111\u1ea1t nh\u00e2n vi\u00ean gi\u1ecfi khi doanh s\u1ed1 b\u00e1n h\u00e0ng t\u1eeb 50-100 tri\u1ec7u \u0111\u1ed3ng; nh\u00e2n vi\u00ean ho\u00e0n th\u00e0nh nhi\u1ec7m v\u1ee5 khi doanh s\u1ed1 b\u00e1n h\u00e0ng t\u1eeb 30-50 tri\u1ec7u \u0111\u1ed3ng, nh\u00e2n vi\u00ean ch\u01b0a ho\u00e0n th\u00e0nh nhi\u1ec7m v\u1ee5 khi doanh s\u1ed1 b\u00e1n h\u00e0ng d\u01b0\u1edbi 30 tri\u1ec7u \u0111\u1ed3ng.<\/li>\n<li style=\"text-align: justify;\">N\u1ebfu \u0111i\u1ec3m r\u00e8n luy\u1ec7n c\u1ee7a sinh vi\u00ean t\u1eeb 90 \u0111i\u1ec3m tr\u1edf l\u00ean th\u00ec x\u1ebfp lo\u1ea1i xu\u1ea5t s\u1eafc, n\u1ebfu t\u1eeb 80-90 \u0111i\u1ec3m th\u00ec x\u1ebfp lo\u1ea1i gi\u1ecfi, n\u1ebfu t\u1eeb 65-79 th\u00ec x\u1ebfp lo\u1ea1i kh\u00e1.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Phan_loai_cac_cach_su_dung_ham_IF_trong_Excel\"><\/span>Ph\u00e2n lo\u1ea1i c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">S\u1eed d\u1ee5ng h\u00e0m IF d\u1ec5 hay kh\u00f3 l\u00e0 c\u00e2u h\u1ecfi c\u1ee7a v\u00f4 s\u1ed1 b\u1ea1n h\u1ecdc sinh, sinh vi\u00ean. Th\u1ef1c ra, n\u1ebfu ch\u00fang ta hi\u1ec3u v\u1ec1 b\u1ea3n ch\u1ea5t c\u1ee7a n\u00f3 th\u00ec kh\u00f4ng c\u00f3 g\u00ec kh\u00f3 kh\u0103n c\u1ea3. T\u00f9y v\u00e0o t\u1eebng tr\u01b0\u1eddng h\u1ee3p m\u00e0 ng\u01b0\u1eddi ta c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF ph\u00f9 h\u1ee3p nh\u1ea5t. N\u1ebfu g\u1eb7p b\u00e0i to\u00e1n y\u00eau c\u1ea7u nhi\u1ec1u h\u01a1n 2 s\u1ef1 l\u1ef1a ch\u1ecdn th\u00ec ta l\u1ea1i \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m IF l\u1ed3ng gh\u00e9p.<\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_IF_co_ban_trong_Excel\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF c\u01a1 b\u1ea3n trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">&#8211; S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m IF c\u01a1 b\u1ea3n r\u1ea5t d\u1ec5 v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel c\u0169ng kh\u00e1 \u0111\u01a1n gi\u1ea3n.<\/p>\n<p style=\"text-align: justify;\">&#8211; C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m IF \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau: =IF(\u0111i\u1ec1u ki\u1ec7n; gi\u00e1 tr\u1ecb 1; gi\u00e1 tr\u1ecb 2)<\/p>\n<p style=\"text-align: justify;\">Trong \u0111\u00f3:<\/p>\n<p style=\"text-align: justify;\">N\u1ebfu \u0111\u00fang, k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 1.<\/p>\n<p style=\"text-align: justify;\">N\u1ebfu sai, k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 2.<\/p>\n<p style=\"text-align: justify;\">V\u00ed d\u1ee5 th\u1ef1c t\u1ebf:<\/p>\n<ul>\n<li style=\"text-align: justify;\">Doanh s\u1ed1 b\u00e1n h\u00e0ng l\u1edbn h\u01a1n 100 tri\u1ec7u \u0111\u1ed3ng th\u00ec \u0111\u01b0\u1ee3c th\u01b0\u1edfng 10 tri\u1ec7u \u0111\u1ed3ng.<\/li>\n<li style=\"text-align: justify;\">Doanh s\u1ed1 b\u00e1n h\u00e0ng nh\u1ecf h\u01a1n 100 tri\u1ec7u \u0111\u1ed3ng th\u00ec kh\u00f4ng \u0111\u01b0\u1ee3c th\u01b0\u1edfng.<\/li>\n<\/ul>\n<figure id=\"attachment_11182\" aria-describedby=\"caption-attachment-11182\" style=\"width: 599px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11182 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/su-dung-ham-if-2.jpg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF c\u01a1 b\u1ea3n trong Excel\" width=\"599\" height=\"378\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/su-dung-ham-if-2.jpg 599w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/su-dung-ham-if-2-400x252.jpg 400w\" sizes=\"auto, (max-width: 599px) 100vw, 599px\" \/><figcaption id=\"caption-attachment-11182\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF c\u01a1 b\u1ea3n trong Excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_IF_nang_cao_trong_Excel\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF n\u00e2ng cao trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"text-align: justify;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF n\u00e2ng cao (h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n) trong Excel \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng cho b\u00e0i to\u00e1n c\u1ea7n ph\u1ea3i ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3. Ng\u01b0\u1eddi ta \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m IF n\u00e2ng cao nh\u1edd v\u00e0o \u01b0u \u0111i\u1ec3m l\u00e0 l\u1ecdc d\u1eef li\u1ec7u v\u00e0 \u0111\u01b0a v\u1ec1 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau, ph\u1ee5 thu\u1ed9c v\u00e0o c\u00e1c thao t\u00e1c m\u00e0 ch\u00fang ta \u0111\u00e3 ki\u1ec3m tra ban \u0111\u1ea7u.<\/li>\n<li style=\"text-align: justify;\">C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m IF n\u00e2ng cao nh\u01b0 sau: =IF (logical_test; [value_if_true]; [value_if_false])<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">H\u00e0m IF n\u00e2ng cao c\u00f3 ba tham s\u1ed1, nh\u01b0ng gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean th\u00ec b\u1eaft bu\u1ed9c c\u00f2n hai tham s\u1ed1 kia l\u00e0 kh\u00f4ng b\u1eaft bu\u1ed9c.<\/p>\n<p style=\"text-align: justify;\">Trong \u0111\u00f3:<\/p>\n<ul>\n<li style=\"text-align: justify;\">logical_test (tham s\u1ed1 b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3) c\u00f3 nhi\u1ec7m v\u1ee5 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n. \u0110\u00e2y l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb ho\u1eb7c bi\u1ec3u th\u1ee9c logic c\u00f3 gi\u00e1 tr\u1ecb TRUE (\u0111\u00fang) ho\u1eb7c FALSE (sai).<\/li>\n<li style=\"text-align: justify;\">\u00a0value_if_true (tham s\u1ed1 kh\u00f4ng b\u1eaft bu\u1ed9c): N\u1ebfu gi\u00e1 tr\u1ecb c\u1ea7n so s\u00e1nh \u0111\u00fang \u0111i\u1ec1u ki\u1ec7n th\u00ec h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb do ng\u01b0\u1eddi d\u00f9ng nh\u1eadp v\u00e0o theo \u00fd mu\u1ed1n.<\/li>\n<li>value_if_false (tham s\u1ed1 kh\u00f4ng b\u1eaft bu\u1ed9c): Ng\u01b0\u1ee3c l\u1ea1i c\u1ee7a value_if_true, n\u1ebfu kh\u00f4ng \u0111\u00fang th\u00ec h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb kh\u00e1c v\u00e0 gi\u00e1 tr\u1ecb n\u00e0y c\u0169ng do ng\u01b0\u1eddi d\u00f9ng t\u1ef1 nh\u1eadp v\u00e0o.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Ch\u00fa \u00fd: Trong qu\u00e1 tr\u00ecnh b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m IF, n\u1ebfu nh\u01b0 b\u1ea1n b\u1ecf tr\u1ed1ng \u00f4 value_if_true v\u00e0 value_if_false, th\u00ec gi\u00e1 tr\u1ecb s\u1ebd tr\u1ebb v\u1ec1 0 n\u1ebfu nh\u01b0 \u0111i\u1ec1u ki\u1ec7n th\u1ecfa m\u00e3n y\u00eau c\u1ea7u v\u00e0 s\u1ebd tr\u1ea3 v\u1ec1 FALSE n\u1ebfu \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng th\u1ecfa m\u00e3n y\u00eau c\u1ea7u.<\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_IF_nang_cao_ket_hop_voi_ham_AND\"><\/span>H\u00e0m IF n\u00e2ng cao k\u1ebft h\u1ee3p v\u1edbi h\u00e0m AND<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">Nhi\u1ec1u b\u1ea1n th\u1eafc m\u1eafc t\u1ea1i sao c\u00f3 m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c c\u00f3 ch\u1ee9a h\u00e0m AND. Khi s\u1eed d\u1ee5ng h\u00e0m AND k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF trong tr\u01b0\u1eddng h\u1ee3p b\u00e0i to\u00e1n \u0111\u00f3 c\u00f3 nhi\u1ec1u ki\u1ec7n k\u00e8m theo v\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3 x\u1ea3y ra \u0111\u1ed3ng th\u1eddi. V\u00ec v\u1eady, ch\u00fang ta c\u1ea7n s\u1eed d\u1ee5ng th\u00eam m\u1ed9t h\u00e0m n\u1eefa l\u00e0 h\u00e0m AND trong bi\u1ec3u th\u1ee9c \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p style=\"text-align: justify;\">C\u00fa ph\u00e1p (c\u00f4ng th\u1ee9c) c\u1ee7a h\u00e0m AND trong Excel: AND(logical1; logical2;&#8230;)<\/p>\n<p style=\"text-align: justify;\">Trong \u0111\u00f3: logical1; logical2 l\u00e0 c\u00e1c m\u1ec7nh \u0111\u1ec1 logic.<\/p>\n<p style=\"text-align: justify;\">K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m AND s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 nh\u01b0 sau:<\/p>\n<ul style=\"list-style-type: disc;\">\n<li style=\"text-align: justify;\">TRUE: N\u1ebfu c\u00e1c m\u1ec7nh \u0111\u1ec1 logic \u0111\u1ec1u \u0111\u00fang.<\/li>\n<li style=\"text-align: justify;\">FALSE: N\u1ebfu c\u00f3 m\u1ed9t trong c\u00e1c m\u1ec7nh \u0111\u1ec1 logic trong h\u00e0m b\u1ecb sai.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">T\u00f3m l\u1ea1i, khi b\u1ea1n th\u1ea5y h\u00e0m AND k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF trong Excel th\u00ec b\u1ea1n ph\u1ea3i \u0111\u1eb7t h\u00e0m AND trong bi\u1ec3u th\u1ee9c c\u1ee7a h\u00e0m IF \u0111\u1ec3 x\u00e9t \u0111i\u1ec1u ki\u1ec7n th\u00ec m\u1edbi cho k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c. N\u1ebfu kh\u00f4ng, k\u1ebft qu\u1ea3 s\u1ebd cho ra l\u00e0 sai.<\/p>\n<p style=\"text-align: justify;\">V\u00ed d\u1ee5: Khi \u0111\u01b0a ra k\u1ebft qu\u1ea3 thi tuy\u1ec3n v\u00e0o l\u1edbp 10 c\u1ee7a tr\u01b0\u1eddng THPT Y\u00ean Th\u00e0nh 2, Ngh\u1ec7 An n\u0103m 2019 l\u00e0 d\u1ef1a v\u00e0o \u0111i\u1ec3m thi c\u1ee7a 2 m\u00f4n l\u00e0 To\u00e1n v\u00e0 Anh. \u0110i\u1ec1u ki\u1ec7n x\u00e9t tuy\u1ec3n n\u1ebfu h\u1ecdc sinh \u0111\u1eadu ph\u1ea3i \u0111\u1ea1t t\u1ed5ng \u0111i\u1ec3m 3 m\u00f4n l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 16.25 \u0111i\u1ec3m v\u00e0 kh\u00f4ng c\u00f3 m\u00f4n n\u00e0o \u0111i\u1ec3m ch\u1ebft. \u0110\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p n\u00e0y, c\u00e1ch t\u1ed1t nh\u1ea5t l\u00e0 s\u1eed d\u1ee5ng h\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi h\u00e0m AND v\u1edbi \u0111i\u1ec1u ki\u1ec7n l\u00e0 t\u1ed5ng \u0111i\u1ec3m &gt;=16.25 v\u00e0 kh\u00f4ng c\u00f3 m\u00f4n n\u00e0o c\u00f3 \u0111i\u1ec3m 0.<\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_IF_nang_cao_ket_hop_voi_ham_OR_trong_dieu_kien_nao\"><\/span>H\u00e0m IF n\u00e2ng cao k\u1ebft h\u1ee3p v\u1edbi h\u00e0m OR trong \u0111i\u1ec1u ki\u1ec7n n\u00e0o?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_11181\" aria-describedby=\"caption-attachment-11181\" style=\"width: 599px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11181 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/su-dung-ham-if-1-e1646815207921.jpg\" alt=\"H\u00e0m IF n\u00e2ng cao k\u1ebft h\u1ee3p v\u1edbi h\u00e0m OR trong \u0111i\u1ec1u ki\u1ec7n n\u00e0o?\" width=\"599\" height=\"335\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/su-dung-ham-if-1-e1646815207921.jpg 599w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/su-dung-ham-if-1-e1646815207921-400x224.jpg 400w\" sizes=\"auto, (max-width: 599px) 100vw, 599px\" \/><figcaption id=\"caption-attachment-11181\" class=\"wp-caption-text\">H\u00e0m IF n\u00e2ng cao k\u1ebft h\u1ee3p v\u1edbi h\u00e0m OR trong \u0111i\u1ec1u ki\u1ec7n n\u00e0o?<\/figcaption><\/figure>\n<p style=\"text-align: justify;\">V\u1edbi nh\u1eefng b\u00e0i to\u00e1n g\u1ed3m nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n; k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng \u0111\u01b0a v\u1ec1 ch\u1ec9 c\u1ea7n \u0111\u00e1p \u1ee9ng m\u1ed9t trong c\u00e1c \u0111i\u1ec1u ki\u1ec7n th\u00ec ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m OR \u0111\u1ec3 \u0111\u01b0a ra k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c cu\u1ed1i c\u00f9ng.<\/p>\n<p style=\"text-align: justify;\">C\u00f4ng th\u1ee9c t\u00ednh c\u1ee7a h\u00e0m OR trong Excel: OR((logical1; logical2;&#8230;)<\/p>\n<p style=\"text-align: justify;\">Trong \u0111\u00f3: logical1; logical2 l\u00e0 c\u00e1c m\u1ec7nh \u0111\u1ec1 logic.<\/p>\n<p style=\"text-align: justify;\">K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m OR \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1: :<\/p>\n<ul>\n<li style=\"text-align: justify;\">TRUE: N\u1ebfu m\u1ec7nh \u0111\u1ec1 b\u1ea5t k\u00ec trong h\u00e0m OR l\u00e0 \u0111\u00fang.<\/li>\n<li style=\"text-align: justify;\">FALSE: N\u1ebfu t\u1ea5t c\u1ea3 m\u1ec7nh \u0111\u1ec1 b\u00ean trong h\u00e0m OR \u0111\u1ec1u sai.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Nh\u01b0 v\u1eady, c\u0169ng gi\u1ed1ng nh\u01b0 h\u00e0m AND, h\u00e0m OR khi k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF c\u0169ng s\u1ebd n\u1eb1m trong bi\u1ec3u th\u1ee9c logic c\u1ee7a h\u00e0m IF.<\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_IF_nang_cao_ket_hop_voi_ca_hai_ham_AND_va_ham_OR\"><\/span>H\u00e0m IF n\u00e2ng cao k\u1ebft h\u1ee3p v\u1edbi c\u1ea3 hai h\u00e0m AND v\u00e0 h\u00e0m OR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">Trong tr\u01b0\u1eddng h\u1ee3p ph\u1ea3i \u0111\u00e1nh gi\u00e1 d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec7n ki\u1ec7n; ng\u01b0\u1eddi ta ph\u1ea3i \u00e1p d\u1ee5ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi h\u00e0m AND v\u00e0 h\u00e0m OR \u0111\u1ed3ng th\u1eddi.<\/p>\n<p style=\"text-align: justify;\">Ch\u00fang ta s\u1ebd k\u1ebft h\u1ee3p c\u1ea3 hai h\u00e0m AND v\u00e0 OR l\u1ea1i \u0111\u1ec3 \u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n cho bi\u1ec3u th\u1ee9c; sao cho h\u1ee3p l\u00fd v\u00e0 ph\u00f9 h\u1ee3p nh\u1ea5t v\u1edbi th\u1ef1c t\u1ebf c\u1ee7a b\u00e0i to\u00e1n \u0111\u01b0a ra.<\/p>\n<figure id=\"attachment_11185\" aria-describedby=\"caption-attachment-11185\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11185 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-if-1-1-e1646815139285.jpg\" alt=\"H\u00e0m IF n\u00e2ng cao k\u1ebft h\u1ee3p v\u1edbi c\u1ea3 hai h\u00e0m AND v\u00e0 h\u00e0m OR\" width=\"600\" height=\"262\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-if-1-1-e1646815139285.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-if-1-1-e1646815139285-400x175.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11185\" class=\"wp-caption-text\">H\u00e0m IF n\u00e2ng cao k\u1ebft h\u1ee3p v\u1edbi c\u1ea3 hai h\u00e0m AND v\u00e0 h\u00e0m OR<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Loi_thuong_gap_va_cach_khac_phuc_trong_cach_su_dung_ham_IF_trong_Excel\"><\/span>L\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c trong c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">&#8211; \u00d4 tr\u1ea3 k\u1ebft qu\u1ea3 v\u1ec1 b\u1eb1ng 0<\/p>\n<p style=\"text-align: justify;\">K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 b\u1eb1ng 0 khi m\u1ed9t trong hai gi\u00e1 tr\u1ecb value_if_true ho\u1eb7c value_if_false \u0111ang \u0111\u1ec3 tr\u1ed1ng.<\/p>\n<p style=\"text-align: justify;\">\u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y ngh\u0129a l\u00e0 s\u1ebd \u0111\u1ec3 gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 l\u00e0 \u0111\u1ec3 tr\u1ed1ng; thay v\u00ec hi\u1ec7n s\u1ed1 0 th\u00ec ch\u00fang ta ph\u1ea3i th\u00eam d\u1ea5u ngo\u1eb7c k\u00e9p (&#8220;&#8221;); ho\u1eb7c ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 th\u00eam gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 tr\u1ea3 v\u1ec1.<\/p>\n<p style=\"text-align: justify;\">&#8211; K\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb v\u1ec1 l\u00e0 #NAME<\/p>\n<p style=\"text-align: justify;\">L\u1ed7i n\u00e0y th\u00ec kh\u00e1 \u0111\u01a1n gi\u1ea3n, c\u00f3 th\u1ec3 trong qu\u00e1 tr\u00ecnh nh\u1eadp c\u00f4ng th\u1ee9c; b\u1ea1n \u0111\u00e3 nh\u1eadp sai ch\u00ednh t\u1ea3 \u1edf c\u00f4ng th\u1ee9c n\u00e0o \u0111\u00f3. \u0110\u1ec3 kh\u1eafc ph\u1ee5c, ch\u00fang ta ch\u1ec9 c\u1ea7n ki\u1ec3m tra v\u00e0 so\u00e1t l\u1ea1i cho \u0111\u00fang ch\u00ednh t\u1ea3.<\/p>\n<p style=\"text-align: justify;\">Tr\u00ean \u0111\u00e2y l\u00e0 to\u00e0n b\u1ed9 ki\u1ebfn th\u1ee9c v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel; m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n. N\u1ebfu b\u1ea1n c\u00f2n b\u1ea5t c\u1ee9 th\u1eafc m\u1eafc n\u00e0o, h\u00e3y li\u00ean h\u1ec7 ngay \u0111\u1ec3 \u0111\u01b0\u1ee3c t\u01b0 v\u1ea5n v\u00e0 h\u1ed7 tr\u1ee3 nh\u00e9.<\/p>\n<p style=\"text-align: justify;\">Xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft:<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/ham-int-trong-excel\/\">H\u00e0m INT trong Excel v\u00e0 nh\u1eefng \u0111i\u1ec1u quan tr\u1ecdng c\u1ea7n bi\u1ebft<\/a><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumif\/\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong Excel hi\u1ec7u qu\u1ea3<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel to\u00e1n h\u1ecdc \u0111\u1ed1i v\u1edbi h\u1ecdc sinh, sinh vi\u00ean nh\u01b0 th\u1ebf n\u00e0o? C\u00f3 th\u1ec3 n\u00f3i, \u0111\u00e2y l\u00e0 h\u00e0m y\u00eau c\u1ea7u Excel ki\u1ec3m tra m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3 v\u00e0 n\u1ebfu n\u00f3 \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c; c\u00f2n n\u1ebfu \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng \u0111\u00e1p \u1ee9ng &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11183,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11169","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/title>\n<meta name=\"description\" content=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel l\u00e0 \u0111i\u1ec1u kh\u00f4ng th\u1ec3 thi\u1ebfu \u0111\u1ed1i v\u1edbi m\u1ed7i ng\u01b0\u1eddi khi s\u1ed1ng trong th\u1ebf h\u1ec7 s\u1ed1 ng\u00e0y nay. V\u1eady h\u00e0m IF c\u00f3 ch\u1ee9c n\u0103ng ra sao\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u\" \/>\n<meta property=\"og:description\" content=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel l\u00e0 \u0111i\u1ec1u kh\u00f4ng th\u1ec3 thi\u1ebfu \u0111\u1ed1i v\u1edbi m\u1ed7i ng\u01b0\u1eddi khi s\u1ed1ng trong th\u1ebf h\u1ec7 s\u1ed1 ng\u00e0y nay. V\u1eady h\u00e0m IF c\u00f3 ch\u1ee9c n\u0103ng ra sao\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-11T05:46:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-13T07:32:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-if.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"338\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u\",\"datePublished\":\"2022-11-11T05:46:38+00:00\",\"dateModified\":\"2022-12-13T07:32:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/\"},\"wordCount\":2359,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-if.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-if.jpg\",\"datePublished\":\"2022-11-11T05:46:38+00:00\",\"dateModified\":\"2022-12-13T07:32:20+00:00\",\"description\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel l\u00e0 \u0111i\u1ec1u kh\u00f4ng th\u1ec3 thi\u1ebfu \u0111\u1ed1i v\u1edbi m\u1ed7i ng\u01b0\u1eddi khi s\u1ed1ng trong th\u1ebf h\u1ec7 s\u1ed1 ng\u00e0y nay. V\u1eady h\u00e0m IF c\u00f3 ch\u1ee9c n\u0103ng ra sao\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-if.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-if.jpg\",\"width\":600,\"height\":338,\"caption\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u","description":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel l\u00e0 \u0111i\u1ec1u kh\u00f4ng th\u1ec3 thi\u1ebfu \u0111\u1ed1i v\u1edbi m\u1ed7i ng\u01b0\u1eddi khi s\u1ed1ng trong th\u1ebf h\u1ec7 s\u1ed1 ng\u00e0y nay. V\u1eady h\u00e0m IF c\u00f3 ch\u1ee9c n\u0103ng ra sao","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u","og_description":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel l\u00e0 \u0111i\u1ec1u kh\u00f4ng th\u1ec3 thi\u1ebfu \u0111\u1ed1i v\u1edbi m\u1ed7i ng\u01b0\u1eddi khi s\u1ed1ng trong th\u1ebf h\u1ec7 s\u1ed1 ng\u00e0y nay. V\u1eady h\u00e0m IF c\u00f3 ch\u1ee9c n\u0103ng ra sao","og_url":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-11T05:46:38+00:00","article_modified_time":"2022-12-13T07:32:20+00:00","og_image":[{"width":600,"height":338,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-if.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u","datePublished":"2022-11-11T05:46:38+00:00","dateModified":"2022-12-13T07:32:20+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/"},"wordCount":2359,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-if.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-if.jpg","datePublished":"2022-11-11T05:46:38+00:00","dateModified":"2022-12-13T07:32:20+00:00","description":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel l\u00e0 \u0111i\u1ec1u kh\u00f4ng th\u1ec3 thi\u1ebfu \u0111\u1ed1i v\u1edbi m\u1ed7i ng\u01b0\u1eddi khi s\u1ed1ng trong th\u1ebf h\u1ec7 s\u1ed1 ng\u00e0y nay. V\u1eady h\u00e0m IF c\u00f3 ch\u1ee9c n\u0103ng ra sao","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-if.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-su-dung-ham-if.jpg","width":600,"height":338,"caption":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11169"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11169\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11183"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}