{"id":24066,"date":"2021-05-07T13:52:38","date_gmt":"2021-05-07T06:52:38","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24066"},"modified":"2021-05-07T13:52:38","modified_gmt":"2021-05-07T06:52:38","slug":"ham-iferror","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-iferror\/","title":{"rendered":"H\u00e0m iferror v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u00ean Google Sheets"},"content":{"rendered":"

Google Sheets l\u00e0 c\u00f4ng c\u1ee5 b\u1ea3ng t\u00ednh mi\u1ec5n ph\u00ed v\u00e0 tr\u1ef1c tuy\u1ebfn, \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 Excel. Tuy nhi\u00ean trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p khi s\u1eed d\u1ee5ng Google Sheets, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1ebd g\u1eb7p ph\u1ea3i m\u1ed9t s\u1ed1 l\u1ed7i nh\u01b0 Value hay N\/A,\u2026. \u0110\u00e2y l\u00e0 l\u00fac ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m iferror<\/strong> \u0111\u1ec3 kh\u1eafc ph\u1ee5c, lo\u1ea1i b\u1ecf c\u00e1c l\u1ed7i Google Sheets n\u00e0y.<\/p>\n

Tham kh\u1ea3o ti\u1ebfp b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ben Computer \u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m iferror trong Google Sheets<\/strong> nh\u01b0 th\u1ebf n\u00e0o nh\u00e9.<\/p>\n

C\u00e1c l\u1ed7i c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p trong Google Sheets<\/strong><\/h2>\n

1. L\u1ed7i #VALUE!<\/strong><\/h3>\n

L\u1ed7i #VALUE! l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i ph\u1ed5 bi\u1ebfn th\u01b0\u1eddng hay g\u1eb7p nh\u1ea5t tr\u00ean Google Sheets c\u0169ng nh\u01b0 Excel. L\u1ed7i n\u00e0y x\u1ea3y ra trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng ki\u1ec3u d\u1eef li\u1ec7u kh\u00f4ng ch\u00ednh x\u00e1c cho c\u00e1c tham s\u1ed1 \u0111\u1ea7u v\u00e0o.<\/p>\n

\"L\u1ed7i
L\u1ed7i #VALUE!<\/figcaption><\/figure>\n

2. L\u1ed7i #REF!<\/strong><\/h3>\n

L\u1ed7i n\u00e0y x\u1ea3y ra khi ng\u01b0\u1eddi d\u00f9ng v\u00f4 t\u00ecnh x\u00f3a c\u00e1c h\u00e0ng, c\u1ed9t ho\u1eb7c b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 kh\u00e1c trong b\u1ea3ng t\u00ednh.<\/p>\n

\"L\u1ed7i
L\u1ed7i #REF!<\/figcaption><\/figure>\n

3. L\u1ed7i #NAME!<\/strong><\/h3>\n

Google Sheets hi\u1ec3n th\u1ecb l\u1ed7i n\u00e0y khi kh\u00f4ng th\u1ec3 nh\u1eadn d\u1ea1ng \u0111\u01b0\u1ee3c m\u1ed9t h\u00e0m Excel c\u1ee5 th\u1ec3 n\u00e0o \u0111\u00f3.<\/p>\n

\"L\u1ed7i
L\u1ed7i #NAME!<\/figcaption><\/figure>\n

4. L\u1ed7i #NUM!<\/strong><\/h3>\n

N\u1ebfu c\u00e1c tham s\u1ed1, \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u v\u00e0o kh\u00f4ng ph\u00f9 h\u1ee3p v\u1edbi nh\u1eefng c\u00e1c h\u00e0m Google Sheets \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng, l\u1ed7i #NUM! s\u1ebd hi\u1ec3n th\u1ecb.<\/p>\n

Gi\u1ea3 s\u1eed nh\u01b0 trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y ch\u00fang ta s\u1eed d\u1ee5ng tham s\u1ed1 l\u00e0 s\u1ed1 \u00e2m cho h\u00e0m SQRT, d\u1eabn \u0111\u1ebfn l\u1ed7i #NUM! x\u1ea3y ra.<\/p>\n

\"L\u1ed7i
L\u1ed7i #NUM!<\/figcaption><\/figure>\n

Ngo\u00e0i ra l\u1ed7i n\u00e0y c\u0169ng xu\u1ea5t hi\u1ec7n khi gi\u00e1 tr\u1ecb n\u1eb1m ngo\u00e0i ph\u1ea1m vi cho tr\u01b0\u1edbc.<\/p>\n

H\u00e0m iferror v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u00ean Google Sheets<\/strong><\/h2>\n

H\u00e0m iferror<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c l\u1ed7i tr\u00ean b\u1ea3ng t\u00ednh Google Sheets. Gi\u1ea3 s\u1eed n\u1ebfu \u0111ang s\u1eed d\u1ee5ng h\u00e0m Google Sheets n\u00e0o \u0111\u00f3 v\u00e0 h\u00e0m li\u00ean t\u1ee5c tr\u1ea3 v\u1ec1 l\u1ed7i. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m iferror<\/strong> \u0111\u1ec3 \u201cb\u1eaby\u201d v\u00e0 x\u1eed l\u00fd c\u00e1c l\u1ed7i, \u0111\u1ec3 b\u1ea3ng t\u00ednh tr\u00f4ng g\u1ecdn g\u00e0ng v\u00e0 d\u1ec5 \u0111\u1ecdc h\u01a1n. H\u00e0m n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00f9ng nhi\u1ec1u h\u00e0m Google Sheets kh\u00e1c nh\u01b0 h\u00e0m Query v\u00e0 Vlookup.<\/p>\n

H\u00e0m iferror<\/strong> ho\u1ea1t \u0111\u1ed9ng b\u1eb1ng c\u00e1ch qu\u00e9t m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 \u0111\u1ec3 t\u00ecm c\u00e1c l\u1ed7i. N\u1ebfu ph\u00e1t hi\u1ec7n c\u00f3 l\u1ed7i x\u1ea3y ra, h\u00e0m s\u1ebd thay th\u1ebf gi\u00e1 tr\u1ecb c\u00e1c \u00f4 ch\u1ee9a l\u1ed7i l\u00e0 gi\u00e1 tr\u1ecb tr\u1ed1ng. N\u1ebfu kh\u00f4ng, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb ban \u0111\u1ea7u.<\/p>\n

C\u00fa ph\u00e1p h\u00e0m iferror trong Google Sheets<\/strong><\/h3>\n

H\u00e0m iferror trong Google Sheets<\/strong> c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=IFERROR(value, [value_if_error])<\/strong><\/p><\/blockquote>\n

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

\u2013 Value:<\/strong>\u00a0l\u00e0 tham s\u1ed1 m\u00e0 h\u00e0m iferror ki\u1ec3m tra l\u1ed7i. Tham s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 l\u00e0 c\u00f4ng th\u1ee9c ho\u1eb7c tham chi\u1ebfu \u00f4 b\u1ea5t k\u1ef3.<\/p>\n

\u2013 value_if_error:<\/strong>\u00a0\u0111\u00e2y l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 h\u00e0m tr\u1ea3 v\u1ec1 n\u1ebfu ph\u00e1t hi\u1ec7n c\u00f3 l\u1ed7i. Gi\u00e1 tr\u1ecb n\u00e0y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1 ho\u1eb7c chu\u1ed7i v\u0103n b\u1ea3n.<\/p>\n

Tham s\u1ed1 n\u00e0y l\u00e0 t\u00f9y ch\u1ecdn, c\u00f3 th\u1ec3 c\u00f3 ho\u1eb7c kh\u00f4ng. N\u1ebfu ch\u00fang ta kh\u00f4ng ch\u1ec9 \u0111\u1ecbnh \u0111i\u1ec1u g\u00ec, h\u00e0m iferror s\u1ebd tr\u1ea3 v\u1ec1 \u00f4 tr\u1ed1ng n\u1ebfu c\u00f3 l\u1ed7i x\u1ea3y ra.<\/p>\n

V\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m iferror<\/strong><\/h3>\n

Ch\u00fang ta c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u1ea1o c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu c\u00f3 c\u00f4ng th\u1ee9c, h\u00e0m Google Sheets n\u00e0o \u0111\u00f3 tr\u1ea3 v\u1ec1 l\u1ed7i. Ch\u1eb3ng h\u1ea1n n\u1ebfu c\u00f3 l\u1ed7i x\u1ea3y ra th\u00ec \u0111\u1ec3 gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 tr\u1ed1ng ho\u1eb7c gi\u00e1 tr\u1ecb l\u00e0 0.<\/p>\n

Gi\u1ea3 s\u1eed n\u1ebfu c\u00f4ng th\u1ee9c, h\u00e0m n\u00e0o \u0111\u00f3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb l\u1ed7i, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m iferror \u0111\u1ec3 b\u1ecdc c\u00f4ng th\u1ee9c g\u00e2y l\u1ed7i v\u00e0 h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 v\u0103n b\u1ea3n c\u00f3 ngh\u0129a ho\u1eb7c gi\u00e1 tr\u1ecb tr\u1ed1ng.<\/p>\n

Cho v\u00ed d\u1ee5, trong b\u1ea3ng d\u1eef li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y ph\u00e9p t\u00ednh trong c\u1ed9t C tr\u1ea3 v\u1ec1 l\u1ed7i n\u1ebfu gi\u00e1 tr\u1ecb s\u1ed1 l\u00e0 0 ho\u1eb7c tr\u1ed1ng:<\/p>\n

\"V\u00ed
V\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m iferror – \u1ea2nh 1<\/figcaption><\/figure>\n

Tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m iferror c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 \u00f4 tr\u1ed1ng thay v\u00ec th\u00f4ng b\u00e1o l\u1ed7i:<\/p>\n

=IFERROR(A2\/B2,\u201d\u201d)<\/strong><\/p>\n

\"V\u00ed
V\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m iferror – \u1ea2nh 2<\/figcaption><\/figure>\n

Ngo\u00e0i ra trong tr\u01b0\u1eddng h\u1ee3p tr\u00ean ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng v\u0103n b\u1ea3n c\u00f3 ngh\u0129a l\u00e0m k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 thay v\u00ec \u00f4 tr\u1ed1ng.<\/p>\n

Cho v\u00ed d\u1ee5, c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 v\u0103n b\u1ea3n c\u00f3 ngh\u0129a: \u201cError\u201d:<\/p>\n

=IFERROR(A2\/B2,\u201dError\u201d)<\/strong><\/p>\n

\"V\u00ed
V\u00ed d\u1ee5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m iferror – \u1ea2nh 3<\/figcaption><\/figure>\n

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

1.<\/strong> N\u1ebfu b\u1ecf qua tham s\u1ed1 \u201cvalue_if_error\u201d<\/strong>, \u00f4 trong b\u1ea3ng t\u00ednh s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb g\u00ec trong tr\u01b0\u1eddng h\u1ee3p n\u1ebfu c\u00f3 l\u1ed7i x\u1ea3y ra (hay \u00f4 tr\u1ed1ng).<\/p>\n

2.<\/strong> N\u1ebfu tham s\u1ed1 value l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng, h\u00e0m iferror s\u1ebd tr\u1ea3 v\u1ec1 m\u1ea3ng k\u1ebft qu\u1ea3 cho m\u1ed7i m\u1ee5c trong ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong value.<\/p>\n

Tr\u00ean \u0111\u00e2y l\u00e0 chi ti\u1ebft h\u00e0m iferror<\/strong> v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m tr\u00ean Google Sheets. Ngo\u00e0i ra n\u1ebfu c\u00f2n th\u1eafc m\u1eafc ho\u1eb7c c\u00e2u h\u1ecfi n\u00e0o c\u1ea7n gi\u1ea3i \u0111\u00e1p, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 \u0111\u1ec3 l\u1ea1i \u00fd ki\u1ebfn c\u1ee7a m\u00ecnh trong ph\u1ea7n b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi b\u00e0i vi\u1ebft nh\u00e9.
\n\u0110\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Left trong Google Sheets<\/a> nh\u01b0 th\u1ebf n\u00e0o, 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 Ben Computer nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"

Google Sheets l\u00e0 c\u00f4ng c\u1ee5 b\u1ea3ng t\u00ednh mi\u1ec5n ph\u00ed v\u00e0 tr\u1ef1c tuy\u1ebfn, \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 Excel. Tuy nhi\u00ean trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p khi s\u1eed d\u1ee5ng Google Sheets, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1ebd g\u1eb7p ph\u1ea3i m\u1ed9t s\u1ed1 l\u1ed7i nh\u01b0 Value hay N\/A,\u2026. \u0110\u00e2y l\u00e0 l\u00fac ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m iferror […]<\/p>\n","protected":false},"author":39,"featured_media":24067,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24066","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\/24066","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=24066"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24066\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24067"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}