{"id":4752,"date":"2024-12-08T07:57:43","date_gmt":"2024-12-08T07:57:43","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cach-tinh-loi-nhuan-dua-vao-bien-dong-gia-ban-kem-theo-so-luong-ban-tren-excel\/"},"modified":"2024-12-08T07:57:43","modified_gmt":"2024-12-08T07:57:43","slug":"cach-tinh-loi-nhuan-dua-vao-bien-dong-gia-ban-kem-theo-so-luong-ban-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cach-tinh-loi-nhuan-dua-vao-bien-dong-gia-ban-kem-theo-so-luong-ban-tren-excel\/","title":{"rendered":"C\u00e1ch t\u00ednh l\u1ee3i nhu\u1eadn d\u1ef1a v\u00e0o bi\u1ebfn \u0111\u1ed9ng gi\u00e1 b\u00e1n k\u00e8m theo s\u1ed1 l\u01b0\u1ee3ng b\u00e1n tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t nhi\u1ec1u trong t\u00e0i ch\u00ednh, qu\u1ea3n tr\u1ecb v\u1edbi kh\u1ea3 n\u0103ng ph\u00e2n t\u00edch d\u1eef li\u1ec7u gi\u00fap \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh. M\u1ed9t trong nh\u1eefng b\u00e0i to\u00e1n th\u01b0\u1eddng g\u1eb7p \u0111\u00f3 l\u00e0 ph\u00e2n t\u00edch bi\u1ebfn \u0111\u1ed9ng doanh thu, l\u1ee3i nhu\u1eadn theo bi\u1ebfn \u0111\u1ed9ng gi\u00e1 b\u00e1n. Vi\u1ec7c bi\u1ebfn \u0111\u1ed9ng gi\u00e1 b\u00e1n s\u1ebd \u1ea3nh h\u01b0\u1edfng t\u1edbi s\u1ed1 l\u01b0\u1ee3ng b\u00e1n, t\u1eeb \u0111\u00f3 \u1ea3nh h\u01b0\u1edfng t\u1edbi doanh thu, l\u1ee3i nhu\u1eadn th\u1ebf n\u00e0o?. Trong b\u00e0i vi\u1ebft n\u00e0y H\u1ecdc Excel Online s\u1ebd gi\u00fap b\u1ea1n n\u1eafm \u0111\u01b0\u1ee3c 1 c\u00e1ch c\u01a1 b\u1ea3n v\u1ec1 vi\u1ec7c ph\u00e2n t\u00edch n\u00e0y, c\u00e1ch t\u00ednh l\u1ee3i nhu\u1eadn d\u1ef1a v\u00e0o bi\u1ebfn \u0111\u1ed9ng gi\u00e1 b\u00e1n k\u00e8m theo s\u1ed1 l\u01b0\u1ee3ng b\u00e1n tr\u00ean Excel.<\/p>\n<p>\u0110\u1ec3 d\u1ec5 h\u00ecnh dung, ch\u00fang ta s\u1ebd l\u1ea5y v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/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-67555176c2f78\" 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\/cach-tinh-loi-nhuan-dua-vao-bien-dong-gia-ban-kem-theo-so-luong-ban-tren-excel.html#De_bai\" title=\"\u0110\u1ec1 b\u00e0i\">\u0110\u1ec1 b\u00e0i<\/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\/cach-tinh-loi-nhuan-dua-vao-bien-dong-gia-ban-kem-theo-so-luong-ban-tren-excel.html#Cach_giai_quyet\" title=\"C\u00e1ch gi\u1ea3i quy\u1ebft\">C\u00e1ch gi\u1ea3i quy\u1ebft<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-loi-nhuan-dua-vao-bien-dong-gia-ban-kem-theo-so-luong-ban-tren-excel.html#1_Trinh_bay_de_bai_tren_Excel\" title=\"1. Tr\u00ecnh b\u00e0y \u0111\u1ec1 b\u00e0i\u00a0tr\u00ean Excel\">1. Tr\u00ecnh b\u00e0y \u0111\u1ec1 b\u00e0i\u00a0tr\u00ean Excel<\/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\/cach-tinh-loi-nhuan-dua-vao-bien-dong-gia-ban-kem-theo-so-luong-ban-tren-excel.html#2_Xay_dung_cong_thuc_tinh_loi_nhuan_theo_cac_muc_gia_ban\" title=\"2. X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh l\u1ee3i nhu\u1eadn theo c\u00e1c m\u1ee9c gi\u00e1 b\u00e1n\">2. X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh l\u1ee3i nhu\u1eadn theo c\u00e1c m\u1ee9c gi\u00e1 b\u00e1n<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"De_bai\"><\/span>\u0110\u1ec1 b\u00e0i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ed9 ph\u1eadn Marketing khi nghi\u00ean c\u1ee9u th\u1ecb tr\u01b0\u1eddng \u0111\u00e3 \u0111\u01b0a ra m\u1ed9t b\u1ea3ng k\u1ebf ho\u1ea1ch nh\u01b0 sau:<\/p>\n<p>\u1ede m\u1ee9c gi\u00e1 gi\u1ea3 \u0111\u1ecbnh ban \u0111\u1ea7u l\u00e0 100.000\u0111\/s\u1ea3n ph\u1ea9m th\u00ec s\u1ed1 l\u01b0\u1ee3ng b\u00e1n nh\u01b0 sau:<\/p>\n<ul>\n<li>Th\u00e1ng 1: 1.236 s\u1ea3n ph\u1ea9m<\/li>\n<li>Th\u00e1ng 2: 1.513 s\u1ea3n ph\u1ea9m<\/li>\n<li>Th\u00e1ng 3: 1.352 s\u1ea3n ph\u1ea9m<\/li>\n<li>Th\u00e1ng 4: 1.684 s\u1ea3n ph\u1ea9m<\/li>\n<li>Th\u00e1ng 5: 1.484\u00a0s\u1ea3n ph\u1ea9m<\/li>\n<li>Th\u00e1ng 6: 1.675 s\u1ea3n ph\u1ea9m<\/li>\n<\/ul>\n<p>Chi ph\u00ed ho\u1ea1t \u0111\u1ed9ng th\u00e1ng 1 l\u00e0 100 tri\u1ec7u, m\u1ed7i th\u00e1ng ti\u1ebfp theo s\u1ebd t\u0103ng 5% so v\u1edbi th\u00e1ng tr\u01b0\u1edbc.<\/p>\n<p>Y\u00eau c\u1ea7u: T\u00ecm m\u1ee9c gi\u00e1 b\u00e1n thu \u0111\u01b0\u1ee3c l\u1ee3i nhu\u1eadn l\u1edbn nh\u1ea5t, bi\u1ebft bi\u1ebfn \u0111\u1ed9ng s\u1ed1 l\u01b0\u1ee3ng b\u00e1n theo c\u00e1c m\u1ee9c gi\u00e1 b\u00e1n nh\u01b0 sau:<\/p>\n<ul>\n<li>M\u1ee9c gi\u00e1 80.000\u0111 th\u00ec s\u1ed1 l\u01b0\u1ee3ng b\u00e1n \u0111\u1ea1t 120% so v\u1edbi m\u1ee9c gi\u00e1 100.000\u0111<\/li>\n<li>M\u1ee9c gi\u00e1 110.000\u0111 th\u00ec s\u1ed1 l\u01b0\u1ee3ng b\u00e1n \u0111\u1ea1t 80% so v\u1edbi m\u1ee9c gi\u00e1 100.000\u0111<\/li>\n<li>M\u1ee9c gi\u00e1 130.000\u0111 th\u00ec s\u1ed1 l\u01b0\u1ee3ng b\u00e1n \u0111\u1ea1t 70% so v\u1edbi m\u1ee9c gi\u00e1 100.000\u0111<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_giai_quyet\"><\/span>C\u00e1ch gi\u1ea3i quy\u1ebft<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"1_Trinh_bay_de_bai_tren_Excel\"><\/span>1. Tr\u00ecnh b\u00e0y \u0111\u1ec1 b\u00e0i\u00a0tr\u00ean Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t trong nh\u1eefng nguy\u00ean nh\u00e2n l\u1edbn khi\u1ebfn h\u1ea7u h\u1ebft ch\u00fang ta kh\u00f4ng l\u00e0m \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c ch\u00ednh l\u00e0 vi\u1ec7c kh\u00f4ng bi\u1ebft c\u00e1ch tr\u00ecnh b\u00e0y l\u1ea1i \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u tr\u00ean Excel. Vi\u1ec7c tr\u00ecnh b\u00e0y m\u1ed9t c\u00e1ch khoa h\u1ecdc s\u1ebd gi\u00fap ch\u00fang ta hi\u1ec3u r\u00f5 \u0111\u01b0\u1ee3c m\u1ee5c \u0111\u00edch v\u00e0 ph\u01b0\u01a1ng ph\u00e1p \u0111\u01b0a ra \u0111\u01b0\u1ee3c c\u00e1ch gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-387.gif\" title=\"ex101_92019-nho-387\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1: L\u1eadp b\u1ea3ng theo d\u00f5i Doanh thu \u2013 Chi ph\u00ed \u2013 L\u1ee3i nhu\u1eadn theo t\u1eebng th\u00e1ng.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18906\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-dt-cp-ln.png\" width=\"883\" height=\"108\" title=\"bang-dt-cp-ln\"><\/p>\n<p>B\u1edfi ch\u00fang ta c\u00f3 6 th\u00e1ng, do \u0111\u00f3 ph\u1ea3i x\u00e1c \u0111\u1ecbnh c\u00e1c ch\u1ec9 ti\u00eau\u00a0theo t\u1eebng th\u00e1ng. C\u1ed9ng t\u1ed5ng c\u00e1c th\u00e1ng l\u1ea1i \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh xem trong 6 th\u00e1ng \u0111\u00f3 l\u1ee3i nhu\u1eadn cu\u1ed1i c\u00f9ng l\u00e0 bao nhi\u00eau.<\/p>\n<p><strong>B\u01b0\u1edbc 2: L\u1eadp b\u1ea3ng t\u00ednh s\u1ed1 l\u01b0\u1ee3ng b\u00e1n theo gi\u00e1 b\u00e1n<\/strong><\/p>\n<p>Trong \u0111\u1ec1 b\u00e0i \u0111\u00e3 cung c\u1ea5p cho ch\u00fang ta \u0111\u1ee7 th\u00f4ng tin v\u1ec1 c\u00e1c m\u1ee9c gi\u00e1 b\u00e1n, s\u1ed1 l\u01b0\u1ee3ng b\u00e1n \u1edf 1 m\u1ee9c l\u00e0 100.000\u0111 v\u00e0 t\u1ef7 l\u1ec7 thay \u0111\u1ed5i theo c\u00e1c m\u1ee9c gi\u00e1 b\u00e1n kh\u00e1c. Do \u0111\u00f3 ch\u00fang ta l\u1eadp b\u1ea3ng t\u00ednh nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18907\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-phan-tich-so-luong-theo-cac-muc-gia.png\" width=\"782\" height=\"129\" title=\"bang-phan-tich-so-luong-theo-cac-muc-gia\"><\/p>\n<p><strong>B\u01b0\u1edbc 3: X\u00e1c \u0111\u1ecbnh m\u1ee5c ti\u00eau<\/strong><\/p>\n<p>Y\u00eau c\u1ea7u b\u00e0i to\u00e1n l\u00e0 x\u00e1c \u0111\u1ecbnh m\u1ee9c gi\u00e1 b\u00e1n thu \u0111\u01b0\u1ee3c l\u1ee3i nhu\u1eadn cao nh\u1ea5t. \u1ede \u0111\u00e2y ch\u00fang ta hi\u1ec3u l\u00e0:<\/p>\n<ul>\n<li>M\u1ed7i m\u1ee9c gi\u00e1 s\u1ebd l\u00e0m thay \u0111\u1ed5i doanh thu<\/li>\n<li>Chi ph\u00ed kh\u00f4ng \u1ea3nh h\u01b0\u1edfng b\u1edfi m\u1ee9c gi\u00e1 (theo d\u1eef ki\u1ec7n \u0111\u1ec1 b\u00e0i)<\/li>\n<li>Do \u0111\u00f3 l\u1ee3i nhu\u1eadn s\u1ebd thay \u0111\u1ed5i khi doanh thu thay \u0111\u1ed5i<\/li>\n<li>C\u1ea7n t\u00ecm ra \u1edf gi\u00e1 b\u00e1n n\u00e0o c\u00f3 l\u1ee3i nhu\u1eadn cao nh\u1ea5t<\/li>\n<\/ul>\n<p>L\u1eadp b\u1ea3ng theo d\u00f5i k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18908\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-xac-dinh-loi-nhuan-theo-cac-muc-gia-ban.png\" width=\"421\" height=\"130\" title=\"bang-xac-dinh-loi-nhuan-theo-cac-muc-gia-ban\"><\/p>\n<p>Sau khi \u0111\u00e3 x\u00e2y d\u1ef1ng \u0111\u01b0\u1ee3c c\u1ea5u tr\u00fac c\u00e1c b\u1ea3ng t\u00ednh ch\u00fang ta s\u1ebd th\u1ef1c hi\u1ec7n x\u00e2y d\u1ef1ng c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh nh\u01b0 sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Xay_dung_cong_thuc_tinh_loi_nhuan_theo_cac_muc_gia_ban\"><\/span>2. X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh l\u1ee3i nhu\u1eadn theo c\u00e1c m\u1ee9c gi\u00e1 b\u00e1n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>B\u01b0\u1edbc 1: X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh b\u1ea3ng S\u1ed1 l\u01b0\u1ee3ng b\u00e1n theo c\u00e1c m\u1ee9c gi\u00e1 b\u00e1n<\/strong><\/p>\n<p>T\u1ea1i m\u1ee9c gi\u00e1 100.000\u0111 \u0111\u01b0\u1ee3c quy \u01b0\u1edbc c\u00f3 t\u1ef7 l\u1ec7 s\u1ed1 l\u01b0\u1ee3ng b\u00e1n \u0111\u1ea1t 100%, t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c s\u1ed1 li\u1ec7u \u0111\u00e3 c\u00f3 \u1edf d\u00f2ng 9<\/p>\n<p>M\u1ee9c gi\u00e1 80.000\u0111 c\u00f3 t\u1ef7 l\u1ec7 s\u1ed1 l\u01b0\u1ee3ng b\u00e1n \u0111\u1ea1t 120% so v\u1edbi m\u1ee9c gi\u00e1 100.000 do \u0111\u00f3:<\/p>\n<p style=\"padding-left: 30px\">B8=B9*120%<\/p>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i B8 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng sang c\u00e1c th\u00e1ng kh\u00e1c t\u1edbi th\u00e1ng 6 (\u00f4 G8)<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 c\u00e1c m\u1ee9c gi\u00e1 kh\u00e1c:<\/p>\n<ul>\n<li>M\u1ee9c gi\u00e1 110.000 \u00f4 B10 = B9*80%<\/li>\n<li>M\u1ee9c gi\u00e1 130.000 \u00f4 B11=B9*70%<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18909\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-phan-tich-so-luong-theo-cac-muc-gia-kq.png\" width=\"782\" height=\"128\" title=\"bang-phan-tich-so-luong-theo-cac-muc-gia-kq\"><\/p>\n<p>L\u01b0u \u00fd: Khi t\u00ednh ra k\u1ebft qu\u1ea3 th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y ph\u1ea7n s\u1ed1 l\u1ebb (s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n). Nh\u01b0ng v\u1ec1 nguy\u00ean t\u1eafc s\u1ea3n ph\u1ea9m kh\u00f4ng c\u00f3 l\u1ebb, do \u0111\u00f3 ch\u00fang ta ph\u1ea3i l\u00e0m tr\u00f2n xu\u1ed1ng cho t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb t\u00ednh \u0111\u01b0\u1ee3c.<\/p>\n<p>S\u1eed d\u1ee5ng h\u00e0m ROUNDDOWN \u0111\u1ec3 l\u00e0m tr\u00f2n xu\u1ed1ng cho c\u00f4ng th\u1ee9c t\u1ea1i c\u00e1c \u00f4 nh\u01b0 sau:<\/p>\n<ul>\n<li>B8=ROUNDDOWN(B9*120%,0)<\/li>\n<li>B10=ROUNDDOWN(B9*80%,0)<\/li>\n<li>B11=ROUNDDOWN(B9*70%,0)<\/li>\n<\/ul>\n<p>\u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c t\u1eeb B8 t\u1edbi G8, B10 t\u1edbi G10, B11 t\u1edbi G11<\/p>\n<p>Khi \u0111\u00f3 b\u1ea3ng k\u1ebft qu\u1ea3 s\u1ebd l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18912\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-phan-tich-so-luong-theo-cac-muc-gia-kq-roundown.png\" width=\"749\" height=\"107\" title=\"bang-phan-tich-so-luong-theo-cac-muc-gia-kq-roundown\"><\/p>\n<p><strong>B\u01b0\u1edbc 2: X\u00e1c \u0111\u1ecbnh chi ph\u00ed c\u00e1c th\u00e1ng<\/strong><\/p>\n<p>Chi ph\u00ed th\u00e1ng sau t\u0103ng 5% so v\u1edbi th\u00e1ng tr\u01b0\u1edbc: c\u00e1ch t\u00ednh nh\u01b0 sau:<\/p>\n<ul>\n<li>Chi ph\u00ed th\u00e1ng 1: B3=100.000.000\u0111<\/li>\n<li>Chi ph\u00ed th\u00e1ng 2: C3=B3*5%+B3=B3*(1+5%)<\/li>\n<li>Chi ph\u00ed th\u00e1ng 3: D3=C3*(1+5%)<\/li>\n<li>C\u1ee9 nh\u01b0 v\u1eady t\u0103ng d\u1ea7n t\u1edbi th\u00e1ng 6<\/li>\n<\/ul>\n<p>Do \u0111\u00f3 k\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c s\u1ebd l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18913\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xac-dinh-chi-phi-cac-thang.png\" width=\"879\" height=\"140\" title=\"xac-dinh-chi-phi-cac-thang\"><\/p>\n<p>\u00a0<\/p>\n<p><strong>B\u01b0\u1edbc 3: X\u00e1c \u0111\u1ecbnh doanh thu : t\u1ea1o danh s\u00e1ch ch\u1ecdn c\u00e1c m\u1ee9c gi\u00e1 b\u00e1n<\/strong><\/p>\n<p>Doanh thu ph\u1ee5 thu\u1ed9c v\u00e0o t\u1eebng m\u1ee9c gi\u00e1 b\u00e1n. Do \u0111\u00f3 ch\u00fang ta c\u1ea7n c\u00f3 1 tham s\u1ed1 l\u00e0 Gi\u00e1 b\u00e1n \u0111\u1ec3 t\u00ednh doanh thu.<\/p>\n<p>Coi v\u1ecb tr\u00ed c\u1ea7n \u0111\u1eb7t\u00a0danh s\u00e1ch ch\u1ecdn gi\u00e1 b\u00e1n\u00a0l\u00e0 H1.<\/p>\n<p>T\u1ea1i \u00f4 H1 s\u1eed d\u1ee5ng Data Validation\/List. Trong \u0111\u00f3 danh s\u00e1ch ch\u1ecdn l\u00e0 c\u00e1c m\u1ee9c gi\u00e1 b\u00e1n (A8:A11)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18915\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xac-dinh-doanh-thu-tao-danh-sach-chon-gia-ban.png\" width=\"946\" height=\"478\" title=\"xac-dinh-doanh-thu-tao-danh-sach-chon-gia-ban\"><\/p>\n<p>(Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cach-thiet-lap-hop-thoai-xo-xuong-dep-mat-cho-chuc-nang-kiem-duyet-du-lieu-data-validation-trong-excel.html\">T\u1ea1o danh s\u00e1ch ch\u1ecdn Drop-down List v\u1edbi ch\u1ee9c n\u0103ng Data Validation<\/a>)<\/p>\n<p><strong>B\u01b0\u1edbc 4: X\u00e1c \u0111\u1ecbnh doanh thu : C\u00f4ng th\u1ee9c t\u00ednh doanh thu<\/strong><\/p>\n<p>V\u1edbi m\u1ee9c gi\u00e1 b\u00e1n \u0111\u01b0\u1ee3c\u00a0 ch\u1ecdn t\u1ea1i \u00f4 H1 ta c\u00f3 doanh thu t\u01b0\u01a1ng \u1ee9ng c\u1ee7a m\u1ed7i th\u00e1ng l\u00e0:<\/p>\n<p>Doanh thu = Gi\u00e1 b\u00e1n * S\u1ed1 l\u01b0\u1ee3ng b\u00e1n.<\/p>\n<p>S\u1ed1 l\u01b0\u1ee3ng b\u00e1n c\u1ee7a th\u00e1ng s\u1ebd \u0111\u01b0\u1ee3c tham chi\u1ebfu t\u1edbi b\u1ea3ng S\u1ed1 l\u01b0\u1ee3ng b\u00e1n theo gi\u00e1 b\u00e1n (b\u01b0\u1edbc 1) b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup. Tuy nhi\u00ean \u1edf \u0111\u00e2y ch\u00fang ta\u00a0c\u1ea7n t\u00ecm theo nhi\u1ec1u c\u1ed9t k\u1ebft qu\u1ea3, do \u0111\u00f3 c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p th\u00eam h\u00e0m Match \u0111\u1ec3 l\u00e0m c\u00f4ng th\u1ee9c vlookup \u0111\u01b0\u1ee3c linh \u0111\u1ed9ng h\u01a1n, kh\u00f4ng ph\u1ea3i x\u00e1c \u0111\u1ecbnh th\u1ee7 c\u00f4ng \u0111\u1ed1i s\u1ed1 <strong>col_index_num<\/strong> trong h\u00e0m vlookup.<\/p>\n<p>(Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-vlookup-ket-hop-ham-match-khi-tim-theo-nhieu-cot-chua-ket-qua.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m vlookup k\u1ebft h\u1ee3p h\u00e0m Match khi t\u00ecm theo nhi\u1ec1u c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3<\/a>)<\/p>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18932\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-vlookup-match-xac-dinh-doanh-thu-theo-tung-thang.png\" width=\"914\" height=\"188\" title=\"ham-vlookup-match-xac-dinh-doanh-thu-theo-tung-thang\"><\/p>\n<p><strong>B\u01b0\u1edbc 5: X\u00e1c \u0111\u1ecbnh l\u1ee3i nhu\u1eadn<\/strong><\/p>\n<p>L\u1ee3i nhu\u1eadn c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng b\u1eb1ng c\u00e1ch:<\/p>\n<p style=\"padding-left: 30px\">L\u1ee3i nhu\u1eadn = Doanh thu \u2013 chi ph\u00ed<\/p>\n<p>Sau khi \u0111\u00e3 th\u1ef1c hi\u1ec7n t\u1ea5t c\u1ea3 c\u00e1c b\u01b0\u1edbc tr\u00ean ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 t\u1ed5ng l\u1ee3i nhu\u1eadn cho m\u1ee9c gi\u00e1 b\u00e1n 80.000\u0111 l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18933\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-loi-nhuan-muc-gia-80k.png\" width=\"919\" height=\"145\" title=\"ket-qua-loi-nhuan-muc-gia-80k\"><\/p>\n<p><strong>B\u01b0\u1edbc 6: X\u00e1c \u0111\u1ecbnh k\u1ebft qu\u1ea3 khi thay \u0111\u1ed5i t\u1eebng m\u1ee9c gi\u00e1 b\u00e1n<\/strong><\/p>\n<p>Sau khi \u0111\u00e3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c l\u1ee3i nhu\u1eadn cho 1 m\u1ee9c gi\u00e1, ch\u00fang ta ch\u1ec9 c\u1ea7n thay \u0111\u1ed5i gi\u00e1 b\u00e1n l\u00e0 c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c l\u1ee3i nhu\u1eadn c\u1ee7a m\u1ee9c gi\u00e1 \u0111\u00f3.<\/p>\n<p>L\u1ea7n l\u01b0\u1ee3t thay \u0111\u1ed5i c\u00e1c gi\u00e1 b\u00e1n, ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18934\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-loi-nhuan-cac-muc-gia.png\" width=\"455\" height=\"141\" title=\"ket-qua-loi-nhuan-cac-muc-gia\"><\/p>\n<p><strong>K\u1ebft lu\u1eadn: M\u1ee9c gi\u00e1 c\u00f3 l\u1ee3i nhu\u1eadn cao nh\u1ea5t l\u00e0 m\u1ee9c gi\u00e1 100.000\u0111<\/strong><\/p>\n<p>\u0110\u00e2y l\u00e0 d\u1ea1ng\u00a0b\u00e0i to\u00e1n \u0111i\u1ec3n h\u00ecnh\u00a0trong c\u00e1c m\u00f4 h\u00ecnh gi\u1ea3 \u0111\u1ecbnh, x\u00e2y d\u1ef1ng ph\u01b0\u01a1ng \u00e1n kinh doanh, ph\u01b0\u01a1ng \u00e1n ho\u1ea1t \u0111\u1ed9ng t\u1ed1i \u01b0u d\u1ef1a tr\u00ean gi\u1ea3 \u0111\u1ecbnh thay \u0111\u1ed5i 1 ti\u00eau ch\u00ed. Qua b\u00e0i to\u00e1n n\u00e0y ch\u00fang ta \u0111\u00e3 c\u00f3 th\u1ec3 b\u01b0\u1edbc \u0111\u1ea7u h\u00ecnh th\u00e0nh \u0111\u01b0\u1ee3c t\u01b0 duy x\u00e2y d\u1ef1ng m\u00f4 h\u00ecnh gi\u1ea3 \u0111\u1ecbnh tr\u00ean Excel m\u1ed9t c\u00e1ch c\u01a1 b\u1ea3n \u0111\u01b0\u1ee3c r\u1ed3i.<\/p>\n<p>T\u1ea3i v\u1ec1 file m\u1eabu t\u1ea1i \u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2JQJuy2\">http:\/\/bit.ly\/2JQJuy2<\/a><\/p>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tu-dong-xac-dinh-ket-qua-tim-muc-gia-ban-toi-uu-bang-cach-su-dung-vba.html\">T\u1ef1 \u0111\u1ed9ng x\u00e1c \u0111\u1ecbnh k\u1ebft qu\u1ea3 t\u00ecm m\u1ee9c gi\u00e1 b\u00e1n t\u1ed1i \u01b0u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng VBA<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0<a href=\"http:\/\/bit.ly\/2t5YjGx\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. Chi ti\u1ebft xem t\u1ea1i:<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-387.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4753,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4752","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\/4752","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=4752"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4752\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4753"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}