{"id":4425,"date":"2024-12-05T09:14:33","date_gmt":"2024-12-05T09:14:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/ham-tinh-giai-thua-trong-excel\/"},"modified":"2024-12-05T09:14:33","modified_gmt":"2024-12-05T09:14:33","slug":"ham-tinh-giai-thua-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/ham-tinh-giai-thua-trong-excel\/","title":{"rendered":"H\u00e0m t\u00ednh Giai th\u1eeba trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong qu\u00e1 tr\u00ecnh h\u1ecdc ph\u1ed5 th\u00f4ng ch\u00fang ta ch\u1eafc h\u1eb3n\u00a0\u0111\u00e3 h\u1ecdc qua v\u00e0 bi\u1ebft c\u00e1ch t\u00ednh\u00a0giai th\u1eeba r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o, n\u1ebfu nh\u01b0 b\u1ea1n\u00a0\u0111\u00e3 qu\u00ean th\u00ec h\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\">Hoc\u00a0Excel Online<\/a> xem l\u1ea1i v\u1ec1 giai th\u1eeba v\u00e0o trong\u00a0Excel th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 t\u00ednh\u00a0\u0111\u01b0\u1ee3c giai th\u1eeba kh\u00f4ng v\u00e0 b\u1eb1ng nh\u1eefng c\u00e1ch n\u00e0o.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67516ef86a71d\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-tinh-giai-thua-trong-excel.html#Cach_tinh_giai_thua_trong_Excel\" title=\"C\u00e1ch t\u00ednh giai th\u1eeba trong\u00a0Excel\">C\u00e1ch t\u00ednh giai th\u1eeba trong\u00a0Excel<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-tinh-giai-thua-trong-excel.html#Gioi_thieu_qua_ve_Giai_thua\" title=\"Gi\u1edbi thi\u1ec7u qua v\u1ec1 Giai th\u1eeba\">Gi\u1edbi thi\u1ec7u qua v\u1ec1 Giai th\u1eeba<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-tinh-giai-thua-trong-excel.html#Cach_tinh_giai_thua_trong_Excel_bang_ham_FACT\" title=\"C\u00e1ch t\u00ednh giai th\u1eeba trong\u00a0Excel b\u1eb1ng h\u00e0m FACT\">C\u00e1ch t\u00ednh giai th\u1eeba trong\u00a0Excel b\u1eb1ng h\u00e0m FACT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-tinh-giai-thua-trong-excel.html#Mot_so_chu_y\" title=\"M\u1ed9t s\u1ed1 ch\u00fa\u00a0\u00fd\">M\u1ed9t s\u1ed1 ch\u00fa\u00a0\u00fd<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Cach_tinh_giai_thua_trong_Excel\"><\/span>C\u00e1ch t\u00ednh giai th\u1eeba trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<h2><span class=\"ez-toc-section\" id=\"Gioi_thieu_qua_ve_Giai_thua\"><\/span>Gi\u1edbi thi\u1ec7u qua v\u1ec1 Giai th\u1eeba<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Theo Wikipedia th\u00ec\u00a0giai th\u1eeba l\u00e0 m\u1ed9t to\u00e1n t\u1eed m\u1ed9t ng\u00f4i tr\u00ean t\u1eadp h\u1ee3p c\u00e1c s\u1ed1 t\u1ef1 nhi\u00ean. Cho <strong>n<\/strong> l\u00e0 m\u1ed9t s\u1ed1 t\u1ef1 nhi\u00ean d\u01b0\u01a1ng, \u201c<strong>n giai th\u1eeba<\/strong>\u201c, k\u00fd hi\u1ec7u <strong>n!<\/strong> l\u00e0 t\u00edch c\u1ee7a n s\u1ed1 t\u1ef1 nhi\u00ean d\u01b0\u01a1ng \u0111\u1ea7u ti\u00ean, hay \u0111\u1ec3 d\u1ec5 hi\u1ec3u h\u01a1n th\u00ec giai th\u1eeba \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng t\u00edch c\u1ee7a c\u00e1c s\u1ed1\u00a0t\u1ef1 nhi\u00ean l\u1edbn s\u1ed1 \u0111\u00f3, <strong>ngo\u1ea1i tr\u1eeb s\u1ed1 0<\/strong>.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">n! = 1*2*3*\u2026* n<br \/>\nVD: 4! = 1*2*3*4 = 24<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd: V\u1edbi n = 0 ta c\u00f3 n! = 1.<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: center\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/07\/1-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28214\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-2-3.png\" width=\"301\" height=\"486\" title=\"1-2-3\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tinh_giai_thua_trong_Excel_bang_ham_FACT\"><\/span>C\u00e1ch t\u00ednh giai th\u1eeba trong\u00a0Excel b\u1eb1ng h\u00e0m FACT<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong\u00a0Excel c\u00f3 m\u1ed9t h\u00e0m h\u1ed7 tr\u1ee3 cho vi\u1ec7c t\u00ednh giai th\u1eeba n\u00e0y,\u00a0\u0111\u00f3 l\u00e0 h\u00e0m FACT. H\u00e0m tr\u1ea3 v\u1ec1 giai th\u1eeba c\u1ee7a m\u1ed9t s\u1ed1 v\u00e0 c\u00f3 c\u00fa ph\u00e1p h\u00e0m \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>FACT(number)<\/strong><\/p>\n<p><strong>number: l\u00e0 m\u1ed9t s\u1ed1 kh\u00f4ng\u00a0\u00e2m m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh giai th\u1eeba.<\/strong><\/p>\n<\/blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/07\/2-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28215\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-2-2.png\" width=\"960\" height=\"755\" title=\"2-2-2\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mot_so_chu_y\"><\/span>M\u1ed9t s\u1ed1 ch\u00fa\u00a0\u00fd<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>N\u1ebfu number &lt;0 th\u00ec h\u00e0m FACT s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i <strong>#NUM!<\/strong><\/li>\n<li>N\u1ebfu\u00a0number kh\u00f4ng ph\u1ea3i l\u00e0 ki\u1ec3u s\u1ed1\u00a0th\u00ec h\u00e0m FACT s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i <strong>#VALUE!<\/strong><\/li>\n<li>N\u1ebfu number l\u00e0 m\u1ed9t s\u1ed1 th\u1eadp ph\u00e2n th\u00ec h\u00e0m FACT s\u1ebd l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a number \u0111\u1ec3 t\u00ednh giai th\u1eeba.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Hy v\u1ecdng, qua b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\">Hoc\u00a0Excel Online<\/a> c\u00e1c b\u1ea1n\u00a0\u0111\u00e3 bi\u1ebft c\u00e1ch t\u00ednh giai th\u1eeba c\u1ee7a m\u1ed9t s\u1ed1 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FACT m\u00e0\u00a0Excel\u00a0\u0111\u00e3 h\u1ed7 tr\u1ee3. Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n<hr>\n<p style=\"text-align: justify\">\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=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2019\/09\/EX101_92019-nho.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4426,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4425","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4425","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=4425"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4425\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4426"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}