{"id":64816,"date":"2026-05-28T16:04:46","date_gmt":"2026-05-28T15:04:46","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/inicio\/?p=64816"},"modified":"2026-05-28T16:04:46","modified_gmt":"2026-05-28T15:04:46","slug":"ifna-the-excel-formula-i-use-whenever-n-a-takes-over-a-sheet","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/ifna-the-excel-formula-i-use-whenever-n-a-takes-over-a-sheet\/","title":{"rendered":"IFNA: The Excel formula I use whenever #N\/A takes over a sheet"},"content":{"rendered":"<p>The Excel formula I use whenever #N\/A takes over a sheet<br \/>\n<a href=\"https:\/\/www.makeuseof.com\/the-ifna-function-in-excel\/\" rel=\"nofollow\">https:\/\/www.makeuseof.com\/the-ifna-function-in-excel\/<\/a><\/p>\n<p>IFNA function &#8211; Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/ifna-function-6626c961-a569-42fc-a49d-79b4951fd461\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/office\/ifna-function-6626c961-a569-42fc-a49d-79b4951fd461<\/a><\/p>\n<p>ALS.NB, functie &#8211; Microsoft Ondersteuning<br \/>\n<a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/als-nb-functie-6626c961-a569-42fc-a49d-79b4951fd461\" rel=\"nofollow\">https:\/\/support.microsoft.com\/nl-nl\/office\/als-nb-functie-6626c961-a569-42fc-a49d-79b4951fd461<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Excel formula I use whenever #N\/A takes over a sheet https:\/\/www.makeuseof.com\/the-ifna-function-in-excel\/ IFNA function &#8211; Microsoft Support https:\/\/support.microsoft.com\/en-us\/office\/ifna-function-6626c961-a569-42fc-a49d-79b4951fd461 ALS.NB, functie &#8211; Microsoft Ondersteuning https:\/\/support.microsoft.com\/nl-nl\/office\/als-nb-functie-6626c961-a569-42fc-a49d-79b4951fd461<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":3,"footnotes":""},"categories":[54],"tags":[],"class_list":["post-64816","post","type-post","status-publish","format-standard","hentry","category-excel"],"publishpress_future_action":{"enabled":false,"date":"2026-06-10 02:23:06","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/64816","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=64816"}],"version-history":[{"count":1,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/64816\/revisions"}],"predecessor-version":[{"id":64817,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/64816\/revisions\/64817"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=64816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=64816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=64816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}