{"id":15480,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/santopla\/"},"modified":"2021-02-25T16:29:25","modified_gmt":"2021-02-25T16:29:25","slug":"imsub","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/imsub\/","title":{"rendered":"SANTOPLA"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, matematiksel ve istatistiksel hesaplamalar\u0131 kolayla\u015ft\u0131ran \u00e7e\u015fitli fonksiyonlar sa\u011flar. Bu fonksiyonlardan biri olan IMSUB, iki karma\u015f\u0131k say\u0131y\u0131 birbirinden \u00e7\u0131kartmay\u0131 sa\u011flar. Bu makalede, IMSUB fonksiyonunun kullan\u0131m\u0131na dair detayl\u0131 bilgiler ve \u00f6rnekler sunulacakt\u0131r.<\/p>\n

Karma\u015f\u0131k Say\u0131larla \u00c7al\u0131\u015fmak<\/h2>\n

Karma\u015f\u0131k say\u0131lar, bir ger\u00e7ek ve bir sanal k\u0131sm\u0131 i\u00e7eren say\u0131lard\u0131r. Excel ve Google Sheets’te, bu say\u0131lar “a+bi” veya “a+bj” (burada “i” ve “j” sanal birimi ifade eder) format\u0131nda temsil edilir.<\/p>\n

Fonksiyonun S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n

IMSUB fonksiyonunun kullan\u0131m s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

=IMSUB(kompleks_say\u01311, kompleks_say\u01312)<\/code><\/pre>\n
    \n
  • kompleks_say\u01311<\/code>: \u00c7\u0131karma i\u015flemi yap\u0131lacak ilk karma\u015f\u0131k say\u0131.<\/li>\n
  • kompleks_say\u01312<\/code>: \u00c7\u0131karma i\u015flemi yap\u0131lacak ikinci karma\u015f\u0131k say\u0131.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m:<\/p>\n
    =IMSUB(\"5+3i\", \"2+i\")<\/code><\/pre>\n
    Bu form\u00fcl, (5+3i) – (2+i) i\u015flemini ger\u00e7ekle\u015ftirir ve sonu\u00e7 olarak “3+2i” d\u00f6nd\u00fcr\u00fcr.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    Karma\u015f\u0131k say\u0131lar, \u00f6zellikle m\u00fchendislik ve fizik gibi alanlarda yayg\u0131n olarak kullan\u0131l\u0131r. \u0130\u015fte IMSUB fonksiyonunun kullan\u0131labilece\u011fi birka\u00e7 pratik \u00f6rnek:<\/p>\n
    Elektrik Devrelerinde Empedans Hesaplama<\/h2>\n
    Elektrik m\u00fchendisli\u011fi, AC devre analizlerinde karma\u015f\u0131k say\u0131lar \u00fczerinden \u00e7al\u0131\u015fmay\u0131 gerektirir. Bu tip analizlerde bile\u015fenlerin empedanslar\u0131n\u0131 (karma\u015f\u0131k diren\u00e7lerini) \u00e7\u0131karmak gerekebilir.<\/p>\n
    =IMSUB(\"8+3i\", \"5+2i\")<\/code><\/pre>\n
    Bu form\u00fcl, bir devrede paralel ba\u011flanm\u0131\u015f iki farkl\u0131 bile\u015fenin toplam empedans\u0131n\u0131 hesaplar. Sonu\u00e7 olarak “3+i” de\u011ferini verir.<\/p>\n
    Sinyal \u0130\u015flemede Dalga \u00c7\u0131karma<\/h2>\n
    Sinyal i\u015fleme uygulamalar\u0131nda, farkl\u0131 frekanslardaki sinyallerin \u00e7\u0131kart\u0131lmas\u0131 gerekebilir. IMSUB, bu t\u00fcr i\u015flemleri kolayca yapman\u0131za olanak tan\u0131r.<\/p>\n
    =IMSUB(\"10+15i\", \"7+9i\")<\/code><\/pre>\n
    Bu form\u00fcl, iki farkl\u0131 sinyali birbirinden \u00e7\u0131kartarak “3+6i” \u015feklinde bir sonu\u00e7 \u00fcretir. Bu, ilk sinyalden ikinci sinyalin etkisini \u00e7\u0131kard\u0131\u011f\u0131n\u0131zda elde edece\u011finiz yeni bir sinyaldir.<\/p>\n
    Yukar\u0131daki bilgiler \u0131\u015f\u0131\u011f\u0131nda, IMSUB fonksiyonu, karma\u015f\u0131k say\u0131larla yap\u0131lan \u00e7\u0131kartma i\u015flemlerini basitle\u015ftiren ve m\u00fchendislik ile bilimsel hesaplamalarda etkili bir ara\u00e7 olarak kullan\u0131labilen bir fonksiyondur.<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u0130ki karma\u015f\u0131k say\u0131n\u0131n fark\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-15480","post","type-post","status-publish","format-standard","hentry","category-muhendislik"],"acf":[],"yoast_head":"\nExcel'de IMSUB (SANTOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da IMSUB (SANTOPLA) 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\/imsub\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de IMSUB (SANTOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da IMSUB (SANTOPLA) 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\/imsub\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:29:25+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 IMSUB (SANTOPLA) 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\/imsub\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/imsub\/\",\"name\":\"Excel'de IMSUB (SANTOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:29:25+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da IMSUB (SANTOPLA) 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\/imsub\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/imsub\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/imsub\/#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\":\"SANTOPLA\"}]},{\"@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 IMSUB (SANTOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da IMSUB (SANTOPLA) 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\/imsub\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de IMSUB (SANTOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da IMSUB (SANTOPLA) 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\/imsub\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:29:25+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de IMSUB (SANTOPLA) 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\/imsub\/","url":"https:\/\/functiontranslator.com\/tr\/imsub\/","name":"Excel'de IMSUB (SANTOPLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:29:25+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da IMSUB (SANTOPLA) 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\/imsub\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/imsub\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/imsub\/#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":"SANTOPLA"}]},{"@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\/15480","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=15480"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15480\/revisions"}],"predecessor-version":[{"id":26748,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15480\/revisions\/26748"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15480"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15480"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}