{"id":464,"date":"2026-01-23T11:18:49","date_gmt":"2026-01-23T11:18:49","guid":{"rendered":"https:\/\/bliv-klogere.dk\/?page_id=464"},"modified":"2026-02-05T17:30:41","modified_gmt":"2026-02-05T17:30:41","slug":"5-formler","status":"publish","type":"page","link":"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/","title":{"rendered":"5. Formler"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Indholdsfortegnelse<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/#1_Formlen_%E2%80%9Chvis%E2%80%9D_samt_%E2%80%9Chvis-i-hvis%E2%80%9D\" >1. Formlen &#8220;hvis&#8221; samt &#8220;hvis-i-hvis&#8221;<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/#Opgaver\" >Opgaver&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/#11_Hvis-saetning\" >1.1 Hvis-s\u00e6tning&nbsp;<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/#2_Opslagsformler_vopslag_lopslag_mv\" >2. Opslagsformler (vopslag, lopslag mv.)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/#Opgaver-2\" >Opgaver<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/#21_Prov_lopslaget_af\" >2.1 Pr\u00f8v lopslaget af&nbsp;<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/#3_Betinget_formatering_med_farver_ud_fra_formel\" >3. Betinget formatering med farver ud fra formel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/#Opgaver-3\" >Opgaver<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/#31_Betinget_formatering\" >3.1 Betinget formatering<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Formlen_%E2%80%9Chvis%E2%80%9D_samt_%E2%80%9Chvis-i-hvis%E2%80%9D\"><\/span>1. Formlen &#8220;hvis&#8221; samt &#8220;hvis-i-hvis&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Excel har 1.000-vis af foruddefinerede formler. En af de mest brugte er &#8220;Hvis&#8221; eller &#8220;If&#8221; p\u00e5 engelsk.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Jeg har indtastet en lille tabel. I kolonne C vil jeg lave en vurdering af s\u00e6lgernes indsats. Hvis de har solgt for 100 eller over, s\u00e5 skal der I cellen st\u00e5 &#8220;Supers\u00e6lger&#8221;. Ellers skal der st\u00e5 &#8220;Dovendyr&#8221;&nbsp;<\/li>\n\n\n\n<li>St\u00e5 I cellen (1)&nbsp;<\/li>\n\n\n\n<li>G\u00e5 op I formellinen oven over, og klik p\u00e5 knappen f<sub>x<\/sub> (2)&nbsp;<\/li>\n\n\n\n<li>Find formlen &#8220;Hvis&#8221; (&#8220;If&#8221; p\u00e5 engelsk) (3)&nbsp;<\/li>\n\n\n\n<li>Klik til sidst p\u00e5 OK (4)&nbsp;<br>&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"543\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-139.png\" alt=\"\" class=\"wp-image-445\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-139.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-139-300x159.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-139-768x407.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Du skal ikke selv taste formlen, du kan udfylde det nye pop-op vindue. G\u00f8r det s\u00e5ledes:\n<ul class=\"wp-block-list\">\n<li>Logisk test B2 &gt;= 100. Dvs. Celle B2 skal v\u00e6re st\u00f8rre end eller lig med 100 (1)&nbsp;<\/li>\n\n\n\n<li>Hvis det er sandt, s\u00e5 skriv v\u00e6rdien &#8220;Supers\u00e6lger&#8221; (2)&nbsp;<\/li>\n\n\n\n<li>Hvis det er falsk, s\u00e5 skriv v\u00e6rdien &#8220;Dovendyr&#8221; (3)&nbsp;<\/li>\n\n\n\n<li>Klik til sidst p\u00e5 knappen OK (4)&nbsp;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"676\" height=\"330\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-140.png\" alt=\"\" class=\"wp-image-446\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-140.png 676w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-140-300x146.png 300w\" sizes=\"auto, (max-width: 676px) 100vw, 676px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Resultatet ser s\u00e5ledes ud. Der st\u00e5r det rigtige I cellen (1)&nbsp;<\/li>\n\n\n\n<li>Bem\u00e6rk at du I formellinjen kan se formlen (2). S\u00e5 du kan alts\u00e5 ogs\u00e5 taste formlen ind. I starten vil jeg dog anbefale, at du bruger formelvinduerne&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"676\" height=\"330\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-140.png\" alt=\"\" class=\"wp-image-447\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-140.png 676w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-140-300x146.png 300w\" sizes=\"auto, (max-width: 676px) 100vw, 676px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Resultatet bliver&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"356\" height=\"192\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-138.png\" alt=\"\" class=\"wp-image-444\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-138.png 356w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-138-300x162.png 300w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Bonusberegning med Hvis-formlen<\/strong>&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>&nbsp;Vi er ikke helt f\u00e6rdige. Hvis de s\u00e6lger for 100 eller mere end det, s\u00e5 skal de have en bonus. Dvs. De f\u00e5r 5 procent. Det kan vi ogs\u00e5 bruge formlen Hvis til.&nbsp;<\/li>\n\n\n\n<li>Start helt lige som f\u00f8r:\n<ul class=\"wp-block-list\">\n<li>St\u00e5 I cellen (1)&nbsp;<\/li>\n\n\n\n<li>G\u00e5 op I formellinen oven over, og klik p\u00e5 knappen f<sub>x<\/sub> (2)&nbsp;<\/li>\n\n\n\n<li>Find formlen &#8220;Hvis&#8221; (&#8220;If&#8221; p\u00e5 engelsk) (3)&nbsp;<\/li>\n\n\n\n<li>Klik til sidst p\u00e5 OK&nbsp;<br>&nbsp;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"546\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-141.png\" alt=\"\" class=\"wp-image-448\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-141.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-141-300x160.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-141-768x410.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Udfyld formelvinduet s\u00e5ledes:\n<ul class=\"wp-block-list\">\n<li>Den logiske test har jeg leget lidt med, I stedet for B2 &gt;= 100 kan man selvf\u00f8lgelig ogs\u00e5 skrive B2 &lt; 100. S\u00e5 det g\u00f8r jeg&nbsp;<\/li>\n\n\n\n<li>Hvis udsagnet er sandt, s\u00e5 er der ingen bonus. Derfor v\u00e6rdien 0&nbsp;<\/li>\n\n\n\n<li>Hvis udsagnet er falsk, s\u00e5 skal s\u00e6lgeren have 5% bonus. Det udregnes som B2 * 5%&nbsp;<br>&nbsp;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"803\" height=\"337\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-142.png\" alt=\"\" class=\"wp-image-449\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-142.png 803w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-142-300x126.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-142-768x322.png 768w\" sizes=\"auto, (max-width: 803px) 100vw, 803px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Resultatet bliver<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"442\" height=\"208\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-143.png\" alt=\"\" class=\"wp-image-450\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-143.png 442w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-143-300x141.png 300w\" sizes=\"auto, (max-width: 442px) 100vw, 442px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Hvis-i-hvis<\/strong>&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Indtil nu har vi kun haft 2 muligheder. Hvad nu hvis der er flere end 2 muligheder?&nbsp;&nbsp;<\/li>\n\n\n\n<li>Vi siger nu, at hvis salget er p\u00e5 eller over 110, s\u00e5 skal s\u00e6lgeren have 8% I bonus&nbsp;<\/li>\n\n\n\n<li>Ovenfor s\u00e5 formlen s\u00e5ledes ud:&nbsp;<br>&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">=IF(B2 &lt; 100;0;B2 * 5%)&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IF er selvf\u00f8lgelig formlen&nbsp;&nbsp;<\/li>\n\n\n\n<li>B2 &lt; 100&nbsp; er sp\u00f8rgsm\u00e5let, om v\u00e6rdien I celle B2 er mindre end 100&nbsp;<\/li>\n\n\n\n<li>0 er svaret, hvis udsagnet er sandt&nbsp;<\/li>\n\n\n\n<li>B2 * 5%&nbsp; er det, den skal g\u00f8re, hvis udsagnet er falsk&nbsp;<br>&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Det, vi skal g\u00f8re, er at s\u00e6tte en ny Hvis-formel ind I stedet for B2 * 5%&nbsp;<\/li>\n\n\n\n<li>Formlen bliver&nbsp;<br>&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">IF (B2 &lt; 110; B2 * 5%; B2*10%)&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Hvis udsagnet er sandt, s\u00e5 udbetales 5%. Hvis falsk, s\u00e5 10%&nbsp;<\/li>\n\n\n\n<li>S\u00e5 kan du m\u00e5ske sp\u00f8rge: &#8220;Jamen, hvad s\u00e5 med dem, der slet ikke skal have bonus?&#8221;. Svaret er, at de er allerede sorteret fra.&nbsp;&nbsp;<\/li>\n\n\n\n<li>P\u00e5 denne m\u00e5de kan vi blive ved med at lave hvis-i-hvis s\u00e6tninger&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Formlen kommer til at se s\u00e5dan ud:\u00a0<ul><li>De 2 f\u00f8rste linjer ser ud som f\u00f8r (1)\u00a0<\/li><li>V\u00e6rdien hvis falsk bliver nu til en hvis s\u00e6tning: IF (B2 &lt; 110; B2 * 5%; B2*10%)\u00a0<\/li><li>Du kan se hele formlen i formel-vinduet \u00f8verst (3)\u00a0<\/li><li>Det ses, at Rikke Rabats bonus nu er dobbelt s\u00e5 stor som f\u00f8r.\u00a0<\/li><\/ul><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Opgaver\"><\/span>Opgaver&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"11_Hvis-saetning\"><\/span><strong>1.1 Hvis-s\u00e6tning<\/strong>&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Indtast nedenst\u00e5ende&nbsp;&nbsp;<\/li>\n\n\n\n<li>F\u00f8lg vejledningen fra det f\u00f8rste afsnit:\n<ul class=\"wp-block-list\">\n<li>Beregn den f\u00f8rste s\u00f8jle, hvor du skal afg\u00f8re, om s\u00e6lgeren er en supers\u00e6lger eller et dovendyr (vist med orange)&nbsp;<\/li>\n\n\n\n<li>Beregn den anden r\u00e6kke med 5% bonus (vist med gr\u00f8n)&nbsp;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Ekstra: Det er blevet jul. S\u00e5 selvom nogle af s\u00e6lgerne er dovne, s\u00e5 f\u00e5r de 2% I bonus alligevel. Ellers skal de have 8%. Lav den nye beregning&nbsp;<br>&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ekstra: Hvis-I-hvis<\/strong>&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Gennemf\u00f8r beregningen, hvor s\u00e6lgerne med p\u00e5 eller over 110 I oms\u00e6tning f\u00e5r ikke 5% men 10%.&nbsp;<\/li>\n\n\n\n<li>Lav en ny r\u00e6kke med Freja Fantastisk. Hun har 154 I oms\u00e6tning. Lav en formel I en ny s\u00f8jle, der kan give s\u00e6lgere med over 150 hele 15% I oms\u00e6tning&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ekstra: Postnumre<\/strong>&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Du husker sikkert kundelisten fra f\u00f8r. Den er vedh\u00e6ftet herunder.&nbsp;<\/li>\n\n\n\n<li>Du skal lave en formel, som kan udf\u00f8re f\u00f8lgende.\n<ul class=\"wp-block-list\">\n<li>Hvis postnummeret er under 5000 s\u00e5 skriv: &#8220;Ligger \u00f8st for Storeb\u00e6lt&#8221;&nbsp;<\/li>\n\n\n\n<li>Hvis postnummeret er p\u00e5 eller over 5000 men under 6000 skriv &#8220;Ligger p\u00e5 Fyn&#8221;&nbsp;&nbsp;<\/li>\n\n\n\n<li>Hvis postnumemret er p\u00e5 eller over 6000 skriv &#8220;Ligger I Jylland&#8221;&nbsp;<\/li>\n\n\n\n<li>Og s\u00e5 den sv\u00e6re: Hvis postnummeret er p\u00e5 eller over 3700 men mindre end 3800 skriv &#8220;Ligger p\u00e5 Bornholm&#8221;&nbsp;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Forklar, hvordan du vil f\u00e5 det til at fungere&nbsp;<\/li>\n\n\n\n<li>Pr\u00f8v det i praksis\u00a0<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Opslagsformler_vopslag_lopslag_mv\"><\/span>2. Opslagsformler (vopslag, lopslag mv.)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Du kan bruge Excel til at lave opslag I tabeller med.&nbsp;<\/li>\n\n\n\n<li>Det lyder m\u00e5ske ikke s\u00e5 nyttigt, men forestil dig, at du har et excel-ark med m\u00e5se 3.000 kunder eller 5.000 varer. S\u00e5 sparer du pludselig meget tid, hvis du kan indtaste f.eks. et varenummer og se oplysningerne om varen&nbsp;<\/li>\n\n\n\n<li>Vigtigt: Den v\u00e6rdi, du sl\u00e5r op p\u00e5, skal v\u00e6re unik. F.eks. kundenummer, varenummer, postnummer, cpr-nummer osv. Ellers virker det ikke.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">&#8212;&#8212;&#8212;&#8212;-&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Der er flere opslagsformler, her vil jeg bruge formlen til et lodret opslag. &#8220;lopslag&#8221; p\u00e5 dansk. &#8220;vlookup&#8221; p\u00e5 engelsk&nbsp;<\/li>\n\n\n\n<li>Det fungere s\u00e5ledes:\n<ul class=\"wp-block-list\">\n<li>Til venstre har du tabellen (1)&nbsp;<\/li>\n\n\n\n<li>Jeg har et felt, hvor jeg indtaster kundenummeret I (2)&nbsp;<\/li>\n\n\n\n<li>Til h\u00f8jre sl\u00e5r min formel s\u00e5 op tabellen og finder de oplysninger, jeg \u00f8nsker (3)&nbsp;<br>&nbsp;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"485\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-144.png\" alt=\"\" class=\"wp-image-451\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-144.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-144-300x142.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-144-768x364.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Lad os kikke ind I formlen: Formlen I celle J3, der finder &#8220;Benny&#8221;, ser s\u00e5dan ud:\n<ul class=\"wp-block-list\">\n<li>Lookup_value = I4. Dvs den celle, hvor jeg indtaster den v\u00e6rdi, jeg vil sl\u00e5 op med. Her kundenummeret (1)&nbsp;<\/li>\n\n\n\n<li>Table_array = A3:G15. Det er det omr\u00e5de, som tabellen befinder sig I (2). Vigtigt: Opslagsv\u00e6rdien skal v\u00e6re den f\u00f8rste kolonne I tabellen&nbsp;<\/li>\n\n\n\n<li>Col_index_num = Jeg vil sl\u00e5 fornavnet op, og det er kolonne 2 fra venstre. Derfor tallet &#8220;2&#8221; (3)&nbsp;<\/li>\n\n\n\n<li>Til sidst st\u00e5r der en v\u00e6rdi &#8220;False&#8221; (4). Det betyder, at jeg kun accepterer n\u00f8jagtige macth p\u00e5 det, jeg sl\u00e5r op med. Hvis jeg satte den til true, ville den m\u00e5ske godt acceptere &#8220;22&#8221; eller &#8220;12&#8221;. Men jeg vil have et pr\u00e6cist match&nbsp;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"855\" height=\"424\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-145.png\" alt=\"\" class=\"wp-image-452\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-145.png 855w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-145-300x149.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-145-768x381.png 768w\" sizes=\"auto, (max-width: 855px) 100vw, 855px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Opgaver-2\"><\/span>Opgaver<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"21_Prov_lopslaget_af\"><\/span><strong>2.1 Pr\u00f8v lopslaget af<\/strong>&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Du er nu en erfaren Excel bruger. S\u00e5 jeg vil overlade forklaringen til nedenst\u00e5ende video <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"S\u00e5dan bruger du LOPSLAG i Excel (VLOOKUP)\" width=\"604\" height=\"340\" src=\"https:\/\/www.youtube.com\/embed\/T0s1XeW90J4?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-5bf4a526-b978-4e3c-97a7-d93350e375af\" href=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/Sortering-og-filtrering1-1.xlsx\">Sortering og filtrering1<\/a><a href=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/Sortering-og-filtrering1-1.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-5bf4a526-b978-4e3c-97a7-d93350e375af\">Download<\/a><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Betinget_formatering_med_farver_ud_fra_formel\"><\/span>3. Betinget formatering med farver ud fra formel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Conditional Formatting to Color Cells in Excel\" width=\"604\" height=\"340\" src=\"https:\/\/www.youtube.com\/embed\/Ac9ZoPlFuKg?start=92&#038;feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Marker det omr\u00e5de, du \u00f8nsker at arbejde med. F.eks. en r\u00e6kke eller hele tabellen (1)<\/li>\n\n\n\n<li>I fanen Hjem v\u00e6lg Betinget formatering (Conditional Formatting) (2) &gt; Ny regel (New Rule) (3)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"558\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-148-1024x558.png\" alt=\"\" class=\"wp-image-458\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-148-1024x558.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-148-300x163.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-148-768x419.png 768w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-148.png 1046w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>I pop-op vinduet v\u00e6lg, at du selv vil skrive formlen: Brug en formel til at afg\u00f8re, hvilke celler der skal formateres (1)<\/li>\n\n\n\n<li>Klik p\u00e5 OK for at lukke vinduet<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"544\" height=\"434\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-149.png\" alt=\"\" class=\"wp-image-459\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-149.png 544w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-149-300x239.png 300w\" sizes=\"auto, (max-width: 544px) 100vw, 544px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>I det nye pop-op vindue skriver du en formel, f.eks.\n<ul class=\"wp-block-list\">\n<li>=$G4 &gt; 200\n<ul class=\"wp-block-list\">\n<li>Det vil sige, at alle celler i tilh\u00f8rende r\u00e6kke til G4 i det tidligere markerede omr\u00e5de (= hele tabellen undtagen r\u00e6kken med overskrifter) , svarende til cellerne A4, B4, C4 osv til og med G4 f\u00e5r den \u00f8nskede formatering, hvis deres v\u00e6rdi er over 200<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Klik p\u00e5 knappen Format (2) og v\u00e6lg den \u00f8nskede formatering. Jeg har valgt farven gr\u00f8n (3)<\/li>\n\n\n\n<li>Klik til sidst p\u00e5 knappen OK (4)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"436\" height=\"414\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-150.png\" alt=\"\" class=\"wp-image-460\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-150.png 436w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-150-300x285.png 300w\" sizes=\"auto, (max-width: 436px) 100vw, 436px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vi er nu i et nyt vindue med en oversigt over reglerne<\/li>\n\n\n\n<li>Den regel, der lige er oprettet, er selvf\u00f8lgelig den eneste regel (1)\n<ul class=\"wp-block-list\">\n<li>Forrest formlen<\/li>\n\n\n\n<li>N\u00e6ste trin viser resultatet, hvis formlen er sand<\/li>\n\n\n\n<li>Og s\u00e5 vises det omr\u00e5de, som den g\u00e6lder i (= hele tabellen undtagen overskrifterne)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>For at se resultatet, klik p\u00e5 knappen Udf\u00f8r (Apply) (2). S\u00e5 ser du, hvad der sker (3), men du lukker ikke vinduet<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"323\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-151-1024x323.png\" alt=\"\" class=\"wp-image-461\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-151-1024x323.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-151-300x95.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-151-768x242.png 768w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-151.png 1166w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vi mangler stadigv\u00e6k et par regler til at farve celler mellem 100 og 200 gule, og dem p\u00e5 og under 100 r\u00f8de\n<ul class=\"wp-block-list\">\n<li>Klik p\u00e5 knappen Ny regel (New rule) (1)<\/li>\n\n\n\n<li>En-efter-en indtast reglerne, s\u00e5 vi ender med at have regler for alle 3 farver\n<ul class=\"wp-block-list\">\n<li>Vi har i forvejen =&nbsp; $G4 &gt; 200, gul farve<\/li>\n\n\n\n<li>=&nbsp; $G4 &gt; 100, gul farve<\/li>\n\n\n\n<li>= $G4 &lt;= 100, r\u00f8d farve<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Der er knapper til at redigere regler, slette regler samt flytte reglerne op og ned i r\u00e6kkef\u00f8lgen.<br>BEM\u00c6RK: Den l\u00e6ser nedefra. Hvis 2 regler d\u00e6kker det samme omr\u00e5de, s\u00e5 bestemmer den \u00f8verste over den nederste. Den gr\u00f8nne regel som d\u00e6kker &gt; 200 vil bestemme over den gule, der d\u00e6kker &gt; 100. Heldigvis, for det er det lige det, jeg \u00f8nsker<\/li>\n\n\n\n<li>Resultatet ser du tv. (4)<\/li>\n\n\n\n<li>Undervejs klik p\u00e5 Apply (5) for at se resultatet uden at lukke vinduet samt OK (6) for til sidst at lukke vinduet, n\u00e5r du er tilfreds med resultatet.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"813\" height=\"410\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-152.png\" alt=\"\" class=\"wp-image-462\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-152.png 813w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-152-300x151.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-152-768x387.png 768w\" sizes=\"auto, (max-width: 813px) 100vw, 813px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Opgaver-3\"><\/span>Opgaver<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"31_Betinget_formatering\"><\/span><strong>3.1 Betinget formatering<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Pr\u00f8v vejledningen af<\/li>\n\n\n\n<li>Ekstra: Leg med mulighederne uden formler under Betinget formatering<\/li>\n\n\n\n<li>Ekstra: Pr\u00f8v i sorteringen at sortere tabellen efter farve, det kan den godt<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/\">toppen af siden<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Formlen &#8220;hvis&#8221; samt &#8220;hvis-i-hvis&#8221; Excel har 1.000-vis af foruddefinerede formler. En af de mest brugte er &#8220;Hvis&#8221; eller &#8220;If&#8221; p\u00e5 engelsk.&nbsp; Link til toppen af siden. Bonusberegning med Hvis-formlen&nbsp; Link til toppen af siden. Hvis-i-hvis&nbsp; =IF(B2 &lt; 100;0;B2 * 5%)&nbsp; IF (B2 &lt; 110; B2 * 5%; B2*10%)&nbsp; Link til toppen af siden. Opgaver&nbsp; &hellip; <a href=\"https:\/\/bliv-klogere.dk\/index.php\/5-formler\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">5. Formler<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-464","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages\/464","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/comments?post=464"}],"version-history":[{"count":3,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages\/464\/revisions"}],"predecessor-version":[{"id":1417,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages\/464\/revisions\/1417"}],"wp:attachment":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/media?parent=464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}