{"id":3766,"date":"2024-12-03T03:56:17","date_gmt":"2024-12-03T03:56:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/mot-so-cach-de-chuyen-so-am-thanh-so-duong\/"},"modified":"2024-12-03T03:56:17","modified_gmt":"2024-12-03T03:56:17","slug":"mot-so-cach-de-chuyen-so-am-thanh-so-duong","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/mot-so-cach-de-chuyen-so-am-thanh-so-duong\/","title":{"rendered":"M\u1ed9t s\u1ed1 c\u00e1ch \u0111\u1ec3 chuy\u1ec3n s\u1ed1 \u00e2m th\u00e0nh s\u1ed1 d\u01b0\u01a1ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn m\u1ed9t s\u1ed1 c\u00e1ch th\u01b0\u1eddng d\u00f9ng \u0111\u1ec3<a href=\"http:\/\/blog.ezworkapp.com\/mot-so-cach-de-chuyen-so-am-thanh-so-duong.html\"><strong> \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel:<\/strong><\/a> chuy\u1ec3n s\u1ed1 \u00e2m th\u00e0nh s\u1ed1 d\u01b0\u01a1ng trong Excel m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/em><\/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-674e816077f4e\" 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\/mot-so-cach-de-chuyen-so-am-thanh-so-duong.html#Su_dung_ham_ABS_de_dinh_dang_so_trong_Excel\" title=\"S\u1eed d\u1ee5ng h\u00e0m ABS \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel\">S\u1eed d\u1ee5ng h\u00e0m ABS \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/mot-so-cach-de-chuyen-so-am-thanh-so-duong.html#Su_dung_ham_SQRT_de_dinh_dang_so_trong_excel\" title=\"S\u1eed d\u1ee5ng h\u00e0m SQRT \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel\">S\u1eed d\u1ee5ng h\u00e0m SQRT \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel<\/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\/mot-so-cach-de-chuyen-so-am-thanh-so-duong.html#Nhan_voi_%E2%80%93_1\" title=\"Nh\u00e2n v\u1edbi \u2013 1\">Nh\u00e2n v\u1edbi \u2013 1<\/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\/mot-so-cach-de-chuyen-so-am-thanh-so-duong.html#Chia_cho_-1\" title=\"Chia cho -1\">Chia cho -1<\/a><\/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\/mot-so-cach-de-chuyen-so-am-thanh-so-duong.html#Cac_cach_khac\" title=\"C\u00e1c c\u00e1ch kh\u00e1c\">C\u00e1c c\u00e1ch kh\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/mot-so-cach-de-chuyen-so-am-thanh-so-duong.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_ABS_de_dinh_dang_so_trong_Excel\"><\/span>S\u1eed d\u1ee5ng h\u00e0m ABS \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 bi\u1ebft, th\u00ec b\u1ea1n ABS s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i c\u1ee7a \u00f4 \u0111\u00f3. V\u00e0 t\u1ea5t nhi\u00ean l\u00e0 gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i c\u1ee7a s\u1ed1 \u00e2m ch\u00ednh l\u00e0 s\u1ed1 d\u01b0\u01a1ng r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o \ud83d\ude0a.<\/p>\n<p>Ta c\u00f3 c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=ABS(B3)<\/strong><\/p>\n<\/blockquote>\n<p>V\u1edbi B3 l\u00e0 1 s\u1ed1 \u00e2m m\u00e0 b\u1ea1n \u0111ang mu\u1ed1n chuy\u1ec3n n\u00f3 v\u1ec1 s\u1ed1 d\u01b0\u01a1ng.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_SQRT_de_dinh_dang_so_trong_excel\"><\/span>S\u1eed d\u1ee5ng h\u00e0m SQRT \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SQRT v\u00e0 ta s\u1ebd t\u00ednh c\u0103n b\u1eadc 2 c\u1ee7a b\u00ecnh ph\u01b0\u01a1ng s\u1ed1 \u00e2m \u0111\u00f3. C\u1ee5 th\u1ec3 ta c\u00f3 nh\u01b0 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tinh-can-bac-2-trong-excel-voi-ham-sqrt.html\"><em><strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ednh c\u0103n b\u1eadc 2 trong excel v\u1edbi h\u00e0m sqrt<\/strong><\/em><\/a><\/p>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/mot-so-cach-de-chuyen-so-am-thanh-so-duong.html\/mot\" rel=\"attachment wp-att-31149\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31149 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/mot.png\" alt=\"dinh-dang-so-trong-excel-1\" width=\"732\" height=\"317\" title=\"mot\"><\/a><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Nhan_voi_%E2%80%93_1\"><\/span>Nh\u00e2n v\u1edbi \u2013 1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel ti\u1ebfp theo l\u00e0 ta ch\u1ec9 c\u1ea7n nh\u00e2n s\u1ed1 \u00e2m \u0111\u00f3 v\u1edbi -1, v\u00e0 v\u00ec sao nh\u00e2n s\u1ed1 \u00e2m v\u1edbi \u2013 1 n\u00f3 l\u1ea1i ra s\u1ed1 d\u01b0\u01a1ng th\u00ec ch\u1eafc c\u00f3 l\u1ebd kh\u00f4ng ph\u1ea3i gi\u1ea3i th\u00edch \u0111\u00e2u nh\u1ec9.<\/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-294.gif\" title=\"ex101_92019-nho-294\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Chia_cho_-1\"><\/span>Chia cho -1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu b\u1ea1n kh\u00f4ng th\u00edch nh\u00e2n, th\u00ec c\u00f3 th\u1ec3 chia s\u1ed1 \u00e2m \u0111\u00f3 cho -1, v\u00e0 k\u1ebft qu\u1ea3 l\u00e0 n\u00f3 s\u1ebd ph\u1ea3i nh\u01b0 nhau r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o \ud83e\udd23<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cac_cach_khac\"><\/span>C\u00e1c c\u00e1ch kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00e0 c\u00f2n r\u1ea5t r\u1ea5t nhi\u1ec1u c\u00e1ch kh\u00e1c nhau trong Excel c\u0169ng nh\u01b0 ch\u01b0a k\u1ec3 t\u1edbi s\u1eed d\u1ee5ng VBA \u0111\u1ec3 c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3. Tu\u1ef3 v\u00e0o \u0111\u1eb7c th\u00f9 d\u1eef li\u1ec7u, t\u00ecnh hu\u1ed1ng m\u00e0 b\u1ea1n g\u1eb7p ph\u1ea3i \u0111\u1ec3 c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn \u00e1p d\u1ee5ng c\u00e1c c\u00e1ch kh\u00e1c nhau m\u1ed9t c\u00e1ch linh ho\u1ea1t.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Hy v\u1ecdng qua b\u00e0i vi\u1ebft ng\u1eafn n\u00e0y c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong>, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1c c\u00e1ch c\u01a1 b\u1ea3n, v\u00e0 th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i m\u1ed9t s\u1ed1 \u00e2m th\u00e0nh s\u1ed1 d\u01b0\u01a1ng trong d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3.<\/p>\n<p>Tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft g\u1ea7n \u0111\u00e2y c\u1ee7a<strong> H\u1ecdc Excel Online\u00a0<\/strong>n\u1eb1m trong<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-tu-co-ban-toi-nang-cao-danh-cho-dan-van-phong-2010-20132016\"><strong> kh\u00f3a h\u1ecdc Excel<\/strong> <\/a>c\u1ee7a ch\u00fang t\u00f4i<\/p>\n<hr>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-vlookup-long-vlookup-trong-excel.html\"><em><strong>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m vlookup l\u1ed3ng vlookup trong excel<\/strong><\/em><\/a><\/p>\n<p><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/31008.html\">Nh\u1eefng l\u00fd do b\u1ea1n n\u00ean s\u1eed d\u1ee5ng table trong excel<\/a><\/strong><\/em><\/p>\n<p><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/tach-roi-ky-tu-ra-khoi-chuoi-don-gian.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch r\u1eddi t\u1eebng k\u00fd m\u1ed9t t\u1ef1 ra kh\u1ecfi chu\u1ed7i<\/a><\/strong><\/em><\/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-294.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3767,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3766","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\/3766","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=3766"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3766\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3767"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3766"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3766"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3766"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}