{"id":3294,"date":"2024-12-03T01:42:08","date_gmt":"2024-12-03T01:42:08","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cong-thuc-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian\/"},"modified":"2024-12-03T01:42:08","modified_gmt":"2024-12-03T01:42:08","slug":"cong-thuc-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cong-thuc-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian\/","title":{"rendered":"C\u00f4ng Th\u1ee9c Excel, v\u00ed d\u1ee5 v\u00e0 m\u1eb9o \u0111\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"c\u00f4ng-th\u1ee9c-excel\" cite=\"https:\/\/blog.hocexcel.online\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html?cong-thuc-excel\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i vi\u1ebft n\u00e0y,<strong> <a href=\"http:\/\/blog.ezworkapp.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n v\u1ec1 t\u1ea1o v\u00e0 s\u1eed d\u1ee5ng c\u00e1c <strong>c\u00f4ng th\u1ee9c Excel<\/strong>. V\u00e0 b\u1edfi v\u00ec m\u1ed9t trong nh\u1eefng c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t \u0111\u1ec3 h\u1ecdc l\u00e0 th\u00f4ng qua th\u1ef1c h\u00e0nh, ch\u00fang t\u00f4i c\u0169ng s\u1ebd th\u1ea3o lu\u1eadn v\u1ec1 m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c v\u00ed d\u1ee5 \u0111\u1ec3 l\u00e0m cho m\u1ecdi vi\u1ec7c tr\u1edf n\u00ean d\u1ec5 hi\u1ec3u h\u01a1n.<\/em><\/p>\n<\/blockquote>\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-674e61ef4c1b3\" 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\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html#Cong_thuc_Excel_%E2%80%93_nhung_dieu_co_ban\" title=\"C\u00f4ng th\u1ee9c Excel \u2013 nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n\">C\u00f4ng th\u1ee9c Excel \u2013 nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n<\/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\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html#Cac_thanh_phan_cua_cong_thuc_Microsoft_Excel\" title=\"C\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c Microsoft Excel\">C\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c Microsoft 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\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html#Cac_toan_tu_trong_cac_bang_tinh_Excel\" title=\"C\u00e1c to\u00e1n t\u1eed trong c\u00e1c b\u1ea3ng t\u00ednh Excel\">C\u00e1c to\u00e1n t\u1eed trong c\u00e1c b\u1ea3ng t\u00ednh Excel<\/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\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html#Su_dung_toan_tu_so_hoc_trong_cong_thuc_Excel\" title=\"S\u1eed d\u1ee5ng to\u00e1n t\u1eed s\u1ed1 h\u1ecdc trong c\u00f4ng th\u1ee9c Excel\">S\u1eed d\u1ee5ng to\u00e1n t\u1eed s\u1ed1 h\u1ecdc trong c\u00f4ng th\u1ee9c Excel<\/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\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html#Cac_toan_tu_so_sanh_trong_cac_cong_thuc_Excel\" title=\"C\u00e1c to\u00e1n t\u1eed so s\u00e1nh trong c\u00e1c c\u00f4ng th\u1ee9c Excel\">C\u00e1c to\u00e1n t\u1eed so s\u00e1nh trong c\u00e1c c\u00f4ng th\u1ee9c Excel<\/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\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html#Toan_tu_noi_van_ban\" title=\"To\u00e1n t\u1eed n\u1ed1i v\u0103n b\u1ea3n\">To\u00e1n t\u1eed n\u1ed1i v\u0103n b\u1ea3n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html#Cac_toan_tu_tham_chieu_trong_cac_cong_thuc_Excel_va_cac_ham\" title=\"C\u00e1c to\u00e1n t\u1eed tham chi\u1ebfu trong c\u00e1c c\u00f4ng th\u1ee9c Excel v\u00e0 c\u00e1c h\u00e0m\">C\u00e1c to\u00e1n t\u1eed tham chi\u1ebfu trong c\u00e1c c\u00f4ng th\u1ee9c Excel v\u00e0 c\u00e1c h\u00e0m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html#Cac_loai_cong_thuc_Excel\" title=\"C\u00e1c lo\u1ea1i c\u00f4ng th\u1ee9c Excel\">C\u00e1c lo\u1ea1i c\u00f4ng th\u1ee9c Excel<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html#Cach_tao_cac_cong_thuc_trong_Excel\" title=\"C\u00e1ch t\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c trong Excel\">C\u00e1ch t\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html#Cach_tao_cac_cong_thuc_tien_tien_trong_Excel\" title=\"C\u00e1ch t\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c ti\u00ean ti\u1ebfn trong Excel\">C\u00e1ch t\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c ti\u00ean ti\u1ebfn trong Excel<\/a><\/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-11\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html#Cong_thuc_Excel_voi_ham_long_nhau\" title=\"C\u00f4ng th\u1ee9c Excel v\u1edbi h\u00e0m l\u1ed3ng nhau\">C\u00f4ng th\u1ee9c Excel v\u1edbi h\u00e0m l\u1ed3ng nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html#Cong_thuc_mang_trong_Excel\" title=\"C\u00f4ng th\u1ee9c m\u1ea3ng trong Excel\">C\u00f4ng th\u1ee9c m\u1ea3ng trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html#Ham_nguoi_dung_tu_tao\" title=\"H\u00e0m ng\u01b0\u1eddi d\u00f9ng t\u1ef1 t\u1ea1o\">H\u00e0m ng\u01b0\u1eddi d\u00f9ng t\u1ef1 t\u1ea1o<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html#Meo_va_cac_phim_tat_tiet_kiem_thoi_gian_cho_cac_cong_thuc_Excel\" title=\"M\u1eb9o v\u00e0 c\u00e1c ph\u00edm t\u1eaft ti\u1ebft ki\u1ec7m th\u1eddi gian cho c\u00e1c c\u00f4ng th\u1ee9c Excel\">M\u1eb9o v\u00e0 c\u00e1c ph\u00edm t\u1eaft ti\u1ebft ki\u1ec7m th\u1eddi gian cho c\u00e1c c\u00f4ng th\u1ee9c Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_Excel_%E2%80%93_nhung_dieu_co_ban\"><\/span>C\u00f4ng th\u1ee9c Excel \u2013 nh\u1eefng <strong>\u0111i\u1ec1u<\/strong> c\u01a1 b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong MS Excel, <strong>c\u00f4ng th\u1ee9c excel<\/strong> l\u00e0 c\u00e1c ph\u01b0\u01a1ng tr\u00ecnh th\u1ef1c hi\u1ec7n c\u00e1c t\u00ednh to\u00e1n kh\u00e1c nhau trong c\u00e1c b\u1ea3ng t\u00ednh. M\u1eb7c d\u00f9 Microsoft gi\u1edbi thi\u1ec7u th\u00eam nhi\u1ec1u h\u00e0m m\u1edbi qua c\u00e1c n\u0103m, kh\u00e1i ni\u1ec7m c\u00f4ng th\u1ee9c b\u1ea3ng t\u00ednh Excel v\u1eabn gi\u1ed1ng nhau trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n Excel 2016, Excel 2013, Excel 2010, Excel 2007 v\u00e0 th\u1ea5p h\u01a1n.<\/p>\n<ul style=\"text-align: justify\">\n<li>T\u1ea5t c\u1ea3 c\u00e1c <strong>c\u00f4ng th\u1ee9c Excel<\/strong> b\u1eaft \u0111\u1ea7u v\u1edbi m\u1ed9t d\u1ea5u b\u1eb1ng (=).<\/li>\n<li>Sau d\u1ea5u b\u1eb1ng, b\u1ea1n nh\u1eadp ho\u1eb7c l\u00e0 ph\u00e9p t\u00ednh ho\u1eb7c h\u00e0m. V\u00ed d\u1ee5: \u0111\u1ec3 c\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 t\u1eeb B1 t\u1edbi B5, b\u1ea1n c\u00f3 th\u1ec3:\n<ul>\n<li>G\u00f5 to\u00e0n b\u1ed9 ph\u01b0\u01a1ng tr\u00ecnh: = B1 + B2 + B3 + B4 + B5<\/li>\n<li>S\u1eed d\u1ee5ng h\u00e0m SUM: = SUM (B1: B5)<\/li>\n<\/ul>\n<\/li>\n<li>Nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c. L\u00e0m xong!<\/li>\n<\/ul>\n<figure style=\"width: 478px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00f4ng th\u1ee9c Microsoft Excel - nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/microsoft-excel-formulas.png\" alt=\"Microsoft Excel formulas\" width=\"478\" height=\"189\"><figcaption class=\"wp-caption-text\">C\u00f4ng th\u1ee9c Microsoft Excel \u2013 nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n<\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cac_thanh_phan_cua_cong_thuc_Microsoft_Excel\"><\/span>C\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c Microsoft Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Khi b\u1ea1n t\u1ea1o m\u1ed9t c\u00f4ng th\u1ee9c trong Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c ph\u1ea7n t\u1eed kh\u00e1c nhau \u0111\u1ec3 cung c\u1ea5p d\u1eef li\u1ec7u ngu\u1ed3n cho c\u00f4ng th\u1ee9c v\u00e0 ch\u1ec9 ra c\u00e1c to\u00e1n t\u1eed n\u00ean \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n tr\u00ean nh\u1eefng d\u1eef li\u1ec7u \u0111\u00f3. T\u00f9y thu\u1ed9c v\u00e0o lo\u1ea1i c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n t\u1ea1o ra, n\u00f3 c\u00f3 th\u1ec3 bao g\u1ed3m b\u1ea5t k\u1ef3 ho\u1eb7c t\u1ea5t c\u1ea3 c\u00e1c ph\u1ea7n sau: \u00b7<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>H\u1eb1ng s\u1ed1<\/strong> \u2013 s\u1ed1 ho\u1eb7c c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n m\u00e0 b\u1ea1n nh\u1eadp tr\u1ef1c ti\u1ebfp v\u00e0o m\u1ed9t c\u00f4ng th\u1ee9c, nh\u01b0 = 2 * 3. \u00b7<\/li>\n<li><strong>Tham chi\u1ebfu \u00f4<\/strong> \u2013 tham chi\u1ebfu \u0111\u1ebfn \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c Excel c\u1ee7a b\u1ea1n, v\u00ed d\u1ee5: = SUM (A1, A2, B5). \u0110\u1ec3 tham kh\u1ea3o d\u1eef li\u1ec7u trong hai ho\u1eb7c nhi\u1ec1u \u00f4 ti\u1ebfp gi\u00e1p, h\u00e3y s\u1eed d\u1ee5ng m\u1ed9t tham chi\u1ebfu ph\u1ea1m vi nh\u01b0 A1: A5. V\u00ed d\u1ee5, \u0111\u1ec3 t\u1ed5ng h\u1ee3p gi\u00e1 tr\u1ecb trong t\u1ea5t c\u1ea3 c\u00e1c \u00f4 gi\u1eefa A1 v\u00e0 A5, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y: = SUM (A1: A5).\u00b7<\/li>\n<li><strong>T\u00ean <\/strong>\u2013 \u00a0\u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh cho m\u1ed9t ph\u1ea1m vi \u00f4, h\u1eb1ng, b\u1ea3ng, ho\u1eb7c h\u00e0m, v\u00ed d\u1ee5 = SUM (my_name). \u00b7<\/li>\n<li><strong>C\u00e1c h\u00e0m<\/strong> \u2013 c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc trong Excel th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n s\u1eed d\u1ee5ng c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c cung c\u1ea5p trong c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ee7a ch\u00fang. \u00b7<\/li>\n<li><strong>To\u00e1n t\u1eed<\/strong> \u2013 c\u00e1c k\u00fd hi\u1ec7u \u0111\u1eb7c bi\u1ec7t ch\u1ec9 \u0111\u1ecbnh lo\u1ea1i ho\u1ea1t \u0111\u1ed9ng ho\u1eb7c t\u00ednh to\u00e1n s\u1ebd \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n.<\/li>\n<\/ul>\n<figure style=\"width: 454px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c Microsoft Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-formula-elements.png\" alt=\"Basic elements of Excel formulas\" width=\"454\" height=\"207\"><figcaption class=\"wp-caption-text\">C\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c Microsoft Excel<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cac_toan_tu_trong_cac_bang_tinh_Excel\"><\/span>C\u00e1c to\u00e1n t\u1eed trong c\u00e1c b\u1ea3ng t\u00ednh Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 n\u00f3i v\u1edbi Microsoft Excel lo\u1ea1i c\u00f4ng vi\u1ec7c b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n trong m\u1ed9t c\u00f4ng th\u1ee9c, b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c k\u00fd hi\u1ec7u \u0111\u1eb7c bi\u1ec7t \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 c\u00e1c to\u00e1n t\u1eed. C\u00f3 4 lo\u1ea1i to\u00e1n t\u1eed trong Excel:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>S\u1ed1 h\u1ecdc<\/strong> \u2013 \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p to\u00e1n c\u01a1 b\u1ea3n.<\/li>\n<li><strong>So s\u00e1nh (h\u1ee3p l\u00fd)<\/strong> \u2013 \u0111\u1ec3 so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb.<\/li>\n<li><strong>K\u1ebft n\u1ed1i<\/strong> \u2013 \u0111\u1ec3 k\u1ebft h\u1ee3p c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n v\u00e0o m\u1ed9t chu\u1ed7i duy nh\u1ea5t.<\/li>\n<li><strong>Tham chi\u1ebfu<\/strong> \u2013 \u0111\u1ec3 t\u1ea1o ra c\u00e1c c\u01a1n th\u1ecbnh n\u1ed9 v\u00e0 c\u00e1c \u0111\u1ed1i s\u1ed1 ri\u00eang bi\u1ec7t trong c\u00e1c h\u00e0m c\u1ee7a Excel.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_toan_tu_so_hoc_trong_cong_thuc_Excel\"><\/span>S\u1eed d\u1ee5ng to\u00e1n t\u1eed s\u1ed1 h\u1ecdc trong c\u00f4ng th\u1ee9c Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00e1c to\u00e1n t\u1eed n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p to\u00e1n c\u01a1 b\u1ea3n nh\u01b0 c\u1ed9ng, tr\u1eeb, nh\u00e2n v\u00e0 chia.<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>To\u00e1n t\u1eed<\/strong><\/td>\n<td><strong>\u00dd ngh\u0129<\/strong><\/td>\n<td><strong>C\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/strong><\/td>\n<\/tr>\n<tr>\n<td>+<\/td>\n<td>Ph\u00e9p c\u1ed9ng<\/td>\n<td><strong>=A2+B2<\/strong><\/td>\n<\/tr>\n<tr>\n<td>\u2013<\/td>\n<td>Ph\u00e9p tr\u1eeb<br \/>\nD\u1ea5u \u00e2m<\/td>\n<td><strong>=A2-B2<\/strong><br \/>\n<strong>=-A2<\/strong>\u00a0(\u0111\u1ed5i d\u1ea5u gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 A2)<\/td>\n<\/tr>\n<tr>\n<td>*<\/td>\n<td>Ph\u00e9p nh\u00e2n<\/td>\n<td><strong>=A2*B2<\/strong><\/td>\n<\/tr>\n<tr>\n<td>\/<\/td>\n<td>Ph\u00e9p chia<\/td>\n<td><strong>=A2\/B2<\/strong><\/td>\n<\/tr>\n<tr>\n<td>%<\/td>\n<td>Ph\u1ea7n tr\u0103m<\/td>\n<td><strong>=A2*10%<\/strong><br \/>\n(tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 10% c\u1ee7a gi\u00e1 tr\u1ecb \u00f4 A2)<\/td>\n<\/tr>\n<tr>\n<td>^<\/td>\n<td>L\u0169y th\u1eeba<\/td>\n<td><strong>=A2^3<\/strong><br \/>\n(L\u0169y th\u1eeba 3 c\u1ee7a \u00f4 A2)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n c\u00f3 gi\u00e1 c\u1ea3 trong \u00f4 A2 v\u00e0 VAT trong \u00f4 B2, b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh s\u1ed1 ti\u1ec1n thu\u1ebf GTGT b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m sau: = A2 * B2<\/p>\n<figure style=\"width: 355px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"S\u1eed d\u1ee5ng to\u00e1n t\u1eed s\u1ed1 h\u1ecdc trong c\u00f4ng th\u1ee9c Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-percentage-formula.png\" alt=\"Using mathematical operators in Excel formulas\" width=\"355\" height=\"264\"><figcaption class=\"wp-caption-text\">S\u1eed d\u1ee5ng to\u00e1n t\u1eed s\u1ed1 h\u1ecdc trong c\u00f4ng th\u1ee9c Excel<\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cac_toan_tu_so_sanh_trong_cac_cong_thuc_Excel\"><\/span>C\u00e1c to\u00e1n t\u1eed so s\u00e1nh trong c\u00e1c c\u00f4ng th\u1ee9c Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong c\u00e1c c\u00f4ng th\u1ee9c Microsoft Excel, so s\u00e1nh, ho\u1eb7c h\u1ee3p l\u00fd, to\u00e1n t\u1eed \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 so s\u00e1nh hai gi\u00e1 tr\u1ecb. K\u1ebft qu\u1ea3 c\u1ee7a vi\u1ec7c so s\u00e1nh lu\u00f4n l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb logic c\u1ee7a TRUE ho\u1eb7c FALSE. C\u00e1c to\u00e1n t\u1eed logic sau c\u00f3 s\u1eb5n trong Excel:<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>To\u00e1n t\u1eed so s\u00e1nh<\/strong><\/td>\n<td><strong>\u00dd ngh\u0129a<\/strong><\/td>\n<td><strong>C\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/strong><\/td>\n<\/tr>\n<tr>\n<td>=<\/td>\n<td>B\u1eb1ng<\/td>\n<td><strong>=A2=B2<\/strong><\/td>\n<\/tr>\n<tr>\n<td>&lt;&gt;<\/td>\n<td>Kh\u00f4ng b\u1eb1ng<\/td>\n<td><strong>=A2&lt;&gt;B2<\/strong><\/td>\n<\/tr>\n<tr>\n<td>&gt;<\/td>\n<td>L\u1edbn h\u01a1n<\/td>\n<td><strong>=A2&gt;B2<\/strong><\/td>\n<\/tr>\n<tr>\n<td>&lt;<\/td>\n<td>Nh\u1ecf h\u01a1n<\/td>\n<td><strong>=A2&lt;B2<\/strong><\/td>\n<\/tr>\n<tr>\n<td>&gt;=<\/td>\n<td>L\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng<\/td>\n<td><strong>=A2&gt;=B2<\/strong><\/td>\n<\/tr>\n<tr>\n<td>&lt;=<\/td>\n<td>Nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng<\/td>\n<td><strong>=A2&lt;=B2<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c = A1 = B1 tr\u1ea3 v\u1ec1 TRUE n\u1ebfu c\u00e1c \u00f4 A1 v\u00e0 B1 c\u00f3 c\u00f9ng m\u1ed9t gi\u00e1 tr\u1ecb (s\u1ed1, v\u0103n b\u1ea3n ho\u1eb7c ng\u00e0y th\u00e1ng), FALSE n\u1ebfu kh\u00f4ng.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-110.gif\" title=\"vba101_92019-nho-110\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-254.gif\" title=\"ex101_92019-nho-254\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Toan_tu_noi_van_ban\"><\/span>To\u00e1n t\u1eed n\u1ed1i v\u0103n b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">To\u00e1n t\u1eed n\u1ed1i v\u0103n b\u1ea3n trong Excel l\u00e0 k\u00fd hi\u1ec7u v\u00e0 (&amp;). B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 k\u1ebft h\u1ee3p hai ho\u1eb7c nhi\u1ec1u chu\u1ed7i v\u0103n b\u1ea3n trong m\u1ed9t chu\u1ed7i duy nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n c\u00f3 m\u00e3 qu\u1ed1c gia trong c\u1ed9t A v\u00e0 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong c\u1ed9t B, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 nh\u1eadn s\u1ed1 \u0111i\u1ec7n tho\u1ea1i k\u1ebft h\u1ee3p v\u1edbi m\u00e3 qu\u1ed1c gia:<\/p>\n<p style=\"text-align: justify\"><strong>= A1 &amp; \u201c\u201d &amp; B1<\/strong><\/p>\n<p style=\"text-align: justify\">Trong c\u00f4ng th\u1ee9c tr\u00ean, ch\u00fang ta th\u00eam m\u1ed9t kho\u1ea3ng tr\u1ed1ng v\u00e0o gi\u1eefa \u0111\u1ec3 l\u00e0m cho c\u00e1c con s\u1ed1 d\u1ec5 \u0111\u1ecdc h\u01a1n:<\/p>\n<figure style=\"width: 402px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"To\u00e1n t\u1eed n\u1ed1i v\u0103n b\u1ea3n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-concatenation-operator.png\" alt=\"Using the text concatenation operator in Excel formulas\" width=\"402\" height=\"139\"><figcaption class=\"wp-caption-text\">To\u00e1n t\u1eed n\u1ed1i v\u0103n b\u1ea3n<\/figcaption><\/figure>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 c\u00f3 th\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng CONCATENATE.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cac_toan_tu_tham_chieu_trong_cac_cong_thuc_Excel_va_cac_ham\"><\/span>C\u00e1c to\u00e1n t\u1eed tham chi\u1ebfu trong c\u00e1c c\u00f4ng th\u1ee9c Excel v\u00e0 c\u00e1c h\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 cung c\u1ea5p v\u00f9ng d\u1eef li\u1ec7u cho MS Excel c\u00f4ng th\u1ee9c v\u00e0 \u0111\u1ed1i s\u1ed1 ri\u00eang bi\u1ec7t trong h\u00e0m Excel, c\u00e1c to\u00e1n t\u1eed sau \u0111\u00e2y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng.<\/p>\n<p style=\"text-align: justify\"><strong>D\u1ea5u hai ch\u1ea5m (:) <\/strong>\u2013 n\u00f3 l\u00e0 m\u1ed9t to\u00e1n t\u1eed ph\u1ea1m vi cho ph\u00e9p b\u1ea1n t\u1ea1o m\u1ed9t tham chi\u1ebfu cho nhi\u1ec1u \u00f4 n\u1eb1m gi\u1eefa 2 \u00f4 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, ph\u1ea1m vi A1: A00 bao g\u1ed3m 100 \u00f4 t\u1eeb A1 \u0111\u1ebfn A100. \u0110\u1ec3 t\u00ecm trung b\u00ecnh c\u1ee7a 100 \u00f4 n\u00e0y, b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau: = AVERAGE (A1: A00)<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 tham kh\u1ea3o to\u00e0n b\u1ed9 c\u1ed9t (A: A) ho\u1eb7c to\u00e0n b\u1ed9 h\u00e0ng (1: 1). V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c sau t\u00ecm t\u1ed5ng s\u1ed1 t\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 trong c\u1ed9t A: = SUM (A: A).<\/p>\n<p style=\"text-align: justify\"><strong>D\u1ea5u ph\u1ea9y (,)<\/strong> \u2013 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 ph\u00e2n bi\u1ec7t \u0111\u1ed1i s\u1ed1 trong c\u00e1c c\u00f4ng th\u1ee9c b\u1ea3ng t\u00ednh Excel. V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c = IF (A1&gt; 0, \u201ct\u1ed1t\u201d, \u201cx\u1ea5u\u201d) \u0111\u1ecdc nh\u01b0 sau: n\u1ebfu A1 l\u1edbn h\u01a1n kh\u00f4ng, tr\u1ea3 l\u1ea1i \u201ct\u1ed1t\u201d, n\u1ebfu kh\u00f4ng \u201cx\u1ea5u\u201d.<\/p>\n<p style=\"text-align: justify\">Ch\u00fa th\u00edch. D\u1ea5u ph\u1ea9y l\u00e0 d\u1ea5u ph\u00e2n c\u00e1ch m\u1eb7c \u0111\u1ecbnh \u1edf B\u1eafc M\u1ef9 v\u00e0 m\u1ed9t s\u1ed1 n\u01b0\u1edbc kh\u00e1c. T\u1ea1i c\u00e1c qu\u1ed1c gia Ch\u00e2u \u00c2u, d\u1ea5u ph\u1ea9y \u0111\u01b0\u1ee3c gi\u1eef nh\u01b0 Bi\u1ec3u t\u01b0\u1ee3ng th\u1eadp ph\u00e2n v\u00e0 d\u1ea5u ph\u00e2n c\u00e1ch th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u0111\u1eb7t th\u00e0nh d\u1ea5u ch\u1ea5m ph\u1ea9y (;). Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u1ea7n ph\u1ea3i t\u00e1ch bi\u1ec7t \u0111\u1ed1i s\u1ed1 v\u1edbi c\u00e1c d\u1ea5u ch\u1ea5m ph\u1ea9y, v\u00ed d\u1ee5: = IF (A1&gt; 0, \u201ct\u1ed1t\u201d, \u201cx\u1ea5u\u201d).<\/p>\n<p style=\"text-align: justify\">V\u00ec v\u1eady, n\u1ebfu b\u1ea1n \u0111ang c\u1ed1 g\u1eafng t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n, nh\u01b0ng Excel kh\u00f4ng ch\u1ea5p nh\u1eadn n\u00f3 v\u00e0 \u0111\u01b0a ra l\u1ed7i \u201cformula invalid formula\u201d, h\u00e3y chuy\u1ec3n t\u1edbi Regional Settings (Control Panel&gt; Region and Language&gt; Additional Settings) v\u00e0 ki\u1ec3m tra k\u00fd hi\u1ec7u n\u00e0o \u0111\u01b0\u1ee3c \u0111\u1eb7t l\u00e0 d\u1ea5u ph\u00e2n c\u00e1ch \u1edf \u0111\u00f3. \u0110\u00f3 l\u00e0 d\u1ea5u m\u00e0 b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ec3 ph\u00e2n bi\u1ec7t \u0111\u1ed1i s\u1ed1 trong c\u00f4ng th\u1ee9c Excel c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\"><strong>Kho\u1ea3ng tr\u1eafng<\/strong> \u2013 n\u00f3 l\u00e0 m\u1ed9t to\u00e1n t\u1eed giao l\u1ed9 cho ph\u00e9p b\u1ea1n l\u1ea5y \u0111\u01b0\u1ee3c c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng v\u1edbi hai tham chi\u1ebfu m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c m\u1ee5c trong c\u1ed9t A v\u00e0 m\u1ed9t s\u1ed1 d\u1eef li\u1ec7u c\u00f3 li\u00ean quan trong c\u00e1c c\u1ed9t kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb t\u1ea1i giao \u0111i\u1ec3m c\u1ee7a m\u1ed9t c\u1ed9t v\u00e0 h\u00e0ng cho tr\u01b0\u1edbc b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c nh\u01b0 sau: = B3: D3 C2: C4<\/p>\n<figure style=\"width: 445px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1c to\u00e1n t\u1eed tham chi\u1ebfu trong c\u00e1c c\u00f4ng th\u1ee9c Excel v\u00e0 c\u00e1c h\u00e0m\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/intersection-operator-excel.png\" alt=\"Use the intersection operator to get a cell common to the two references that you specify.\" width=\"445\" height=\"140\"><figcaption class=\"wp-caption-text\">C\u00e1c to\u00e1n t\u1eed tham chi\u1ebfu trong c\u00e1c c\u00f4ng th\u1ee9c Excel v\u00e0 c\u00e1c h\u00e0m<\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cac_loai_cong_thuc_Excel\"><\/span>C\u00e1c lo\u1ea1i c\u00f4ng th\u1ee9c Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n t\u1ea1o trong b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 \u0111\u01a1n gi\u1ea3n ho\u1eb7c ph\u1ee9c t\u1ea1p:<\/p>\n<ul style=\"text-align: justify\">\n<li>C\u00e1c c\u00f4ng th\u1ee9c Excel \u0111\u01a1n gi\u1ea3n ch\u1ec9 th\u1ef1c hi\u1ec7n m\u1ed9t thao t\u00e1c to\u00e1n h\u1ecdc, v\u00ed d\u1ee5 = 10 * 5 ho\u1eb7c = SUM (A1: A10)<\/li>\n<li>C\u00e1c c\u00f4ng th\u1ee9c Excel ph\u1ee9c t\u1ea1p (ti\u00ean ti\u1ebfn) bao g\u1ed3m nhi\u1ec1u t\u00ednh to\u00e1n, v\u00ed d\u1ee5 = 10 * 5 + 20 ho\u1eb7c = SUM (A1: A10) \/ 2<\/li>\n<\/ul>\n<p style=\"text-align: justify\">H\u01a1n n\u1eefa trong h\u01b0\u1edbng d\u1eabn n\u00e0y, b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y c\u00e1c b\u01b0\u1edbc chi ti\u1ebft \u0111\u1ec3 t\u1ea1o c\u1ea3 hai lo\u1ea1i c\u00f4ng th\u1ee9c b\u1ea3ng t\u00ednh Excel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_tao_cac_cong_thuc_trong_Excel\"><\/span>C\u00e1ch t\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp, b\u1ea5t k\u1ef3 c\u00f4ng th\u1ee9c Excel n\u00e0o b\u1eaft \u0111\u1ea7u v\u1edbi d\u1ea5u b\u1eb1ng (=). V\u00ec v\u1eady, b\u1ea5t c\u1ee9 c\u00f4ng th\u1ee9c n\u00e0o b\u1ea1n s\u1ebd vi\u1ebft, b\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch g\u00f5 = trong \u00f4 ch\u1ec9 \u0111\u1ecbnh ho\u1eb7c trong thanh c\u00f4ng th\u1ee9c Excel. V\u00e0 b\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y c\u00f9ng xem x\u00e9t c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c nhau trong Excel.<\/p>\n<p style=\"text-align: justify\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n trong Excel<\/p>\n<p style=\"text-align: justify\">M\u1eb7c d\u00f9 c\u00e1c c\u00f4ng th\u1ee9c Excel \u0111\u01a1n gi\u1ea3n ch\u1ec9 th\u1ef1c hi\u1ec7n m\u1ed9t ph\u00e9p t\u00ednh, ch\u00fang c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo nhi\u1ec1u c\u00e1ch kh\u00e1c nhau. B\u1ea1n c\u00f3 th\u1ec3 cung c\u1ea5p d\u1eef li\u1ec7u ngu\u1ed3n d\u01b0\u1edbi d\u1ea1ng h\u1eb1ng s\u1ed1, tham chi\u1ebfu \u00f4, ho\u1eb7c c\u00e1c t\u00ean \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh, v\u00e0 th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c to\u00e1n t\u1eed to\u00e1n h\u1ecdc ho\u1eb7c c\u00e1c h\u00e0m Excel.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tao_cac_cong_thuc_tien_tien_trong_Excel\"><\/span>C\u00e1ch t\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c ti\u00ean ti\u1ebfn trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Khi b\u1ea1n c\u00f3 m\u1ed9t s\u1ed1 kinh nghi\u1ec7m v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c Excel \u0111\u01a1n gi\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n th\u1ef1c hi\u1ec7n m\u1ed9t s\u1ed1 t\u00ednh to\u00e1n trong m\u1ed9t c\u00f4ng th\u1ee9c. V\u00e0 c\u00e1c v\u00ed d\u1ee5 sau cho th\u1ea5y c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y.<\/p>\n<p style=\"text-align: justify\">T\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p v\u1edbi c\u00e1c h\u1eb1ng s\u1ed1 v\u00e0 c\u00e1c to\u00e1n t\u1eed to\u00e1n h\u1ecdc<\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p \u0111\u1ec3 ch\u00ednh x\u00e1c, m\u1ed9t s\u1ed1 thao t\u00e1c nh\u1ea5t \u0111\u1ecbnh ph\u1ea3i \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n tr\u01b0\u1edbc. L\u1ec7nh m\u1eb7c \u0111\u1ecbnh ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00e1c c\u00f4ng th\u1ee9c Excel l\u00e0:<\/p>\n<ul style=\"text-align: justify\">\n<li>Ph\u00e9p t\u00ednh trong d\u1ea5u ngo\u1eb7c \u0111\u01a1n<\/li>\n<li>L\u0169y th\u1eeba<\/li>\n<li>Nh\u00e2n v\u00e0 chia, t\u00f9y \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u1ebfn tr\u01b0\u1edbc trong m\u1ed9t c\u00f4ng th\u1ee9c<\/li>\n<li>C\u1ed9ng v\u00e0 tr\u1eeb, t\u00f9y \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u1ebfn tr\u01b0\u1edbc trong m\u1ed9t c\u00f4ng th\u1ee9c<\/li>\n<\/ul>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c sau \u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 v\u00e0 hoa h\u1ed3ng:<\/p>\n<figure style=\"width: 551px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1ch t\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c ti\u00ean ti\u1ebfn trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/complex-excel-formula.png\" alt=\"Complex Excel formulas with constants and mathematic operators\" width=\"551\" height=\"161\"><figcaption class=\"wp-caption-text\">C\u00e1ch t\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c ti\u00ean ti\u1ebfn trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, h\u00e3y ph\u00e2n t\u00edch c\u00e1c c\u00f4ng th\u1ee9c n\u00e0y \u0111\u1ec3 xem c\u00e1ch Microsoft Excel t\u00ednh to\u00e1n ch\u00fang nh\u01b0 th\u1ebf n\u00e0o:<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c: <strong>= $B2*$D2 + $B2 * $D2 * $C2<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>L\u1ea7n nh\u00e2n th\u1ee9 nh\u1ea5t: $B2 * $D2 (gi\u00e1 * s\u1ed1 l\u01b0\u1ee3ng. = S\u1ed1 ti\u1ec1n)<\/li>\n<li>Ph\u00e9p nh\u00e2n s\u1ed1 th\u1ee9 2 v\u00e0 th\u1ee9 3: $B2*$D2*$C2 (gi\u00e1 * s\u1ed1 l\u01b0\u1ee3ng * VAT% = s\u1ed1 VAT)<\/li>\n<li>Ph\u00e9p c\u1ed9ng: S\u1ed1 ti\u1ec1n + S\u1ed1 ti\u1ec1n thu\u1ebf VAT = t\u1ed5ng s\u1ed1<\/li>\n<\/ul>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c hoa h\u1ed3ng: <strong>= ($B2 * $D2 + $B2 * $D2 * $C2) * 10%<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh kho\u1ea3n hoa h\u1ed3ng 10%, b\u1ea1n c\u1ea7n nh\u00e2n t\u1ed5ng c\u1ed9ng v\u1edbi 10%, do \u0111\u00f3 b\u1ea1n k\u00e8m theo t\u00ednh to\u00e1n tr\u01b0\u1edbc \u0111\u00f3 trong ngo\u1eb7c v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 mong mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\">T\u1ea5t nhi\u00ean, kh\u00f4ng c\u00f3 g\u00ec ng\u0103n c\u1ea3n b\u1ea1n nh\u00e2n t\u1ed5ng s\u1ed1 \u0111\u00e3 \u0111\u01b0\u1ee3c t\u00ednh trong c\u1ed9t E v\u1edbi 10%, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y c\u00f4ng th\u1ee9c s\u1ebd th\u00e0nh m\u1ed9t ph\u00e9p t\u00ednh \u0111\u01a1n gi\u1ea3n = E2 * 10%. Tuy nhi\u00ean, trong c\u00e1c b\u1ea3ng t\u00ednh l\u1edbn, n\u00ean vi\u1ebft c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n \u0111\u1ed9c l\u1eadp m\u1ed9t c\u00e1ch h\u1ee3p l\u00fd.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_Excel_voi_ham_long_nhau\"><\/span>C\u00f4ng th\u1ee9c Excel v\u1edbi h\u00e0m l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong c\u00f4ng th\u1ee9c Microsoft Excel, l\u1ed3ng h\u00e0m b\u00ean trong m\u1ed9t h\u00e0m kh\u00e1c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t h\u00e0m nh\u01b0 m\u1ed9t \u0111\u1ed1i s\u1ed1 c\u1ee7a m\u1ed9t h\u00e0m kh\u00e1c. Trong c\u00e1c phi\u00ean b\u1ea3n hi\u1ec7n t\u1ea1i c\u1ee7a Excel 2016, 2013, 2010 v\u00e0 2010, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed1i \u0111a 64 h\u00e0m l\u1ed3ng nhau. Trong c\u00e1c phi\u00ean b\u1ea3n c\u0169 c\u1ee7a Excel 2003 v\u00e0 phi\u00ean b\u1ea3n th\u1ea5p h\u01a1n, ch\u1ec9 \u0111\u01b0\u1ee3c ph\u00e9p c\u00f3 7 h\u00e0m.<\/p>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u1ec1 c\u00f4ng th\u1ee9c Excel l\u1ed3ng nhau c\u00f3 ch\u1ee9a h\u00e0m SUM \u0111\u1ec3 t\u00ecm t\u1ed5ng s\u1ed1, v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-lam-tron-round-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">ch\u1ee9c n\u0103ng ROUND<\/a> \u0111\u1ec3 tr\u00f2n s\u1ed1 \u0111\u00f3 \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t (0 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n): = ROUND (SUM (B2: B6), 0)<\/p>\n<figure style=\"width: 244px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00f4ng th\u1ee9c Excel v\u1edbi h\u00e0m l\u1ed3ng nhau\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nested-excel-functions.png\" alt=\"An example of Excel formula with nested functions\" width=\"244\" height=\"204\"><figcaption class=\"wp-caption-text\">C\u00f4ng th\u1ee9c Excel v\u1edbi h\u00e0m l\u1ed3ng nhau<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Trong t\u1ea5t c\u1ea3 c\u00e1c h\u00e0m Excel, <a href=\"http:\/\/blog.ezworkapp.com\/ham-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m IF l\u1ed3ng<\/a> th\u01b0\u1eddng xuy\u00ean h\u01a1n t\u1ea5t c\u1ea3 c\u00e1c h\u00e0m kh\u00e1c. Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 bi\u1ebft, <a href=\"http:\/\/blog.ezworkapp.com\/ham-if-va-cach-su-dung-ham-if-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m IF <\/a>\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3 v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb khi \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng v\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c khi \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng. Tuy nhi\u00ean, th\u1ef1c t\u1ebf b\u1ea1n th\u01b0\u1eddng ph\u1ea3i \u0111\u1ed1i ph\u00f3 v\u1edbi c\u00e1c t\u00ecnh hu\u1ed1ng c\u00f3 nhi\u1ec1u h\u01a1n hai k\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 x\u1ea3y ra. V\u00e0 n\u1ebfu tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft m\u1ed9t s\u1ed1 h\u00e0m IF v\u00e0 l\u1ed3ng n\u00f3 v\u00e0o nhau:<\/p>\n<figure style=\"width: 378px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00f4ng th\u1ee9c Excel v\u1edbi h\u00e0m l\u1ed3ng nhau 01\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nested-if-functions.png\" alt=\"Using nested IF functions in Excel\" width=\"378\" height=\"162\"><figcaption class=\"wp-caption-text\">C\u00f4ng th\u1ee9c Excel v\u1edbi h\u00e0m l\u1ed3ng nhau 01<\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_mang_trong_Excel\"><\/span>C\u00f4ng th\u1ee9c m\u1ea3ng trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel l\u00e0 m\u1ed9t b\u01b0\u1edbc c\u1ea3i ti\u1ebfn. M\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng Excel \u0111\u01a1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n h\u00e0ng ng\u00e0n ph\u00e9p t\u00ednh v\u00e0 thay th\u1ebf h\u00e0ng tr\u0103m c\u00f4ng th\u1ee9c th\u00f4ng th\u01b0\u1eddng. Nghi\u00ean c\u1ee9u c\u00f4ng th\u1ee9c m\u1ea3ng ch\u1eafc ch\u1eafn \u0111\u00f2i h\u1ecfi th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c, nh\u01b0ng x\u1ee9ng \u0111\u00e1ng.<\/p>\n<p style=\"text-align: justify\">V\u00ec h\u01b0\u1edbng d\u1eabn n\u00e0y d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u, t\u00f4i s\u1ebd kh\u00f4ng h\u0103m d\u1ecda b\u1ea1n b\u1edfi c\u00e1c \u0111\u1ecbnh ngh\u0129a c\u00e1c h\u1eb1ng s\u1ed1 m\u1ea3ng v\u00e0 c\u00e1c c\u00f4ng th\u1ee9c nhi\u1ec1u d\u00f2ng ph\u1ee9c t\u1ea1p. T\u00f4i s\u1ebd ch\u1ec9 hi\u1ec3n th\u1ecb m\u1ed9t v\u00ed d\u1ee5 r\u1ea5t \u0111\u01a1n gi\u1ea3n c\u1ee7a m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng Excel th\u1ec3 hi\u1ec7n nh\u1eefng g\u00ec n\u00f3 c\u00f3 th\u1ec3 l\u00e0m.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 2 c\u1ed9t s\u1ed1, c\u1ed9t A v\u00e0 B. V\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft c\u00f3 bao nhi\u00eau l\u1ea7n c\u1ed9t B l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng c\u1ed9t A khi gi\u00e1 tr\u1ecb trong c\u1ed9t B l\u1edbn h\u01a1n 0. Nhi\u1ec7m v\u1ee5 n\u00e0y \u0111\u00f2i h\u1ecfi ph\u1ea3i so s\u00e1nh hai d\u00e3y v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng sau:<\/p>\n<p style=\"text-align: justify\"><strong>= SUM ((B2: B10&gt; = A2: A10) * (B2: B10&gt; 0))<\/strong><\/p>\n<figure style=\"width: 432px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00f4ng th\u1ee9c m\u1ea3ng trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-array-formula.png\" alt=\"An example of an Excel array formula\" width=\"432\" height=\"284\"><figcaption class=\"wp-caption-text\">C\u00f4ng th\u1ee9c m\u1ea3ng trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Ch\u00fa th\u00edch. \u0110\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c m\u1ea3ng Excel m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c, b\u1ea1n ph\u1ea3i nh\u1ea5n <strong>Ctrl + Shift + Enter<\/strong> thay v\u00ec g\u00f5 Enter th\u00f4ng th\u01b0\u1eddng.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_nguoi_dung_tu_tao\"><\/span>H\u00e0m ng\u01b0\u1eddi d\u00f9ng t\u1ef1 t\u1ea1o<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">M\u1eb7c d\u00f9 Microsoft Excel c\u00f3 h\u00e0ng tr\u0103m h\u00e0m \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng, b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 th\u1ea5y m\u00ecnh ph\u1ea3i \u0111\u1ed1i m\u1eb7t v\u1edbi m\u1ed9t th\u00e1ch th\u1ee9c m\u00e0 kh\u00f4ng c\u00f3 h\u00e0m Excel ph\u00f9 h\u1ee3p. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra h\u00e0m \u0111\u00f3 \u2026 ho\u1eb7c c\u00f3 ai \u0111\u00f3 t\u1ea1o ra n\u00f3 cho b\u1ea1n \ud83d\ude42<\/p>\n<p style=\"text-align: justify\">C\u00e1c h\u00e0m t\u00f9y ch\u1ec9nh n\u00e0y \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 C\u00e1c h\u00e0m do ng\u01b0\u1eddi d\u00f9ng t\u1ea1o (UDF), v\u00e0 ch\u00fang \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch cho c\u00e1c t\u00ednh to\u00e1n to\u00e1n ho\u1eb7c k\u1ef9 thu\u1eadt cao c\u1ea5p. Gi\u1ed1ng nh\u01b0 macro, c\u00e1c h\u00e0m do ng\u01b0\u1eddi d\u00f9ng t\u1ea1o \u0111\u01b0\u1ee3c vi\u1ebft b\u1eb1ng <a href=\"http:\/\/blog.ezworkapp.com\/bat-dau-voi-excel-macros-va-lap-trinh-vba.html\" target=\"_blank\" rel=\"noopener noreferrer\">VBA <\/a>(Visual Basic for Applications).<\/p>\n<p style=\"text-align: justify\">C\u00e1c tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i, t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 h\u1ed7n h\u1ee3p trong c\u00e1c c\u00f4ng th\u1ee9c Excel<\/p>\n<p style=\"text-align: justify\">C\u00f3 3 lo\u1ea1i tham chi\u1ebfu \u00f4 trong Excel: tuy\u1ec7t \u0111\u1ed1i ($A$1), t\u01b0\u01a1ng \u0111\u1ed1i (A1) v\u00e0 h\u1ed7n h\u1ee3p ($A1 ho\u1eb7c A$1). C\u1ea3 ba lo\u1ea1i tr\u00ean \u0111\u1ec1 c\u1eadp \u0111\u1ebfn c\u00f9ng m\u1ed9t \u00f4, v\u00e0 d\u1ea5u \u0111\u00f4 la ($) ch\u1ec9 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho m\u1ed9t m\u1ee5c \u0111\u00edch \u2013 n\u00f3 n\u00f3i v\u1edbi Microsoft Excel r\u1eb1ng c\u00f3 thay \u0111\u1ed5i hay kh\u00f4ng thay \u0111\u1ed5i c\u00e1c tham chi\u1ebfu \u00f4 khi c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c di chuy\u1ec3n ho\u1eb7c sao ch\u00e9p sang c\u00e1c \u00f4 kh\u00e1c.<\/p>\n<p style=\"text-align: justify\"><strong>Tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i ($A$1)<\/strong> \u2013 d\u1ea5u $ tr\u01b0\u1edbc khi c\u00e1c t\u1ecda \u0111\u1ed9 c\u1ee7a h\u00e0ng v\u00e0 c\u1ed9t l\u00e0m cho tham chi\u1ebfu t\u0129nh v\u00e0 cho ph\u00e9p b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng thay \u0111\u1ed5i t\u00e0i li\u1ec7u tham kh\u1ea3o.<\/p>\n<p style=\"text-align: justify\"><strong>Tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i (A1)<\/strong> \u2013 m\u1ed9t tham chi\u1ebfu \u00f4 kh\u00f4ng c\u00f3 d\u1ea5u hi\u1ec7u thay \u0111\u1ed5i d\u1ef1a tr\u00ean v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a h\u00e0ng v\u00e0 c\u1ed9t trong m\u1ed9t b\u1ea3ng t\u00ednh.<\/p>\n<p style=\"text-align: justify\"><strong>Tham chi\u1ebfu \u00f4 h\u1ed7n h\u1ee3p<\/strong> \u2013 c\u00f3 th\u1ec3 c\u00f3 2 lo\u1ea1i:<\/p>\n<ul style=\"text-align: justify\">\n<li>C\u1ed9t tuy\u1ec7t \u0111\u1ed1i v\u00e0 h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i ($A1) \u2013 d\u1ea5u hi\u1ec7u $ \u1edf ph\u00eda tr\u01b0\u1edbc c\u1ee7a c\u1ed9t ch\u1eef c\u00e1i kh\u00f3a tham chi\u1ebfu \u0111\u1ebfn c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh, v\u00ec v\u1eady c\u1ed9t kh\u00f4ng bao gi\u1edd thay \u0111\u1ed5i. Tham chi\u1ebfu h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i, kh\u00f4ng c\u00f3 d\u1ea5u \u0111\u00f4 la, thay \u0111\u1ed5i t\u00f9y thu\u1ed9c v\u00e0o h\u00e0ng m\u00e0 c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sao ch\u00e9p.<\/li>\n<li>C\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 h\u00e0ng tuy\u1ec7t \u0111\u1ed1i (A$1) \u2013 tham chi\u1ebfu c\u1ee7a h\u00e0ng \u0111\u01b0\u1ee3c kh\u00f3a b\u1edfi $ kh\u00f4ng thay \u0111\u1ed5i, v\u00e0 tham chi\u1ebfu c\u1ee7a c\u1ed9t \u0111\u00f3 thay \u0111\u1ed5i.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y c\u00e1c lo\u1ea1i tham chi\u1ebfu kh\u00e1c nhau ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o trong th\u1ef1c t\u1ebf.<\/p>\n<figure style=\"width: 469px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"H\u00e0m ng\u01b0\u1eddi d\u00f9ng t\u1ef1 t\u1ea1o\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-cell-references.png\" alt=\"Absolute, relative and mixed cell references in Excel formulas\" width=\"469\" height=\"544\"><figcaption class=\"wp-caption-text\">H\u00e0m ng\u01b0\u1eddi d\u00f9ng t\u1ef1 t\u1ea1o<\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Meo_va_cac_phim_tat_tiet_kiem_thoi_gian_cho_cac_cong_thuc_Excel\"><\/span>M\u1eb9o v\u00e0 c\u00e1c ph\u00edm t\u1eaft ti\u1ebft ki\u1ec7m th\u1eddi gian cho c\u00e1c c\u00f4ng th\u1ee9c Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00e1c c\u00f4ng th\u1ee9c trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 \u0111a di\u1ec7n m\u1ea1nh m\u1ebd v\u00e0 ch\u00fang c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft r\u1ea5t nhi\u1ec1u c\u00f4ng vi\u1ec7c trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n. T\u1ea5t nhi\u00ean, h\u1ecdc c\u00e1c kh\u00eda c\u1ea1nh kh\u00e1c nhau c\u1ee7a h\u00e0m Excel v\u00e0 c\u00f4ng th\u1ee9c s\u1ebd t\u1ed1n th\u1eddi gian, v\u00ec v\u1eady b\u1ea1n c\u00f3 th\u1ec3 c\u1ea3m th\u1ea5y kh\u00f4ng c\u00f3 \u0111\u1ee7 th\u1eddi gian \u0111\u1ec3 t\u00ecm hi\u1ec3u t\u1ea5t c\u1ea3 m\u1ecdi th\u1ee9. V\u00e2ng, m\u1ed9t c\u00e1ch t\u1ed1t \u0111\u1ec3 t\u00ecm th\u00eam th\u1eddi gian l\u00e0 \u0111\u1ec3 ti\u1ebft ki\u1ec7m m\u1ed9t th\u1eddi gian \ud83d\ude42<\/p>\n<ul>\n<li style=\"text-align: justify\">\u0110\u1ec3 chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i, t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 h\u1ed7n h\u1ee3p trong m\u1ed9t c\u00f4ng th\u1ee9c, s\u1eed d\u1ee5ng ph\u00edm F4.<\/li>\n<li style=\"text-align: justify\">\u0110\u1ec3 xem t\u1ea5t c\u1ea3 c\u00f4ng th\u1ee9c tr\u00ean trang t\u00ednh, nh\u1ea5p v\u00e0o n\u00fat <strong>Show Formulas <\/strong>tr\u00ean tab Formulas&gt; Nh\u00f3m Formulas Auditing ho\u1eb7c nh\u1ea5n ph\u00edm t\u1eaft <strong>Ctrl + ~.<\/strong><\/li>\n<li style=\"text-align: justify\">\u0110\u1ec3 ch\u1ec9nh s\u1eeda m\u1ed9t c\u00f4ng th\u1ee9c, <strong>nh\u1ea5n F2<\/strong>, ho\u1eb7c nh\u1ea5p \u0111\u00fap v\u00e0o m\u1ed9t \u00f4, ho\u1eb7c nh\u1ea5p v\u00e0o thanh c\u00f4ng th\u1ee9c.<\/li>\n<li style=\"text-align: justify\">\u0110\u1ec3 g\u1ee1 l\u1ed7i c\u00f4ng th\u1ee9c trong Excel, h\u00e3y ch\u1ecdn m\u1ed9t ph\u1ea7n c\u00f4ng th\u1ee9c v\u00e0 <strong>nh\u1ea5n F9<\/strong>. \u0110i\u1ec1u n\u00e0y s\u1ebd cho ph\u00e9p b\u1ea1n xem c\u00e1c gi\u00e1 tr\u1ecb th\u1ef1c t\u1ebf \u0111\u1eb1ng sau c\u00e1c tham chi\u1ebfu \u00f4.<\/li>\n<li style=\"text-align: justify\">\u0110\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c t\u1edbi t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong m\u1ed9t c\u1ed9t, nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean, ch\u1ecdn \u00f4 \u0111\u00f3 v\u00e0 di con tr\u1ecf qua h\u00ecnh vu\u00f4ng nh\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i cho \u0111\u1ebfn khi n\u00f3 chuy\u1ec3n th\u00e0nh ch\u1eef th\u1eadp \u0111\u1ecf \u0111en (\u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 Fill handle). Nh\u1ea5p \u0111\u00fap v\u00e0o ch\u1eef th\u1eadp \u0111\u00f3 v\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sao ch\u00e9p qua to\u00e0n b\u1ed9 c\u1ed9t.<\/li>\n<li style=\"text-align: justify\">\u0110\u1ec3 chuy\u1ec3n \u0111\u1ed5i c\u00e1c c\u00f4ng th\u1ee9c sang c\u00e1c gi\u00e1 tr\u1ecb, h\u00e3y ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i, nh\u1ea5n <strong>Ctrl + C<\/strong> \u0111\u1ec3 sao ch\u00e9p c\u00e1c c\u00f4ng th\u1ee9c \u0111\u00f3, sau \u0111\u00f3 nh\u1ea5n <strong>Shift + F10<\/strong>, sau \u0111\u00f3 <strong>nh\u1ea5n V<\/strong>, v\u00e0 sau \u0111\u00f3 nh\u1ea5n <strong>Enter.<\/strong> <strong>Shift + F10 + V<\/strong> l\u00e0 ph\u00edm t\u1eaft cho c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1eb7c bi\u1ec7t <strong>Paste<\/strong> c\u1ee7a Excel. N\u1ebfu b\u1ea1n kh\u00f4ng ch\u1eafc ch\u1eafn s\u1ebd nh\u1edb l\u1ed1i t\u1eaft n\u00e0y, sau \u0111\u00f3 ch\u1ec9 c\u1ea7n nh\u1ea5n ph\u00edm t\u1eaft th\u00f4ng th\u01b0\u1eddng \u0111\u1ec3 d\u00e1n<strong> Ctrl + V<\/strong>, nh\u1ea5p v\u00e0o m\u0169i t\u00ean nh\u1ecf \u1edf b\u00ean ph\u1ea3i c\u1ee7a n\u00fat Paste \u0111\u1ec3 m\u1edf danh s\u00e1ch th\u1ea3 xu\u1ed1ng v\u00e0 ch\u1ecdn <strong>Paste Values<\/strong>.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn chuy\u00ean gia c\u00f9ng gi\u1ea3ng vi\u00ean Nguy\u1ec5n \u0110\u1ee9c Thanh hay DT Nguyen.<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-110.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3295,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3294","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\/3294","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=3294"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3294\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3295"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}