{"id":1391,"date":"2024-12-02T04:50:14","date_gmt":"2024-12-02T04:50:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-chuyen-do-c-sang-do-f-trong-excel\/"},"modified":"2024-12-02T04:50:14","modified_gmt":"2024-12-02T04:50:14","slug":"huong-dan-cach-chuyen-do-c-sang-do-f-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-chuyen-do-c-sang-do-f-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch chuy\u1ec3n \u0111\u1ed9 C sang \u0111\u1ed9 F trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Th\u00f4ng th\u01b0\u1eddng\u00a0\u1edf Vi\u1ec7t Nam ch\u00fang ta hay d\u00f9ng\u00a0\u0111\u1ed9 C, nh\u01b0ng trong m\u1ed9t s\u1ed1 c\u00f4ng vi\u1ec7c\u00a0\u0111\u1eb7c th\u00f9: k\u1ef9 thu\u1eadt, th\u1ed1ng k\u00ea, y t\u1ebf, th\u1eddi ti\u1ebft\u2026 ch\u00fang ta ph\u1ea3i\u00a0\u0111\u1ed5i\u00a0\u0111\u1ed9 C sang\u00a0\u0111\u1ed9 F\u00a0\u0111\u1ec3 l\u00e0m vi\u1ec7c. Trong b\u00e0i vi\u1ebft n\u00e0y H\u1ecdc\u00a0Excel online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n 2 c\u00e1ch chuy\u1ec3n \u0111\u1ed9 C sang \u0111\u1ed9 F trong Excel r\u1ea5t\u00a0\u0111\u01a1n gi\u1ea3n.<\/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-674d3c85aa41e\" 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\/huong-dan-cach-chuyen-do-c-sang-do-f-trong-excel.html#Cach_chuyen_do_C_sang_do_F_trong_Excel_bang_phep_tinh\" title=\"C\u00e1ch chuy\u1ec3n \u0111\u1ed9 C sang \u0111\u1ed9 F trong Excel b\u1eb1ng ph\u00e9p t\u00ednh\">C\u00e1ch chuy\u1ec3n \u0111\u1ed9 C sang \u0111\u1ed9 F trong Excel b\u1eb1ng ph\u00e9p t\u00ednh<\/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\/huong-dan-cach-chuyen-do-c-sang-do-f-trong-excel.html#Cach_chuyen_do_C_sang_do_F_trong_Excel_bang_ham_CONVERT\" title=\"C\u00e1ch\u00a0chuy\u1ec3n \u0111\u1ed9 C sang \u0111\u1ed9 F trong Excel b\u1eb1ng h\u00e0m CONVERT\">C\u00e1ch\u00a0chuy\u1ec3n \u0111\u1ed9 C sang \u0111\u1ed9 F trong Excel b\u1eb1ng h\u00e0m CONVERT<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_chuyen_do_C_sang_do_F_trong_Excel_bang_phep_tinh\"><\/span>C\u00e1ch chuy\u1ec3n \u0111\u1ed9 C sang \u0111\u1ed9 F trong Excel b\u1eb1ng ph\u00e9p t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>T\u1ef7 l\u1ec7 quy\u00a0\u0111\u1ed5i c\u1ee7a\u00a0\u0111\u1ed9 C sang\u00a0\u0111\u1ed9 F l\u00e0:<\/p>\n<ul>\n<li>0 \u0111\u1ed9 C = 32\u00a0\u0111\u1ed9 F<\/li>\n<li>M\u1ed7i 1\u00a0\u0111\u1ed9 C t\u0103ng th\u00eam = + 1,8\u00a0\u0111\u1ed9 F<\/li>\n<li>M\u1ed7i 1\u00a0\u0111\u1ed9 C gi\u1ea3m\u00a0\u0111i = \u2013 1,8\u00a0\u0111\u1ed9 F<\/li>\n<\/ul>\n<p>Ta c\u00f3 c\u00e1ch t\u00ednh th\u00f4ng th\u01b0\u1eddng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27448\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-tinh-doi-do-c-sang-do-f.png\" width=\"292\" height=\"173\" title=\"cong-thuc-tinh-doi-do-c-sang-do-f\"><\/p>\n<p>C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t l\u00e0:<\/p>\n<blockquote>\n<p>S\u1ed1\u00a0\u0111\u1ed9 F = S\u1ed1\u00a0\u0111\u1ed9 C * 1.8 + 32<\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Cach_chuyen_do_C_sang_do_F_trong_Excel_bang_ham_CONVERT\"><\/span>C\u00e1ch\u00a0chuy\u1ec3n \u0111\u1ed9 C sang \u0111\u1ed9 F trong Excel b\u1eb1ng h\u00e0m CONVERT<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m CONVERT l\u00e0 h\u00e0m gi\u00fap chuy\u1ec3n\u00a0\u0111\u1ed5i h\u1ea7u h\u1ebft c\u00e1c lo\u1ea1i\u00a0\u0111\u01a1n v\u1ecb trong\u00a0Excel. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m CONVERT:<\/p>\n<p>=CONVERT(number, from_unit, to_unit)<\/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-100.gif\" title=\"ex101_92019-nho-100\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>Number: S\u1ed1 c\u1ea7n\u00a0\u0111\u1ed5i<\/li>\n<li>from_unit:\u00a0\u0111\u01a1n v\u1ecb hi\u1ec7n t\u1ea1i c\u1ee7a s\u1ed1 c\u1ea7n\u00a0\u0111\u1ed5i<\/li>\n<li>to_unit:\u00a0\u0111\u01a1n v\u1ecb c\u1ea7n chuy\u1ec3n c\u1ee7a k\u1ebft qu\u1ea3<\/li>\n<\/ul>\n<p>C\u00e1c\u00a0\u0111\u01a1n v\u1ecb khi vi\u1ebft ph\u1ea3i\u00a0\u0111\u1eb7t trong c\u1eb7p d\u1ea5u nh\u00e1y k\u00e9p.<\/p>\n<p>V\u00ed d\u1ee5:\u00a0\u0110\u1ed5i t\u1eeb\u00a0\u0111\u1ed9 C sang\u00a0\u0111\u1ed9 F ta c\u00f3 c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27449\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-convert-tinh-doi-do-c-sang-do-f.png\" width=\"392\" height=\"174\" title=\"ham-convert-tinh-doi-do-c-sang-do-f\"><\/p>\n<blockquote>\n<p>=CONVERT(s\u1ed1 c\u1ea7n\u00a0\u0111\u1ed5i, \u201cC\u201d, \u201cF\u201d)<\/p>\n<\/blockquote>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta kh\u00f4ng c\u1ea7n ph\u1ea3i nh\u1edb quy t\u1eafc\u00a0\u0111\u1ed5i n\u1eefa, m\u00e0 ch\u1ec9 c\u1ea7n vi\u1ebft\u00a0\u0111\u00fang c\u00fa ph\u00e1p c\u1ee7a h\u00e0m CONVERT l\u00e0 s\u1ebd thu\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0\u00a0\u00fd mu\u1ed1n.<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y k\u1ebft qu\u1ea3 c\u1ee7a 2 c\u00e1ch l\u00e0m\u00a0\u0111\u1ec1u gi\u1ed1ng nhau. Nh\u01b0 v\u1eady k\u1ebft qu\u1ea3 t\u00ednh\u00a0\u0111\u00e3 ch\u00ednh x\u00e1c.<\/p>\n<p>Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m CONVERT\u00a0\u0111\u1ec3 chuy\u1ec3n\u00a0\u0111\u1ed5i c\u00e1c\u00a0\u0111\u01a1n v\u1ecb kh\u00e1c:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/doi-don-vi-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ed5i \u0111\u01a1n v\u1ecb trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-nhanh-chong-chuyen-doi-dong-dollar-pound-euro-trong-excel.html\">C\u00e1ch nhanh ch\u00f3ng chuy\u1ec3n \u0111\u1ed5i \u0111\u1ed3ng Dollar, Pound, Euro trong Excel<\/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-100.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1392,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1391","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\/1391","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=1391"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1391\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1392"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}