{"id":1016,"date":"2025-03-20T00:03:34","date_gmt":"2025-03-19T17:03:34","guid":{"rendered":"https:\/\/www.ckconitsha.com\/vn\/?p=1016"},"modified":"2025-06-12T17:09:16","modified_gmt":"2025-06-12T10:09:16","slug":"thu-tu-uu-tien-cua-cac-phep-toan-trong-bieu-thuc-excel-la-gi","status":"publish","type":"post","link":"https:\/\/www.ckconitsha.com\/vn\/thu-tu-uu-tien-cua-cac-phep-toan-trong-bieu-thuc-excel-la-gi\/","title":{"rendered":"Th\u1ee9 t\u1ef1 \u01b0u ti\u00ean c\u1ee7a c\u00e1c ph\u00e9p to\u00e1n trong bi\u1ec3u th\u1ee9c Excel l\u00e0 g\u00ec?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_79_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.ckconitsha.com\/vn\/thu-tu-uu-tien-cua-cac-phep-toan-trong-bieu-thuc-excel-la-gi\/#Thu_tu_tinh_toan_trong_Excel\" >Th\u1ee9 t\u1ef1 t\u00ednh to\u00e1n trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.ckconitsha.com\/vn\/thu-tu-uu-tien-cua-cac-phep-toan-trong-bieu-thuc-excel-la-gi\/#Bang_thu_tu_uu_tien_toan_tu_trong_Excel\" >B\u1ea3ng th\u1ee9 t\u1ef1 \u01b0u ti\u00ean to\u00e1n t\u1eed trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.ckconitsha.com\/vn\/thu-tu-uu-tien-cua-cac-phep-toan-trong-bieu-thuc-excel-la-gi\/#Su_dung_dau_ngoac_don_trong_cong_thuc_Excel\" >S\u1eed d\u1ee5ng d\u1ea5u ngo\u1eb7c \u0111\u01a1n trong c\u00f4ng th\u1ee9c Excel<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Thu_tu_tinh_toan_trong_Excel\"><\/span>Th\u1ee9 t\u1ef1 t\u00ednh to\u00e1n trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Bi\u1ec3u th\u1ee9c trong Excel lu\u00f4n b\u1eaft \u0111\u1ea7u b\u1eb1ng d\u1ea5u b\u1eb1ng (=). Excel s\u1ebd nh\u1eadn bi\u1ebft c\u00e1c k\u00fd t\u1ef1 ti\u1ebfp theo d\u1ea5u b\u1eb1ng l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c c\u1ea7n t\u00ednh to\u00e1n. C\u00f4ng th\u1ee9c bao g\u1ed3m c\u00e1c to\u00e1n h\u1ea1ng (s\u1ed1, tham chi\u1ebfu \u00f4) v\u00e0 c\u00e1c to\u00e1n t\u1eed (+, -, *, \/,&#8230;). Excel t\u00ednh to\u00e1n t\u1eeb tr\u00e1i sang ph\u1ea3i, theo th\u1ee9 t\u1ef1 \u01b0u ti\u00ean c\u1ee7a t\u1eebng to\u00e1n t\u1eed.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Bang_thu_tu_uu_tien_toan_tu_trong_Excel\"><\/span>B\u1ea3ng th\u1ee9 t\u1ef1 \u01b0u ti\u00ean to\u00e1n t\u1eed trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi k\u1ebft h\u1ee3p nhi\u1ec1u to\u00e1n t\u1eed trong c\u00f9ng m\u1ed9t bi\u1ec3u th\u1ee9c, Excel s\u1ebd th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p to\u00e1n theo th\u1ee9 t\u1ef1 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y. N\u1ebfu c\u00f3 nhi\u1ec1u to\u00e1n t\u1eed c\u00f9ng m\u1ee9c \u01b0u ti\u00ean (v\u00ed d\u1ee5: * v\u00e0 \/), Excel s\u1ebd t\u00ednh to\u00e1n t\u1eeb tr\u00e1i sang ph\u1ea3i.<\/p>\n<table>\n<thead>\n<tr>\n<th>To\u00e1n t\u1eed<\/th>\n<th>M\u00f4 t\u1ea3<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>: ; ,<\/td>\n<td>To\u00e1n t\u1eed tham chi\u1ebfu<\/td>\n<\/tr>\n<tr>\n<td>&#8211;<\/td>\n<td>Ph\u1ee7 \u0111\u1ecbnh (v\u00ed d\u1ee5: -1)<\/td>\n<\/tr>\n<tr>\n<td>%<\/td>\n<td>Ph\u1ea7n tr\u0103m<\/td>\n<\/tr>\n<tr>\n<td>^<\/td>\n<td>L\u0169y th\u1eeba<\/td>\n<\/tr>\n<tr>\n<td>* v\u00e0 \/<\/td>\n<td>Nh\u00e2n v\u00e0 chia<\/td>\n<\/tr>\n<tr>\n<td>+ v\u00e0 &#8211;<\/td>\n<td>C\u1ed9ng v\u00e0 tr\u1eeb<\/td>\n<\/tr>\n<tr>\n<td>&amp;<\/td>\n<td>N\u1ed1i chu\u1ed7i<\/td>\n<\/tr>\n<tr>\n<td>=, &lt;&gt;, &lt;, &gt;, &lt;=, &gt;=<\/td>\n<td>So s\u00e1nh<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_dau_ngoac_don_trong_cong_thuc_Excel\"><\/span>S\u1eed d\u1ee5ng d\u1ea5u ngo\u1eb7c \u0111\u01a1n trong c\u00f4ng th\u1ee9c Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 thay \u0111\u1ed5i th\u1ee9 t\u1ef1 t\u00ednh to\u00e1n, h\u00e3y s\u1eed d\u1ee5ng d\u1ea5u ngo\u1eb7c \u0111\u01a1n. Ph\u1ea7n n\u1eb1m trong ngo\u1eb7c \u0111\u01a1n s\u1ebd \u0111\u01b0\u1ee3c \u01b0u ti\u00ean t\u00ednh to\u00e1n tr\u01b0\u1edbc.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<ul>\n<li><code>=5+2*3<\/code> cho k\u1ebft qu\u1ea3 l\u00e0 11 (nh\u00e2n tr\u01b0\u1edbc, c\u1ed9ng sau).<\/li>\n<li><code>=(5+2)*3<\/code> cho k\u1ebft qu\u1ea3 l\u00e0 21 (c\u1ed9ng tr\u01b0\u1edbc, nh\u00e2n sau).<\/li>\n<\/ul>\n<p>M\u1ed9t v\u00ed d\u1ee5 kh\u00e1c:<\/p>\n<ul>\n<li><code>=(B4+25)\/SUM(D5:F5)<\/code>:  Excel s\u1ebd t\u00ednh B4+25 tr\u01b0\u1edbc, sau \u0111\u00f3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb D5 \u0111\u1ebfn F5, cu\u1ed1i c\u00f9ng th\u1ef1c hi\u1ec7n ph\u00e9p chia.<\/li>\n<\/ul>\n<p>Vi\u1ec7c n\u1eafm v\u1eefng th\u1ee9 t\u1ef1 \u01b0u ti\u00ean to\u00e1n t\u1eed v\u00e0 s\u1eed d\u1ee5ng d\u1ea5u ngo\u1eb7c \u0111\u01a1n linh ho\u1ea1t s\u1ebd gi\u00fap b\u1ea1n x\u00e2y d\u1ef1ng c\u00e1c c\u00f4ng th\u1ee9c Excel ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Th\u1ee9 t\u1ef1 t\u00ednh to\u00e1n trong Excel Bi\u1ec3u th\u1ee9c trong Excel lu\u00f4n b\u1eaft \u0111\u1ea7u b\u1eb1ng d\u1ea5u b\u1eb1ng (=). Excel s\u1ebd nh\u1eadn bi\u1ebft c\u00e1c k\u00fd t\u1ef1 ti\u1ebfp theo d\u1ea5u b\u1eb1ng l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c c\u1ea7n t\u00ednh to\u00e1n. C\u00f4ng th\u1ee9c bao g\u1ed3m c\u00e1c to\u00e1n h\u1ea1ng (s\u1ed1, tham chi\u1ebfu \u00f4) v\u00e0 c\u00e1c to\u00e1n t\u1eed (+, -, *, \/,&#8230;). Excel&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1016","post","type-post","status-publish","format-standard","hentry","category-blog"],"_links":{"self":[{"href":"https:\/\/www.ckconitsha.com\/vn\/wp-json\/wp\/v2\/posts\/1016","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ckconitsha.com\/vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ckconitsha.com\/vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ckconitsha.com\/vn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ckconitsha.com\/vn\/wp-json\/wp\/v2\/comments?post=1016"}],"version-history":[{"count":1,"href":"https:\/\/www.ckconitsha.com\/vn\/wp-json\/wp\/v2\/posts\/1016\/revisions"}],"predecessor-version":[{"id":1379,"href":"https:\/\/www.ckconitsha.com\/vn\/wp-json\/wp\/v2\/posts\/1016\/revisions\/1379"}],"wp:attachment":[{"href":"https:\/\/www.ckconitsha.com\/vn\/wp-json\/wp\/v2\/media?parent=1016"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ckconitsha.com\/vn\/wp-json\/wp\/v2\/categories?post=1016"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ckconitsha.com\/vn\/wp-json\/wp\/v2\/tags?post=1016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}