{"id":1922,"date":"2017-05-06T18:37:06","date_gmt":"2017-05-06T11:37:06","guid":{"rendered":"https:\/\/engisv.info\/?p=1922"},"modified":"2018-08-23T11:15:58","modified_gmt":"2018-08-23T04:15:58","slug":"ham-excel-cac-ham-luan-ly-ham-dieu-kien-va-cac-phep-toan-phep-sanh","status":"publish","type":"post","link":"https:\/\/www.engisv.info\/?p=1922","title":{"rendered":"H\u00e0m Excel &#8211;  C\u00e1c  h\u00e0m lu\u1eadn l\u00fd, h\u00e0m \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1c ph\u00e9p to\u00e1n, ph\u00e9p so s\u00e1nh"},"content":{"rendered":"<p>Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi c\u00e1c h\u00e0m to\u00e1n h\u1ecdc ABS, INT, MOD, \u00a0PRODUCT, \u00a0ROUND, SQRT, SUM, SUMIF h\u00e0m logic \u00a0AND, OR, NOT v\u00e0 h\u00e0m \u0111i\u1ec1u ki\u1ec7n IF. C\u00e1c h\u00e0m n\u00e0y r\u1ea5t th\u00f4ng d\u1ee5ng trong vi\u1ec7c x\u1eed l\u00fd c\u00e1c b\u00e0i to\u00e1n Excel. Trong qu\u00e1 tr\u00ecnh t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c h\u00e0m, ta s\u1ebd k\u1ebft h\u1ee3p t\u00ecm hi\u1ec3u v\u1edbi c\u00e1c ph\u00e9p to\u00e1n g\u1ed3m c\u1ed9ng (+) , tr\u1eeb (-), nh\u00e2n (*) , chia (\/), c\u00e1c ph\u00e9p so s\u00e1nh g\u1ed3m l\u1edbn h\u01a1n (&gt;), b\u00e9 h\u01a1n (&lt;), l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng (&gt;=), b\u00e9 h\u01a1n ho\u1eb7c h\u1eb1ng (&lt;=), kh\u00e1c (&lt;&gt;), b\u1eb1ng nhau (=) \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u v\u00e0 \u0111\u01b0a ra k\u1ebft qu\u1ea3.<\/p>\n<p><strong>H\u00e0m IF: D\u00f9ng \u00a0\u0111\u1ec3 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai.<\/strong><\/p>\n<p>=IF (logical_test, value_if_true, [value_if_false])<\/p>\n<p>Ng\u01b0\u1eddi ta c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m IF l\u1ed3ng v\u00e0o nhau \u0111\u1ec3 xu\u1ea5t ra k\u1ebft qu\u1ea3 theo nhi\u1ec1u d\u1eef li\u1ec7u kh\u00e1c nhau:<\/p>\n<p>=IF (logical_test1, value_if_true1,IF (logical_test2, value_if_true2, [value_if_false2]))<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<ul>\n<li>N\u1ebfu H\u00c0NG TRONG KHO\u00a0b\u1eb1ng 0, tr\u1ea3 ra k\u1ebft qu\u1ea3 &#8220;h\u1ebft h\u00e0ng&#8221;.<\/li>\n<li>N\u1ebfu H\u00c0NG TRONG KHO \u00edt h\u01a1n T\u1ed2N KHO T\u1ed0I THI\u1ec2U th\u00ec tr\u1ea3 ra &#8220;Nh\u1eadp th\u00eam&#8221;.<\/li>\n<li>Ngo\u00e0i hai tr\u01b0\u1eddng h\u1ee3p n\u00e0y th\u00ec tr\u1ea3 ra &#8220;Ch\u01b0a c\u1ea7n nh\u1eadp&#8221;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1967 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/ham-if.png\" alt=\"\" width=\"734\" height=\"231\" \/><\/p>\n<p><strong>H\u00e0m OR: h\u00e0m tr\u1ea3 v\u1ec1 TRUE n\u1ebfu b\u1ea5t k\u1ef3 \u0111\u1ed1i s\u1ed1 c\u1ee7a n\u00f3 \u0111\u00e1nh gi\u00e1 l\u00e0 TRUE, v\u00e0 tr\u1ea3 v\u1ec1 FALSE n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i s\u1ed1 \u0111\u1ecbnh tr\u1ecb l\u00e0 FALSE.<\/strong><\/p>\n<p>=OR(logical1, logical2, \u2026)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1973 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/or1-300x171.png\" alt=\"\" width=\"300\" height=\"171\" \/><\/p>\n<p>V\u00ed d\u1ee5: Tr\u1ea3 ra th\u00f4ng tin T\u00ccNH TR\u1ea0NG H\u00c0NG THEO Y\u00caU C\u1ea6U XU\u1ea4T KHO:<\/p>\n<ul>\n<li>N\u1ebfu Y\u00caU C\u1ea6U XU\u1ea4T KHO l\u1edbn h\u01a1n H\u00c0NG TRONG KHO ho\u1eb7c H\u00c0NG TRONG KHO b\u1eb1ng 0 th\u00ec tr\u1ea3 ra &#8220;Thi\u1ebfu h\u00e0ng&#8221;.<\/li>\n<li>N\u1ebfu kh\u00f4ng n\u1eb1m trong 1 trong hai tr\u01b0\u1eddng h\u1ee3p tr\u00ean th\u00ec tr\u1ea3 ra &#8220;\u0110\u1ee7 H\u00e0ng&#8221;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1968 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/OR.png\" alt=\"\" width=\"811\" height=\"251\" \/><\/p>\n<p><strong>H\u00e0m AND:\u00a0tr\u1ea3 v\u1ec1 TRUE n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i s\u1ed1 \u0111\u1ecbnh tr\u1ecb l\u00e0 TRUE, v\u00e0 tr\u1ea3 v\u1ec1 FALSE n\u1ebfu m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111\u1ed1i s\u1ed1 \u0111\u1ecbnh tr\u1ecb l\u00e0 FALSE.<\/strong><\/p>\n<p>=AND(logical1, logical2, \u2026)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1975 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/and1.png\" alt=\"\" width=\"364\" height=\"182\" \/><\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p>Tr\u1ea3 ra T\u00ccNH TR\u1ea0NG XU\u1ea4T KHO THEO C\u00c1C Y\u00caU C\u1ea6U l\u00e0 &#8220;xu\u1ea5t kho&#8221; n\u1ebfu:<\/p>\n<ul>\n<li>Y\u00caU C\u1ea6U XU\u1ea4T KHO nh\u1ecf h\u01a1n H\u00c0NG TRONG KHO<\/li>\n<li>V\u00e0 Y\u00caU C\u1ea6U XU\u1ea4T KHO ph\u1ea3i l\u1edbn h\u01a1n 0<\/li>\n<li>V\u00e0 H\u1ea2NG TRONG KHO ph\u1ea3i nhi\u1ec1u h\u01a1n T\u1ed2N KHO T\u1ed0I THI\u1ec2U.<\/li>\n<\/ul>\n<p>Ng\u01b0\u1ee3c l\u1ea1i th\u00ec &#8220;Kh\u00f4ng xu\u1ea5t kho&#8221;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1969 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/AND.png\" alt=\"\" width=\"791\" height=\"197\" \/><\/p>\n<p><strong>H\u00e0m NOT:\u00a0\u0111\u1ea3o ng\u01b0\u1ee3c l\u1ea1i gi\u00e1 tr\u1ecb c\u1ee7a \u0111\u1ed1i s\u1ed1 c\u1ee7a n\u00f3. N\u1ebfu \u0111i\u1ec1u ki\u1ec7n l\u00e0 TRUE th\u00ec tr\u1ea3 v\u1ec1 FALSE, n\u1ebfu \u0111i\u1ec1u ki\u1ec7n l\u00e0 FALSE th\u00ec tr\u1ea3 v\u1ec1 l\u00e0 TRUE.<\/strong><\/p>\n<p>=NOT(logical)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1976 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/not-1.png\" alt=\"\" width=\"334\" height=\"142\" \/><\/p>\n<p>V\u00ed d\u1ee5: N\u1ebfu H\u00c0NG TRONG KHO kh\u00f4ng l\u1edbn h\u01a1n T\u1ed2N KHO T\u1ed0I THI\u1ec2U (ngh\u0129a l\u00e0 H\u00c0NG TRONG KHO nh\u1ecf h\u01a1n T\u1ed2N KHO T\u1ed0I THI\u1ec2U) th\u00ec t\u1ea3 v\u1ec1 &#8220;C\u1ea7n nh\u1eadp th\u00eam&#8221; ng\u01b0\u1ee3c l\u1ea1i th\u00ec tr\u1ea3 v\u1ec1 &#8220;Ch\u01b0a c\u1ea7n nh\u1eadp th\u00eam&#8221;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1977 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/NOT.png\" alt=\"\" width=\"794\" height=\"300\" \/><\/p>\n<p>C\u00e1c h\u00e0m to\u00e1n h\u1ecdc<\/p>\n<p><strong>H\u00e0m ABS:\u00a0Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i c\u1ee7a m\u1ed9t s\u1ed1. Gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i c\u1ee7a m\u1ed9t s\u1ed1 l\u00e0 s\u1ed1 \u0111\u00f3 kh\u00f4ng c\u00f3 d\u1ea5u.<\/strong><\/p>\n<p>=ABS(number)<\/p>\n<p>V\u00ed d\u1ee5: T\u00ednh S\u1ed0 H\u00c0NG C\u00d2N THI\u1ebeU SO V\u1edaI \u0110\u01a0N H\u00c0NG\u00a0n\u1ebfu Y\u00caU C\u1ea6U XU\u1ea4T KHO l\u1edbn h\u01a1n H\u00c0NG TRONG KHO. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, th\u1ef1c hi\u1ec7n ph\u00e9p tr\u1eeb s\u1ebd ra s\u1ed1 \u00e2m, v\u00ec v\u1eady ta c\u1ea7n l\u1ea5y gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1981 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/ABS.png\" alt=\"\" width=\"537\" height=\"262\" \/><\/p>\n<p><strong>H\u00e0m SUM: \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong m\u1ed9t pha\u0323m vi. H\u00e0m SUM c\u00f3 th\u1ec3 d\u00f9ng t\u00ednh t\u1ed5ng m\u1ed9t v\u00f9ng, nhi\u1ec1u v\u00f9ng ho\u1eb7c c\u00e1c \u00f4 \u0111\u1ecba ch\u1ec9 ri\u00eang l\u1ebb.<\/strong><\/p>\n<p>=SUM(number1, number2, &#8230;)<\/p>\n<p>V\u00ed d\u1ee5: T\u00ednh t\u1ed5ng TH\u00c0NH TI\u1ec0N THEO Y\u00caU C\u1ea6U XU\u1ea4T KHO (bi\u1ebft th\u00e0nh ti\u1ec1n b\u1eb1ng \u0110\u01a0N GI\u00c1 VND*Y\u00caU C\u1ea6U XU\u1ea4T KHO).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1983 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/sum.png\" alt=\"\" width=\"698\" height=\"271\" \/><\/p>\n<p>V\u00ec d\u1ee5 v\u1ec1 t\u00ednh t\u1ed5ng tr\u00ean c\u00e1c v\u00f9ng v\u00e0 \u00f4 ch\u1ecdn ri\u00eang l\u1ebb:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1987 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/sum01.png\" alt=\"\" width=\"678\" height=\"294\" \/><\/p>\n<p>H\u00e0m SUMIF:\u00a0T\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/p>\n<p>SUMIF(range, criteria [, sum_range])<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1984 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/SUMIF-1.png\" alt=\"\" width=\"747\" height=\"267\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1985 size-full aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/SUMIF2.png\" alt=\"\" width=\"767\" height=\"287\" \/><\/p>\n<p><strong>H\u00e0m\u00a0SQRT: l\u1ea5y c\u0103n b\u1eadc hai c\u1ee7a m\u1ed9t s\u1ed1.<\/strong><\/p>\n<p>=SQRT(number)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1989 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/sqrt.png\" alt=\"\" width=\"188\" height=\"156\" \/><\/p>\n<p><strong>H\u00e0m INT: L\u00e0m tr\u00f2n s\u1ed1 xu\u1ed1ng t\u1edbi s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t.<\/strong><\/p>\n<p>=INT(number)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1991 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/int.png\" alt=\"\" width=\"178\" height=\"148\" \/><\/p>\n<p><strong>Ha\u0300m ROUND: la\u0300m tro\u0300n m\u00f4\u0323t s\u00f4\u0301 t\u01a1\u0301i m\u00f4\u0323t s\u00f4\u0301 ch\u01b0\u0303 s\u00f4\u0301 \u0111a\u0303 xa\u0301c \u0111i\u0323nh<\/strong><\/p>\n<p>=ROUND(number, num_digits)<\/p>\n<ul>\n<li><b class=\"ocpRunInHead\">number<\/b>\u00a0\u00a0\u00a0\u00a0B\u1eaft bu\u1ed9c. S\u00f4\u0301 ma\u0300 ba\u0323n mu\u00f4\u0301n la\u0300m tro\u0300n.<\/li>\n<li><b class=\"ocpRunInHead\">num_digits<\/b>\u00a0\u00a0\u00a0\u00a0B\u1eaft bu\u1ed9c. S\u00f4\u0301 ch\u01b0\u0303 s\u00f4\u0301 ma\u0300 ba\u0323n mu\u00f4\u0301n la\u0300m tro\u0300n s\u00f4\u0301 t\u01a1\u0301i \u0111o\u0301.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1990 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/round.png\" alt=\"\" width=\"195\" height=\"143\" \/><\/p>\n<p>MOD: Tra\u0309 v\u00ea\u0300 s\u00f4\u0301 d\u01b0 sau khi chia m\u00f4\u0323t s\u00f4\u0301 cho \u01b0\u01a1\u0301c s\u00f4\u0301. K\u00ea\u0301t qua\u0309 co\u0301 cu\u0300ng d\u00e2\u0301u v\u01a1\u0301i \u01b0\u01a1\u0301c s\u00f4\u0301.<\/p>\n<p>=MOD(number, divisor)<\/p>\n<ul>\n<li><b class=\"ocpRunInHead\">Number<\/b>\u00a0\u00a0\u00a0\u00a0B\u1eaft bu\u1ed9c. S\u00f4\u0301 ma\u0300 ba\u0323n mu\u00f4\u0301n ti\u0300m s\u00f4\u0301 d\u01b0.<\/li>\n<li><b class=\"ocpRunInHead\">Divisor<\/b>\u00a0\u00a0\u00a0\u00a0B\u1eaft bu\u1ed9c. S\u00f4\u0301 ma\u0300 ba\u0323n mu\u00f4\u0301n chia s\u00f4\u0301 cho no\u0301.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1992 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/MOD-300x149.png\" alt=\"\" width=\"300\" height=\"149\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Ha\u0300m PRODUCT: nh\u00e2n t\u00e2\u0301t ca\u0309 ca\u0301c \u0111\u00f4\u0301i s\u00f4\u0301 \u0111a\u0303 cho v\u01a1\u0301i nhau va\u0300 tra\u0309 v\u00ea\u0300 ti\u0301ch cu\u0309a chu\u0301ng.<\/strong><\/p>\n<p>=PRODUCT(number1, number2, &#8230;)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1993 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/05\/product1-300x195.png\" alt=\"\" width=\"300\" height=\"195\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi c\u00e1c h\u00e0m to\u00e1n h\u1ecdc ABS, INT, MOD, \u00a0PRODUCT, \u00a0ROUND, SQRT, SUM, SUMIF h\u00e0m logic \u00a0AND, OR, NOT v\u00e0 h\u00e0m \u0111i\u1ec1u ki\u1ec7n IF. C\u00e1c h\u00e0m n\u00e0y r\u1ea5t th\u00f4ng d\u1ee5ng trong vi\u1ec7c x\u1eed l\u00fd c\u00e1c b\u00e0i to\u00e1n Excel. Trong qu\u00e1 tr\u00ecnh t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c h\u00e0m, ta s\u1ebd k\u1ebft h\u1ee3p t\u00ecm hi\u1ec3u v\u1edbi c\u00e1c ph\u00e9p to\u00e1n g\u1ed3m c\u1ed9ng (+) , tr\u1eeb (-), nh\u00e2n (*) , chia (\/), c\u00e1c ph\u00e9p so s\u00e1nh g\u1ed3m l\u1edbn h\u01a1n (&gt;), b\u00e9 h\u01a1n (&lt;), l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng&hellip;<\/p>\n","protected":false},"author":2,"featured_media":1108,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"footnotes":""},"categories":[14,15],"tags":[37,42],"class_list":["post-1922","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat","category-van-phong","tag-excel","tag-ham-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>H\u00e0m Excel - C\u00e1c h\u00e0m lu\u1eadn l\u00fd, h\u00e0m \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1c ph\u00e9p to\u00e1n, ph\u00e9p so s\u00e1nh - EngISV<\/title>\n<meta name=\"description\" content=\"Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi c\u00e1c h\u00e0m to\u00e1n h\u1ecdc ABS, INT, MOD, PRODUCT, ROUND, SQRT, SUM, SUMIF h\u00e0m logic AND, OR, NOT v\u00e0 h\u00e0m \u0111i\u1ec1u ki\u1ec7n IF. C\u00e1c h\u00e0m n\u00e0y r\u1ea5t th\u00f4ng d\u1ee5ng trong vi\u1ec7c x\u1eed l\u00fd c\u00e1c b\u00e0i to\u00e1n Excel. Trong qu\u00e1 tr\u00ecnh t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c h\u00e0m, ta s\u1ebd k\u1ebft h\u1ee3p t\u00ecm hi\u1ec3u v\u1edbi c\u00e1c ph\u00e9p to\u00e1n g\u1ed3m c\u1ed9ng (+) , tr\u1eeb (-), nh\u00e2n (*) , chia (\/), c\u00e1c ph\u00e9p so s\u00e1nh g\u1ed3m l\u1edbn h\u01a1n (&gt;), b\u00e9 h\u01a1n (=), b\u00e9 h\u01a1n ho\u1eb7c h\u1eb1ng (&lt;=), kh\u00e1c (), b\u1eb1ng nhau (=) \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u v\u00e0 \u0111\u01b0a ra k\u1ebft qu\u1ea3.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.engisv.info\/?p=1922\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m Excel - C\u00e1c h\u00e0m lu\u1eadn l\u00fd, h\u00e0m \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1c ph\u00e9p to\u00e1n, ph\u00e9p so s\u00e1nh - EngISV\" \/>\n<meta property=\"og:description\" content=\"Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi c\u00e1c h\u00e0m to\u00e1n h\u1ecdc ABS, INT, MOD, PRODUCT, ROUND, SQRT, SUM, SUMIF h\u00e0m logic AND, OR, NOT v\u00e0 h\u00e0m \u0111i\u1ec1u ki\u1ec7n IF. C\u00e1c h\u00e0m n\u00e0y r\u1ea5t th\u00f4ng d\u1ee5ng trong vi\u1ec7c x\u1eed l\u00fd c\u00e1c b\u00e0i to\u00e1n Excel. Trong qu\u00e1 tr\u00ecnh t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c h\u00e0m, ta s\u1ebd k\u1ebft h\u1ee3p t\u00ecm hi\u1ec3u v\u1edbi c\u00e1c ph\u00e9p to\u00e1n g\u1ed3m c\u1ed9ng (+) , tr\u1eeb (-), nh\u00e2n (*) , chia (\/), c\u00e1c ph\u00e9p so s\u00e1nh g\u1ed3m l\u1edbn h\u01a1n (&gt;), b\u00e9 h\u01a1n (=), b\u00e9 h\u01a1n ho\u1eb7c h\u1eb1ng (&lt;=), kh\u00e1c (), b\u1eb1ng nhau (=) \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u v\u00e0 \u0111\u01b0a ra k\u1ebft qu\u1ea3.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.engisv.info\/?p=1922\" \/>\n<meta property=\"og:site_name\" content=\"EngISV\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/engisv\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-06T11:37:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-08-23T04:15:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"hoanghiepktv\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"hoanghiepktv\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1922#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1922\"},\"author\":{\"name\":\"hoanghiepktv\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/person\\\/dcbab2ddc35f4c71f45c7e13f36367bf\"},\"headline\":\"H\u00e0m Excel &#8211; C\u00e1c h\u00e0m lu\u1eadn l\u00fd, h\u00e0m \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1c ph\u00e9p to\u00e1n, ph\u00e9p so s\u00e1nh\",\"datePublished\":\"2017-05-06T11:37:06+00:00\",\"dateModified\":\"2018-08-23T04:15:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1922\"},\"wordCount\":1105,\"publisher\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1922#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"keywords\":[\"Excel\",\"H\u00e0m Excel\"],\"articleSection\":[\"Th\u1ee7 thu\u1eadt\",\"V\u0103n ph\u00f2ng\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1922\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/?p=1922\",\"name\":\"H\u00e0m Excel - C\u00e1c h\u00e0m lu\u1eadn l\u00fd, h\u00e0m \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1c ph\u00e9p to\u00e1n, ph\u00e9p so s\u00e1nh - EngISV\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1922#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1922#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"datePublished\":\"2017-05-06T11:37:06+00:00\",\"dateModified\":\"2018-08-23T04:15:58+00:00\",\"description\":\"Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi c\u00e1c h\u00e0m to\u00e1n h\u1ecdc ABS, INT, MOD, PRODUCT, ROUND, SQRT, SUM, SUMIF h\u00e0m logic AND, OR, NOT v\u00e0 h\u00e0m \u0111i\u1ec1u ki\u1ec7n IF. C\u00e1c h\u00e0m n\u00e0y r\u1ea5t th\u00f4ng d\u1ee5ng trong vi\u1ec7c x\u1eed l\u00fd c\u00e1c b\u00e0i to\u00e1n Excel. Trong qu\u00e1 tr\u00ecnh t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c h\u00e0m, ta s\u1ebd k\u1ebft h\u1ee3p t\u00ecm hi\u1ec3u v\u1edbi c\u00e1c ph\u00e9p to\u00e1n g\u1ed3m c\u1ed9ng (+) , tr\u1eeb (-), nh\u00e2n (*) , chia (\\\/), c\u00e1c ph\u00e9p so s\u00e1nh g\u1ed3m l\u1edbn h\u01a1n (>), b\u00e9 h\u01a1n (=), b\u00e9 h\u01a1n ho\u1eb7c h\u1eb1ng (&lt;=), kh\u00e1c (), b\u1eb1ng nhau (=) \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u v\u00e0 \u0111\u01b0a ra k\u1ebft qu\u1ea3.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1922#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.engisv.info\\\/?p=1922\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1922#primaryimage\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"contentUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"width\":300,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1922#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.engisv.info\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m Excel &#8211; C\u00e1c h\u00e0m lu\u1eadn l\u00fd, h\u00e0m \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1c ph\u00e9p to\u00e1n, ph\u00e9p so s\u00e1nh\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#website\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/\",\"name\":\"EngISV\",\"description\":\"H\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng vi\u1ec7c nh\u1ecf!\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.engisv.info\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\",\"name\":\"EngISV\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/logo2-3-1-1.png\",\"contentUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/logo2-3-1-1.png\",\"width\":200,\"height\":76,\"caption\":\"EngISV\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/engisv\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/person\\\/dcbab2ddc35f4c71f45c7e13f36367bf\",\"name\":\"hoanghiepktv\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"caption\":\"hoanghiepktv\"},\"url\":\"https:\\\/\\\/www.engisv.info\\\/?author=2\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"H\u00e0m Excel - C\u00e1c h\u00e0m lu\u1eadn l\u00fd, h\u00e0m \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1c ph\u00e9p to\u00e1n, ph\u00e9p so s\u00e1nh - EngISV","description":"Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi c\u00e1c h\u00e0m to\u00e1n h\u1ecdc ABS, INT, MOD, PRODUCT, ROUND, SQRT, SUM, SUMIF h\u00e0m logic AND, OR, NOT v\u00e0 h\u00e0m \u0111i\u1ec1u ki\u1ec7n IF. C\u00e1c h\u00e0m n\u00e0y r\u1ea5t th\u00f4ng d\u1ee5ng trong vi\u1ec7c x\u1eed l\u00fd c\u00e1c b\u00e0i to\u00e1n Excel. Trong qu\u00e1 tr\u00ecnh t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c h\u00e0m, ta s\u1ebd k\u1ebft h\u1ee3p t\u00ecm hi\u1ec3u v\u1edbi c\u00e1c ph\u00e9p to\u00e1n g\u1ed3m c\u1ed9ng (+) , tr\u1eeb (-), nh\u00e2n (*) , chia (\/), c\u00e1c ph\u00e9p so s\u00e1nh g\u1ed3m l\u1edbn h\u01a1n (>), b\u00e9 h\u01a1n (=), b\u00e9 h\u01a1n ho\u1eb7c h\u1eb1ng (&lt;=), kh\u00e1c (), b\u1eb1ng nhau (=) \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u v\u00e0 \u0111\u01b0a ra k\u1ebft qu\u1ea3.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.engisv.info\/?p=1922","og_locale":"en_US","og_type":"article","og_title":"H\u00e0m Excel - C\u00e1c h\u00e0m lu\u1eadn l\u00fd, h\u00e0m \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1c ph\u00e9p to\u00e1n, ph\u00e9p so s\u00e1nh - EngISV","og_description":"Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi c\u00e1c h\u00e0m to\u00e1n h\u1ecdc ABS, INT, MOD, PRODUCT, ROUND, SQRT, SUM, SUMIF h\u00e0m logic AND, OR, NOT v\u00e0 h\u00e0m \u0111i\u1ec1u ki\u1ec7n IF. C\u00e1c h\u00e0m n\u00e0y r\u1ea5t th\u00f4ng d\u1ee5ng trong vi\u1ec7c x\u1eed l\u00fd c\u00e1c b\u00e0i to\u00e1n Excel. Trong qu\u00e1 tr\u00ecnh t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c h\u00e0m, ta s\u1ebd k\u1ebft h\u1ee3p t\u00ecm hi\u1ec3u v\u1edbi c\u00e1c ph\u00e9p to\u00e1n g\u1ed3m c\u1ed9ng (+) , tr\u1eeb (-), nh\u00e2n (*) , chia (\/), c\u00e1c ph\u00e9p so s\u00e1nh g\u1ed3m l\u1edbn h\u01a1n (>), b\u00e9 h\u01a1n (=), b\u00e9 h\u01a1n ho\u1eb7c h\u1eb1ng (&lt;=), kh\u00e1c (), b\u1eb1ng nhau (=) \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u v\u00e0 \u0111\u01b0a ra k\u1ebft qu\u1ea3.","og_url":"https:\/\/www.engisv.info\/?p=1922","og_site_name":"EngISV","article_publisher":"https:\/\/www.facebook.com\/engisv","article_published_time":"2017-05-06T11:37:06+00:00","article_modified_time":"2018-08-23T04:15:58+00:00","og_image":[{"width":300,"height":300,"url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","type":"image\/png"}],"author":"hoanghiepktv","twitter_card":"summary_large_image","twitter_misc":{"Written by":"hoanghiepktv","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.engisv.info\/?p=1922#article","isPartOf":{"@id":"https:\/\/www.engisv.info\/?p=1922"},"author":{"name":"hoanghiepktv","@id":"https:\/\/www.engisv.info\/#\/schema\/person\/dcbab2ddc35f4c71f45c7e13f36367bf"},"headline":"H\u00e0m Excel &#8211; C\u00e1c h\u00e0m lu\u1eadn l\u00fd, h\u00e0m \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1c ph\u00e9p to\u00e1n, ph\u00e9p so s\u00e1nh","datePublished":"2017-05-06T11:37:06+00:00","dateModified":"2018-08-23T04:15:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.engisv.info\/?p=1922"},"wordCount":1105,"publisher":{"@id":"https:\/\/www.engisv.info\/#organization"},"image":{"@id":"https:\/\/www.engisv.info\/?p=1922#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","keywords":["Excel","H\u00e0m Excel"],"articleSection":["Th\u1ee7 thu\u1eadt","V\u0103n ph\u00f2ng"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.engisv.info\/?p=1922","url":"https:\/\/www.engisv.info\/?p=1922","name":"H\u00e0m Excel - C\u00e1c h\u00e0m lu\u1eadn l\u00fd, h\u00e0m \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1c ph\u00e9p to\u00e1n, ph\u00e9p so s\u00e1nh - EngISV","isPartOf":{"@id":"https:\/\/www.engisv.info\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.engisv.info\/?p=1922#primaryimage"},"image":{"@id":"https:\/\/www.engisv.info\/?p=1922#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","datePublished":"2017-05-06T11:37:06+00:00","dateModified":"2018-08-23T04:15:58+00:00","description":"Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta s\u1ebd l\u00e0m quen v\u1edbi c\u00e1c h\u00e0m to\u00e1n h\u1ecdc ABS, INT, MOD, PRODUCT, ROUND, SQRT, SUM, SUMIF h\u00e0m logic AND, OR, NOT v\u00e0 h\u00e0m \u0111i\u1ec1u ki\u1ec7n IF. C\u00e1c h\u00e0m n\u00e0y r\u1ea5t th\u00f4ng d\u1ee5ng trong vi\u1ec7c x\u1eed l\u00fd c\u00e1c b\u00e0i to\u00e1n Excel. Trong qu\u00e1 tr\u00ecnh t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c h\u00e0m, ta s\u1ebd k\u1ebft h\u1ee3p t\u00ecm hi\u1ec3u v\u1edbi c\u00e1c ph\u00e9p to\u00e1n g\u1ed3m c\u1ed9ng (+) , tr\u1eeb (-), nh\u00e2n (*) , chia (\/), c\u00e1c ph\u00e9p so s\u00e1nh g\u1ed3m l\u1edbn h\u01a1n (>), b\u00e9 h\u01a1n (=), b\u00e9 h\u01a1n ho\u1eb7c h\u1eb1ng (&lt;=), kh\u00e1c (), b\u1eb1ng nhau (=) \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u v\u00e0 \u0111\u01b0a ra k\u1ebft qu\u1ea3.","breadcrumb":{"@id":"https:\/\/www.engisv.info\/?p=1922#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.engisv.info\/?p=1922"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.engisv.info\/?p=1922#primaryimage","url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","contentUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","width":300,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/www.engisv.info\/?p=1922#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.engisv.info\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m Excel &#8211; C\u00e1c h\u00e0m lu\u1eadn l\u00fd, h\u00e0m \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1c ph\u00e9p to\u00e1n, ph\u00e9p so s\u00e1nh"}]},{"@type":"WebSite","@id":"https:\/\/www.engisv.info\/#website","url":"https:\/\/www.engisv.info\/","name":"EngISV","description":"H\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng vi\u1ec7c nh\u1ecf!","publisher":{"@id":"https:\/\/www.engisv.info\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.engisv.info\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.engisv.info\/#organization","name":"EngISV","url":"https:\/\/www.engisv.info\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.engisv.info\/#\/schema\/logo\/image\/","url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/06\/logo2-3-1-1.png","contentUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/06\/logo2-3-1-1.png","width":200,"height":76,"caption":"EngISV"},"image":{"@id":"https:\/\/www.engisv.info\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/engisv"]},{"@type":"Person","@id":"https:\/\/www.engisv.info\/#\/schema\/person\/dcbab2ddc35f4c71f45c7e13f36367bf","name":"hoanghiepktv","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","caption":"hoanghiepktv"},"url":"https:\/\/www.engisv.info\/?author=2"}]}},"_links":{"self":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/1922","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1922"}],"version-history":[{"count":1,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/1922\/revisions"}],"predecessor-version":[{"id":3820,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/1922\/revisions\/3820"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/media\/1108"}],"wp:attachment":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}