{"id":64700,"date":"2026-04-16T09:53:54","date_gmt":"2026-04-16T08:53:54","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/inicio\/?p=64700"},"modified":"2026-04-16T10:17:06","modified_gmt":"2026-04-16T09:17:06","slug":"dont-bother-with-if-in-excel-when-you-can-use-this-function-instead","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/dont-bother-with-if-in-excel-when-you-can-use-this-function-instead\/","title":{"rendered":"Don&#8217;t bother with IF in Excel when you can use this function instead"},"content":{"rendered":"<p>Don&#8217;t bother with IF in Excel when you can use this function instead<br \/>\n<a href=\"https:\/\/www.makeuseof.com\/dont-bother-if-in-excel-when-you-use-this-function\/\" rel=\"nofollow\">https:\/\/www.makeuseof.com\/dont-bother-if-in-excel-when-you-use-this-function\/<\/a><\/p>\n<ul>\n<li>SWITCH is the function you should have been using<br \/>\nIt does the same job as nested IF, but without the chaos<\/li>\n<li>SWITCH handles real-world scenarios better than IF<br \/>\nHere&#8217;s what that looks like with actual data<\/li>\n<li>There are a few things SWITCH can&#8217;t do<br \/>\nWhen your conditions involve ranges, IFS is the smarter call<\/li>\n<li>Make the switch from IF in your existing spreadsheets<br \/>\nYou don&#8217;t have to rewrite everything at once<\/li>\n<li>There&#8217;s more where this came from<br \/>\nSWITCH and IFS are good, but they work even better with these functions<\/li>\n<\/ul>\n<p>Zie ook:<\/p>\n<ul>\n<li>IFS function &#8211; Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/office\/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45<\/a><\/p>\n<ul>\n<li>ALS.VOORWAARDEN, functie &#8211; Microsoft Ondersteuning<br \/>\n<a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/als-voorwaarden-functie-36329a26-37b2-467c-972b-4a39bd951d45\" rel=\"nofollow\">https:\/\/support.microsoft.com\/nl-nl\/office\/als-voorwaarden-functie-36329a26-37b2-467c-972b-4a39bd951d45<\/a><\/li>\n<\/ul>\n<\/li>\n<li>SWITCH function &#8211; Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-au\/office\/switch-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-au\/office\/switch-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e<\/a><\/p>\n<ul>\n<li>SCHAKELEN, functie &#8211; Microsoft Ondersteuning<br \/>\n<a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/schakelen-functie-47ab33c0-28ce-4530-8a45-d532ec4aa25e\" rel=\"nofollow\">https:\/\/support.microsoft.com\/nl-nl\/office\/schakelen-functie-47ab33c0-28ce-4530-8a45-d532ec4aa25e<\/a><\/li>\n<\/ul>\n<\/li>\n<li>LET function &#8211; Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-au\/office\/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-au\/office\/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999<\/a><\/p>\n<ul>\n<li>LET-functie &#8211; Microsoft Ondersteuning<br \/>\n<a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/let-functie-34842dd8-b92b-4d3f-b325-b8b8f9908999\" rel=\"nofollow\">https:\/\/support.microsoft.com\/nl-nl\/office\/let-functie-34842dd8-b92b-4d3f-b325-b8b8f9908999<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div id=\"simple-translate\" class=\"simple-translate-system-theme\">\n<div>\n<div class=\"simple-translate-button isShow\" style=\"background-image: url('moz-extension:\/\/4fe9cde6-e923-4f4e-95a2-0682052323f6\/icons\/512.png'); height: 22px; width: 22px; top: -16px; left: 29px;\"><\/div>\n<div class=\"simple-translate-panel \" style=\"width: 300px; height: 200px; top: 0px; left: 0px; font-size: 13px;\">\n<div class=\"simple-translate-result-wrapper\" style=\"overflow: hidden;\">\n<div class=\"simple-translate-move\" draggable=\"true\"><\/div>\n<div class=\"simple-translate-result-contents\">\n<p class=\"simple-translate-candidate\" dir=\"auto\">\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Don&#8217;t bother with IF in Excel when you can use this function instead https:\/\/www.makeuseof.com\/dont-bother-if-in-excel-when-you-use-this-function\/ SWITCH is the function you should have been using It does the same job as nested IF, but without the chaos SWITCH handles real-world scenarios better than IF Here&#8217;s what that looks like with actual data<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":2,"footnotes":""},"categories":[375,246],"tags":[587],"class_list":["post-64700","post","type-post","status-publish","format-standard","hentry","category-excel-office-2010","category-office-2010","tag-excel"],"publishpress_future_action":{"enabled":false,"date":"2026-05-01 04:05:00","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\/64700","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=64700"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/64700\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=64700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=64700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=64700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}