{"id":335911,"date":"2024-05-07T10:49:18","date_gmt":"2024-05-07T09:49:18","guid":{"rendered":"https:\/\/learnesy.com\/?p=335911"},"modified":"2024-05-07T13:29:17","modified_gmt":"2024-05-07T12:29:17","slug":"veckans-exceltips-xletaupp","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/veckans-exceltips-xletaupp\/","title":{"rendered":"Veckans Exceltips: XLETAUPP \ud83d\udd0d"},"content":{"rendered":"<p><em>Se veckans Exceltips och l\u00e4r dig mer om XLETAUPP \u2013 funktionen som var menad att ers\u00e4tta LETARAD. Lektionen kommer fr\u00e5n v\u00e5r grundkurs <a href=\"https:\/\/learnesy.com\/sv\/courses\/excelkurs-bas\/\">Excelkurs Bas<\/a>. Vill du l\u00e4ra dig mer om XLETAUPP eller l\u00e4ra dig fler Excelfunktioner? Bes\u00f6k d\u00e5 v\u00e5rt <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/\">funktionsbibliotek<\/a>.<\/em><\/p>\n<p>For v\u00e5re norske brukere \ud83d\udc49 <a href=\"https:\/\/learnesy.com\/no\/ukas-exceltips-xoppslag\/\">https:\/\/learnesy.com\/no\/ukas-exceltips-xoppslag\/<\/a><\/p>\n<hr \/>\n<span id=\"heading-vad-ar-xletaupp\"><h2>Vad \u00e4r XLETAUPP?<\/h2><\/span>\n<p>En av de nyare funktionerna i Excel \u00e4r XLETAUPP. Funktionen XLETAUPP \u00e4r mycket lik LETARAD och LETAKOLUMN, men till skillnad beh\u00f6ver vi inte ange ett indexv\u00e4rde f\u00f6r kolumner eller rader d\u00e4r vi h\u00e4mtar v\u00e4rdet ifr\u00e5n, utan vi anger ett omr\u00e5de. Vi beh\u00f6ver inte heller ha v\u00e4rdet vi letar upp l\u00e4ngst till v\u00e4nster eller h\u00f6gst upp, vilket g\u00f6r att funktionen \u00e4r mer flexibel.<\/p>\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/943573640?dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media\"><\/iframe><\/div>\n<p>Vi ska i det h\u00e4r exemplet ta reda p\u00e5 skattesatsen och gruppen f\u00f6r en inkomst vi anger i cell F2. Vi g\u00e5r till cell H2 och skriver in XLETAUPP funktionen. Det f\u00f6rsta argumentet \u00e4r v\u00e4rdet vi letar upp, s\u00e5 vi markerar cellen d\u00e4r vi anger inkomst. N\u00e4sta argument \u00e4r omr\u00e5det d\u00e4r vi letar, och h\u00e4r anger vi cell C2 till C9. Vi g\u00e5r vidare och anger nu omr\u00e5det som funktionen returnerar v\u00e4rden fr\u00e5n, vilket i v\u00e5rt fall \u00e4r alla celler i kolumn A och B.<\/p>\n<p>Vi \u00e4r nu klara med alla argument som beh\u00f6vs f\u00f6r en XLETAUPP funktion, men som vi ser kan vi \u00e4ven ange ytterligare argument. Den f\u00f6rsta \u00e4r v\u00e4rdet som returneras om vi inte hittar v\u00e4rdet vi letar upp. Vi skriver noll h\u00e4r. Som n\u00e4sta skriver vi 1 f\u00f6r exakt matchning, och ifall det inte finns returneras n\u00e4sta st\u00f6rre v\u00e4rde i listan. I sista argumentet skriver vi ocks\u00e5 1 f\u00f6r att s\u00f6ka fr\u00e5n f\u00f6rsta till sista. Vi \u00e4r nu klara med v\u00e5r XLETAUPP funktion s\u00e5 vi klickar p\u00e5 Enter och skriver in en inkomst p\u00e5 36 000 dollar och ser att XLETAUPP funktionen returnerar den r\u00e4tta skattesatsen och skattegruppen.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Se veckans Exceltips!<\/p>\n","protected":false},"author":54291,"featured_media":335954,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[],"class_list":["post-335911","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/335911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/users\/54291"}],"replies":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/comments?post=335911"}],"version-history":[{"count":3,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/335911\/revisions"}],"predecessor-version":[{"id":336026,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/335911\/revisions\/336026"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/335954"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=335911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=335911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=335911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}