{"id":11757,"date":"2025-01-15T05:04:12","date_gmt":"2025-01-15T05:04:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi\/"},"modified":"2025-01-15T05:04:12","modified_gmt":"2025-01-15T05:04:12","slug":"tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi\/","title":{"rendered":"T\u1ea1i sao ph\u1ea3i s\u1eed d\u1ee5ng k\u00fd hi\u1ec7u dollar ($) trong c\u00f4ng th\u1ee9c Excel \u2013 c\u00e1c tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online cung c\u1ea5p cho b\u1ea1n \u0111\u1ea7y \u0111\u1ee7 chi ti\u1ebft v\u1ec1 t\u00ednh n\u0103ng c\u1ee7a d\u1ea5u $.<\/p>\n<p>T\u1ea7m quan tr\u1ecdng c\u1ee7a tham chi\u1ebfu \u00f4 kh\u00f4ng th\u1ec3 xem th\u01b0\u1eddng.\u00a0Hi\u1ec3u s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i, t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 h\u1ed7n h\u1ee3p l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 n\u1eafm t\u00ednh linh ho\u1ea1t c\u1ee7a c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m trong Excel.<\/p>\n<p>T\u1ea5t c\u1ea3 c\u00e1c b\u1ea1n c\u00f3 l\u1ebd \u0111\u00e3 th\u1ea5y d\u1ea5u dollar ($) trong c\u00f4ng th\u1ee9c Excel v\u00e0 t\u1ef1 h\u1ecfi r\u1ed1t cu\u1ed9c ch\u00fang l\u00e0 g\u00ec.\u00a0Th\u1ef1c t\u1ebf, b\u1ea1n c\u00f3 th\u1ec3 tham chi\u1ebfu m\u1ed9t v\u00e0 c\u00f9ng m\u1ed9t \u00f4 theo b\u1ed1n c\u00e1ch kh\u00e1c nhau, v\u00ed d\u1ee5 A1, $A$1, $A1, v\u00e0 A$1.<\/p>\n<p>D\u1ea5u dollar trong m\u1ed9t tham chi\u1ebfu \u00f4 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn m\u1ed9t \u0111i\u1ec1u duy nh\u1ea5t \u2013 n\u00f3 h\u01b0\u1edbng d\u1eabn Excel c\u00e1ch \u0111\u1ed1i x\u1eed l\u00fd v\u1edbi d\u1eef li\u1ec7u tham chi\u1ebfu khi c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c di chuy\u1ec3n ho\u1eb7c sao ch\u00e9p sang c\u00e1c \u00f4 kh\u00e1c.\u00a0T\u00f3m l\u1ea1i, s\u1eed d\u1ee5ng d\u1ea5u $ tr\u01b0\u1edbc h\u00e0ng v\u00e0 c\u1ed9t t\u1ea1o ra m\u1ed9t tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i, n\u00f3 s\u1ebd kh\u00f4ng thay \u0111\u1ed5i.\u00a0N\u1ebfu kh\u00f4ng c\u00f3 d\u1ea5u dollar, tham chi\u1ebfu l\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 n\u00f3 s\u1ebd thay \u0111\u1ed5i.<\/p>\n<p>N\u1ebfu b\u1ea1n \u0111ang vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c v\u00e0o m\u1ed9t \u00f4 \u0111\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng b\u1ea5t k\u1ef3 lo\u1ea1i tham chi\u1ebfu n\u00e0o v\u00e0 \u0111\u1ec1u c\u00f3 \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c \u0111\u00fang.\u00a0Nh\u01b0ng n\u1ebfu b\u1ea1n d\u1ef1 \u0111\u1ecbnh sao ch\u00e9p c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n v\u00e0o c\u00e1c \u00f4 kh\u00e1c, vi\u1ec7c ch\u1ecdn ki\u1ec3u tham chi\u1ebfu \u00f4 th\u00edch h\u1ee3p l\u00e0 r\u1ea5t quan tr\u1ecdng.\u00a0N\u1ebfu b\u1ea1n mu\u1ed1n nghi\u00ean c\u1ee9u nghi\u00eam t\u00fac, h\u00e3y \u0111\u1ea7u t\u01b0 m\u1ed9t v\u00e0i ph\u00fat h\u1ecdc t\u1ea5t c\u1ea3 ki\u1ebfn th\u1ee9c c\u1ee7a c\u00e1c tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i trong Excel, v\u00e0 khi n\u00e0o s\u1eed d\u1ee5ng n\u00f3.<\/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-678741c9a0d06\" 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\/tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi.html#Tham_chieu_o_Excel_la_gi\" title=\"Tham chi\u1ebfu \u00f4 Excel l\u00e0 g\u00ec?\">Tham chi\u1ebfu \u00f4 Excel l\u00e0 g\u00ec?<\/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\/tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi.html#Tham_chieu_o_tuong_doi_khong_co_ky_hieu\" title=\"Tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i (kh\u00f4ng c\u00f3 k\u00fd hi\u1ec7u $)\">Tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i (kh\u00f4ng c\u00f3 k\u00fd hi\u1ec7u $)<\/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\/tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi.html#Su_dung_tham_chieu_tuong_doi_%E2%80%93_cong_thuc_vi_du\" title=\"S\u1eed d\u1ee5ng tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i \u2013 c\u00f4ng th\u1ee9c v\u00ed d\u1ee5\">S\u1eed d\u1ee5ng tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i \u2013 c\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/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\/tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi.html#Phim_tat_de_sao_chep_cong_thuc_vao_cac_o_khac\" title=\"Ph\u00edm t\u1eaft \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 kh\u00e1c\">Ph\u00edm t\u1eaft \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 kh\u00e1c<\/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\/tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi.html#Tham_chieu_o_tuyet_doi_trong_Excel_voi_dau\" title=\"Tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i trong Excel (v\u1edbi d\u1ea5u $)\">Tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i trong Excel (v\u1edbi d\u1ea5u $)<\/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\/tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi.html#Su_dung_tham_chieu_o_tuong_doi_va_tuyet_doi_trong_mot_cong_thuc\" title=\"S\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 tuy\u1ec7t \u0111\u1ed1i trong m\u1ed9t c\u00f4ng th\u1ee9c\">S\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 tuy\u1ec7t \u0111\u1ed1i trong m\u1ed9t c\u00f4ng th\u1ee9c<\/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\/tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi.html#Tham_chieu_o_hon_hop\" title=\"Tham chi\u1ebfu \u00f4 h\u1ed7n h\u1ee3p\">Tham chi\u1ebfu \u00f4 h\u1ed7n h\u1ee3p<\/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\/tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi.html#Su_dung_tham_chieu_hon_hop_trong_Excel_%E2%80%93_cong_thuc_vi_du\" title=\"S\u1eed d\u1ee5ng tham chi\u1ebfu h\u1ed7n h\u1ee3p trong Excel \u2013 c\u00f4ng th\u1ee9c v\u00ed d\u1ee5\">S\u1eed d\u1ee5ng tham chi\u1ebfu h\u1ed7n h\u1ee3p trong Excel \u2013 c\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi.html#Lam_the_nao_de_tham_chieu_toan_bo_cot_hoac_hang_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t ho\u1eb7c h\u00e0ng trong Excel\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t ho\u1eb7c h\u00e0ng trong 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-10\" href=\"https:\/\/blog.hocexcel.online\/tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi.html#Tham_chieu_toan_bo_cot\" title=\"Tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t\">Tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi.html#Tham_chieu_toan_bo_hang\" title=\"Tham chi\u1ebfu to\u00e0n b\u1ed9 h\u00e0ng\">Tham chi\u1ebfu to\u00e0n b\u1ed9 h\u00e0ng<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tham_chieu_o_Excel_la_gi\"><\/span><strong>Tham chi\u1ebfu \u00f4 <\/strong><strong>Excel l\u00e0 g\u00ec?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n th\u00ec tham chi\u1ebfu \u00f4 trong Excel l\u00e0 m\u1ed9t \u0111\u1ecba ch\u1ec9 \u00f4.\u00a0N\u00f3 cho Microsoft Excel bi\u1ebft n\u01a1i \u0111\u1ec3 t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c.<\/p>\n<p>V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n nh\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n =A1 trong \u00f4 C1, Excel s\u1ebd k\u00e9o m\u1ed9t gi\u00e1 tr\u1ecb t\u1eeb \u00f4 A1 v\u00e0o C1:<\/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\/2025\/01\/vba101_92019-nho-58.gif\" title=\"vba101_92019-nho-58\"><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\/2025\/01\/ex101_92019-nho-323.gif\" title=\"ex101_92019-nho-323\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"An Excel cell reference\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-cell-reference.png\" alt=\"An Excel cell reference\"><\/p>\n<p>Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp, mi\u1ec5n l\u00e0 b\u1ea1n vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c cho m\u1ed9t\u00a0<strong>\u00f4<\/strong>\u00a0, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng b\u1ea5t k\u1ef3 ki\u1ec3u tham chi\u1ebfu n\u00e0o, c\u00f3 ho\u1eb7c kh\u00f4ng c\u00f3 d\u1ea5u dollar ($), k\u1ebft qu\u1ea3 v\u1eabn s\u1ebd gi\u1ed1ng nhau:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Using $ in Excel formulas\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-formula-dollar-sign.png\" alt=\"Using $ in Excel formulas\">Nh\u01b0ng n\u1ebfu b\u1ea1n mu\u1ed1n\u00a0<strong>di chuy\u1ec3n<\/strong>\u00a0ho\u1eb7c\u00a0<strong>sao ch\u00e9p<\/strong>\u00a0c\u00f4ng th\u1ee9c tr\u00ean worksheet, \u0111i\u1ec1u quan tr\u1ecdng l\u00e0 b\u1ea1n ph\u1ea3i ch\u1ecdn \u0111\u00fang lo\u1ea1i tham chi\u1ebfu cho c\u00f4ng th\u1ee9c \u0111\u1ec3 sao ch\u00e9p ch\u00ednh x\u00e1c \u0111\u1ebfn c\u00e1c \u00f4 kh\u00e1c.\u00a0.<\/p>\n<p><strong>Ch\u00fa \u00fd:\u00a0<\/strong>Ngo\u00e0i\u00a0<strong>ki\u1ec3u tham chi\u1ebfu A1<\/strong>, c\u00e1c c\u1ed9t \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh theo ch\u1eef c\u00e1i v\u00e0 c\u00e1c d\u00f2ng theo s\u1ed1, c\u0169ng t\u1ed3n t\u1ea1i\u00a0<strong>ki\u1ec3u t\u00e0i li\u1ec7u tham chi\u1ebfu R1C1<\/strong>\u00a0khi c\u1ea3 h\u00e0ng v\u00e0 c\u1ed9t \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1eb1ng s\u1ed1 (R1C1 ch\u1ec9 \u0111\u1ecbnh h\u00e0ng 1, c\u1ed9t 1).<\/p>\n<p>B\u1edfi v\u00ec A1 l\u00e0 ki\u1ec3u tham chi\u1ebfu m\u1eb7c \u0111\u1ecbnh trong Excel v\u00e0 n\u00f3 h\u1ea7u nh\u01b0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng m\u1ecdi l\u00fac, n\u00ean ch\u00fang ta ch\u1ec9 th\u1ea3o lu\u1eadn v\u1ec1 c\u00e1c tham chi\u1ebfu lo\u1ea1i A1 trong h\u01b0\u1edbng d\u1eabn n\u00e0y.\u00a0N\u1ebfu ai hi\u1ec7n \u0111ang s\u1eed d\u1ee5ng ki\u1ec3u R1C1, th\u00ec c\u00f3 th\u1ec3 t\u1eaft n\u00f3 b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o\u00a0<strong><em>File\u00a0&gt;\u00a0Options\u00a0&gt;\u00a0Formulas<\/em><\/strong>\u00a0v\u00e0 b\u1ecf ch\u1ecdn\u00a0h\u1ed9p\u00a0<strong><em>R1C1 reference style<\/em><\/strong>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tham_chieu_o_tuong_doi_khong_co_ky_hieu\"><\/span><strong>Tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i (kh\u00f4ng c\u00f3 k\u00fd hi\u1ec7u $)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed9t\u00a0<strong>tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i<\/strong>\u00a0trong Excel l\u00e0 m\u1ed9t tham chi\u1ebfu \u00f4 kh\u00f4ng c\u00f3 d\u1ea5u dollar, nh\u01b0\u00a0<em>A1<\/em>\u00a0.<\/p>\n<p>S\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i trong c\u00f4ng th\u1ee9c \u0111\u1ec3\u00a0<strong>\u0111i\u1ec1u ch\u1ec9nh tham chi\u1ebfu \u0111\u00f3<\/strong>\u00a0t\u00f9y thu\u1ed9c v\u00e0o n\u01a1i b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c.\u00a0Ch\u00ednh x\u00e1c h\u01a1n, m\u1ed9t tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i thay \u0111\u1ed5i d\u1ef1a tr\u00ean v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t.<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 c\u00f4ng th\u1ee9c sau trong \u00f4 B1:<\/p>\n<p><strong>=A1*10<\/strong><\/p>\n<p>N\u1ebfu b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c n\u00e0y sang\u00a0<strong>m\u1ed9t h\u00e0ng kh\u00e1c<\/strong>\u00a0trong c\u00f9ng m\u1ed9t c\u1ed9t, ch\u1eb3ng h\u1ea1n \u00f4 B2, c\u00f4ng th\u1ee9c s\u1ebd \u0111i\u1ec1u ch\u1ec9nh cho d\u00f2ng 2 (A2 * 10) v\u00ec Excel gi\u1ea3 \u0111\u1ecbnh b\u1ea1n \u0111ang mu\u1ed1n nh\u00e2n m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed7i h\u00e0ng c\u1ed9t A v\u1edbi 10.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"A relative cell reference in Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-relative-sell-reference.png\" alt=\"A relative cell reference in Excel\">N\u1ebfu b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c ch\u1ee9a tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i \u0111\u1ebfn\u00a0<strong>m\u1ed9t c\u1ed9t kh\u00e1c<\/strong>\u00a0trong c\u00f9ng m\u1ed9t h\u00e0ng, Excel s\u1ebd thay \u0111\u1ed5i\u00a0<em>tham chi\u1ebfu c\u1ed9t cho<\/em>\u00a0ph\u00f9 h\u1ee3p:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Copying the formula with a relative cell reference to another column\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-relative-sell-reference2.png\" alt=\"Copying the formula with a relative cell reference to another column\">V\u00e0 n\u1ebfu b\u1ea1n sao ch\u00e9p ho\u1eb7c di chuy\u1ec3n m\u1ed9t c\u00f4ng th\u1ee9c Excel ch\u1ee9a tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i \u0111\u1ebfn\u00a0<strong>m\u1ed9t h\u00e0ng kh\u00e1c v\u00e0 m\u1ed9t c\u1ed9t kh\u00e1c<\/strong>, c\u1ea3 hai\u00a0<em>tham chi\u1ebfu c\u1ed9t v\u00e0 h\u00e0ng <\/em>s\u1ebd thay \u0111\u1ed5i:<br \/>\n<img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Copying the formula with a relative cell reference to another column and row\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-relative-sell-reference3.png\" alt=\"Copying the formula with a relative cell reference to another column and row\"><\/p>\n<p>Nh\u01b0 b\u1ea1n th\u1ea5y, vi\u1ec7c s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i trong c\u00f4ng th\u1ee9c Excel l\u00e0 m\u1ed9t c\u00e1ch ti\u1ec7n l\u1ee3i \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c t\u00ednh to\u00e1n gi\u1ed1ng nhau tr\u00ean to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh.\u00a0\u0110\u1ec3 r\u00f5 h\u01a1n \u0111i\u1ec1u n\u00e0y, h\u00e3y xem m\u1ed9t v\u00ed d\u1ee5 th\u1ef1c t\u1ebf.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_tham_chieu_tuong_doi_%E2%80%93_cong_thuc_vi_du\"><\/span><strong>S\u1eed d\u1ee5ng tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i \u2013 c\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t c\u1ed9t gi\u00e1 USD (c\u1ed9t B) trong b\u1ea3ng t\u00ednh, v\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n ch\u00fang sang EUR.\u00a0Bi\u1ebft t\u1ef7 l\u1ec7 chuy\u1ec3n \u0111\u1ed5i USD \u2013 EUR (th\u1eddi \u0111i\u1ec3m n\u00e0y l\u00e0 0.93), c\u00f4ng th\u1ee9c cho h\u00e0ng 2 \u0111\u01a1n gi\u1ea3n l\u00e0\u00a0<strong>=B2*0.93<\/strong>.\u00a0Ch\u00fa \u00fd r\u1eb1ng ch\u00fang ta \u0111ang s\u1eed d\u1ee5ng m\u1ed9t tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i, kh\u00f4ng c\u00f3 d\u1ea5u dollar.<\/p>\n<p>Nh\u1ea5n ph\u00edm Enter, k\u1ebft qu\u1ea3 s\u1ebd xu\u1ea5t hi\u1ec7n ngay l\u1eadp t\u1ee9c trong \u00f4.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"An Excel formula with a relative cell reference\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-formula-relative-reference.png\" alt=\"An Excel formula with a relative cell reference\"><strong>M\u1eb9o.\u00a0<\/strong>Theo m\u1eb7c \u0111\u1ecbnh, t\u1ea5t c\u1ea3 c\u00e1c tham chi\u1ebfu \u00f4 trong Excel l\u00e0 c\u00e1c tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i.\u00a0V\u00ec v\u1eady, khi vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam m\u1ed9t tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o \u00f4 t\u01b0\u01a1ng \u1ee9ng tr\u00ean b\u1ea3ng t\u00ednh thay v\u00ec nh\u1eadp m\u1ed9t tham chi\u1ebfu \u00f4 theo c\u00e1ch th\u1ee7 c\u00f4ng.<\/p>\n<p>\u0110\u1ec3\u00a0<strong>sao ch\u00e9p c\u00f4ng th\u1ee9c\u00a0v\u00e0o c\u00e1c \u00f4 b\u00ean c\u1ea1nh<\/strong>\u00a0, h\u00e3y di chu\u1ed9t qua thanh \u0111i\u1ec1u khi\u1ec3n fill handle\u00a0 (m\u1ed9t h\u00ecnh vu\u00f4ng nh\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn).\u00a0Khi b\u1ea1n l\u00e0m \u0111i\u1ec1u n\u00e0y, con tr\u1ecf s\u1ebd chuy\u1ec3n th\u00e0nh m\u1ed9t ch\u1eef th\u1eadp m\u00e0u \u0111en m\u1ecfng, b\u1ea1n gi\u1eef v\u00e0 k\u00e9o n\u00f3 qua c\u00e1c \u00f4 b\u1ea1n mu\u1ed1n t\u1ef1 \u0111\u1ed9ng sao ch\u00e9p c\u00f4ng th\u1ee9c.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Copying the formula with a relative cell reference to other cells\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/copy-formula-relative-references.png\" alt=\"Copying the formula with a relative cell reference to other cells\"><\/p>\n<p>\u0110\u1ec3\u00a0<strong>sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 kh\u00f4ng li\u1ec1n k\u1ec1<\/strong>\u00a0, h\u00e3y nh\u1ea5p v\u00e0o \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c, nh\u1ea5n\u00a0Ctrl + C\u00a0\u0111\u1ec3 sao ch\u00e9p, ch\u1ecdn m\u1ed9t \u00f4 kh\u00e1c ho\u1eb7c m\u1ed9t d\u1ea3i \u00f4, v\u00e0 nh\u1ea5n\u00a0Ctrl + V\u00a0\u0111\u1ec3 d\u00e1n c\u00f4ng th\u1ee9c.<\/p>\n<p>C\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sao ch\u00e9p v\u00e0o c\u00e1c \u00f4 kh\u00e1c v\u1edbi tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i \u0111\u01b0\u1ee3c \u0111i\u1ec1u ch\u1ec9nh ph\u00f9 h\u1ee3p cho m\u1ed7i \u00f4 ri\u00eang l\u1ebb.\u00a0\u0110\u1ec3 \u0111\u1ea3m b\u1ea3o gi\u00e1 tr\u1ecb trong m\u1ed7i \u00f4 \u0111\u01b0\u1ee3c t\u00ednh ch\u00ednh x\u00e1c, ch\u1ecdn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o v\u00e0 xem c\u00f4ng th\u1ee9c trong thanh c\u00f4ng th\u1ee9c.\u00a0Trong v\u00ed d\u1ee5 n\u00e0y, t\u00f4i ch\u1ecdn \u00f4 C4 v\u00e0 th\u1ea5y r\u1eb1ng tham chi\u1ebfu \u00f4 trong c\u00f4ng th\u1ee9c li\u00ean quan \u0111\u1ebfn h\u00e0ng 4, v\u1eady l\u00e0 ch\u00ednh x\u00e1c!:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"A relative cell reference is adjusted for each individual cell\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/img-blog\/cell-reference-relative-row.png\" alt=\"A relative cell reference is adjusted for each individual cell\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Phim_tat_de_sao_chep_cong_thuc_vao_cac_o_khac\"><\/span><strong>Ph\u00edm t\u1eaft \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 kh\u00e1c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ctrl + D\u00a0\u2013 \u00a0l\u1ec7nh sao ch\u00e9p d\u1eef li\u1ec7u t\u1eeb c\u00e1c \u00f4 \u1edf tr\u00ean.\u00a0V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t c\u00f4ng th\u1ee9c trong \u00f4 A1 v\u00e0 b\u1ea1n mu\u1ed1n sao ch\u00e9p n\u00f3 v\u00e0o \u00f4 A2, ch\u1ecdn A2 v\u00e0 nh\u1ea5n\u00a0t\u1ed5 h\u1ee3p ph\u00edm Ctrl + D\u00a0.<\/p>\n<p>Ctrl + R\u00a0\u2013 \u0111\u1ec3 sao ch\u00e9p d\u1eef li\u1ec7u t\u1eeb \u00f4 b\u00ean tr\u00e1i.\u00a0V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t c\u00f4ng th\u1ee9c trong \u00f4 A1 v\u00e0 b\u1ea1n mu\u1ed1n sao ch\u00e9p n\u00f3 v\u00e0o \u00f4 B1, ch\u1ecdn B1 v\u00e0 nh\u1ea5n\u00a0Ctrl + R\u00a0.<\/p>\n<p>C\u00e1c ph\u00edm t\u1eaft n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 sao ch\u00e9p c\u00e1c c\u00f4ng th\u1ee9c cho nhi\u1ec1u \u00f4.\u00a0Th\u1ee7 thu\u1eadt l\u00e0 ch\u1ecdn c\u1ea3 \u00f4 ngu\u1ed3n v\u00e0 \u00f4 \u0111\u00edch tr\u01b0\u1edbc khi nh\u1ea5n ph\u00edm t\u1eaft.\u00a0V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n sao ch\u00e9p c\u00f4ng th\u1ee9c t\u1eeb A1 \u0111\u1ebfn 9 h\u00e0ng ti\u1ebfp theo, ch\u1ecdn c\u00e1c \u00f4 A1: A10 v\u00e0 nh\u1ea5n\u00a0t\u1ed5 h\u1ee3p ph\u00edm Ctrl + D\u00a0.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tham_chieu_o_tuyet_doi_trong_Excel_voi_dau\"><\/span><strong>Tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i trong Excel (v\u1edbi d\u1ea5u $)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed9t\u00a0<strong>tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i<\/strong>\u00a0trong Excel l\u00e0 m\u1ed9t tham chi\u1ebfu \u00f4 v\u1edbi d\u1ea5u $, nh\u01b0\u00a0<em>$A$1<\/em>\u00a0.<\/p>\n<p>D\u1ea5u dollar c\u1ed1 \u0111\u1ecbnh tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 nh\u1ea5t \u0111\u1ecbnh, sao cho n\u00f3\u00a0<strong>v\u1eabn t\u0129nh<\/strong>\u00a0b\u1ea5t k\u1ec3 v\u1ecb tr\u00ed c\u1ee7a c\u00f4ng th\u1ee9c.\u00a0N\u00f3i c\u00e1ch kh\u00e1c, b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng $ trong tham chi\u1ebfu \u00f4 cho ph\u00e9p b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c trong Excel m\u00e0 kh\u00f4ng thay \u0111\u1ed5i tham chi\u1ebfu.<\/p>\n<p>Xin l\u01b0u \u00fd r\u1eb1ng trong tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i c\u1ee7a Excel, c\u00f3 m\u1ed9t d\u1ea5u dollar ($) tr\u01b0\u1edbc h\u00e0ng v\u00e0 c\u1ed9t.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"An absolute cell reference in Excel\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/img-blog\/absolute-cell-reference-excel.png\" alt=\"An absolute cell reference in Excel\">V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n c\u00f3 10 trong \u00f4 A1 v\u00e0 b\u1ea1n s\u1eed d\u1ee5ng\u00a0<strong>tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i<\/strong>\u00a0(<em>$A$1<\/em>), c\u00f4ng th\u1ee9c\u00a0<strong>=$A$1+5 <\/strong>s\u1ebd lu\u00f4n lu\u00f4n tr\u1ea3 v\u1ec1 15, cho d\u00f9 c\u00e1c \u00f4 kh\u00e1c c\u00f3 c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sao ch\u00e9p.\u00a0M\u1eb7t kh\u00e1c, n\u1ebfu b\u1ea1n vi\u1ebft c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c v\u1edbi m\u1ed9t\u00a0<strong>tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i<\/strong>\u00a0(<em>A<\/em>\u00a0), v\u00e0 sau \u0111\u00f3 sao ch\u00e9p n\u00f3 xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t, m\u1ed7i gi\u00e1 tr\u1ecb kh\u00e1c s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh cho m\u1ed7i h\u00e0ng.\u00a0H\u00ecnh \u1ea3nh sau \u0111\u00e2y th\u1ec3 hi\u1ec7n s\u1ef1 kh\u00e1c bi\u1ec7t:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Absolute cell reference vs. relative reference\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/absolute-cell-reference-example.png\" alt=\"Absolute cell reference vs. relative reference\"><\/p>\n<p><strong>Ch\u00fa \u00fd.\u00a0<\/strong>M\u1eb7c d\u00f9 ch\u00fang ta \u0111\u00e3 n\u00f3i r\u1eb1ng m\u1ed9t d\u1eef li\u1ec7u tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i trong Excel kh\u00f4ng bao gi\u1edd thay \u0111\u1ed5i, tr\u00ean th\u1ef1c t\u1ebf n\u00f3 thay \u0111\u1ed5i khi b\u1ea1n th\u00eam ho\u1eb7c xo\u00e1 c\u00e1c h\u00e0ng v\u00e0 \/ ho\u1eb7c c\u00e1c c\u1ed9t trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n v\u00e0 \u0111i\u1ec1u n\u00e0y thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu.\u00a0Trong v\u00ed d\u1ee5 tr\u00ean, n\u1ebfu ch\u00fang ta ch\u00e8n m\u1ed9t h\u00e0ng m\u1edbi \u1edf \u0111\u1ea7u trang t\u00ednh, Excel \u0111\u1ee7 th\u00f4ng minh \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh c\u00f4ng th\u1ee9c \u0111\u1ec3 ph\u1ea3n \u00e1nh s\u1ef1 thay \u0111\u1ed5i \u0111\u00f3:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"An absolute reference changes when you add or remove rows or columns in the worksheet.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/absolute-cell-reference-change.png\" alt=\"An absolute reference changes when you add or remove rows or columns in the worksheet.\">Trong b\u1ea3ng t\u00ednh th\u1ef1c, \u0111\u00e2y l\u00e0 m\u1ed9t tr\u01b0\u1eddng h\u1ee3p r\u1ea5t hi\u1ebfm khi b\u1ea1n ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng c\u00e1c tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i trong c\u00f4ng th\u1ee9c Excel c\u1ee7a m\u00ecnh.\u00a0Tuy nhi\u00ean, c\u00f3 r\u1ea5t nhi\u1ec1u nhu c\u1ea7u th\u1ef1c t\u1ebf \u0111\u00f2i h\u1ecfi ph\u1ea3i s\u1eed d\u1ee5ng c\u1ea3 d\u1eef li\u1ec7u tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i, nh\u01b0 th\u1ec3 hi\u1ec7n trong c\u00e1c v\u00ed d\u1ee5 sau \u0111\u00e2y.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_tham_chieu_o_tuong_doi_va_tuyet_doi_trong_mot_cong_thuc\"><\/span><strong>S\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 tuy\u1ec7t \u0111\u1ed1i trong m\u1ed9t c\u00f4ng th\u1ee9c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n m\u1ed9t c\u00f4ng th\u1ee9c m\u00e0 m\u1ed9t s\u1ed1 tham chi\u1ebfu \u00f4 \u0111\u01b0\u1ee3c \u0111i\u1ec1u ch\u1ec9nh cho c\u00e1c c\u1ed9t v\u00e0 c\u00e1c h\u00e0ng m\u00e0 c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sao ch\u00e9p, trong khi c\u00e1c \u00f4 kh\u00e1c v\u1eabn c\u1ed1 \u0111\u1ecbnh.\u00a0N\u00f3i c\u00e1ch kh\u00e1c, b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 tuy\u1ec7t \u0111\u1ed1i trong m\u1ed9t c\u00f4ng th\u1ee9c.<\/p>\n<p>V\u00ed d\u1ee5 1. Li\u00ean k\u1ebft \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 tuy\u1ec7t \u0111\u1ed1i \u0111\u1ec3 t\u00ednh to\u00e1n s\u1ed1<\/p>\n<p>Trong\u00a0v\u00ed d\u1ee5 tr\u01b0\u1edbc \u0111\u00e2y\u00a0c\u1ee7a ch\u00fang ta\u00a0v\u1edbi t\u1ef7 gi\u00e1 USD v\u00e0 EUR, b\u1ea1n c\u00f3 th\u1ec3 kh\u00f4ng mu\u1ed1n nh\u1eadp t\u1ef7 gi\u00e1 h\u1ed1i \u0111o\u00e1i trong c\u00f4ng th\u1ee9c.\u00a0Thay v\u00e0o \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp s\u1ed1 \u0111\u00f3 v\u00e0o m\u1ed9t s\u1ed1 \u00f4, v\u00ed d\u1ee5 C1 v\u00e0 c\u1ed1 \u0111\u1ecbnh tham chi\u1ebfu \u00f4 \u0111\u00f3 nh\u01b0 sau:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Using relative and absolute cell references in one formula\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/relative-absolute-cell-references.png\" alt=\"Using relative and absolute cell references in one formula\">Trong c\u00f4ng th\u1ee9c n\u00e0y (B4 * $C$1), c\u00f3 hai lo\u1ea1i tham chi\u1ebfu \u00f4:<\/p>\n<ul>\n<li>B4 \u2013\u00a0tham chi\u1ebfu \u00f4\u00a0<strong>t\u01b0\u01a1ng \u0111\u1ed1i<\/strong> thay \u0111\u1ed5i theo m\u1ed7i h\u00e0ng, v\u00e0<\/li>\n<li>$C$1 \u2013\u00a0tham chi\u1ebfu \u00f4\u00a0<strong>tuy\u1ec7t \u0111\u1ed1i<\/strong>\u00a0 kh\u00f4ng bao gi\u1edd thay \u0111\u1ed5i b\u1ea5t k\u1ec3 c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sao ch\u00e9p \u0111i \u0111\u00e2u.<\/li>\n<\/ul>\n<p>L\u1ee3i th\u1ebf c\u1ee7a c\u00e1ch n\u00e0y l\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 t\u00ednh gi\u00e1 EUR d\u1ef1a tr\u00ean t\u1ef7 gi\u00e1 h\u1ed1i \u0111o\u00e1i thay \u0111\u1ed5i m\u00e0 kh\u00f4ng thay \u0111\u1ed5i c\u00f4ng th\u1ee9c.\u00a0Khi t\u1ef7 gi\u00e1 trao \u0111\u1ed5i thay \u0111\u1ed5i, t\u1ea5t c\u1ea3 nh\u1eefng g\u00ec b\u1ea1n ph\u1ea3i l\u00e0m l\u00e0 c\u1eadp nh\u1eadt gi\u00e1 tr\u1ecb trong \u00f4 C1.<\/p>\n<p>V\u00ed d\u1ee5 2. Li\u00ean k\u1ebft \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 tuy\u1ec7t \u0111\u1ed1i \u0111\u1ec3 t\u00ednh ng\u00e0y th\u00e1ng<\/p>\n<p>M\u1ed9t \u1ee9ng d\u1ee5ng ph\u1ed5 bi\u1ebfn kh\u00e1c c\u1ee7a tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i trong c\u00f4ng th\u1ee9c \u0111\u01a1n l\u00e0\u00a0t\u00ednh ng\u00e0y trong Excel\u00a0d\u1ef1a tr\u00ean ng\u00e0y hi\u1ec7n t\u1ea1i.<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch ng\u00e0y ph\u00e2n ph\u1ed1i trong c\u1ed9t B, v\u00e0 b\u1ea1n nh\u1eadp ng\u00e0y hi\u1ec7n t\u1ea1i v\u00e0o C1 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0TODAY ().\u00a0Nh\u1eefng g\u00ec b\u1ea1n mu\u1ed1n bi\u1ebft l\u00e0 m\u1ed7i chuy\u1ebfn h\u00e0ng t\u1ed1n bao nhi\u00eau ng\u00e0y v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh to\u00e1n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau: <strong>=B4-$C$1<\/strong><br \/>\n<img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Using relative and absolute cell references for calculating dates\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/relative-absolute-cell-references-formula.png\" alt=\"Using relative and absolute cell references for calculating dates\"><\/p>\n<p>Ch\u00fang ta s\u1eed d\u1ee5ng hai lo\u1ea1i tham chi\u1ebfu trong c\u00f4ng th\u1ee9c:<\/p>\n<ul>\n<li><strong>T\u01b0\u01a1ng \u0111\u1ed1i<\/strong>\u00a0cho \u00f4 c\u00f3 ng\u00e0y giao h\u00e0ng \u0111\u1ea7u ti\u00ean (B4), b\u1edfi v\u00ec b\u1ea1n mu\u1ed1n tham chi\u1ebfu \u00f4 n\u00e0y thay \u0111\u1ed5i t\u00f9y thu\u1ed9c v\u00e0o h\u00e0ng m\u00e0 c\u00f4ng th\u1ee9c xu\u1ea5t hi\u1ec7n.<\/li>\n<li><strong>Tuy\u1ec7t \u0111\u1ed1i<\/strong>\u00a0v\u1edbi \u00f4 v\u1edbi ng\u00e0y hi\u1ec7n t\u1ea1i ($C$1), b\u1edfi v\u00ec b\u1ea1n mu\u1ed1n tham chi\u1ebfu \u00f4 n\u00e0y kh\u00f4ng \u0111\u1ed5i.<\/li>\n<\/ul>\n<p>N\u00f3i chung l\u00e0 b\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n mu\u1ed1n t\u1ea1o m\u1ed9t tham chi\u1ebfu t\u0129nh, ghi th\u00eam d\u1ea5u dollar ($) trong c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u1ea1o m\u1ed9t d\u1eef li\u1ec7u tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i trong Excel.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tham_chieu_o_hon_hop\"><\/span><strong>Tham chi\u1ebfu \u00f4 h\u1ed7n h\u1ee3p<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed9t tham chi\u1ebfu \u00f4 h\u1ed7n h\u1ee3p trong Excel l\u00e0 tham chi\u1ebfu m\u00e0 m\u1ed9t c\u1ed9t ho\u1eb7c m\u1ed9t h\u00e0ng \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh.\u00a0V\u00ed d\u1ee5: $A1 v\u00e0 A$1 l\u00e0 tham chi\u1ebfu h\u1ed7n h\u1ee3p.<\/p>\n<p>Tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i c\u1ee7a Excel\u00a0ch\u1ee9a 2 d\u1ea5u dollar ($) kh\u00f3a c\u1ea3 c\u1ed9t v\u00e0 h\u00e0ng.\u00a0Trong m\u1ed9t tham chi\u1ebfu \u00f4 h\u1ed7n h\u1ee3p, ch\u1ec9 c\u00f3 m\u1ed9t t\u1ecda \u0111\u1ed9 c\u1ed1 \u0111\u1ecbnh (tuy\u1ec7t \u0111\u1ed1i) v\u00e0 ph\u1ea7n kh\u00e1c (t\u01b0\u01a1ng \u0111\u1ed1i) s\u1ebd thay \u0111\u1ed5i d\u1ef1a tr\u00ean v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a h\u00e0ng ho\u1eb7c c\u1ed9t:<\/p>\n<ul>\n<li><strong>C\u1ed9t tuy\u1ec7t \u0111\u1ed1i v\u00e0 h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i<\/strong>, $A1.\u00a0Khi m\u1ed9t c\u00f4ng th\u1ee9c v\u1edbi ki\u1ec3u tham chi\u1ebfu n\u00e0y \u0111\u01b0\u1ee3c sao ch\u00e9p v\u00e0o c\u00e1c \u00f4 kh\u00e1c, k\u00fd hi\u1ec7u $ \u1edf ph\u00eda tr\u01b0\u1edbc c\u1ed9t ch\u1eef c\u00e1i s\u1ebd kh\u00f3a tham chi\u1ebfu \u0111\u1ebfn c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh \u0111\u1ec3 n\u00f3 kh\u00f4ng bao gi\u1edd thay \u0111\u1ed5i.\u00a0Tham chi\u1ebfu h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i, kh\u00f4ng c\u00f3 k\u00fd hi\u1ec7u dollar, 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><strong>C\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 h\u00e0ng tuy\u1ec7t \u0111\u1ed1i<\/strong>\u00a0, A$1.\u00a0Trong lo\u1ea1i tham chi\u1ebfu n\u00e0y, tham chi\u1ebfu c\u1ee7a h\u00e0ng s\u1ebd kh\u00f4ng thay \u0111\u1ed5i, c\u00f2n tham chi\u1ebfu c\u1ee7a c\u1ed9t s\u1ebd thay \u0111\u1ed5i.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Mixed cell references in Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-mixed-cell-reference.png\" alt=\"Mixed cell references in Excel\"><\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y m\u1ed9t v\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng c\u1ea3 hai lo\u1ea1i tham chi\u1ebfu \u00f4 h\u1ed7n h\u1ee3p, hy v\u1ecdng s\u1ebd l\u00e0m cho m\u1ecdi th\u1ee9 d\u1ec5 hi\u1ec3u h\u01a1n.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_tham_chieu_hon_hop_trong_Excel_%E2%80%93_cong_thuc_vi_du\"><\/span><strong>S\u1eed d\u1ee5ng<\/strong> <strong>tham chi\u1ebfu h\u1ed7n h\u1ee3p trong Excel \u2013 c\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ed1i v\u1edbi v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng\u00a0l\u1ea1i\u00a0b\u1ea3ng chuy\u1ec3n \u0111\u1ed5i ti\u1ec1n t\u1ec7\u00a0\u1edf tr\u00ean.\u00a0Nh\u01b0ng l\u1ea7n n\u00e0y, ch\u00fang ta s\u1ebd kh\u00f4ng ch\u1ec9 gi\u1edbi h\u1ea1n vi\u1ec7c chuy\u1ec3n \u0111\u1ed5i USD \u2013 EUR.\u00a0Nh\u1eefng g\u00ec ch\u00fang ta s\u1ebd l\u00e0m l\u00e0 chuy\u1ec3n \u0111\u1ed5i gi\u00e1 dollar sang m\u1ed9t s\u1ed1 lo\u1ea1i ti\u1ec1n t\u1ec7 kh\u00e1c, t\u1ea5t c\u1ea3 ch\u1ec9 b\u1eb1ng m\u1ed9t\u00a0<strong>c\u00f4ng th\u1ee9c duy nh\u1ea5t<\/strong>!<\/p>\n<p>\u0110\u1ec3 b\u1eaft \u0111\u1ea7u, h\u00e3y nh\u1eadp t\u1ef7 gi\u00e1 \u1edf m\u1ed9t h\u00e0ng, ch\u1eb3ng h\u1ea1n h\u00e0ng 2, nh\u01b0 th\u1ec3 hi\u1ec7n trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.\u00a0V\u00e0 sau \u0111\u00f3, b\u1ea1n ch\u1ec9 vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c cho \u00f4 tr\u00ean c\u00f9ng b\u00ean tr\u00e1i (C5 trong v\u00ed d\u1ee5 n\u00e0y) \u0111\u1ec3 t\u00ednh gi\u00e1 EUR:<\/p>\n<p><strong>=$B5*C$2<\/strong><\/p>\n<p>Trong \u0111\u00f3 $B5 l\u00e0 gi\u00e1 dollar trong c\u00f9ng m\u1ed9t h\u00e0ng v\u00e0 C$2 l\u00e0 t\u1ef7 l\u1ec7 chuy\u1ec3n \u0111\u1ed5i USD \u2013 EUR.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Using a mixed reference in an Excel formula\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mixed-reference-excel-formula.png\" alt=\"Using a mixed reference in an Excel formula\"><\/p>\n<p>V\u00e0 b\u00e2y gi\u1edd, sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t C, sau \u0111\u00f3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n c\u00e1c c\u1ed9t kh\u00e1c c\u00f3 c\u00f9ng c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch k\u00e9o ch\u1ed1t.\u00a0K\u1ebft qu\u1ea3 l\u00e0 b\u1ea1n s\u1ebd c\u00f3 3 c\u1ed9t gi\u00e1 kh\u00e1c nhau \u0111\u01b0\u1ee3c t\u00ednh ch\u00ednh x\u00e1c d\u1ef1a tr\u00ean t\u1ef7 gi\u00e1 t\u01b0\u01a1ng \u1ee9ng trong h\u00e0ng 2 trong c\u00f9ng m\u1ed9t c\u1ed9t.\u00a0\u0110\u1ec3 x\u00e1c minh \u0111i\u1ec1u n\u00e0y, h\u00e3y ch\u1ecdn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong b\u1ea3ng v\u00e0 xem c\u00f4ng th\u1ee9c trong thanh c\u00f4ng th\u1ee9c.<\/p>\n<p>V\u00ed d\u1ee5, h\u00e3y ch\u1ecdn \u00f4 D7 (trong c\u1ed9t GBP).\u00a0 Ta th\u1ea5y \u1edf \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c\u00a0<strong>=$B7*D$2 <\/strong>t\u00ednh gi\u00e1 USD \u1edf B7 v\u00e0 nh\u00e2n n\u00f3 b\u1eb1ng gi\u00e1 tr\u1ecb trong D2, \u0111\u00f3 l\u00e0 t\u1ef7 l\u1ec7 chuy\u1ec3n \u0111\u1ed5i USD-GBP.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"A mixed cell reference is adjusted correctly for each cell.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/using-mixed-reference-excel.png\" alt=\"A mixed cell reference is adjusted correctly for each cell.\"><\/p>\n<p>\u0110\u1ec3 hi\u1ec3u l\u00e0m th\u1ebf n\u00e0o m\u00e0 Excel bi\u1ebft \u0111\u01b0\u1ee3c c\u00e1i n\u00e0o c\u1ea7n ph\u1ea3i c\u00f3 v\u00e0 t\u1ef7 gi\u00e1 h\u1ed1i \u0111o\u00e1i n\u00e0o s\u1ebd \u0111\u01b0\u1ee3c l\u1ea5y \u0111em nh\u00e2n.\u00a0\u0110\u00f3 l\u00e0 v\u00ec c\u00e1c tham chi\u1ebfu \u00f4 h\u1ed7n h\u1ee3p ra l\u1ec7nh ($B5 * C$2).<\/p>\n<ul>\n<li>$B5 \u2013\u00a0<strong>c\u1ed9t tuy\u1ec7t \u0111\u1ed1i v\u00e0 h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i<\/strong>\u00a0.\u00a0\u1ede \u0111\u00e2y, b\u1ea1n ch\u1ec9 th\u00eam k\u00fd hi\u1ec7u dollar ($) tr\u01b0\u1edbc c\u1ed9t ch\u1eef c\u00e1i neo tham chi\u1ebfu \u0111\u1ebfn c\u1ed9t A, do \u0111\u00f3, Excel lu\u00f4n s\u1eed d\u1ee5ng gi\u00e1 g\u1ed1c cho t\u1ea5t c\u1ea3 c\u00e1c chuy\u1ec3n \u0111\u1ed5i.\u00a0Tham chi\u1ebfu h\u00e0ng (kh\u00f4ng c\u00f3 d\u1ea5u dollar) kh\u00f4ng b\u1ecb kh\u00f3a v\u00ec b\u1ea1n mu\u1ed1n t\u00ednh gi\u00e1 cho m\u1ed7i h\u00e0ng ri\u00eang l\u1ebb.<\/li>\n<li>C$2 \u2013\u00a0<strong>c\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 h\u00e0ng tuy\u1ec7t \u0111\u1ed1i<\/strong>\u00a0.\u00a0B\u1edfi v\u00ec t\u1ea5t c\u1ea3 c\u00e1c t\u1ef7 gi\u00e1 h\u1ed1i \u0111o\u00e1i n\u1eb1m trong h\u00e0ng 2, b\u1ea1n s\u1ebd kh\u00f3a tham chi\u1ebfu h\u00e0ng b\u1eb1ng c\u00e1ch \u0111\u1eb7t d\u1ea5u dollar ($) \u1edf ph\u00eda tr\u01b0\u1edbc s\u1ed1 h\u00e0ng.\u00a0V\u00e0 b\u00e2y gi\u1edd, cho d\u00f9 b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c, Excel s\u1ebd lu\u00f4n lu\u00f4n t\u00ecm ki\u1ebfm t\u1ef7 gi\u00e1 h\u1ed1i \u0111o\u00e1i trong h\u00e0ng 2. V\u00e0 v\u00ec tham chi\u1ebfu c\u1ed9t l\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i (kh\u00f4ng c\u00f3 d\u1ea5u dollar), n\u00f3 s\u1ebd \u0111i\u1ec1u ch\u1ec9nh c\u1ed9t \u1edf c\u00f4ng th\u1ee9c Sao ch\u00e9p.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_tham_chieu_toan_bo_cot_hoac_hang_trong_Excel\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t ho\u1eb7c h\u00e0ng trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi m\u1ed9t b\u1ea3ng t\u00ednh Excel c\u00f3 m\u1ed9t s\u1ed1 c\u00e1c h\u00e0ng thay \u0111\u1ed5i, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n tham chi\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong m\u1ed9t c\u1ed9t c\u1ee5 th\u1ec3.\u00a0\u0110\u1ec3 tham kh\u1ea3o to\u00e0n b\u1ed9 c\u1ed9t, ch\u1ec9 c\u1ea7n g\u00f5 hai l\u1ea7n k\u00fd c\u1ed9t v\u1edbi m\u1ed9t d\u1ea5u hai ch\u1ea5m \u1edf gi\u1eefa, v\u00ed d\u1ee5\u00a0<em>A:A<\/em>\u00a0.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tham_chieu_toan_bo_cot\"><\/span><strong>Tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u0169ng nh\u01b0 tham chi\u1ebfu \u00f4, to\u00e0n b\u1ed9 tham chi\u1ebfu c\u1ed9t c\u00f3 th\u1ec3 l\u00e0 tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i, v\u00ed d\u1ee5:<\/p>\n<ul>\n<li>Tham chi\u1ebfu c\u1ed9t tuy\u1ec7t \u0111\u1ed1i\u00a0<strong>,<\/strong>\u00a0 v\u00ed d\u1ee5 $A:$A<\/li>\n<li>Tham kh\u1ea3o c\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i, v\u00ed d\u1ee5 A:A<\/li>\n<\/ul>\n<p>V\u00e0 m\u1ed9t l\u1ea7n n\u1eefa, b\u1ea1n s\u1eed d\u1ee5ng k\u00fd hi\u1ec7u dollar ($) trong m\u1ed9t\u00a0<strong>tham chi\u1ebfu c\u1ed9t tuy\u1ec7t \u0111\u1ed1i<\/strong>\u00a0\u0111\u1ec3 kh\u00f3a n\u00f3 v\u00e0o m\u1ed9t c\u1ed9t nh\u1ea5t \u0111\u1ecbnh, v\u00ec tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t kh\u00f4ng thay \u0111\u1ed5i khi b\u1ea1n sao ch\u00e9p m\u1ed9t c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 kh\u00e1c.<\/p>\n<p>M\u1ed9t\u00a0<strong>tham chi\u1ebfu c\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i<\/strong>\u00a0s\u1ebd thay \u0111\u1ed5i khi c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sao ch\u00e9p ho\u1eb7c di chuy\u1ec3n c\u00e1c c\u1ed9t kh\u00e1c v\u00e0 s\u1ebd v\u1eabn c\u00f2n nguy\u00ean v\u1eb9n khi b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c \u0111\u1ebfn c\u00e1c \u00f4 kh\u00e1c trong c\u00f9ng m\u1ed9t c\u1ed9t.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tham_chieu_toan_bo_hang\"><\/span><strong>Tham chi\u1ebfu to\u00e0n b\u1ed9 h\u00e0ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 tham chi\u1ebfu \u0111\u1ebfn to\u00e0n b\u1ed9 h\u00e0ng, b\u1ea1n s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p t\u01b0\u01a1ng t\u1ef1, b\u1ea1n nh\u1eadp s\u1ed1 h\u00e0ng thay v\u00ec c\u00e1c k\u00fd t\u1ef1 c\u1ed9t:<\/p>\n<ul>\n<li>Tham chi\u1ebfu h\u00e0ng tuy\u1ec7t \u0111\u1ed1i,\u00a0 v\u00ed d\u1ee5 $1:$1<\/li>\n<li>Li\u00ean k\u1ebft h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i, v\u00ed d\u1ee5 1:1<\/li>\n<\/ul>\n<p>V\u1ec1 l\u00fd thuy\u1ebft, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t\u00a0<strong>tham chi\u1ebfu h\u1ed7n h\u1ee3p to\u00e0n b\u1ed9 c\u1ed9t<\/strong>\u00a0ho\u1eb7c\u00a0<strong>h\u1ed7n h\u1ee3p\u00a0to\u00e0n b\u1ed9 h\u00e0ng,<\/strong>\u00a0nh\u01b0 $A:A ho\u1eb7c $1:1, t\u01b0\u01a1ng \u1ee9ng.\u00a0Nh\u01b0ng ch\u1ec9 \u201ctr\u00ean l\u00fd thuy\u1ebft\u201d, b\u1edfi v\u00ec kh\u00f4ng th\u1ea5y c\u00f3 b\u1ea5t k\u1ef3 \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf n\u00e0o c\u1ee7a c\u00e1c tham chi\u1ebfu nh\u01b0 v\u1eady, m\u1eb7c d\u00f9\u00a0v\u00ed d\u1ee5 4\u00a0ch\u1ee9ng minh r\u1eb1ng c\u00f4ng th\u1ee9c v\u1edbi c\u00e1c tham chi\u1ebfu \u0111\u00f3 c\u00f3 ho\u1ea1t \u0111\u1ed9ng.<\/p>\n<p>V\u00ed d\u1ee5 1. Tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t c\u1ee7a Excel (tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i)<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t s\u1ed1 con s\u1ed1 trong c\u1ed9t B v\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft t\u1ed5ng s\u1ed1 v\u00e0 trung b\u00ecnh c\u1ee7a ch\u00fang.\u00a0V\u1ea5n \u0111\u1ec1 l\u00e0 c\u00e1c h\u00e0ng m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o b\u1ea3ng m\u1ed7i tu\u1ea7n, do \u0111\u00f3, vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c th\u00f4ng th\u01b0\u1eddng SUM () ho\u1eb7c AVERAGE () cho m\u1ed9t ph\u1ea1m vi c\u1ed1 \u0111\u1ecbnh c\u1ee7a c\u00e1c \u00f4 kh\u00f4ng ph\u1ea3i l\u00e0 c\u00e1ch t\u1ed1t.\u00a0Thay v\u00e0o \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t B:<\/p>\n<p><strong>=SUM($B:$B)<\/strong>\u2013 s\u1eed d\u1ee5ng k\u00fd hi\u1ec7u dollar ($) \u0111\u1ec3 t\u1ea1o m\u1ed9t\u00a0<strong>tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t\u00a0tuy\u1ec7t \u0111\u1ed1i<\/strong>\u00a0\u0111\u1ec3 kh\u00f3a c\u00f4ng th\u1ee9c v\u00e0o c\u1ed9t B.<\/p>\n<p><strong>=SUM(B:B)<\/strong>\u2013 vi\u1ebft c\u00f4ng th\u1ee9c kh\u00f4ng c\u00f3 $ \u0111\u1ec3 t\u1ea1o m\u1ed9t\u00a0<strong>tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t\u00a0t\u01b0\u01a1ng \u0111\u1ed1i<\/strong>\u00a0s\u1ebd \u0111\u01b0\u1ee3c thay \u0111\u1ed5i khi b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c c\u1ed9t kh\u00e1c.<\/p>\n<p><strong>M\u1eb9o.\u00a0<\/strong>Khi vi\u1ebft c\u00f4ng th\u1ee9c, h\u00e3y nh\u1ea5p v\u00e0o k\u00fd t\u1ef1 c\u1ed9t \u0111\u1ec3 tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t v\u00e0o c\u00f4ng th\u1ee9c.\u00a0C\u0169ng nh\u01b0 c\u00e1c tham chi\u1ebfu \u00f4, theo m\u1eb7c \u0111\u1ecbnh Excel s\u1ebd ch\u00e8n tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i (kh\u00f4ng c\u00f3 d\u1ea5u dollar):<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Writing a formula with an entire-column reference\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/reference-entire-column.png\" alt=\"Writing a formula with an entire-column reference\"><\/p>\n<p>C\u0169ng nh\u01b0 th\u1ebf, ch\u00fang ta vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh gi\u00e1 trung b\u00ecnh trong to\u00e0n b\u1ed9 c\u1ed9t B:<\/p>\n<p><strong>=AVERAGE(B:B)<\/strong><\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta \u0111ang s\u1eed d\u1ee5ng tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i, v\u00ec v\u1eady c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta \u0111\u01b0\u1ee3c \u0111i\u1ec1u ch\u1ec9nh \u0111\u00fang khi ch\u00fang ta sao ch\u00e9p n\u00f3 v\u00e0o c\u00e1c c\u1ed9t kh\u00e1c:<br \/>\n<img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Use a relative entire-column reference for the formula to get adjusted when copied to other columns.\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-column-reference.png\" alt=\"Use a relative entire-column reference for the formula to get adjusted when copied to other columns.\"><\/p>\n<p><strong>Ch\u00fa \u00fd.\u00a0<\/strong>Khi s\u1eed d\u1ee5ng tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t trong c\u00f4ng th\u1ee9c Excel, kh\u00f4ng bao gi\u1edd \u0111\u01b0\u1ee3c nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o b\u1ea5t k\u1ef3 \u0111\u00e2u trong c\u00f9ng m\u1ed9t c\u1ed9t.\u00a0V\u00ed d\u1ee5, c\u00f3 th\u1ec3 b\u1ea1n mu\u1ed1n nh\u1eadp c\u00f4ng th\u1ee9c = SUM(B:B) v\u00e0o m\u1ed9t trong nh\u1eefng \u00f4 tr\u1ed1ng d\u01b0\u1edbi c\u00f9ng trong c\u1ed9t B \u0111\u1ec3 c\u00f3 t\u1ed5ng s\u1ed1 \u1edf cu\u1ed1i m\u1ed7i c\u1ed9t.\u00a0\u0110\u1eebng l\u00e0m v\u1eady!\u00a0\u0110i\u1ec1u n\u00e0y s\u1ebd t\u1ea1o ra m\u1ed9t\u00a0<strong>tham chi\u1ebfu v\u00f2ng tr\u00f2n<\/strong>\u00a0 v\u00e0 c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 0.<\/p>\n<p>V\u00ed d\u1ee5 2. Tham chi\u1ebfu to\u00e0n b\u1ed9 d\u00f2ng Excel (tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i)<\/p>\n<p>N\u1ebfu d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo h\u00e0ng, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 tham chi\u1ebfu to\u00e0n b\u1ed9 h\u00e0ng trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n.\u00a0V\u00ed d\u1ee5: \u0111\u00e2y l\u00e0 c\u00e1ch ch\u00fang ta c\u00f3 th\u1ec3 t\u00ednh gi\u00e1 trung b\u00ecnh \u1edf h\u00e0ng 2:<\/p>\n<p><strong>=AVERAGE($2:$2)<\/strong>\u2013 m\u1ed9t\u00a0<strong>tham chi\u1ebfu\u00a0tuy\u1ec7t \u0111\u1ed1i tr\u00ean\u00a0to\u00e0n b\u1ed9 h\u00e0ng<\/strong>\u00a0b\u1ecb kho\u00e1 v\u00e0o m\u1ed9t h\u00e0ng c\u1ee5 th\u1ec3 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng k\u00fd hi\u1ec7u dollar ($).<\/p>\n<p><strong>=AVERAGE(2:2)<\/strong>\u2013 m\u1ed9t\u00a0<strong>tham chi\u1ebfu to\u00e0n b\u1ed9\u00a0h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i<\/strong>\u00a0s\u1ebd thay \u0111\u1ed5i khi c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sao ch\u00e9p v\u00e0o c\u00e1c h\u00e0ng kh\u00e1c.<\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta c\u1ea7n m\u1ed9t tham chi\u1ebfu to\u00e0n b\u1ed9 h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i v\u00ec ch\u00fang ta c\u00f3 3 h\u00e0ng d\u1eef li\u1ec7u v\u00e0 ch\u00fang ta mu\u1ed1n t\u00ednh trung b\u00ecnh trong m\u1ed7i h\u00e0ng b\u1eb1ng c\u00e1ch sao ch\u00e9p c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c:<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Using an entire-row reference in Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-row-reference.png\" alt=\"Using an entire-row reference in Excel\"><\/p>\n<p>V\u00ed d\u1ee5 3. L\u00e0m th\u1ebf n\u00e0o tham chi\u1ebfu \u0111\u1ebfn to\u00e0n b\u1ed9 m\u1ed9t c\u1ed9t nh\u01b0ng tr\u1eeb v\u00e0i h\u00e0ng \u0111\u1ea7u ti\u00ean<\/p>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t v\u1ea5n \u0111\u1ec1 r\u1ea5t ph\u1ed5 bi\u1ebfn, b\u1edfi v\u00ec trong v\u00e0i h\u00e0ng \u0111\u1ea7u ti\u00ean trong m\u1ed9t b\u1ea3ng t\u00ednh th\u01b0\u1eddng ch\u1ee9a m\u1ed9t s\u1ed1 m\u1ec7nh \u0111\u1ec1 gi\u1edbi thi\u1ec7u ho\u1eb7c th\u00f4ng tin gi\u1ea3i th\u00edch v\u00e0 b\u1ea1n kh\u00f4ng mu\u1ed1n g\u1ed9p ch\u00fang trong t\u00ednh to\u00e1n c\u1ee7a b\u1ea1n.\u00a0\u0110\u00e1ng ti\u1ebfc l\u00e0 Excel kh\u00f4ng cho ph\u00e9p tham chi\u1ebfu ki\u1ec3u nh\u01b0 B5:B \u0111\u1ec3 tham chi\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng trong c\u1ed9t B b\u1eaft \u0111\u1ea7u t\u1eeb h\u00e0ng 5. N\u1ebfu b\u1ea1n c\u1ed1 th\u00eam m\u1ed9t tham chi\u1ebfu nh\u01b0 th\u1ebf, c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n r\u1ea5t c\u00f3 th\u1ec3 s\u1ebd tr\u1ea3 l\u1ea1i l\u1ed7i #NAME.<\/p>\n<p>Thay v\u00e0o \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 \u0111\u1ecbnh m\u1ed9t\u00a0<strong>h\u00e0ng t\u1ed1i \u0111a<\/strong>, do \u0111\u00f3 tham chi\u1ebfu c\u1ee7a b\u1ea1n bao g\u1ed3m t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng trong m\u1ed9t c\u1ed9t nh\u1ea5t \u0111\u1ecbnh.\u00a0Trong Excel 2016, 2013, 2010 v\u00e0 2007, t\u1ed1i \u0111a l\u00e0 1.048.576 h\u00e0ng v\u00e0 16.384 c\u1ed9t.\u00a0Phi\u00ean b\u1ea3n Excel tr\u01b0\u1edbc s\u1ed1 h\u00e0ng t\u1ed1i \u0111a l\u00e0 65.536 v\u00e0 c\u1ed9t t\u1ed1i \u0111a l\u00e0 256.<\/p>\n<p>V\u00ec v\u1eady, \u0111\u1ec3 t\u00ecm trung b\u00ecnh cho m\u1ed7i c\u1ed9t gi\u00e1 trong b\u1ea3ng b\u00ean d\u01b0\u1edbi (c\u00e1c c\u1ed9t t\u1eeb B \u0111\u1ebfn D), b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 F2, v\u00e0 sau \u0111\u00f3 sao ch\u00e9p n\u00f3 v\u00e0o \u00f4 G2 v\u00e0 H2:<\/p>\n<p><strong>=AVERAGE(B5:B1048576)<\/strong><br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/New-Bitmap-Image-5.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7603\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/new-bitmap-image-5.bmp\" width=\"600\" height=\"246\" title=\"new-bitmap-image-5\"><\/a><\/p>\n<p>N\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng h\u00e0m SUM, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 tr\u1eeb c\u00e1c h\u00e0ng b\u1ea1n mu\u1ed1n tr\u1eeb:<\/p>\n<p><strong>=SUM(B:B)-SUM(B1:B4)<\/strong><\/p>\n<p>V\u00ed d\u1ee5 4. S\u1eed d\u1ee5ng tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t h\u1ed7n h\u1ee3p trong Excel<\/p>\n<p>Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf tr\u00ean, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t tham chi\u1ebfu h\u1ed7n h\u1ee3p to\u00e0n b\u1ed9 c\u1ed9t ho\u1eb7c to\u00e0n b\u1ed9 d\u00f2ng trong Excel:<\/p>\n<ul>\n<li>Tham chi\u1ebfu c\u1ed9t h\u1ed7n h\u1ee3p, ch\u1eb3ng h\u1ea1n $A:A<\/li>\n<li>Tham chi\u1ebfu d\u00f2ng h\u1ed7n h\u1ee3p, ch\u1eb3ng h\u1ea1n $1:1<\/li>\n<\/ul>\n<p>B\u00e2y gi\u1edd, h\u00e3y xem nh\u1eefng g\u00ec x\u1ea3y ra khi b\u1ea1n sao ch\u00e9p m\u1ed9t c\u00f4ng th\u1ee9c v\u1edbi c\u00e1c tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 kh\u00e1c.\u00a0Gi\u1ea3 s\u1eed b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c\u00a0<strong>=SUM($B:B) <\/strong>v\u00e0o m\u1ed9t \u00f4, ch\u1eb3ng h\u1ea1n F2.\u00a0Khi b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o \u00f4 b\u00ean ph\u1ea3i li\u1ec1n k\u1ec1 (G2), n\u00f3 s\u1ebd thay \u0111\u1ed5i\u00a0<strong>=SUM($B:C)<\/strong>b\u1edfi v\u00ec B \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh b\u1eb1ng d\u1ea5u $, c\u00f2n ph\u1ea7n th\u1ee9 hai th\u00ec kh\u00f4ng.\u00a0K\u1ebft qu\u1ea3 l\u00e0, c\u00f4ng th\u1ee9c s\u1ebd c\u1ed9ng t\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 trong c\u00e1c c\u1ed9t B v\u00e0 C. Kh\u00f4ng ch\u1eafc ch\u1eafn n\u00f3 c\u00f3 b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb th\u1ef1c t\u1ebf n\u00e0o, nh\u01b0ng c\u00f3 th\u1ec3 b\u1ea1n c\u0169ng mu\u1ed1n bi\u1ebft n\u00f3 ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/1-12.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7604\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-12.bmp\" width=\"600\" height=\"188\" title=\"1-12\"><\/a><strong>C\u1ea3nh b\u00e1o!\u00a0<\/strong>Kh\u00f4ng n\u00ean s\u1eed d\u1ee5ng qu\u00e1 nhi\u1ec1u c\u00e1c tham chi\u1ebfu c\u1ed9t \/ h\u00e0ng to\u00e0n b\u1ed9 trong m\u1ed9t b\u1ea3ng v\u00ec ch\u00fang c\u00f3 th\u1ec3 l\u00e0m ch\u1eadm Excel c\u1ee7a b\u1ea1n.<\/p>\n<p>C\u00e1ch chuy\u1ec3n \u0111\u1ed5i gi\u1eefa tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i, t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 h\u1ed7n h\u1ee3p (ph\u00edm F4)<\/p>\n<p>Khi b\u1ea1n vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c Excel, d\u1ea5u $ c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c g\u00f5 b\u1eb1ng tay \u0111\u1ec3 thay \u0111\u1ed5i m\u1ed9t tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i th\u00e0nh tuy\u1ec7t \u0111\u1ed1i ho\u1eb7c h\u1ed7n h\u1ee3p.\u00a0Ho\u1eb7c, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n\u00a0ph\u00edm\u00a0F4\u00a0.\u00a0\u0110\u1ec3 ph\u00edm t\u1eaft F4 ho\u1ea1t \u0111\u1ed9ng, b\u1ea1n ph\u1ea3i \u1edf ch\u1ebf \u0111\u1ed9 ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c:<\/p>\n<ol>\n<li>Ch\u1ecdn \u00f4 v\u1edbi c\u00f4ng th\u1ee9c.<\/li>\n<li>V\u00e0o ch\u1ebf \u0111\u1ed9 ch\u1ec9nh s\u1eeda b\u1eb1ng c\u00e1ch nh\u1ea5n ph\u00edm\u00a0F2, ho\u1eb7c ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o b\u00ean trong thanh c\u00f4ng th\u1ee9c, v\u00e0 ch\u1ecdn tham chi\u1ebfu \u00f4 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i.<\/li>\n<li>Nh\u1ea5n\u00a0F4\u00a0\u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i gi\u1eefa b\u1ed1n lo\u1ea1i tham chi\u1ebfu \u00f4.<\/li>\n<\/ol>\n<p>N\u1ebfu b\u1ea1n \u0111\u00e3 ch\u1ecdn tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i m\u00e0 kh\u00f4ng c\u00f3 d\u1ea5u dollar, nh\u01b0 A1, li\u00ean t\u1ee5c nh\u1ea5n\u00a0n\u00fat\u00a0F4 s\u1ebd\u00a0chuy\u1ec3n \u0111\u1ed5i gi\u1eefa tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i v\u1edbi c\u1ea3 hai d\u1ea5u dollar nh\u01b0 $ A $ 1, h\u00e0ng tuy\u1ec7t \u0111\u1ed1i A $ 1, c\u1ed9t tuy\u1ec7t \u0111\u1ed1i $ A1 v\u00e0 sau \u0111\u00f3 tr\u1edf l\u1ea1i Tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i A1.<\/p>\n<p><img decoding=\"async\" class=\"imgl2 aligncenter\" title=\"Switching between absolute, relative, and mixed references in Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/f4-toggle-cell-references.png\" alt=\"Switching between absolute, relative, and mixed references in Excel\"><\/p>\n<p><strong>Ch\u00fa \u00fd.\u00a0<\/strong>N\u1ebfu b\u1ea1n nh\u1ea5n F4 m\u00e0 kh\u00f4ng ch\u1ecdn b\u1ea5t k\u1ef3 tham chi\u1ebfu \u00f4 n\u00e0o, tham chi\u1ebfu b\u00ean tr\u00e1i c\u1ee7a con tr\u1ecf chu\u1ed9t s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0 thay \u0111\u1ed5i th\u00e0nh m\u1ed9t lo\u1ea1i tham chi\u1ebfu kh\u00e1c.<\/p>\n<p>Khi s\u1eed d\u1ee5ng Excel, nh\u1eefng sai s\u00f3t r\u1ea5t nh\u1ecf c\u00f3 th\u1ec3 d\u1eabn t\u1edbi sai s\u00f3t h\u00e0ng lo\u1ea1t tr\u00ean to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c, c\u00f4ng vi\u1ec7c v\u1ec1 sau. V\u00ec v\u1eady, b\u1ea1n c\u1ea7n hi\u1ec3u \u0111\u00fang b\u1ea3n ch\u1ea5t, c\u00e1ch v\u1eadn h\u00e0nh v\u00e0 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m, c\u00f4ng th\u1ee9c, th\u1ee9 t\u1ef1 s\u1eed d\u1ee5ng tr\u00ean Excel, k\u00e8m theo \u0111\u00f3 l\u00e0 s\u1ef1 c\u1ea9n th\u1eadn t\u1ec9 m\u1ec9. \u0110\u1ec3 tr\u1edf th\u00e0nh ng\u01b0\u1eddi \u0111i\u1ec1u khi\u1ec3n c\u00e1c t\u00ednh n\u0103ng Excel, ph\u1ee5c v\u1ee5 c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh, b\u1ea1n ph\u1ea3i h\u1ecdc Excel theo l\u1ed9 tr\u00ecnh, c\u00f3 h\u1ec7 th\u1ed1ng v\u00e0 luy\u1ec7n t\u1eadp li\u00ean t\u1ee5c.<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c v\u1ec1 Excel c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\">HocExcel.Online<\/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\/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\/2025\/01\/vba101_92019-nho-58.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11758,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11757","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\/11757","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=11757"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11757\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11758"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11757"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11757"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11757"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}