{"id":2205,"date":"2024-12-02T07:14:34","date_gmt":"2024-12-02T07:14:34","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/lam-chu-cong-thuc-trong-excel\/"},"modified":"2024-12-02T07:14:34","modified_gmt":"2024-12-02T07:14:34","slug":"lam-chu-cong-thuc-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/lam-chu-cong-thuc-trong-excel\/","title":{"rendered":"L\u00e0m ch\u1ee7 c\u00f4ng th\u1ee9c trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n <a href=\"https:\/\/hocexcel.online\">C\u00e1c\u00a0c\u00e1ch t\u1ea1o c\u00f4ng th\u1ee9c trong Excel<\/a> \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 m\u00ecnh vi\u1ebft c\u00f4ng th\u1ee9c, b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n nh\u1ea5t. B\u1ea1n s\u1ebd h\u1ecdc c\u00e1ch t\u1ea1o c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u1eb1ng s\u1ed1, tham chi\u1ebfu \u00f4 v\u00e0 t\u00ean ch\u1ec9 \u0111\u1ecbnh. B\u1ea1n c\u0169ng s\u1ebd bi\u1ebft c\u00e1ch t\u1ea1o c\u00f4ng th\u1ee9c b\u1eb1ng b\u1ea3ng c\u00f4ng th\u1ee9c ho\u1eb7c nh\u1eadp c\u00f4ng th\u1ee9c tr\u1ef1c ti\u1ebfp v\u00e0o \u00f4.<\/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-674d5e59e0e7b\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/lam-chu-cong-thuc-trong-excel.html#Cach_tao_cong_thuc_don_gian_bang_hang_so_va_cac_phep_tinh\" title=\"C\u00e1ch t\u1ea1o c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n b\u1eb1ng h\u1eb1ng s\u1ed1 v\u00e0 c\u00e1c ph\u00e9p t\u00ednh\">C\u00e1ch t\u1ea1o c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n b\u1eb1ng h\u1eb1ng s\u1ed1 v\u00e0 c\u00e1c ph\u00e9p t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/lam-chu-cong-thuc-trong-excel.html#Cach_viet_cong_thuc_su_dung_tham_chieu_o\" title=\"C\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4\">C\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/lam-chu-cong-thuc-trong-excel.html#Cach_tao_cong_thuc_Excel_bang_cach_su_dung_ten_chi_dinh\" title=\"C\u00e1ch t\u1ea1o c\u00f4ng th\u1ee9c Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng t\u00ean ch\u1ec9 \u0111\u1ecbnh\">C\u00e1ch t\u1ea1o c\u00f4ng th\u1ee9c Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng t\u00ean ch\u1ec9 \u0111\u1ecbnh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/lam-chu-cong-thuc-trong-excel.html#Cach_tao_cong_thuc_Excel_bang_ham\" title=\"C\u00e1ch t\u1ea1o c\u00f4ng th\u1ee9c Excel b\u1eb1ng h\u00e0m\">C\u00e1ch t\u1ea1o c\u00f4ng th\u1ee9c Excel b\u1eb1ng h\u00e0m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/lam-chu-cong-thuc-trong-excel.html#Tao_cong_thuc_bang_Function_Wizard\" title=\"T\u1ea1o c\u00f4ng th\u1ee9c b\u1eb1ng Function Wizard\">T\u1ea1o c\u00f4ng th\u1ee9c b\u1eb1ng Function Wizard<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tao_cong_thuc_don_gian_bang_hang_so_va_cac_phep_tinh\"><\/span><strong>C\u00e1ch t\u1ea1o c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n b\u1eb1ng h\u1eb1ng s\u1ed1 v\u00e0 c\u00e1c ph\u00e9p t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong c\u00f4ng th\u1ee9c Microsoft Excel, h\u1eb1ng s\u1ed1 l\u00e0 c\u00e1c s\u1ed1, ng\u00e0y th\u00e1ng, gi\u00e1 tr\u1ecb text m\u00e0 b\u1ea1n g\u00f5 tr\u1ef1c ti\u1ebfp v\u00e0o c\u00f4ng th\u1ee9c. \u0110\u1ec3 t\u1ea1o c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng h\u1eb1ng s\u1ed1, h\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn m\u1ed9t \u00f4 t\u00ednh s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3<\/li>\n<li>G\u00f5 d\u1ea5u \u201c=\u201d v\u00e0 g\u00f5 ph\u00e9p t\u00ednh<\/li>\n<li>Nh\u1ea5n Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c<\/li>\n<\/ul>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 v\u00ed d\u1ee5 cho ph\u00e9p tr\u1eeb trong Excel:<strong><em> =100-50<\/em><\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_viet_cong_thuc_su_dung_tham_chieu_o\"><\/span><strong>C\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Thay v\u00ec nh\u1eadp gi\u00e1 tr\u1ecb tr\u1ef1c ti\u1ebfp v\u00e0o thanh c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 \u0111\u1ecbnh m\u1ed9t \u00f4 ch\u1ee9a \u0111\u1ef1ng gi\u00e1 tr\u1ecb \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n gi\u00e1 tr\u1ecb trong \u00f4 A2 tr\u1eeb gi\u00e1 tr\u1ecb trong \u00f4 B2, vi\u1ebft c\u00f4ng th\u1ee9c tr\u1eeb sau: <strong><em>=A2-B2<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-formula-references.png\" alt=\"Creating a subtraction formula in Excel using cell references\" title=\"excel-formula-references\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Khi t\u1ea1o c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 g\u00f5 \u0111\u1ecba ch\u1ec9 \u00f4 tr\u1ef1c ti\u1ebfp v\u00e0o c\u00f4ng th\u1ee9c, ho\u1eb7c nh\u1ea5p v\u00e0o \u00f4 t\u00ednh v\u00e0 Excel s\u1ebd ch\u00e8n \u00f4 \u0111\u00f3 v\u00e0o c\u00f4ng th\u1ee9c. \u0110\u1ec3 nh\u1eadp \u0111\u1ecba ch\u1ec9 \u00f4, ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a \u00f4 t\u00ednh \u0111\u00f3 trong trang t\u00ednh.<\/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-69.gif\" title=\"vba101_92019-nho-69\"><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-168.gif\" title=\"ex101_92019-nho-168\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-cell-reference-formula.png\" alt=\"To have a cell reference inserted in your formula, click the corresponding cell on the sheet.\" title=\"add-cell-reference-formula\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong>Theo m\u1eb7c \u0111\u1ecbnh, Excel s\u1ebd th\u00eam c\u00e1c \u0111\u1ecba ch\u1ec9 \u00f4 c\u00f3 li\u00ean quan. \u0110\u1ec3 tr\u00e1nh vi\u1ec7c chuy\u1ec3n sang \u0111\u1ecba ch\u1ec9 \u00f4 kh\u00e1c, nh\u1ea5n ph\u00edm <strong><em>F4<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">\u01afu \u0111i\u1ec3m l\u1edbn nh\u1ea5t khi s\u1eed d\u1ee5ng \u0111\u1ecba ch\u1ec9 \u00f4 l\u00e0 b\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n thay \u0111\u1ed5i gi\u00e1 tr\u1ecb trong \u00f4 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh, c\u00f4ng th\u1ee9c s\u1ebd \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n l\u1ea1i m\u00e0 kh\u00f4ng c\u1ea7n c\u1eadp nh\u1eadt ph\u00e9p t\u00ednh v\u00e0 c\u00f4ng th\u1ee9c theo c\u00e1ch th\u1ee7 c\u00f4ng.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tao_cong_thuc_Excel_bang_cach_su_dung_ten_chi_dinh\"><\/span><strong>C\u00e1ch t\u1ea1o c\u00f4ng th\u1ee9c Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng t\u00ean ch\u1ec9 \u0111\u1ecbnh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n nhi\u1ec1u thao t\u00e1c h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t t\u00ean cho m\u1ed9t \u00f4 c\u1ee5 th\u1ec3 ho\u1eb7c m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u c\u1ee5 th\u1ec3, sau \u0111\u00f3 ch\u1ec9 \u0111\u1ecbnh n\u00f3 v\u00e0o c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch g\u00f5 t\u00ean \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 \u0111\u1eb7t t\u00ean trong Excel l\u00e0 ch\u1ecdn m\u1ed9t hay c\u00e1c \u00f4 t\u00ednh v\u00e0 g\u00f5 t\u00ean tr\u1ef1c ti\u1ebfp v\u00e0o h\u1ed9p t\u00ean nh\u01b0 trong h\u00ecnh. V\u00ed d\u1ee5, \u0111\u1eb7t t\u00ean cho \u00f4 A2:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/create-name-excel.png\" alt=\"Creating a name for a cell in Excel\" title=\"create-name-excel\"><\/p>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch chuy\u00ean nghi\u1ec7p \u0111\u1ec3 \u0111\u1eb7t t\u00ean l\u00e0 v\u00e0o th\u1ebb <strong><em>Formulas &gt; Defined names <\/em><\/strong>ho\u1eb7c nh\u1ea5n <strong><em>F3<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, t\u00f4i s\u1ebd t\u1ea1o hai t\u00ean:<\/p>\n<ul style=\"text-align: justify\">\n<li>\u00d4 A2 \u2013 Revenue<\/li>\n<li>\u00d4 A3 \u2013 Expenses<\/li>\n<\/ul>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, \u0111\u1ec3 t\u00ednh thu nh\u1eadp r\u00f2ng, t\u00f4i c\u00f3 th\u1ec3 g\u00f5 c\u00f4ng th\u1ee9c sau v\u00e0o b\u1ea5t k\u1ef3 \u00f4 t\u00ednh n\u00e0o trong b\u1ea5t k\u1ef3 trang t\u00ednh n\u00e0o v\u1edbi b\u1ea3ng t\u00ednh ch\u1ee9a c\u00f3 c\u00e1c t\u00ean v\u1eeba \u0111\u1eb7t: <strong>=Revenue-Expenses<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-formula-defined-name.png\" alt=\"Creating a formula with Excel names\" title=\"excel-formula-defined-name\"><\/p>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ean thay v\u00ec \u0111\u1ecba ch\u1ec9 \u00f4 hay v\u00f9ng \u00f4 \u0111\u1ec3 tham chi\u1ebfu.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, b\u1ea1n \u0111\u1eb7t t\u00ean cho v\u00f9ng d\u1eef li\u1ec7u A2:A100 l\u00e0 2015_sales, b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 n\u00e0y b\u1eb1ng c\u00f4ng th\u1ee9c <strong><em>SUM<\/em><\/strong>: <strong><em>=SUM(2015_sales)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u01b0\u01a1ng nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 b\u1eb1ng c\u00e1ch \u0111i\u1ec1n \u0111\u1ecba ch\u1ec9 v\u00f9ng d\u1eef li\u1ec7u v\u00e0o h\u00e0m: <strong><em>=SUM(A2:A100)<\/em><\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tao_cong_thuc_Excel_bang_ham\"><\/span><strong>C\u00e1ch t\u1ea1o c\u00f4ng th\u1ee9c Excel b\u1eb1ng h\u00e0m<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">H\u00e0m Excel l\u00e0 nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp s\u1eb5n \u0111\u1ec3 th\u1ef1c hi\u1ec7n nh\u1eefng t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u.<\/p>\n<p style=\"text-align: justify\">M\u1ed7i c\u00f4ng th\u1ee9c b\u1eaft \u0111\u1ea7u b\u1eb1ng d\u1ea5u \u201c=\u201d, theo sau l\u00e0 t\u00ean h\u00e0m v\u00e0 c\u00e1c tham chi\u1ebfu \u00f4 \u0111\u01b0\u1ee3c g\u00f5 v\u00e0o d\u1ea5u (). M\u1ed7i h\u00e0m c\u00f3 m\u1ed9t c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch tham chi\u1ebfu kh\u00e1c nhau.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_cong_thuc_bang_Function_Wizard\"><\/span><a href=\"https:\/\/hocexcel.online\"><strong>T\u1ea1o c\u00f4ng th\u1ee9c b\u1eb1ng Function Wizard<\/strong><\/a><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng th\u00edch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c, c\u00f4ng c\u1ee5 <strong><em>Insert Function <\/em><\/strong>c\u00f3 th\u1ec3 l\u00e0m b\u1ea1n h\u00e0i l\u00f2ng.<\/p>\n<ol style=\"text-align: justify\">\n<li><strong> Ch\u1ea1y c\u00f4ng c\u1ee5 Function<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">\u0110\u1ec3 m\u1edf c\u00f4ng c\u1ee5 n\u00e0y, nh\u1ea5p ch\u1ecdn <strong><em>Insert Function<\/em><\/strong> trong th\u1ebb <strong><em>Formulas<\/em><\/strong> \u1edf nh\u00f3m <strong><em>Function Library<\/em><\/strong>, ho\u1eb7c ch\u1ecdn m\u1ed9t h\u00e0m t\u1eeb danh m\u1ee5c.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-function-wizard.png\" alt=\"Click the Insert Function button to run the wizard.\" title=\"excel-function-wizard\"><\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o n\u00fat \u00a0\u1edf b\u00ean tr\u00e1i thanh c\u00f4ng c\u1ee5.<\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c, g\u00f5 d\u1ea5u (=) v\u00e0o \u00f4 v\u00e0 ch\u1ecdn m\u1ed9t h\u00e0m t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn \u1edf b\u00ean tr\u00e1i thanh c\u00f4ng th\u1ee9c. Theo m\u1eb7c \u0111\u1ecbnh, danh s\u00e1ch t\u00f9y ch\u1ecdn s\u1ebd hi\u1ec3n th\u1ecb 10 h\u00e0m hay s\u1eed d\u1ee5ng g\u1ea7n \u0111\u00e2y nh\u1ea5t. \u0110\u1ec3 hi\u1ec3n th\u1ecb to\u00e0n b\u1ed9 danh s\u00e1ch, nh\u1ea5p v\u00e0o <strong><em>More Functions\u2026<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-more-functions.png\" alt=\"Pick a function from the drop-down menu or click More Functions...\" title=\"excel-more-functions\"><\/em><\/strong><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li><strong> T\u00ecm h\u00e0m b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">Khi c\u1eeda s\u1ed5 <strong><em>Insert Function <\/em><\/strong>m\u1edf ra, h\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>N\u1ebfu b\u1ea1n bi\u1ebft t\u00ean h\u00e0m, g\u00f5 n\u00f3 v\u00e0o v\u00f9ng <strong><em>Search for a function<\/em><\/strong> v\u00e0 nh\u1ea5p <strong><em>Go<\/em><\/strong>.<\/li>\n<li>N\u1ebfu b\u1ea1n kh\u00f4ng bi\u1ebft ch\u00ednh x\u00e1c t\u00ean h\u00e0m, g\u00f5 m\u00f4 t\u1ea3 ng\u1eafn g\u1ecdn nhi\u1ec7m v\u1ee5 b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n v\u00e0o \u00f4 <strong><em>Search for a function<\/em><\/strong> v\u00e0 nh\u1ea5n <strong><em>Go<\/em><\/strong>. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 g\u00f5 nh\u1eefng th\u1ee9 nh\u01b0 sum cells (t\u00ednh t\u1ed5ng c\u00e1c \u00f4) hay count empty cells (\u0111\u1ebfm c\u00e1c \u00f4 r\u1ed7ng).<\/li>\n<li>N\u1ebfu b\u1ea1n bi\u1ebft th\u1ec3 lo\u1ea1i h\u00e0m m\u00ecnh c\u1ea7n, nh\u1ea5n v\u00e0o m\u0169i t\u00ean m\u00e0u \u0111en nh\u1ecf k\u1ebf b\u00ean <strong><em>Select a category<\/em><\/strong> v\u00e0 ch\u1ecdn m\u1ed9t trong 13 danh m\u1ee5c \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea \u1edf \u0111\u00f3. C\u00e1c h\u00e0m n\u1eb1m trong danh m\u1ee5c \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd xu\u1ea5t hi\u1ec7n trong <strong><em>Select a function<\/em><\/strong>.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">B\u1ea1n c\u1ea7n \u0111\u1ecdc d\u00f2ng m\u00f4 t\u1ea3 ng\u1eafn c\u1ee7a h\u00e0m \u0111\u01b0\u1ee3c ch\u1ecdn ngay d\u01b0\u1edbi h\u1ed9p <strong><em>Select a function<\/em><\/strong>. N\u1ebfu b\u1ea1n bi\u1ebft chi ti\u1ebft h\u01a1n, nh\u1ea5n v\u00e0o li\u00ean k\u1ebft <strong><em>Help on this function <\/em><\/strong>g\u1ea7n d\u01b0\u1edbi h\u1ed9p tho\u1ea1i.<\/p>\n<p style=\"text-align: justify\">Khi \u0111\u00e3 ch\u1ecdn \u0111\u01b0\u1ee3c h\u00e0m m\u00ecnh mu\u1ed1n, nh\u1ea5n OK.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/insert-function-wizard-excel.png\" alt=\"Find the function you want to use.\" title=\"insert-function-wizard-excel\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li><strong> X\u00e1c \u0111\u1ecbnh tham s\u1ed1 trong h\u00e0m<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">Trong b\u01b0\u1edbc th\u1ee9 hai c\u1ee7a <strong><em>Function Wizard<\/em><\/strong>, b\u1ea1n ph\u1ea3i x\u00e1c \u0111\u1ecbnh c\u00e1c tham s\u1ed1 c\u1ee7a h\u00e0m. B\u1ea1n kh\u00f4ng c\u1ea7n c\u00f3 ki\u1ebfn th\u1ee9c v\u1ec1 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m, ch\u1ec9 c\u1ea7n nh\u1eadp \u0111\u1ecba ch\u1ec9 \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u v\u00e0o h\u1ed9p tham s\u1ed1, <strong><em>Function Wizard <\/em><\/strong>s\u1ebd th\u1ef1c hi\u1ec7n ph\u1ea7n vi\u1ec7c c\u00f2n l\u1ea1i.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 nh\u1eadp m\u1ed9t tham s\u1ed1, b\u1ea1n c\u1ea7n g\u00f5 \u0111\u1ecba ch\u1ec9 \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u tr\u1ef1c ti\u1ebfp v\u00e0o h\u1ed9p, ho\u1eb7c nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng k\u1ebf b\u00ean h\u1ed9p (ho\u1eb7c \u0111\u1eb7t con tr\u1ecf v\u00e0o h\u1ed9p tham s\u1ed1), sau \u0111\u00f3 ch\u1ecdn m\u1ed9t \u00f4 t\u00ednh hay m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u trong trang t\u00ednh b\u1eb1ng chu\u1ed9t. Trong khi th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y, <strong><em>Function Wizard <\/em><\/strong>s\u1ebd thu h\u1eb9p c\u1eeda s\u1ed5 ch\u1ecdn. Khi b\u1ea1n th\u1ea3 chu\u1ed9t, h\u1ed9p tho\u1ea1i s\u1ebd \u0111\u01b0\u1ee3c kh\u00f4i ph\u1ee5c v\u1ec1 k\u00edch th\u01b0\u1edbc \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a n\u00f3.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3i th\u00edch ng\u1eafn g\u1ecdn cho ph\u1ea7n tham s\u1ed1 \u0111\u01b0\u1ee3c ch\u1ecdn hi\u1ec3n th\u1ecb ngang b\u00ean d\u01b0\u1edbi ph\u1ea7n m\u00f4 t\u1ea3 h\u00e0m. N\u1ebfu b\u1ea1n bi\u1ebft chi ti\u1ebft h\u01a1n, nh\u1ea5n v\u00e0o li\u00ean k\u1ebft <a href=\"https:\/\/hocexcel.online\"><strong><em>Help on this function <\/em><\/strong><\/a>g\u1ea7n d\u01b0\u1edbi h\u1ed9p tho\u1ea1i<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5926\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-102.png\" width=\"600\" height=\"541\" title=\"excel-dialog-box-launcher-1-102\"><\/p>\n<p style=\"text-align: justify\">Ngay sau khi x\u00e1c \u0111\u1ecbnh tham s\u1ed1, gi\u00e1 tr\u1ecb ho\u1eb7c m\u1ea3ng gi\u00e1 tr\u1ecb gi\u00e1 tr\u1ecb trong \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd hi\u1ec3n th\u1ecb ngay trong h\u1ed9p tho\u1ea1i tham s\u1ed1.<\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li><strong> Ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">Khi b\u1ea1n x\u00e1c \u0111\u1ecbnh xong t\u1ea5t c\u1ea3 tham s\u1ed1, nh\u1ea5n OK (ho\u1eb7c nh\u1ea5n Enter), v\u00e0 c\u00f4ng th\u1ee9c ho\u00e0n ch\u1ec9nh s\u1ebd \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o \u00f4 t\u00ednh.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-average-formula.png\" alt=\"Press Enter to complete the formula.\" title=\"excel-average-formula\"><\/p>\n<p style=\"text-align: justify\"><strong>Vi\u1ebft c\u00f4ng th\u1ee9c tr\u1ef1c ti\u1ebfp v\u00e0o m\u1ed9t \u00f4 t\u00ednh ho\u1eb7c thanh c\u00f4ng th\u1ee9c<\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 th\u1ea5y, nh\u1eadp c\u00f4ng th\u1ee9c b\u1eb1ng <strong><em>Function Wizard <\/em><\/strong>r\u1ea5t d\u1ec5 d\u00e0ng nh\u01b0ng th\u00f4ng qua qu\u00e1 nhi\u1ec1u b\u01b0\u1edbc. Khi b\u1ea1n th\u00f4ng th\u1ea1o s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Excel h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n nh\u1eadp tr\u1ef1c ti\u1ebfp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 t\u00ednh ho\u1eb7c thanh c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 th\u01b0\u1eddng l\u1ec7, b\u1ea1n th\u01b0\u1eddng b\u1eaft \u0111\u1ea7u b\u1eb1ng d\u1ea5u \u201c=\u201d, theo sau l\u00e0 t\u00ean h\u00e0m. Excel s\u1ebd th\u1ef1c hi\u1ec7n m\u1ed9t s\u1ed1 t\u00ecm ki\u1ebfm v\u00e0 hi\u1ec3n th\u1ecb danh s\u00e1ch c\u00e1c h\u00e0m \u1ee9ng v\u1edbi t\u00ean h\u00e0m b\u1ea1n v\u1eeba g\u00f5:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/type-function-name.png\" alt=\"Start typing the function name in a cell or formula bar.\" title=\"type-function-name\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 g\u00f5 ho\u00e0n thi\u1ec7n t\u00ean h\u00e0m ho\u1eb7c ch\u1ecdn t\u1eeb danh s\u00e1ch hi\u1ec3n th\u1ecb. Ngay sau khi b\u1ea1n g\u00f5 d\u1ea5u ngo\u1eb7c \u0111\u01a1n, Excel s\u1ebd hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c h\u00e0m v\u00e0 highlight ph\u1ea7n tham s\u1ed1 b\u1ea1n c\u1ea7n g\u00f5 ti\u1ebfp theo. B\u1ea1n c\u00f3 th\u1ec3 g\u00f5 tham s\u1ed1 v\u00e0o c\u00f4ng th\u1ee9c m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng, ho\u1eb7c nh\u1ea5p v\u00e0o \u00f4 t\u00ednh trong trang t\u00ednh v\u00e0 \u0111\u1ecba ch\u1ec9 \u00f4\/v\u00f9ng d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c th\u00eam v\u00e0o tham s\u1ed1 \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/enter-formula-argument.png\" alt=\"Entering the function arguments in the formula\" title=\"enter-formula-argument\"><\/p>\n<p style=\"text-align: justify\">Sau khi \u0111i\u1ec1n v\u00e0o tham s\u1ed1 cu\u1ed1i c\u00f9ng, g\u00f5 d\u1ea5u \u0111\u00f3ng ngo\u1eb7c v\u00e0 \u0111\u00e1nh Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>N\u1ebfu b\u1ea1n kh\u00f4ng quen v\u1edbi c\u00f4ng th\u1ee9c Excel, h\u00e3y nh\u1ea5p v\u00e0o t\u00ean h\u00e0m v\u00e0 <strong><em>Excel Help topic <\/em><\/strong>s\u1ebd hi\u1ec7n l\u00ean ngay l\u1eadp t\u1ee9c.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-function-help.png\" alt=\"If you are not familiar with the function's syntax, click the function name for the corresponding Help topic to appear.\" title=\"excel-function-help\"><\/p>\n<p style=\"text-align: justify\"><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/em><\/p>\n<p><strong>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-trong-excel-vi-du-va-meo-de-tiet-kiem-thoi-gian.html\">C\u00f4ng th\u1ee9c excel c\u01a1 b\u1ea3n<\/a> m\u1ecdi ng\u01b0\u1eddi \u0111\u1ec1u c\u1ea7n bi\u1ebft<\/strong><\/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-69.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2206,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2205","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\/2205","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=2205"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2205\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2206"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}