{"id":24334,"date":"2021-05-10T17:18:27","date_gmt":"2021-05-10T10:18:27","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24334"},"modified":"2021-05-10T17:18:27","modified_gmt":"2021-05-10T10:18:27","slug":"ham-max-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-max-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng H\u00e0m Max trong Excel qua v\u00ed d\u1ee5 b\u00e0i t\u1eadp"},"content":{"rendered":"

H\u00e0m Max trong Excel<\/strong> \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m th\u1ed1ng k\u00ea. H\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t c\u1ee7a m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u c\u1ee5 th\u1ec3. Kh\u00e1c v\u1edbi h\u00e0m MAXA, h\u00e0m MAX s\u1ebd \u0111\u1ebfm s\u1ed1 nh\u01b0ng b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng, \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb l\u00e0 v\u0103n b\u1ea3n, ho\u1eb7c c\u00e1c gi\u00e1 tr\u1ecb logic TRUE v\u00e0 FALSE.<\/p>\n

H\u00e0m Max trong Excel<\/strong><\/h2>\n

Nh\u01b0 Ben Computer \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf tr\u00ean, h\u00e0m Max trong Excel<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong t\u1eadp, chu\u1ed7i gi\u00e1 tr\u1ecb. Ng\u01b0\u1ee3c l\u1ea1i \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong t\u1eadp gi\u00e1 tr\u1ecb, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m Min.<\/p>\n

\"H\u00e0m
H\u00e0m Max trong Excel<\/figcaption><\/figure>\n

C\u00fa ph\u00e1p h\u00e0m Max trong Excel<\/strong><\/h3>\n

C\u00f4ng th\u1ee9c, c\u00fa ph\u00e1p h\u00e0m Max trong Excel<\/strong> c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=MAX(number1, [number2], \u2026)<\/strong><\/p><\/blockquote>\n

Trong \u0111\u00f3:\u00a0Number1<\/strong>\u00a0v\u00e0\u00a0Number2<\/strong>\u00a0l\u00e0 c\u00e1c \u0111\u1ed1i s\u1ed1 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u c\u1ee7a h\u00e0m Max. Tham s\u1ed1 Number1 l\u00e0 b\u1eaft bu\u1ed9c, tham s\u1ed1 Number2 l\u00e0 t\u00f9y ch\u1ecdn.<\/p>\n

Trong Excel 2007 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n cao h\u01a1n, h\u00e0m Max ch\u1ea5p nh\u1eadn t\u1ed1i \u0111a 255 \u0111\u1ed1i s\u1ed1. Tr\u00ean c\u00e1c phi\u00ean b\u1ea3n Excel c\u0169 h\u01a1n, bao g\u1ed3m Excel 2003 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n c\u0169 h\u01a1n, h\u00e0m Max ch\u1ec9 c\u00f3 th\u1ec3 ch\u1ea5p nh\u1eadn t\u1ed1i \u0111a 30 \u0111\u1ed1i s\u1ed1 s\u1ed1.<\/p>\n

C\u00e1c tham s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c cung c\u1ea5p d\u01b0\u1edbi d\u1ea1ng h\u1eb1ng s\u1ed1 ho\u1eb7c tham chi\u1ebfu \u00f4, v\u00f9ng d\u1eef li\u1ec7u. N\u1ebfu c\u00e1c tham s\u1ed1 n\u00e0y l\u00e0 tham chi\u1ebfu \u00f4 ho\u1eb7c m\u1ea3ng \u00f4 th\u00ec h\u00e0m Max b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng v\u00e0 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, gi\u00e1 tr\u1ecb logic trong ph\u1ea1m vi c\u00e1c \u00f4 \u0111\u01b0\u1ee3c cung c\u1ea5p.<\/p>\n

H\u00e0m Max c\u00f3 s\u1eb5n trong phi\u00ean b\u1ea3n Excel n\u00e0o?<\/strong><\/h3>\n

H\u00e0m Max c\u00f3 s\u1eb5n trong c\u00e1c phi\u00ean b\u1ea3n Excel bao g\u1ed3m: Excel cho Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 cho Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000.<\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Max trong Excel<\/strong><\/h3>\n

L\u00e0m m\u1ed9t h\u00e0m trang t\u00ednh, h\u00e0m Max c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 m\u1ed9t ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c trong \u00f4 b\u1ea3ng t\u00ednh. \u0110\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Max trong Excel, ch\u00fang ta xem qua m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

Cho b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y, nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 t\u00ednh s\u1ed1 \u0111i\u1ec3m, gi\u00e1 tr\u1ecb cao nh\u1ea5t trong b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y:<\/p>\n

\"C\u00e1ch
C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Max trong Excel – \u1ea2nh 1<\/figcaption><\/figure>\n

C\u00f4ng th\u1ee9c h\u00e0m Max \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u00f3 d\u1ea1ng:<\/p>\n

\"C\u00e1ch
C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Max trong Excel – \u1ea2nh 2<\/figcaption><\/figure>\n

Trong c\u00f4ng th\u1ee9c tr\u00ean, h\u00e0m Max Excel b\u1ecf qua gi\u00e1 tr\u1ecb tr\u1ed1ng v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 100.<\/p>\n

\"C\u00e1ch
C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Max trong Excel – \u1ea2nh 3<\/figcaption><\/figure>\n

T\u01b0\u01a1ng t\u1ef1, trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y h\u00e0m Max b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb logic v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n

\"C\u00e1ch
C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Max trong Excel – \u1ea2nh 4<\/figcaption><\/figure>\n
\"C\u00e1ch
C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Max trong Excel – \u1ea2nh 5<\/figcaption><\/figure>\n

M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Max trong Excel<\/strong><\/h3>\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng khi s\u1eed d\u1ee5ng h\u00e0m Max \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong chu\u1ed7i gi\u00e1 tr\u1ecb c\u0169ng nh\u01b0 m\u1ed9t s\u1ed1 l\u1ed7i ph\u1ed5 bi\u1ebfn m\u00e0 ng\u01b0\u1eddi d\u00f9ng hay g\u1eb7p ph\u1ea3i khi s\u1eed d\u1ee5ng h\u00e0m Excel n\u00e0y:<\/p>\n

    \n
  1. H\u00e0m Max Excel tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE! n\u1ebfu tham s\u1ed1 \u0111\u01b0\u1ee3c cung c\u1ea5p cho h\u00e0m kh\u00f4ng ph\u1ea3i gi\u00e1 tr\u1ecb s\u1ed1.<\/li>\n
  2. N\u1ebfu c\u00e1c \u0111\u1ed1i s\u1ed1 kh\u00f4ng ch\u1ee9a s\u1ed1, h\u00e0m Max tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 0.<\/li>\n
  3. \u0110i\u1ec3m kh\u00e1c bi\u1ec7t l\u1edbn nh\u1ea5t gi\u1eefa h\u00e0m MAX v\u00e0 MAXA l\u00e0 h\u00e0m MAXA \u0111\u00e1nh gi\u00e1 c\u00e1c gi\u00e1 tr\u1ecb TRUE v\u00e0 FALSE l\u1ea7n l\u01b0\u1ee3t l\u00e0 1 v\u00e0 0. V\u00ec v\u1eady n\u1ebfu b\u1ea3ng t\u00ednh ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb logic ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m MAXA.<\/li>\n
  4. H\u00e0m Max b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng, kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb n\u00e0o.<\/li>\n
  5. H\u00e0m Max tr\u00ean Excel 2010 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n m\u1edbi h\u01a1n ch\u1ea5p nh\u1eadn t\u1ed1i \u0111a 255 \u0111\u1ed1i s\u1ed1.<\/li>\n
  6. C\u00e1c \u0111\u1ed1i s\u1ed1 h\u00e0m Max c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c cung c\u1ea5p d\u01b0\u1edbi d\u1ea1ng s\u1ed1, t\u00ean, m\u1ea3ng ho\u1eb7c tham chi\u1ebfu c\u00f3 ch\u1ee9a s\u1ed1.<\/li>\n<\/ol>\n

    B\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y Ben Computer v\u1eeba gi\u1edbi thi\u1ec7u cho b\u1ea1n v\u1ec1 h\u00e0m Max trong Excel<\/strong> v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng, c\u00fa ph\u00e1p c\u0169ng nh\u01b0 c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m Excel n\u00e0y. Hy v\u1ecdng v\u1edbi nh\u1eefng th\u00f4ng tin m\u00e0 Ben v\u1eeba gi\u1edbi thi\u1ec7u tr\u00ean \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 \u0111\u01b0\u1ee3c h\u00e0m Max Excel d\u1ec5 d\u00e0ng h\u01a1n.<\/p>\n

    Ngo\u00e0i ra b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean trang \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ea5y k\u00fd t\u1ef1 b\u1ea5t k\u1ef3 trong Excel<\/a> nh\u01b0 th\u1ebf n\u00e0o nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"

    H\u00e0m Max trong Excel \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m th\u1ed1ng k\u00ea. H\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t c\u1ee7a m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u c\u1ee5 th\u1ec3. Kh\u00e1c v\u1edbi h\u00e0m MAXA, h\u00e0m MAX s\u1ebd \u0111\u1ebfm s\u1ed1 nh\u01b0ng b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng, \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb l\u00e0 v\u0103n b\u1ea3n, ho\u1eb7c c\u00e1c gi\u00e1 tr\u1ecb […]<\/p>\n","protected":false},"author":39,"featured_media":24335,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24334","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24334","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=24334"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24334\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24335"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}