{"id":8660,"date":"2024-12-24T06:59:57","date_gmt":"2024-12-24T06:59:57","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/24\/huong-dan-viet-so-la-ma-trong-excel\/"},"modified":"2024-12-24T06:59:57","modified_gmt":"2024-12-24T06:59:57","slug":"huong-dan-viet-so-la-ma-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/24\/huong-dan-viet-so-la-ma-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn vi\u1ebft s\u1ed1 la m\u00e3 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 vi\u1ebft s\u1ed1 la m\u00e3 trong Excel m\u00e0 kh\u00f4ng c\u1ea7n nh\u1eadp th\u1ee7 c\u00f4ng k\u00ed t\u1ef1 nh\u01b0 \u201cX\u201d, \u201cV\u201d, \u201cD\u201d, \u201cC\u201d, \u201cI\u201d, \u201cL\u201d\u2026? Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch l\u00e0m nhanh g\u1ecdn nh\u1ea5t.<\/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-676a5bec8e16b\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/viet-so-la-ma-trong-excel.html#Ham_ROMAN_chuyen_so_Arab_thanh_so_la_ma_trong_Excel\" title=\"H\u00e0m ROMAN chuy\u1ec3n s\u1ed1 Arab th\u00e0nh s\u1ed1 la m\u00e3 trong Excel\">H\u00e0m ROMAN chuy\u1ec3n s\u1ed1 Arab th\u00e0nh s\u1ed1 la m\u00e3 trong Excel<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/viet-so-la-ma-trong-excel.html#Cong_thuc\" title=\"C\u00f4ng th\u1ee9c\">C\u00f4ng th\u1ee9c<\/a><\/li>\n<\/ul>\n<\/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\/viet-so-la-ma-trong-excel.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_ROMAN_chuyen_so_Arab_thanh_so_la_ma_trong_Excel\"><\/span>H\u00e0m ROMAN chuy\u1ec3n s\u1ed1 Arab th\u00e0nh s\u1ed1 la m\u00e3 trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_27293\" aria-describedby=\"caption-attachment-27293\" style=\"width: 767px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-27293\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/so-la-ma-1.png\" width=\"767\" height=\"122\" title=\"so-la-ma-1\"><figcaption id=\"caption-attachment-27293\" class=\"wp-caption-text\">b\u1ea3ng s\u1ed1 La M\u00e3<\/figcaption><\/figure>\n<p>\u0110\u1ec3 nhanh ch\u00f3ng vi\u1ebft s\u1ed1 La M\u00e3 m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i b\u0103n kho\u0103n ghi nh\u1edb hay tra c\u1ee9u b\u1ea3ng, ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m <strong>ROMAN<\/strong>.<\/p>\n<p>H\u00e0m\u00a0<strong>ROMAN<\/strong> s\u1ebd chuy\u1ec3n \u0111\u1ed5i s\u1ed1 Arab th\u00e0nh s\u1ed1 La M\u00e3 \u1edf d\u1ea1ng v\u0103n b\u1ea3n.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc\"><\/span>C\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>H\u00e0m ROMAN c\u00f3 c\u00fa ph\u00e1p nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=ROMAN(s\u1ed1 arab, form chuy\u1ec3n)<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>S\u1ed1 Arab\u00a0<\/strong>l\u00e0 s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i<\/p>\n<p><strong>Form chuy\u1ec3n<\/strong> l\u00e0 ki\u1ec3u ch\u1eef s\u1ed1 La M\u00e3 mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i, t\u1eeb c\u1ed5 \u0111i\u1ec3n cho \u0111\u1ebfn gi\u1ea3n th\u1ec3. Form chuy\u1ec3n \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh nh\u01b0 sau:<\/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-803.gif\" title=\"ex101_92019-nho-803\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><em>0 \u2013\u00a0<\/em>c\u1ed5 \u0111i\u1ec3n<\/p>\n<p><em>1, 2, 3 \u2013\u00a0<\/em>ng\u1eafn g\u1ecdn h\u01a1n<\/p>\n<p><em>4 \u2013\u00a0<\/em>gi\u1ea3n th\u1ec3<\/p>\n<p>L\u01b0u \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<h3><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span>V\u00ed d\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h3>\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> =&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> =&gt; XDIV<\/p>\n<p><strong><em>=ROMAN(499,3)<\/em><\/strong> =&gt; VDIV<\/p>\n<p><strong><em>=ROMAN(499,4)<\/em><\/strong> =&gt; ID<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c s\u1ed1 kh\u00e1c c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u h\u01a1n m\u1ed9t c\u00e1ch \u0111\u1ecdc, ta s\u1eed d\u1ee5ng h\u00e0m ROMAN v\u1edbi nh\u1eefng tham s\u1ed1 kh\u00e1c nhau \u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ecm ra.<\/p>\n<hr>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 d\u01b0\u1edbi \u0111\u00e2y:<\/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<\/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-803.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8661,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8660","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\/8660","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=8660"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8660\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8661"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8660"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8660"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}