{"id":284092,"date":"2023-11-13T20:28:18","date_gmt":"2023-11-13T13:28:18","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=284092"},"modified":"2023-11-13T20:28:18","modified_gmt":"2023-11-13T13:28:18","slug":"ham-max","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-max\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m MIN, MAX trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u nh\u1ea5t"},"content":{"rendered":"

B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u1eadp trung v\u00e0o vi\u1ec7c h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MIN<\/strong> v\u00e0 h\u00e0m MAX <\/strong>trong Excel m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u. D\u00f9 b\u1ea1n m\u1edbi b\u1eaft \u0111\u1ea7u l\u00e0m quen v\u1edbi Excel hay \u0111\u00e3 c\u00f3 kinh nghi\u1ec7m, vi\u1ec7c n\u1eafm v\u1eefng c\u00e1ch s\u1eed d\u1ee5ng hai h\u00e0m n\u00e0y s\u1ebd gi\u00fap b\u1ea1n t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u. T\u1eeb vi\u1ec7c ph\u00e2n t\u00edch doanh s\u1ed1, qu\u1ea3n l\u00fd h\u00e0ng t\u1ed3n kho cho \u0111\u1ebfn vi\u1ec7c theo d\u00f5i v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u00e1 nh\u00e2n.<\/p>\n

Kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n v\u1ec1 h\u00e0m MIN v\u00e0 MAX trong Excel<\/h2>\n

H\u00e0m MIN<\/strong>: H\u00e0m MIN trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong m\u1ed9t d\u00e3y s\u1ed1 ho\u1eb7c m\u1ed9t ph\u1ea1m vi c\u1ee5 th\u1ec3. C\u00fa ph\u00e1p c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m n\u00e0y l\u00e0 MIN(number1, [number2], …)<\/strong>, trong \u0111\u00f3, number1, number2,… l\u00e0 c\u00e1c s\u1ed1 ho\u1eb7c ph\u1ea1m vi b\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t.<\/p>\n

H\u00e0m MAX<\/strong>: T\u01b0\u01a1ng t\u1ef1, h\u00e0m MAX \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong m\u1ed9t lo\u1ea1t s\u1ed1. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m MAX l\u00e0 MAX(number1, [number2], …)<\/strong>. H\u00e0m n\u00e0y r\u1ea5t h\u1eefu \u00edch trong vi\u1ec7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u khi c\u1ea7n x\u00e1c \u0111\u1ecbnh gi\u1edbi h\u1ea1n tr\u00ean c\u1ee7a m\u1ed9t t\u1eadp d\u1eef li\u1ec7u.<\/p>\n

\"ham-max-1\"<\/picture><\/p>\n

C\u00e1c \u1ee9ng d\u1ee5ng ch\u00ednh c\u1ee7a h\u00e0m MIN v\u00e0 MAX trong x\u1eed l\u00fd d\u1eef li\u1ec7u:<\/p>\n

Ph\u00e2n t\u00edch d\u1eef li\u1ec7u th\u1ed1ng k\u00ea<\/strong>: Trong th\u1ed1ng k\u00ea v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, h\u00e0m MIN v\u00e0 MAX c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh ph\u1ea1m vi c\u1ee7a d\u1eef li\u1ec7u. Ch\u00fang gi\u00fap x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb c\u1ef1c ti\u1ec3u v\u00e0 c\u1ef1c \u0111\u1ea1i, t\u1eeb \u0111\u00f3 c\u00f3 c\u00e1i nh\u00ecn t\u1ed5ng quan v\u1ec1 s\u1ef1 bi\u1ebfn \u0111\u1ed9ng c\u1ee7a d\u1eef li\u1ec7u.<\/p>\n

Qu\u1ea3n l\u00fd kinh doanh<\/strong>: Trong kinh doanh v\u00e0 qu\u1ea3n l\u00fd, vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m MIN c\u00f3 th\u1ec3 h\u1ed7 tr\u1ee3 trong vi\u1ec7c x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb \u0111\u01a1n h\u00e0ng th\u1ea5p nh\u1ea5t, c\u00f2n h\u00e0m MAX gi\u00fap x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb \u0111\u01a1n h\u00e0ng cao nh\u1ea5t, h\u1eefu \u00edch cho vi\u1ec7c \u0111\u00e1nh gi\u00e1 hi\u1ec7u su\u1ea5t b\u00e1n h\u00e0ng ho\u1eb7c qu\u1ea3n l\u00fd h\u00e0ng t\u1ed3n kho.<\/p>\n

\"ham-max-2\"<\/picture><\/p>\n

\u1ee8ng d\u1ee5ng trong T\u00e0i ch\u00ednh v\u00e0 K\u1ebf to\u00e1n<\/strong>: H\u00e0m MIN v\u00e0 MAX c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch c\u00e1c ch\u1ec9 s\u1ed1 t\u00e0i ch\u00ednh nh\u01b0 l\u1ee3i nhu\u1eadn th\u1ea5p nh\u1ea5t v\u00e0 cao nh\u1ea5t, ho\u1eb7c \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh bi\u00ean \u0111\u1ed9 l\u00e3i v\u00e0 l\u1ed7 trong c\u00e1c kho\u1ea3n \u0111\u1ea7u t\u01b0.<\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MAX v\u00e0 MIN trong Excel hi\u1ec7u qu\u1ea3 nh\u1ea5t<\/h2>\n

Sau khi hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 h\u00e0m MIN v\u00e0 MAX, ch\u00fang ta s\u1ebd c\u00f9ng nhau t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a hai lo\u1ea1i h\u00e0m ph\u1ed5 bi\u1ebfn trong Excel n\u00e0y ngay nh\u00e9.<\/p>\n

S\u1eed d\u1ee5ng h\u00e0m MAX<\/h3>\n

Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp, h\u00e0m MAX trong Excel l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong m\u1ed9t lo\u1ea1t c\u00e1c s\u1ed1 li\u1ec7u. H\u00e0m n\u00e0y \u0111\u01a1n gi\u1ea3n nh\u01b0ng m\u1ea1nh m\u1ebd gi\u00fap ng\u01b0\u1eddi d\u00f9ng nhanh ch\u00f3ng t\u00ecm ra s\u1ed1 l\u1edbn nh\u1ea5t trong m\u1ed9t t\u1eadp h\u1ee3p d\u1eef li\u1ec7u c\u1ee5 th\u1ec3.<\/p>\n

C\u00f4ng th\u1ee9c <\/strong><\/p>\n

C\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m MAX l\u00e0 =MAX(number1, number2,…). Trong \u0111\u00f3, number1, number2,… l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb ho\u1eb7c ph\u1ea1m vi c\u1ea7n so s\u00e1nh \u0111\u1ec3 t\u00ecm ra gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t.<\/p>\n

\"ham-max-cach-su-dung\"<\/picture><\/p>\n

V\u00ed d\u1ee5 c\u01a1 b\u1ea3n <\/strong><\/p>\n

T\u00ecm <\/strong>\u0111<\/strong>i\u1ec3m <\/strong>c<\/strong>ao <\/strong>n<\/strong>h\u1ea5t <\/strong>t<\/strong>rong <\/strong>l<\/strong>\u1edbp:<\/strong><\/p>\n

B\u01b0\u1edbc 1: Nh\u1eadp c\u00f4ng th\u1ee9c =MAX(C2:E6) v\u00e0o \u00f4 mong mu\u1ed1n. C2:E6 l\u00e0 ph\u1ea1m vi d\u1eef li\u1ec7u c\u1ea7n x\u00e9t.<\/p>\n

\"ham-max-cach-su-dung-1\"<\/picture><\/p>\n

B\u01b0\u1edbc 2: Nh\u1ea5n ENTER \u0111\u1ec3 xem k\u1ebft qu\u1ea3.<\/p>\n

\"ham-max-cach-su-dung-2\"<\/picture><\/p>\n

T\u00ecm \u0111i\u1ec3m cao nh\u1ea5t m\u00f4n Anh<\/strong><\/p>\n

B\u01b0\u1edbc 1: Nh\u1eadp =MAX(E2:E6) v\u00e0o \u00f4 d\u00e0nh cho k\u1ebft qu\u1ea3. E2:E6 l\u00e0 ph\u1ea1m vi d\u1eef li\u1ec7u m\u00f4n Anh.<\/p>\n

\"ham-max-cach-su-dung-3\"<\/picture><\/p>\n

B\u01b0\u1edbc 2: Nh\u1ea5n ENTER \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3.<\/p>\n

\"ham-max-cach-su-dung-4\"<\/picture><\/p>\n

M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m MAX<\/strong><\/p>\n