{"id":5508,"date":"2025-11-27T18:30:51","date_gmt":"2025-11-27T11:30:51","guid":{"rendered":"https:\/\/autofillform.com\/blog\/huong-dan-cach-su-dung-ham-value-trong-excel-chi-tiet-de-hieu\/"},"modified":"2025-11-27T18:30:51","modified_gmt":"2025-11-27T11:30:51","slug":"huong-dan-cach-su-dung-ham-value-trong-excel-chi-tiet-de-hieu","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/huong-dan-cach-su-dung-ham-value-trong-excel-chi-tiet-de-hieu\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VALUE trong Excel chi ti\u1ebft, d\u1ec5 hi\u1ec3u"},"content":{"rendered":"
\n
\u00a0<\/div>\n

H\u00e0m VALUE trong Excel gi\u00fap chuy\u1ec3n \u0111\u1ed5i chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh gi\u00e1 tr\u1ecb s\u1ed1, h\u1ed7 tr\u1ee3 trong vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u. D\u00f9 d\u1eef li\u1ec7u l\u00e0 s\u1ed1, th\u1eddi gian hay ng\u00e0y th\u00e1ng, h\u00e0m VALUE gi\u00fap Excel nh\u1eadn di\u1ec7n v\u00e0 chuy\u1ec3n \u0111\u1ed5i d\u1ec5 d\u00e0ng. C\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VALUE \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c trong b\u00e0i vi\u1ebft n\u00e0y.<\/p>\n

\"H\u01b0\u1edbngC\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VALUE trong Excel<\/em><\/p>\n

\n

1. C\u00f4ng th\u1ee9c h\u00e0m VALUE trong Excel<\/h2>\n<\/div>\n

C\u00fa ph\u00e1p: =VALUE(text)<\/strong><\/p>\n

Trong \u0111\u00f3:<\/p>\n

Text:<\/strong> V\u0103n ba\u0309n \u0111\u01b0\u01a1\u0323c \u0111\u0103\u0323t trong ngo\u0103\u0323c ke\u0301p ho\u0103\u0323c m\u00f4\u0323t tham chi\u00ea\u0301u \u0111\u00ea\u0301n m\u00f4\u0323t \u00f4 co\u0301 ch\u01b0\u0301a v\u0103n ba\u0309n ba\u0323n mu\u00f4\u0301n chuy\u00ea\u0309n \u0111\u00f4\u0309i.<\/p>\n

L\u01b0u \u00fd:<\/strong><\/p>\n

    \n
  • Text c\u00f3 th\u1ec3 l\u00e0 th\u1eddi gian, ng\u00e0y th\u00e1ng ho\u1eb7c m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1, mi\u1ec5n l\u00e0 Microsoft Excel c\u00f4ng nh\u1eadn n\u00f3.<\/li>\n
  • N\u1ebfu v\u0103n b\u1ea3n kh\u00f4ng n\u1eb1m trong \u0111\u1ecbnh d\u1ea1ng h\u1ee3p l\u1ec7, k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE.<\/li>\n
  • Th\u00f4ng th\u01b0\u1eddng, ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m VALUE v\u00ec Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n v\u0103n b\u1ea3n th\u00e0nh s\u1ed1.<\/li>\n
  • H\u00e0m VALUE \u0111\u01b0\u1ee3c cung c\u1ea5p \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh t\u01b0\u01a1ng th\u00edch v\u1edbi c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh b\u1ea3ng t\u00ednh kh\u00e1c.<\/li>\n<\/ul>\n

    \"C\u00f4ngC\u00fa ph\u00e1p h\u00e0m VALUE<\/em><\/p>\n

    \n

    2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VALUE trong Excel chuy\u1ec3n v\u0103n b\u1ea3n th\u00e0nh s\u1ed1<\/h2>\n<\/div>\n

    Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p s\u1eed d\u1ee5ng Excel, ch\u00fang ta c\u1ea7n chuy\u1ec3n \u0111\u1ed5i c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh gi\u00e1 tr\u1ecb s\u1ed1 \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n ho\u1eb7c truy xu\u1ea5t d\u1eef li\u1ec7u.<\/p>\n

    C\u00e1c c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y minh h\u1ecda c\u00e1ch chu\u1ed7i c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c chuy\u1ec3n th\u00e0nh s\u1ed1:<\/p>\n

      \n
    • =VALUE(“18,500”) s\u1ebd tr\u1ea3 v\u1ec1 18500: Chuy\u1ec3n \u0111\u1ed5i chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh gi\u00e1 tr\u1ecb s\u1ed1 t\u01b0\u01a1ng \u1ee9ng.<\/li>\n
    • =VALUE(“09:30”) s\u1ebd tr\u1ea3 v\u1ec1 0,395833333: Chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian 9 gi\u1edd 30 ph\u00fat th\u00e0nh gi\u00e1 tr\u1ecb th\u1eadp ph\u00e2n trong Excel.<\/li>\n
    • =VALUE(“3:15”)+VALUE(“1:45”) s\u1ebd tr\u1ea3 v\u1ec1 0.208333333: T\u1ed5ng th\u1eddi gian 5 gi\u1edd (3:15 + 1:45 = 5:00) \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1 th\u1eadp ph\u00e2n t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<\/ul>\n

      \"H\u00e0mV\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VALUE \u0111\u1ec3 chuy\u1ec3n gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n v\u1ec1 gi\u00e1 tr\u1ecb s\u1ed1<\/em><\/p>\n

      Xem th\u00eam: <\/strong>C\u00e1ch d\u00f9ng h\u00e0m FIND, FINDB trong Excel chi ti\u1ebft, d\u1ec5 hi\u1ec3u<\/div>\n
      \n

      3. H\u00e0m VALUE k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c<\/h2>\n<\/div>\n
      \n

      3.1 H\u00e0m VALUE k\u1ebft h\u1ee3p h\u00e0m RIGHT\/LEFT<\/h3>\n<\/div>\n

      C\u00fa ph\u00e1p:<\/p>\n

      =VALUE(RIGHT(A, n))<\/strong><\/p>\n

      =VALUE(LEFT(A, n))<\/strong><\/p>\n

      Gi\u1ea3i th\u00edch:<\/p>\n

        \n
      • A:<\/strong> L\u00e0 \u00f4 ch\u1ee9a chu\u1ed7i v\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1.<\/li>\n
      • n:<\/strong> L\u00e0 s\u1ed1 k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t t\u1eeb chu\u1ed7i v\u0103n b\u1ea3n.<\/li>\n<\/ul>\n

        V\u00ed d\u1ee5:<\/strong> Tri\u0301ch xu\u00e2\u0301t ky\u0301 t\u01b0\u0323 cu\u1ed1i trong m\u00f4\u0323t chu\u00f4\u0303i va\u0300 tra\u0309 v\u00ea\u0300 k\u00ea\u0301t qua\u0309 b\u0103\u0300ng s\u00f4\u0301<\/p>\n

        B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 k\u1ebft qu\u1ea3, nh\u1eadp c\u00f4ng th\u1ee9c =VALUE(RIGHT(A2,3))<\/strong> \u0111\u1ec3 tr\u00edch xu\u1ea5t 3 k\u00fd t\u1ef1 cu\u1ed1i t\u1eeb chu\u1ed7i trong \u00f4 A2.<\/p>\n

        B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 Excel th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3.<\/p>\n

        \"K\u1ebftV\u00ed d\u1ee5 k\u1ebft h\u1ee3p h\u00e0m VALUE v\u1edbi h\u00e0m RIGHT<\/em><\/p>\n

        \n

        3.2 H\u00e0m VALUE k\u1ebft h\u1ee3p h\u00e0m MID<\/h3>\n<\/div>\n

        C\u00fa ph\u00e1p: =VALUE(MID(A, t,n))<\/strong><\/p>\n

        Trong \u0111\u00f3:<\/p>\n

          \n
        • A:<\/strong> L\u00e0 \u00f4 ch\u1ee9a chu\u1ed7i v\u0103n b\u1ea3n b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1.<\/li>\n
        • t:<\/strong> V\u1ecb tr\u00ed k\u00fd t\u1ef1 b\u1eaft \u0111\u1ea7u t\u1eeb \u0111\u00f3 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t.<\/li>\n
        • n:<\/strong> S\u1ed1 k\u00fd t\u1ef1 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t t\u1eeb v\u1ecb tr\u00ed t.<\/li>\n<\/ul>\n

          V\u00ed d\u1ee5:<\/strong> Tr\u00edch xu\u1ea5t m\u1ed9t ph\u1ea7n chu\u1ed7i t\u1eeb gi\u1eefa v\u00e0 chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1<\/p>\n

          B\u01b0\u1edbc 1:<\/strong> Nh\u1eadp c\u00f4ng th\u1ee9c =VALUE(MID(A2, 3, 4))<\/strong> v\u00e0o \u00f4 k\u1ebft qu\u1ea3.<\/p>\n

          B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 t\u1eeb ph\u1ea7n chu\u1ed7i \u0111\u00e3 tr\u00edch xu\u1ea5t.<\/p>\n

          \"S\u1eedV\u00ed d\u1ee5 k\u1ebft h\u1ee3p h\u00e0m VALUE v\u1edbi h\u00e0m MID<\/em><\/p>\n

          V\u1edbi h\u00e0m VALUE, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng chuy\u1ec3n \u0111\u1ed5i chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh gi\u00e1 tr\u1ecb s\u1ed1 \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho c\u00e1c ph\u00e9p to\u00e1n trong Excel. \u0110i\u1ec1u n\u00e0y gi\u00fap c\u00f4ng vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u1edf n\u00ean nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n. \u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u th\u1ee7 thu\u1eadt h\u1eefu \u00edch!<\/p>\n

          N\u1ebfu b\u1ea1n \u0111ang c\u1ea7n mua m\u00e1y t\u00ednh b\u1ea3ng, \u0111i\u1ec7n tho\u1ea1i v\u1edbi ch\u1ea5t l\u01b0\u1ee3ng v\u01b0\u1ee3t tr\u1ed9i, h\u00e3y \u0111\u1ebfn ngay Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 t\u1eadn h\u01b0\u1edfng nh\u1eefng \u01b0u \u0111\u00e3i h\u1ea5p d\u1eabn.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

          \u00a0 H\u00e0m VALUE trong Excel gi\u00fap chuy\u1ec3n \u0111\u1ed5i chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh gi\u00e1 tr\u1ecb s\u1ed1, h\u1ed7 tr\u1ee3 trong vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u. D\u00f9 d\u1eef li\u1ec7u l\u00e0 s\u1ed1, th\u1eddi gian hay ng\u00e0y th\u00e1ng, h\u00e0m VALUE gi\u00fap Excel nh\u1eadn di\u1ec7n v\u00e0 chuy\u1ec3n \u0111\u1ed5i d\u1ec5 d\u00e0ng. C\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VALUE […]<\/p>\n","protected":false},"author":1,"featured_media":5509,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5508","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19483.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5508","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=5508"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5508\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5509"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}