{"id":122399,"date":"2022-01-18T09:06:32","date_gmt":"2022-01-18T07:06:32","guid":{"rendered":"https:\/\/learnesy.com\/?p=122399"},"modified":"2022-01-18T12:07:56","modified_gmt":"2022-01-18T10:07:56","slug":"vi-kombinerar-om-funktioner","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/vi-kombinerar-om-funktioner\/","title":{"rendered":"Vi kombinerar OM-funktioner"},"content":{"rendered":"<p>I denna veckas lektion ska vi kombinera en v\u00e4lanv\u00e4nd funktion i Excel, OM-funktionen. =OM(N\u00e5gonting \u00e4r Sant, g\u00f6r d\u00e5 s\u00e5 h\u00e4r, g\u00f6r annars n\u00e5got annat).<\/p>\n<p><strong>Kombinera OM med OCH\/ELLER f\u00f6r flera villkor<\/strong><\/p>\n<ul>\n<li>OCH-funktionen anv\u00e4nds om vi vill se om flera villkor \u00e4r sanna.<\/li>\n<li>ELLER-funktionen anv\u00e4nder vi f\u00f6r att se om ett av flera villkor \u00e4r sanna.<\/li>\n<\/ul>\n<p>Lektionen \u00e4r h\u00e4mtad fr\u00e5n kursen <a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\">Excelfunktioner F\u00f6rdjupning<\/a> &#8211; En kurs som g\u00e5r genom \u00f6ver 100 funktioner i Excel.<\/p>\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/185009512?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><strong><span dir=\"ltr\" role=\"presentation\">Denna lektion kommer att g\u00e5 igenom hur man kan anv\u00e4nda OCH-funktionen. <\/span><\/strong><span dir=\"ltr\" role=\"presentation\">Den anv\u00e4nds inom en OM-funktion, och returv\u00e4rdet blir SANT endast om <\/span><span dir=\"ltr\" role=\"presentation\">alla givna villkor \u00e4r sanna. <\/span><span dir=\"ltr\" role=\"presentation\">Vi kommer ocks\u00e5 att ta en titt p\u00e5 ELLER funktionen, vars returv\u00e4rde blir <\/span><span dir=\"ltr\" role=\"presentation\">SANT om en eller fler villkor \u00e4r sanna. <\/span><span dir=\"ltr\" role=\"presentation\">OCH funktionen har tv\u00e5 argument: de tv\u00e5 villkoren som ska verifieras. <\/span><span dir=\"ltr\" role=\"presentation\">I v\u00e5rt exempel kommer vi att se om v\u00e4rdena i b\u00e5de B8 och B9 \u00e4r st\u00f6rre <\/span><span dir=\"ltr\" role=\"presentation\">\u00e4n 10. <\/span><span dir=\"ltr\" role=\"presentation\">Vi skriver in Lika med, OM, och b\u00f6rjar OCH funktionen inom OM-<\/span><span dir=\"ltr\" role=\"presentation\">funktionen. <\/span><span dir=\"ltr\" role=\"presentation\">Vi skriver in v\u00e5ra tv\u00e5 villkor \u201dS\u201d om det \u00e4r SANT, och \u201dF\u201d om det \u00e4r <\/span><span dir=\"ltr\" role=\"presentation\">FALSKT. <\/span><span dir=\"ltr\" role=\"presentation\">Slutresultatet \u00e4r falskt, eftersom b\u00e5da villkoren m\u00e5ste anses vara sanna <\/span><span dir=\"ltr\" role=\"presentation\">f\u00f6r att returv\u00e4rdet ska vara SANT. <\/span><span dir=\"ltr\" role=\"presentation\">ELLER funktionen \u00e4r lik OCH funktionen, f\u00f6rutom att endast ett argument <\/span><span dir=\"ltr\" role=\"presentation\">m\u00e5ste vara sant f\u00f6r returv\u00e4rdet att vara sant. <\/span><span dir=\"ltr\" role=\"presentation\">Vi g\u00e5r in i funktionen, och ers\u00e4tter OCH med ELLER. S\u00e5 ser vi att <\/span><span dir=\"ltr\" role=\"presentation\">returv\u00e4rdet har nu blivit SANT.<\/span><\/p>\n<p>N\u00e4sta vecka ska vi se \u00f6ver cellreferenser och hur vi hanterar dem. Vi ses d\u00e5!<\/p>\n<p><em>Kom ih\u00e5g att f\u00f6lja oss p\u00e5 <a href=\"https:\/\/www.linkedin.com\/company\/learnesy\">Linkedin<\/a> &#8211; F\u00f6r mer kunskap i fl\u00f6det!<\/em><\/p>\n<p>Dela g\u00e4rna inl\u00e4gget via n\u00e5gon av de kopplade medierna nedan!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I denna veckas lektion ska vi kombinera en v\u00e4lanv\u00e4nd funktion i Excel, OM-funktionen. =OM(N\u00e5gonting \u00e4r Sant, g\u00f6r d\u00e5 s\u00e5 h\u00e4r, g\u00f6r annars n\u00e5got annat). Kombinera OM med OCH\/ELLER f\u00f6r flera villkor OCH-funktionen anv\u00e4nds om vi [&hellip;]<\/p>\n","protected":false},"author":41201,"featured_media":122825,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[74,65,255,300,299],"class_list":["post-122399","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-excel-3","tag-excelkurs","tag-funktioner","tag-och-eller","tag-om-funktioner"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/122399","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\/41201"}],"replies":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/comments?post=122399"}],"version-history":[{"count":14,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/122399\/revisions"}],"predecessor-version":[{"id":122921,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/122399\/revisions\/122921"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/122825"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=122399"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=122399"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=122399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}