{"id":125481,"date":"2021-12-10T14:50:06","date_gmt":"2021-12-10T12:50:06","guid":{"rendered":"https:\/\/learnesy.com\/excelfunktioner\/slump-mellan\/"},"modified":"2023-05-16T10:09:54","modified_gmt":"2023-05-16T09:09:54","slug":"slump-mellan","status":"publish","type":"excel-functions","link":"https:\/\/learnesy.com\/sv\/excelfunktioner\/slump-mellan\/","title":{"rendered":"SLUMP.MELLAN"},"content":{"rendered":"\n<p><em>Se \u00e4ven:<\/em> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/slump-mellan\/\">SLUMP.MELLAN<\/a> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/slumpmatris\/\">SLUMPMATRIS<\/a> |<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-vimeo wp-block-embed-vimeo wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/185011937?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<\/div><figcaption class=\"wp-element-caption\"><em>Den h\u00e4r lektionen och m\u00e5nga fler hittar man i v\u00e5r kurs <a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\" data-type=\"sfwd-courses\" data-id=\"736\">Excelfunktioner F\u00f6rdjupning<\/a>!<\/em><\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Sammanfattning<\/h2>\n\n\n\n<p>SLUMP.MELLAN \u00e4r en Excel-funktion som returnerar ett slumpm\u00e4ssigt heltal mellan tv\u00e5 givna tal. SLUMP.MELLAN ber\u00e4knas om varje g\u00e5ng ett kalkylblad \u00f6ppnas eller \u00e4ndras, precis som den n\u00e4rbesl\u00e4ktade funktionen <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/slump\/\" data-type=\"excel-functions\" data-id=\"125498\">SLUMP<\/a>. <\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>Syfte<\/strong><br>F\u00e5 ett slumpm\u00e4ssigt heltal mellan tv\u00e5 angivna tal <em>a<\/em> och <em>b<\/em> i ett intervall.<\/p>\n\n\n\n<p><strong>Argument<\/strong><br><em>nedre \u2013 <\/em>Ett heltal som representerar intervallets nedre v\u00e4rde.<br><em>\u00f6vre \u2013 <\/em>Ett heltal som representerar intervallets \u00f6vre v\u00e4rde.<\/p>\n\n\n\n<p><strong>Returv\u00e4rde<\/strong><br>Ett heltal st\u00f6rre eller lika med a och mindre eller lika med b. <\/p>\n\n\n\n<p><strong>Syntax<\/strong><br>=SLUMP.MELLAN(nedre;\u00f6vre)<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Hur anv\u00e4nds funktionen SLUMP.MELLAN i Excel?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 1 \u2013 grundl\u00e4ggande anv\u00e4ndning<\/h3>\n\n\n\n<p>Nedan f\u00f6ljer tv\u00e5 grundl\u00e4ggande exempel av anv\u00e4ndandet av funktionen SLUMP.MELLAN: <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SLUMP.MELLAN(1;10)<\/pre>\n\n\n\n<p>returnerar ett slumpm\u00e4ssigt heltal mellan 1 och 10, och <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SLUMP.MELLAN(-231;0)<\/pre>\n\n\n\n<p>returnerar ett slumpm\u00e4ssigt heltal mellan -231 och 0, t ex -29. <\/p>\n\n\n\n<p>Notera att funktionen bara tar emot sifferv\u00e4rden eller celler inneh\u00e5llande tal. Funktionen tar emot decimaltal, men kommer alltid returnera ett heltal. Exemplet nedan<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SLUMP.MELLAN(1,1;5)<\/pre>\n\n\n\n<p>kommer returnera heltalen 2 till 5. <\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 2 \u2013 slumpm\u00e4ssiga klockslag f\u00f6r ett givet intervall<\/h3>\n\n\n\n<p>Med SLUMP.MELLAN kan man generera slumpm\u00e4ssiga klockslag inom ett givet intervall. I exemplet nedan ses formeln f\u00f6r detta. H\u00e4r anv\u00e4nds funktionerna SLUMP.MELLAN och <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/datum-och-klockslag\/\">KLOCKSLAG<\/a>. Notera att v\u00e4rdet 10 000 anv\u00e4nds f\u00f6r att multiplicera och dividera. Detta p\u00e5 grund av formateringssk\u00e4l. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"891\" height=\"527\" src=\"\/wp-content\/uploads\/2021\/12\/excel-slumpmellan-1.png\" alt=\"Den h\u00e4r bilden visar anv\u00e4ndandet av funktionen SLUMP.MELLAN i Excel. I det h\u00e4r fallet genereras slumpm\u00e4ssiga klockslag. \" class=\"wp-image-237060\" srcset=\"\/wp-content\/uploads\/2021\/12\/excel-slumpmellan-1.png 891w, \/wp-content\/uploads\/2021\/12\/excel-slumpmellan-1-300x177.png 300w, \/wp-content\/uploads\/2021\/12\/excel-slumpmellan-1-768x454.png 768w\" sizes=\"auto, (max-width: 891px) 100vw, 891px\" \/><figcaption class=\"wp-element-caption\"><em>Exempel 2: i exemplet ser vi hur slumpm\u00e4ssiga klockslag i intervallet 09:00-15:30 har genererats. <\/em><\/figcaption><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 3 \u2013 slumpm\u00e4ssiga arbetsdagar f\u00f6r ett givet intervall<\/h3>\n\n\n\n<p>En anv\u00e4ndning f\u00f6r SLUMP.MELLAN i Excel kan vara att slumpa fram datum. I exemplet nedan anv\u00e4nds funktionerna <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/arbetsdagar\/\" data-type=\"excel-functions\" data-id=\"126635\">ARBETSDAGAR<\/a>, <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/datum-och-klockslag\/\" data-type=\"excel-functions\" data-id=\"125469\">DATUM<\/a> och SLUMP.MELLAN f\u00f6r att generera slumpm\u00e4ssiga arbetsdagar. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"893\" height=\"527\" src=\"\/wp-content\/uploads\/2023\/05\/excel-slumpmellan-2.png\" alt=\"\" class=\"wp-image-237067\" srcset=\"\/wp-content\/uploads\/2023\/05\/excel-slumpmellan-2.png 893w, \/wp-content\/uploads\/2023\/05\/excel-slumpmellan-2-300x177.png 300w, \/wp-content\/uploads\/2023\/05\/excel-slumpmellan-2-768x453.png 768w\" sizes=\"auto, (max-width: 893px) 100vw, 893px\" \/><figcaption class=\"wp-element-caption\"><em>Exempel 2: i det h\u00e4r exemplet erh\u00e5lls slumpade arbetsdagar i intervallet 2023-04-01 \u2013 2023-05-31.<\/em><\/figcaption><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 4 \u2013 v\u00e4lj ett antal slumpm\u00e4ssiga v\u00e4rden<\/h3>\n\n\n\n<p>Med funktionerna SLUMP.MELLAN och <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/passa-index-valj\/\" data-type=\"excel-functions\" data-id=\"125172\">V\u00c4LJ<\/a> kan man v\u00e4lja ett antal slumpm\u00e4ssiga v\u00e4rden. Hur m\u00e5nga beror p\u00e5 det \u00f6vre intervallet i funktionen SLUMP.MELLAN. I exemplet nedan v\u00e4ljs 4 slumpm\u00e4ssiga namn utifr\u00e5n 4 stycken namn. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"711\" src=\"\/wp-content\/uploads\/2023\/05\/excel-slumpmellan-3-1024x711.png\" alt=\"\" class=\"wp-image-237073\" srcset=\"\/wp-content\/uploads\/2023\/05\/excel-slumpmellan-3-1024x711.png 1024w, \/wp-content\/uploads\/2023\/05\/excel-slumpmellan-3-300x208.png 300w, \/wp-content\/uploads\/2023\/05\/excel-slumpmellan-3-768x533.png 768w, \/wp-content\/uploads\/2023\/05\/excel-slumpmellan-3.png 1037w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Exempel 4: h\u00e4r tilldelas slumpm\u00e4ssiga namn till cellerna AD7-AD12. <\/em><\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Mer om funktionen SLUMP.MELLAN<\/h2>\n\n\n\n<p>SLUMP.MELLAN \u00e4r en volatil eller r\u00f6rlig funktion som hela tiden kalkyleras p\u00e5 nytt. Detta kan orsaka prestandaproblem i stora eller komplexa kalkylblad, varf\u00f6r det \u00e4r b\u00e4ttre att kopiera slumptalen och klistra in som statiska v\u00e4rden. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Bra att veta om SLUMP.MELLAN-funktionen<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Funktionen SLUMP.MELLAN tar tv\u00e5 argument.<\/li>\n\n\n\n<li>Liksom funktionen SLUMP, s\u00e5 kalkyleras SLUMP.MELLAN om varje g\u00e5ng ett kalkylblad \u00f6ppnas eller \u00e4ndras.<\/li>\n\n\n\n<li>I Excel 365 \u00e4r <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/slumpmatris\/\">SLUMPMATRIS<\/a>-funktionen ett annat s\u00e4tt att generera flera slumptal och att generera slumptal mellan tv\u00e5 v\u00e4rden.<\/li>\n\n\n\n<li>SLUMP.MELLAN returnerar heltal. Anv\u00e4nd SLUMP-funktionen f\u00f6r att returnera slumpm\u00e4ssiga decimalv\u00e4rden.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Mer l\u00e4sning<\/h3>\n\n\n\n<p>Man l\u00e4r sig mer om SLUMP.MELLAN-funktionen i v\u00e5r kurs\u00a0<a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\" data-type=\"sfwd-courses\" data-id=\"736\">Excelfunktioner F\u00f6rdjupning<\/a>!<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Har du en fr\u00e5ga eller vill l\u00e4ra dig mer om funktionen? Bes\u00f6k d\u00e5 v\u00e5rt\u00a0<a href=\"https:\/\/learnesy.com\/sv\/forums\/excel\/\">forum<\/a>\u00a0eller v\u00e5r\u00a0<a href=\"https:\/\/learnesy.com\/sv\/resursbank\/\">resursbank<\/a>.<\/li>\n\n\n\n<li>Vill du har fler Exceltips? P\u00e5 Learnesys&nbsp;<a href=\"https:\/\/learnesy.com\/sv\/blogg\/\">blogg<\/a>&nbsp;hittar du massvis av tips! Eller, prenumerera p\u00e5 v\u00e5rt&nbsp;<a href=\"https:\/\/learnesy.com\/newsletter\/\">nyhetsbrev<\/a>.<\/li>\n\n\n\n<li><a href=\"https:\/\/learnesy.com\/sv\/courses\/\">Till v\u00e5ra kurssidor \u2192<\/a><\/li>\n<\/ul>\n","protected":false},"featured_media":0,"menu_order":0,"template":"","excel_function_category":[308],"class_list":["post-125481","excel-functions","type-excel-functions","status-publish","hentry","excel_function_category-statistiska-funktioner-sv"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel-functions\/125481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel-functions"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/excel-functions"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=125481"}],"wp:term":[{"taxonomy":"excel_function_category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel_function_category?post=125481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}