{"id":10453,"date":"2025-07-15T13:34:49","date_gmt":"2025-07-15T13:34:49","guid":{"rendered":"https:\/\/functiontranslator.com\/ifs\/"},"modified":"2021-02-26T05:11:16","modified_gmt":"2021-02-26T05:11:16","slug":"ifs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pl\/ifs\/","title":{"rendered":"IFS,"},"content":{"rendered":"

Funkcja IFS<\/strong> w Microsoft Excel oraz Arkuszach Google zapewnia mo\u017cliwo\u015b\u0107 przeprowadzenia serii test\u00f3w warunkowych, zwracaj\u0105c warto\u015b\u0107 dla pierwszego testu, kt\u00f3ry spe\u0142nia kryterium prawdy (PRAWDA). Jest to szczeg\u00f3lnie u\u017cyteczne, gdy wymagane jest sprawdzenie kilku warunk\u00f3w r\u00f3wnocze\u015bnie.<\/p>\n

Sk\u0142adnia i Przyk\u0142ady<\/h2>\n

Sk\u0142adnia funkcji IFS<\/code> jest przedstawiona w nast\u0119puj\u0105cy spos\u00f3b:<\/p>\n

IFS(warunek1, warto\u015b\u01071, [warunek2, warto\u015b\u01072], ...)<\/code><\/pre>\n
Elementy sk\u0142adni funkcji to:<\/p>\n
    \n
  • warunek1, warunek2, ...<\/code> – serie test\u00f3w logicznych, kt\u00f3re musz\u0105 zwr\u00f3ci\u0107 warto\u015b\u0107 PRAWDA lub FA\u0141SZ.<\/li>\n
  • warto\u015b\u01071, warto\u015b\u01072, ...<\/code> – warto\u015bci zwracane, gdy odpowiadaj\u0105ce im warunki zostan\u0105 spe\u0142nione.<\/li>\n<\/ul>\n
    Przyk\u0142ad 1:<\/strong> Przyjmijmy, \u017ce chcesz oceni\u0107 wynik testu ucznia i przypisa\u0107 ocen\u0119 zgodnie z poni\u017csz\u0105 skal\u0105 punktow\u0105:<\/p>\n\n\n\n\n\n\n
    Punkty<\/th>\nOcena<\/th>\n<\/tr>\n
    >= 90<\/td>\n5.0<\/td>\n<\/tr>\n
    >= 80<\/td>\n4.0<\/td>\n<\/tr>\n
    >= 70<\/td>\n3.0<\/td>\n<\/tr>\n
    < 70<\/td>\n2.0<\/td>\n<\/tr>\n<\/table>\n
    =IFS(A1 >= 90, \"5.0\", A1 >= 80, \"4.0\", A1 >= 70, \"3.0\", TRUE, \"2.0\")<\/code><\/pre>\n
    Zastosowania praktyczne<\/h2>\n
    Zadanie 1: Okre\u015blanie priorytet\u00f3w zada\u0144<\/strong><\/p>\n
    Dzi\u0119ki funkcji IFS<\/code>, mo\u017cesz automatycznie przypisa\u0107 priorytet zadaniom bazuj\u0105c na ich pilno\u015bci:<\/p>\n
    =IFS(B1=\"Wysoka\", \"Natychmiastowy\", B1=\"\u015arednia\", \"Standardowy\", B1=\"Niska\", \"Niski priorytet\")<\/code><\/pre>\n
    W powy\u017cszym przyk\u0142adzie, warto\u015b\u0107 w kom\u00f3rce B1 decyduje o przypisaniu odpowiedniego priorytetu.<\/p>\n
    Zadanie 2: Automatyczna kategoryzacja wiekowa<\/strong><\/p>\n
    U\u017cywaj\u0105c funkcji IFS<\/code>, mo\u017cesz automatycznie przydzieli\u0107 kategorie wiekowe osobom w bazie danych:<\/p>\n
    =IFS(C1 >= 60, \"Senior\", C1 >= 30, \"Doros\u0142y\", C1 >= 18, \"M\u0142ody doros\u0142y\", TRUE, \"M\u0142odzie\u017c\")<\/code><\/pre>\n
    W tym przypadku osoba w wieku 60 lat i starsza zostanie zaklasyfikowana jako „Senior”, a osoby w odpowiednich przedzia\u0142ach wiekowych otrzymaj\u0105 swoje kategorie.<\/p>\n
    Funkcja IFS<\/code> w Excelu oraz Arkuszach Google to doskona\u0142e narz\u0119dzie do efektywnego zarz\u0105dzania scenariuszami wymagaj\u0105cymi sprawdzania wielu warunk\u00f3w, co umo\u017cliwia szybkie i skuteczne podejmowanie decyzji opartych na danych.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Sprawdza, czy spe\u0142niono jeden lub wi\u0119cej warunk\u00f3w, i zwraca warto\u015b\u0107 odpowiadaj\u0105c\u0105 pierwszemu warunkowi ocenionemu jako PRAWDA<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[426],"tags":[],"class_list":["post-10453","post","type-post","status-publish","format-standard","hentry","category-logiczne"],"acf":[],"yoast_head":"\nFunkcja IFS (IFS,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia<\/title>\n<meta name=\"description\" content=\"Opis funkcji IFS (IFS,) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/pl\/ifs\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkcja IFS (IFS,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia\" \/>\n<meta property=\"og:description\" content=\"Opis funkcji IFS (IFS,) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pl\/ifs\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T05:11:16+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkcja IFS (IFS,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Szacowany czas czytania\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuta\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pl\/ifs\/\",\"url\":\"https:\/\/functiontranslator.com\/pl\/ifs\/\",\"name\":\"Funkcja IFS (IFS,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:49+00:00\",\"dateModified\":\"2021-02-26T05:11:16+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcji IFS (IFS,) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pl\/ifs\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pl\/ifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pl\/ifs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkcje programu Excel\",\"item\":\"https:\/\/functiontranslator.com\/pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Logiczne\",\"item\":\"https:\/\/functiontranslator.com\/pl\/logiczne\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"IFS,\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/pl\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funkcja IFS (IFS,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","description":"Opis funkcji IFS (IFS,) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/pl\/ifs\/","og_locale":"pl_PL","og_type":"article","og_title":"Funkcja IFS (IFS,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","og_description":"Opis funkcji IFS (IFS,) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.","og_url":"https:\/\/functiontranslator.com\/pl\/ifs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:49+00:00","article_modified_time":"2021-02-26T05:11:16+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkcja IFS (IFS,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","twitter_misc":{"Napisane przez":"glavadmin","Szacowany czas czytania":"1 minuta"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pl\/ifs\/","url":"https:\/\/functiontranslator.com\/pl\/ifs\/","name":"Funkcja IFS (IFS,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:49+00:00","dateModified":"2021-02-26T05:11:16+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcji IFS (IFS,) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pl\/ifs\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pl\/ifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pl\/ifs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkcje programu Excel","item":"https:\/\/functiontranslator.com\/pl\/"},{"@type":"ListItem","position":2,"name":"Logiczne","item":"https:\/\/functiontranslator.com\/pl\/logiczne\/"},{"@type":"ListItem","position":3,"name":"IFS,"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pl-PL"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/pl\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts\/10453","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/comments?post=10453"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts\/10453\/revisions"}],"predecessor-version":[{"id":27768,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts\/10453\/revisions\/27768"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/media?parent=10453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/categories?post=10453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/tags?post=10453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}