{"id":23924,"date":"2021-05-05T10:54:03","date_gmt":"2021-05-05T03:54:03","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=23924"},"modified":"2021-05-05T11:00:00","modified_gmt":"2021-05-05T04:00:00","slug":"ham-value-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-value-trong-excel\/","title":{"rendered":"Gi\u1edbi thi\u1ec7u H\u00e0m Value trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng"},"content":{"rendered":"

H\u00e0m VALUE \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i l\u00e0 h\u00e0m text (v\u0103n b\u1ea3n) trong Excel. H\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 chuy\u1ec3n chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh gi\u00e1 tr\u1ecb s\u1ed1. Tuy nhi\u00ean trong ph\u00e2n t\u00edch t\u00e0i ch\u00ednh, h\u00e0m VALUE kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u v\u00ec Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n \u0111\u1ed5i v\u0103n b\u1ea3n sang gi\u00e1 tr\u1ecb s\u1ed1. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y Ben Computer s\u1ebd gi\u1edbi thi\u1ec7u chi ti\u1ebft cho b\u1ea1n h\u00e0m Value trong Excel<\/strong> v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng.<\/p>\n

C\u00f4ng th\u1ee9c h\u00e0m Value trong Excel<\/strong><\/h2>\n

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

=VALUE(Text)<\/strong><\/p>\n

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

Text<\/strong>\u00a0(v\u0103n b\u1ea3n) l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c, l\u00e0 chu\u1ed7i s\u1ed1 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p, tham chi\u1ebfu \u0111\u1ebfn \u00f4 c\u00f3 ch\u1ee9a v\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i. N\u1ebfu gi\u00e1 tr\u1ecb tham s\u1ed1 text kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1, h\u00e0m Value s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!.<\/p>\n

\"H\u00e0m<\/p>\n

H\u00e0m Value c\u00f3 trong phi\u00ean b\u1ea3n Excel n\u00e0o?<\/strong><\/h2>\n

H\u00e0m Value c\u00f3 s\u1eb5n tr\u00ean 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

H\u00e0m Value trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/strong><\/h2>\n

H\u00e0m Value c\u00f3 s\u1eb5n tr\u00ean h\u1ea7u h\u1ebft c\u00e1c phi\u00ean b\u1ea3n Excel, bao g\u1ed3m c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n m\u1edbi h\u01a1n. \u0110\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Excel n\u00e0y nh\u01b0 th\u1ebf n\u00e0o, ch\u00fang ta s\u1ebd c\u00f9ng xem qua m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y nh\u00e9:<\/p>\n

V\u00ed d\u1ee5 1:<\/strong><\/p>\n

Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m Value \u0111\u1ec3 chuy\u1ec3n chu\u1ed7i v\u0103n b\u1ea3n sang \u0111\u1ecbnh d\u1ea1ng s\u1ed1:<\/p>\n

\"1<\/p>\n

K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

\"2<\/p>\n

V\u00ed d\u1ee5 2:<\/strong><\/p>\n

Trong v\u00ed d\u1ee5 n\u00e0y, gi\u1ea3 s\u1eed ch\u00fang ta mu\u1ed1n t\u00ednh s\u1ed1 \u0111i\u1ec3m ph\u1ea1t nh\u00e2n vi\u00ean \u0111i mu\u1ed9n h\u00e0ng ng\u00e0y trong c\u00f4ng ty. \u0110\u1ec3 g\u00e1n \u0111i\u1ec3m ph\u1ea1t d\u1ef1a tr\u00ean s\u1ed1 ph\u00fat, th\u1eddi gian \u0111i mu\u1ed9n, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m IF l\u1ed3ng nhau.<\/p>\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 chi ti\u1ebft d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c cung c\u1ea5p:<\/p>\n

\"3<\/p>\n

C\u00fa ph\u00e1p, c\u00f4ng th\u1ee9c h\u00e0m IF l\u1ed3ng nhau c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

\"4<\/p>\n

K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

\"5<\/p>\n

Trong v\u00ed d\u1ee5 tr\u00ean, c\u00f4ng th\u1ee9c h\u00e0m Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 ki\u1ec3m tra xem th\u1eddi gian trong \u00f4 D5 c\u00f3 ph\u1ea3i l\u00e0 0 hay kh\u00f4ng, sau \u0111\u00f3 ch\u1ec9 \u0111\u1ecbnh v\u00e0 g\u00e1n \u0111i\u1ec3m l\u00e0 0. N\u1ebfu k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 FALSE, c\u00f4ng th\u1ee9c Excel s\u1ebd ki\u1ec3m tra xem li\u1ec7u gi\u00e1 tr\u1ecb \u00f4 C3 c\u00f3 nh\u1ecf h\u01a1n ng\u01b0\u1ee1ng ti\u1ebfp theo hay kh\u00f4ng, hay c\u00f3 \u00edt h\u01a1n 5 ph\u00fat kh\u00f4ng v\u00e0 g\u00e1n gi\u00e1 tr\u1ecb l\u00e0 1. S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m Excel t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c \u00f4 ti\u1ebfp theo tr\u00ean b\u1ea3ng t\u00ednh.<\/p>\n

H\u00e0m Value \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 Excel coi gi\u00e1 tr\u1ecb th\u1eddi gian \u1edf m\u1ed7i \u00f4 b\u1ea3ng t\u00ednh l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1.<\/p>\n

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