{"id":4932,"date":"2015-12-11T15:02:35","date_gmt":"2015-12-11T15:02:35","guid":{"rendered":"http:\/\/tapchicntt.com\/?p=4932"},"modified":"2016-11-30T02:53:02","modified_gmt":"2016-11-30T02:53:02","slug":"chuyen-doi-so-am-thanh-so-0","status":"publish","type":"post","link":"https:\/\/tapchicntt.com\/chuyen-doi-so-am-thanh-so-0\/","title":{"rendered":"Chuy\u1ec3n \u0111\u1ed5i s\u1ed1 \u00e2m th\u00e0nh s\u1ed1 0"},"content":{"rendered":"<p>M\u1ed9t th\u1ee7 thu\u1eadt Excel kh\u00e1 hay nh\u1eb1m thay \u0111\u1ed5i s\u1ed1 \u00e2m th\u00e0nh 0 trong m\u1ed9t d\u00e3y s\u1ed1, nh\u01b0ng s\u1ed1 d\u01b0\u01a1ng v\u1eabn gi\u1eef nguy\u00ean gi\u00e1 tr\u1ecb.<br \/>\n<!--more--><br \/>\nD\u01b0\u1edbi \u0111\u00e2y b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y hai c\u1ed9t v\u1edbi c\u00e1c con s\u1ed1. Tr\u1eeb c\u00e1c s\u1ed1 trong c\u1ed9t B t\u1eeb nh\u1eefng con s\u1ed1 trong c\u1ed9t A, th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau \u0111\u00e2y.<br \/>\n1. Ch\u1ecdn \u00f4 C1.<br \/>\n2. Nh\u1eadp c\u00f4ng th\u1ee9c = A1-B1<br \/>\n3. Nh\u1ea5p v\u00e0o g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 C1 v\u00e0 k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/upload.lyminhhoang.com\/repository\/2016\/tintuc\/chuyen-doi-so-am-thanh-so-0\/negative-numbers-to-zero-example.png\" alt=\"Chuy\u1ec3n \u0111\u1ed5i s\u1ed1 \u00e2m th\u00e0nh s\u1ed1 0\" \/><\/p>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/upload.lyminhhoang.com\/repository\/2016\/tintuc\/chuyen-doi-so-am-thanh-so-0\/negative-numbers.png\" alt=\"Chuy\u1ec3n \u0111\u1ed5i s\u1ed1 \u00e2m th\u00e0nh s\u1ed1 0\" \/><\/p>\n<p>4. \u0110\u1ec3 thay \u0111\u1ed5i s\u1ed1 \u00e2m th\u00e0nh 0 nh\u01b0ng nh\u1eefng kh\u00f4ng l\u00e0m \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn c\u00e1c con s\u1ed1 d\u01b0\u01a1ng, ch\u00fang ta l\u00e0m nh\u01b0 sau thay v\u00ec = A1-B1, s\u1eed d\u1ee5ng <strong>=MAX(0,A1-B1)<\/strong> v\u00e0 k\u00e9o h\u00e0m xu\u1ed1ng.<\/p>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/upload.lyminhhoang.com\/repository\/2016\/tintuc\/chuyen-doi-so-am-thanh-so-0\/negative-numbers-to-zero-result.png\" alt=\"Chuy\u1ec3n \u0111\u1ed5i s\u1ed1 \u00e2m th\u00e0nh s\u1ed1 0\" \/><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>M\u1ed9t th\u1ee7 thu\u1eadt Excel kh\u00e1 hay nh\u1eb1m thay \u0111\u1ed5i s\u1ed1 \u00e2m th\u00e0nh 0 trong m\u1ed9t d\u00e3y s\u1ed1, nh\u01b0ng s\u1ed1 d\u01b0\u01a1ng [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[128],"tags":[],"class_list":["post-4932","post","type-post","status-publish","format-standard","hentry","category-van-phong"],"views":658,"_links":{"self":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts\/4932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/comments?post=4932"}],"version-history":[{"count":0,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts\/4932\/revisions"}],"wp:attachment":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/media?parent=4932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/categories?post=4932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/tags?post=4932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}