{"id":12234,"date":"2025-01-15T07:43:29","date_gmt":"2025-01-15T07:43:29","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-even-va-ham-odd-trong-excel\/"},"modified":"2025-01-15T07:43:29","modified_gmt":"2025-01-15T07:43:29","slug":"ham-even-va-ham-odd-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-even-va-ham-odd-trong-excel\/","title":{"rendered":"H\u00e0m EVEN v\u00e0 h\u00e0m ODD trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>H\u00e0m EVEN v\u00e0 h\u00e0m ODD l\u00e0 hai h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 r\u1ea5t \u0111\u01a1n gi\u1ea3n. EVEN() l\u00e0m tr\u00f2n \u0111\u1ebfn s\u1ed1 nguy\u00ean ch\u1eb5n g\u1ea7n nh\u1ea5t, c\u00f2n ODD() l\u00e0m tr\u00f2n \u0111\u1ebfn s\u1ed1 nguy\u00ean l\u1ebb g\u1ea7n nh\u1ea5t. C\u1ea3 hai \u0111\u1ec1u l\u00e0m tr\u00f2n theo ki\u1ec3u ch\u1ea1y xa kh\u1ecfi s\u1ed1 0.<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><strong>1\/ H\u00e0m EVEN:<\/strong><\/p>\n<p style=\"text-align: justify\">\u2013 C\u00fa ph\u00e1p:\u00a0<strong>= EVEN(number)<\/strong><\/p>\n<p style=\"text-align: justify\">\u2013 V\u00ed d\u1ee5:<\/p>\n<ul style=\"text-align: justify\">\n<li>L\u00e0m tr\u00f2n 2 s\u1ed1 cho d\u01b0\u1edbi \u0111\u00e2y v\u1ec1\u00a0m\u1ed9t s\u1ed1 g\u1ea7n nh\u1ea5t l\u00e0 s\u1ed1 nguy\u00ean ch\u1eb5n.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3684 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-even-2.png\" width=\"374\" height=\"129\" title=\"ham-even-2\"><\/p>\n<ul style=\"text-align: justify\">\n<li>D\u00f9ng h\u00e0m <strong>EVEN<\/strong>, thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3683 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-even-1.png\" width=\"600\" height=\"409\" title=\"ham-even-1\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">h\u00e0m excel<\/a> c\u01a1 b\u1ea3n<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>2\/ H\u00e0m ODD:<\/strong><\/p>\n<p style=\"text-align: justify\">\u2013 C\u00fa ph\u00e1p:\u00a0<strong>= ODD(number)<\/strong><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-371.gif\" title=\"ex101_92019-nho-371\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">\u2013 V\u00ed d\u1ee5:<\/p>\n<ul style=\"text-align: justify\">\n<li>L\u00e0m tr\u00f2n 2 s\u1ed1 cho d\u01b0\u1edbi \u0111\u00e2y v\u1ec1\u00a0m\u1ed9t s\u1ed1 g\u1ea7n nh\u1ea5t l\u00e0 s\u1ed1 nguy\u00ean l\u1ebb.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3685 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-even-3.png\" alt=\"ham-odd\" width=\"389\" height=\"130\" title=\"ham-even-3\"><\/p>\n<ul style=\"text-align: justify\">\n<li>D\u00f9ng h\u00e0m <strong>ODD<\/strong>, thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3686 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-even-4.png\" alt=\"ham-odd\" width=\"600\" height=\"408\" title=\"ham-even-4\"><\/p>\n<p style=\"text-align: justify\">Th\u1ebf l\u00e0 xong.<\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Round \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong excel <a href=\"https:\/\/blog.hocexcel.online\/ham-lam-tron-round-trong-excel.html\" target=\"_blank\">t\u1ea1i \u0111\u00e2y<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-371.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12235,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12234","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12234","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=12234"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12234\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12235"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}