{"id":15474,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/sangercek\/"},"modified":"2021-02-25T16:29:13","modified_gmt":"2021-02-25T16:29:13","slug":"imreal","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/imreal\/","title":{"rendered":"SANGER\u00c7EK"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, b\u00fcy\u00fck veri k\u00fcmesi \u00fczerinde \u00e7al\u0131\u015fmay\u0131 kolayla\u015ft\u0131ran \u00e7e\u015fitli fonksiyonlarla donat\u0131lm\u0131\u015f iki geli\u015fmi\u015f elektronik tablo program\u0131d\u0131r. Bu makalede, “IMREAL” fonksiyonu (T\u00fcrk\u00e7e kar\u015f\u0131l\u0131\u011f\u0131 “SANGER\u00c7EK”) \u00fczerine odaklanaca\u011f\u0131z. Bu fonksiyon, karma\u015f\u0131k bir say\u0131n\u0131n ger\u00e7ek k\u0131sm\u0131n\u0131 elde etmenize imkan tan\u0131r. Detaylar, \u00f6rnekler ve pratik kullan\u0131m senaryolar\u0131 ile bu fonksiyonu ayr\u0131nt\u0131l\u0131 olarak inceleyece\u011fiz.<\/p>\n

SANGER\u00c7EK Fonksiyonunun S\u00f6zdizimi<\/h2>\n
SANGER\u00c7EK(kompleks_say\u0131)<\/code><\/pre>\n
kompleks_say\u0131<\/code> – Ger\u00e7ek k\u0131sm\u0131n\u0131 \u00e7\u0131karmak istedi\u011finiz karma\u015f\u0131k say\u0131d\u0131r. Bu arg\u00fcman metin format\u0131nda olmal\u0131; \u00f6rne\u011fin “3+4i” veya “5-2i” gibi.<\/p>\n
\u00d6rnek:<\/strong><\/p>\n
=SANGER\u00c7EK(\"3+4i\")<\/code><\/pre>\n
Bu form\u00fcl, 3 sonucunu d\u00f6nd\u00fcr\u00fcr.<\/p>\n
Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
SANGER\u00c7EK fonksiyonu, \u00f6zellikle m\u00fchendislik ve fizik gibi alanlarda karma\u015f\u0131k say\u0131larla \u00e7al\u0131\u015f\u0131rken olduk\u00e7a faydal\u0131d\u0131r. \u0130\u015fte bu fonksiyonun kullan\u0131labilece\u011fi birka\u00e7 pratik uygulama:<\/p>\n
\u00c7al\u0131\u015fma Senaryosu 1: Elektrik Devre Analizi<\/h2>\n
Elektronikte, devre elemanlar\u0131n\u0131n empedanslar\u0131 s\u0131kl\u0131kla karma\u015f\u0131k say\u0131larla ifade edilir. Gerilim ve ak\u0131m dalgalar\u0131 aras\u0131ndaki faz fark\u0131n\u0131 hesaplarken, ger\u00e7ek k\u0131s\u0131mlar\u0131n bilinmesi gereklidir.<\/p>\n
\u00d6rnek Devre Empedans\u0131: \"50+30i\" ohm Gerilim: \"120-40i\" volt<\/code><\/pre>\n
Karma\u015f\u0131k say\u0131n\u0131n ger\u00e7ek k\u0131sm\u0131n\u0131 hesaplamak i\u00e7in:<\/p>\n
=SANGER\u00c7EK(\"50+30i\")<\/code><\/pre>\n
Bu form\u00fcl, empedans\u0131n ger\u00e7ek k\u0131sm\u0131 olan 50 sonucunu d\u00f6nd\u00fcr\u00fcr.<\/p>\n
\u00c7al\u0131\u015fma Senaryosu 2: Sinyal \u0130\u015fleme<\/h2>\n
Sinyal i\u015flemede, \u00e7e\u015fitli dijital filtreler tasarlan\u0131rken karma\u015f\u0131k say\u0131lar kullan\u0131labilir. Filtrenin belirli bir frekansta ger\u00e7ek tepkisini analiz etmek isteyebilirsiniz.<\/p>\n
\u00d6rnek Filtre Katsay\u0131s\u0131: \"0.33+0.44i\"<\/code><\/pre>\n
Ger\u00e7ek tepkiyi hesaplamak i\u00e7in:<\/p>\n
=SANGER\u00c7EK(\"0.33+0.44i\")<\/code><\/pre>\n
Bu \u00f6rnekte fonksiyon, filtrenin ger\u00e7ek k\u0131sm\u0131n\u0131 yans\u0131tan 0.33 sonucunu d\u00f6nd\u00fcr\u00fcr.<\/p>\n
Makalemizde sunulan \u00f6rnekler, SANGER\u00c7EK fonksiyonunun karma\u015f\u0131k say\u0131lar\u0131n ger\u00e7ek k\u0131s\u0131mlar\u0131n\u0131 \u00e7\u0131karmak i\u00e7in nas\u0131l kullan\u0131labilece\u011fini g\u00f6stermektedir. M\u00fchendislikten finansa kadar \u00e7e\u015fitli alanlarda uygulanabilir olan bu fonksiyon, verilerle daha etkin \u00e7al\u0131\u015fman\u0131za yard\u0131mc\u0131 olacak g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
Karma\u015f\u0131k bir say\u0131n\u0131n ger\u00e7ek katsay\u0131s\u0131n\u0131 verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[583],"tags":[],"class_list":["post-15474","post","type-post","status-publish","format-standard","hentry","category-muhendislik"],"acf":[],"yoast_head":"\nExcel'de IMREAL (SANGER\u00c7EK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da IMREAL (SANGER\u00c7EK) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\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\/tr\/imreal\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de IMREAL (SANGER\u00c7EK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da IMREAL (SANGER\u00c7EK) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/imreal\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:29:13+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de IMREAL (SANGER\u00c7EK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/imreal\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/imreal\/\",\"name\":\"Excel'de IMREAL (SANGER\u00c7EK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:29:13+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da IMREAL (SANGER\u00c7EK) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/imreal\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/imreal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/imreal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"M\u00fchendislik\",\"item\":\"https:\/\/functiontranslator.com\/tr\/muhendislik\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SANGER\u00c7EK\"}]},{\"@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\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@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\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de IMREAL (SANGER\u00c7EK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da IMREAL (SANGER\u00c7EK) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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\/tr\/imreal\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de IMREAL (SANGER\u00c7EK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da IMREAL (SANGER\u00c7EK) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/imreal\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:29:13+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de IMREAL (SANGER\u00c7EK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/imreal\/","url":"https:\/\/functiontranslator.com\/tr\/imreal\/","name":"Excel'de IMREAL (SANGER\u00c7EK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:29:13+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da IMREAL (SANGER\u00c7EK) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/imreal\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/imreal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/imreal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"M\u00fchendislik","item":"https:\/\/functiontranslator.com\/tr\/muhendislik\/"},{"@type":"ListItem","position":3,"name":"SANGER\u00c7EK"}]},{"@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":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@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\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15474","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15474"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15474\/revisions"}],"predecessor-version":[{"id":26742,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15474\/revisions\/26742"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15474"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15474"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}