{"id":8376,"date":"2024-12-22T14:19:46","date_gmt":"2024-12-22T14:19:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/ham-danh-so-thu-tu-bang-ky-hieu-la-ma-trong-excel\/"},"modified":"2024-12-22T14:19:46","modified_gmt":"2024-12-22T14:19:46","slug":"ham-danh-so-thu-tu-bang-ky-hieu-la-ma-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/ham-danh-so-thu-tu-bang-ky-hieu-la-ma-trong-excel\/","title":{"rendered":"H\u00e0m \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng k\u00fd hi\u1ec7u la m\u00e3 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00e0m n\u00e0o cho ph\u00e9p <strong>\u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 la m\u00e3<\/strong>? L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng k\u00fd hi\u1ec7u la m\u00e3?\u00a0 <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong> <\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 la m\u00e3 b\u1eb1ng h\u00e0m ROMAN trong Excel ngay sau \u0111\u00e2y.<\/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-6768200166333\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-danh-thu-tu-bang-ky-hieu-la-ma-trong-excel.html#Ham_danh_so_thu_tu_la_ma_%E2%80%93_ham_ROMAN\" title=\"H\u00e0m \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 la m\u00e3 \u2013 h\u00e0m ROMAN\">H\u00e0m \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 la m\u00e3 \u2013 h\u00e0m ROMAN<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-danh-thu-tu-bang-ky-hieu-la-ma-trong-excel.html#Y_nghia\" title=\"\u00dd ngh\u0129a\">\u00dd ngh\u0129a<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-danh-thu-tu-bang-ky-hieu-la-ma-trong-excel.html#Cong_thuc\" title=\"C\u00f4ng th\u1ee9c\">C\u00f4ng th\u1ee9c<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-danh-thu-tu-bang-ky-hieu-la-ma-trong-excel.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-danh-thu-tu-bang-ky-hieu-la-ma-trong-excel.html#Moi_tuong_quan_giua_so_La_Ma_voi_chu_cai\" title=\"M\u1ed1i t\u01b0\u01a1ng quan gi\u1eefa s\u1ed1 La M\u00e3 v\u1edbi ch\u1eef c\u00e1i\">M\u1ed1i t\u01b0\u01a1ng quan gi\u1eefa s\u1ed1 La M\u00e3 v\u1edbi ch\u1eef c\u00e1i<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_danh_so_thu_tu_la_ma_%E2%80%93_ham_ROMAN\"><\/span>H\u00e0m \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 la m\u00e3 \u2013 h\u00e0m ROMAN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Y_nghia\"><\/span>\u00dd ngh\u0129a<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m ROMAN s\u1ebd chuy\u1ec3n m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1 Arab (1, 2, 3, 4, 5\u2026) th\u00e0nh s\u1ed1 la m\u00e3 (I, II, II, IV, V\u2026) d\u01b0\u1edbi d\u1ea1ng Text.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc\"><\/span><strong>C\u00f4ng th\u1ee9c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m ROMAN nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=ROMAN(s\u1ed1 c\u1ea7n chuy\u1ec3n, [d\u1ea1ng chuy\u1ec3n])<\/strong><\/p>\n<\/blockquote>\n<p>Nh\u1eefng d\u1ea1ng chuy\u1ec3n ta c\u00f3 nh\u01b0 sau:<\/p>\n<p><strong>0, TRUE ho\u1eb7c \u0111\u1ec3 tr\u1ed1ng \u2013\u00a0<\/strong>d\u1ea1ng ph\u1ed5 th\u00f4ng<\/p>\n<p><strong>1, 2, 3<\/strong><em> \u2013 <\/em>d\u1ea1ng\u00a0ng\u1eafn g\u1ecdn h\u01a1n<\/p>\n<p><strong>4 ho\u1eb7c FALSE<\/strong><em>\u00a0\u2013\u00a0<\/em>d\u1ea1ng\u00a0gi\u1ea3n th\u1ec3<\/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\/2024\/12\/ex101_92019-nho-765.gif\" title=\"ex101_92019-nho-765\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ch\u00fa\u00a0\u00fd: V\u1edbi s\u1ed1 \u00e2m v\u00e0 s\u1ed1 l\u1edbn h\u01a1n 3999, gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 l\u00e0 #VALUE!<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span>V\u00ed d\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 chuy\u1ec3n s\u1ed1 499 th\u00e0nh ki\u1ec3u La M\u00e3, ta s\u1eed d\u1ee5ng 1 trong nh\u1eefng c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p><strong><em>=ROMAN(499,0)<\/em><\/strong>\u00a0=&gt; CDXCIX<\/p>\n<p>=<strong><em>ROMAN(499,1)\u00a0<\/em><\/strong>=&gt; LDVLIV<\/p>\n<p><em><strong>=ROMAN(499,2)<\/strong><\/em>\u00a0=&gt; XDIX<\/p>\n<p><strong><em>=ROMAN(499,3)<\/em><\/strong>\u00a0=&gt; VDIV<\/p>\n<p><strong><em>=ROMAN(499,4)<\/em><\/strong>\u00a0=&gt; ID<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Moi_tuong_quan_giua_so_La_Ma_voi_chu_cai\"><\/span>M\u1ed1i t\u01b0\u01a1ng quan gi\u1eefa s\u1ed1 La M\u00e3 v\u1edbi ch\u1eef c\u00e1i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea1n c\u00f3 th\u1ec3<strong> \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 La M\u00e3<\/strong> th\u1ee7 c\u00f4ng b\u1eb1ng tay trong tr\u01b0\u1eddng h\u1ee3p nh\u1edb b\u1ea3n ch\u1eef s\u1ed1 La M\u00e3. Ch\u1eb3ng h\u1ea1n nh\u01b0 1 = I, 5 = V, 10 = X\u2026 V\u1eady s\u1ed1 La M\u00e3 c\u00f3 kh\u00e1c k\u00ed t\u1ef1 ch\u1eef c\u00e1i tr\u00ean b\u00e0n ph\u00edm kh\u00f4ng? B\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u1ef1 ki\u1ec3m tra l\u1ea1i b\u1eb1ng h\u00e0m EXACT \u0111\u1ec3 bi\u1ebft c\u00e2u tr\u1ea3 l\u1eddi:<\/p>\n<figure id=\"attachment_28099\" aria-describedby=\"caption-attachment-28099\" style=\"width: 473px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-28099 size-full\" title=\"H\u00e0m \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 la m\u00e3 - h\u00e0m ROMAN\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-danh-so-thu-tu-bang-ki-hieu-la-ma-1.png\" alt=\"H\u00e0m \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 la m\u00e3 - h\u00e0m ROMAN\" width=\"473\" height=\"242\"><figcaption id=\"caption-attachment-28099\" class=\"wp-caption-text\"><em>H\u00e0m \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 la m\u00e3 \u2013 h\u00e0m ROMAN<\/em><\/figcaption><\/figure>\n<p>V\u00e0 h\u00e3y nh\u1edb r\u1eb1ng k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m ROMAN l\u00e0 d\u1ea1ng TEXT, b\u1ea1n kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh to\u00e1n v\u00e0 c\u0169ng kh\u00f4ng n\u00ean s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh to\u00e1n. V\u1edbi c\u00f4ng vi\u1ec7c c\u1ea7n s\u1eed d\u1ee5ng <strong>s\u1ed1 th\u1ee9 t\u1ef1 la m\u00e3<\/strong> \u0111\u1ec3 t\u00ednh to\u00e1n, h\u00e3y l\u00e0m theo quy lu\u1eadt <strong>t\u00ednh tr\u01b0\u1edbc, chuy\u1ec3n \u0111\u1ed5i sau<\/strong>.<\/p>\n<hr>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-chuyen-doi-kieu-chu-trong-excel.html\"><strong>H\u00e0m chuy\u1ec3n \u0111\u1ed5i ki\u1ec3u ch\u1eef trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-chuyen-doi-duong-lich-lich-trong-excel-voi-vba.html\"><strong>Chuy\u1ec3n \u0111\u1ed5i \u00e2m l\u1ecbch d\u01b0\u01a1ng l\u1ecbch b\u1eb1ng VBA<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/viet-so-la-ma-trong-excel.html\"><strong>H\u00e0m ROMAN trong Excel<\/strong><\/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\/2024\/12\/ex101_92019-nho-765.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8377,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8376","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\/8376","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=8376"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8376\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8377"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}