{"id":20569,"date":"2026-02-19T16:53:17","date_gmt":"2026-02-19T16:53:17","guid":{"rendered":"https:\/\/undetectable.ai/blog\/?p=20569"},"modified":"2026-03-04T19:23:59","modified_gmt":"2026-03-04T19:23:59","slug":"elektronik-tablo-formulleri","status":"publish","type":"post","link":"https:\/\/undetectable.ai/blog\/tr\/elektronik-tablo-formulleri\/","title":{"rendered":"G\u00f6rmezden Gelemeyece\u011finiz Excel ve Google Elektronik Tablo Form\u00fclleri"},"content":{"rendered":"<p>G\u00fcnl\u00fck i\u015flerinizin bir par\u00e7as\u0131 olarak Excel\/Google Sheets kullan\u0131yorsan\u0131z, bir kez \u00f6\u011frendi\u011finizde kendinizi geri d\u00f6nerken bulaca\u011f\u0131n\u0131z baz\u0131 ciddi yararl\u0131 form\u00fcller vard\u0131r.&nbsp;&nbsp;<\/p>\n\n\n\n<p>Farkl\u0131 hesaplama t\u00fcrleri i\u00e7in \u00e7al\u0131\u015fan muhtemelen y\u00fczden fazla farkl\u0131 elektronik tablo form\u00fcl\u00fc vard\u0131r.<\/p>\n\n\n\n<p>Bu blogdaki amac\u0131m, daha sonra \u00f6\u011frenebilece\u011finiz t\u00fcm bu ileri hesaplamalar\u0131n temelini olu\u015fturan en basit hesaplamalardan bahsetmek.&nbsp;<\/p>\n\n\n\n<p>\u00d6nce baz\u0131 temel aritmetik hesaplama komutlar\u0131n\u0131n \u00fczerinden ge\u00e7ece\u011fiz, ard\u0131ndan size daha geli\u015fmi\u015f analizler yapabilece\u011finiz birka\u00e7 yolu tan\u0131taca\u011f\u0131m.<\/p>\n\n\n\n<p>Bunlar aras\u0131nda E\u011eER deyimleri, D\u00dc\u015eEYARA, D\u0130Z\u0130N ve MATCH komutlar\u0131 vb. yer al\u0131r.&nbsp;<\/p>\n\n\n\n<p>Ve d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcn\u00fczden daha basit!<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"has-text-align-center\"><strong>\u00d6nemli \u00c7\u0131kar\u0131mlar<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Excel ve Google E-Tablolar, hesaplamalar yapmak i\u00e7in yararl\u0131 olan bir\u00e7ok yerle\u015fik form\u00fcl komutuna sahiptir.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SUM, AVERAGE, COUNT, VLOOKUP, INDEX ve MATCH g\u00fcnl\u00fck hesaplamalara yard\u0131mc\u0131 olabilecek baz\u0131 form\u00fcllerdir. Ayr\u0131ca ko\u015fullu mant\u0131klar\u0131 tan\u0131tarak bunlarla oynayabilirsiniz.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Bir form\u00fcl yazarken herhangi bir hata olmamal\u0131d\u0131r, aksi takdirde sonu\u00e7lar\u0131n\u0131z\u0131 alamazs\u0131n\u0131z. \u00d6zellikle, d\u00f6ng\u00fcsel referanslardan ka\u00e7\u0131nd\u0131\u011f\u0131n\u0131zdan ve Excel'in sonsuz bir hesaplama d\u00f6ng\u00fcs\u00fcne girmesini engelledi\u011finizden emin olun.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Elektronik Tablo Form\u00fcl\u00fc Tam Olarak Nedir<\/h2>\n\n\n\n<p>Verilerinizin hesaplamalar\u0131n\u0131 yapabilece\u011finiz komutlar elektronik tablo form\u00fclleri olarak bilinir.<\/p>\n\n\n\n<p>Hem Microsoft Excel hem de Google Docs bu t\u00fcr komutlarla doludur ve bu nedenle her i\u015fyerinde temel ara\u00e7lard\u0131r.&nbsp;<\/p>\n\n\n\n<p>Excel'de yaz\u0131lan herhangi bir form\u00fcl\u00fcn \u00f6n\u00fcnde bir (=) i\u015fareti bulunur. Bu, Excel'in izleyen metni d\u00fcz metin giri\u015fi yerine gerekli hesaplamay\u0131 ger\u00e7ekle\u015ftirmek i\u00e7in bir form\u00fcl olarak ele almas\u0131n\u0131n bir g\u00f6stergesidir.<\/p>\n\n\n\n<p>Tarihler i\u00e7in Google E-Tablolar veya Excel elektronik tablo form\u00fcllerini kullanman\u0131n yan\u0131 s\u0131ra, Excel ve Google E-Tablolar'\u0131n y\u00fczlerce form\u00fcl komutuna sahip olmas\u0131n\u0131n baz\u0131 nedenlerini a\u015fa\u011f\u0131da bulabilirsiniz:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Hesaplamalar\u0131 h\u0131zla otomatikle\u015ftirir<\/strong><\/li>\n<\/ul>\n\n\n\n<p>\u0130\u015fimizin niteli\u011fi ne olursa olsun, hepimizin aritmetik veya ortalama hesaplama gibi baz\u0131 temel hesaplamalar\u0131 yapmam\u0131z gerekir.&nbsp;<\/p>\n\n\n\n<p>\u0130\u015finiz veri a\u011f\u0131rl\u0131kl\u0131ysa, \u00e7ok daha y\u00fcksek bir frekansta daha kapsaml\u0131 hesaplamalara ihtiya\u00e7 duyars\u0131n\u0131z.&nbsp;<\/p>\n\n\n\n<p>Bu hesaplamalar\u0131 bir hesap makinesine aktarmak yerine, verilerinizin depoland\u0131\u011f\u0131 elektronik tablo i\u00e7inde yapabiliyorsan\u0131z \u00e7ok kullan\u0131\u015fl\u0131d\u0131r.<\/p>\n\n\n\n<p>Ayr\u0131ca form\u00fcl\u00fc sadece bir kez ayarlayabilirsiniz ve gerekti\u011fi kadar sat\u0131r veya veri girdi\u011finizde \u00e7al\u0131\u015fmaya devam eder.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Manuel hatalar\u0131 azalt\u0131r<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Verilerinizi bir hesap makinesi uygulamas\u0131na aktarmak sadece zaman almakla kalmaz, ayn\u0131 zamanda hatalara da maruz kal\u0131r. Tek bir yanl\u0131\u015f giri\u015f ve ilerideki t\u00fcm hesaplamalar\u0131n\u0131z g\u00fcvenilmez olur.<\/p>\n\n\n\n<p>Birden fazla d\u00fczeltme okumas\u0131 yapsan\u0131z bile, t\u00fcm de\u011ferleri do\u011fru girip girmedi\u011finizden emin olamazs\u0131n\u0131z.&nbsp;<\/p>\n\n\n\n<p>Bir elektronik tablo form\u00fcl\u00fc \u00e7al\u0131\u015ft\u0131rmak bu hata noktas\u0131n\u0131 azalt\u0131r.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Verileri mant\u0131ksal olarak ba\u011flar<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Hesaplamalar yoluyla veri k\u00fcmelerinizi \u00e7ok daha mant\u0131kl\u0131 bir \u015fekilde anlamland\u0131rabilirsiniz. Verilerinizi s\u0131ralay\u0131n, filtreleyin, bir analiz \u00e7al\u0131\u015ft\u0131r\u0131n ve elektronik tablonuzun her bir h\u00fccresindeki t\u00fcm bu say\u0131lar\u0131n neye kar\u015f\u0131l\u0131k geldi\u011fini daha iyi anlay\u0131n.&nbsp;<\/p>\n\n\n\n<p>\u015eunun i\u00e7in harika:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>B\u00fct\u00e7eleme&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ki\u015fisel veya ticari mali kay\u0131t tutma&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u00d6\u011frencilerinin \u00f6dev\/s\u0131nav performanslar\u0131n\u0131n kayd\u0131n\u0131 tutmak isteyen \u00f6\u011fretmenler&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ara\u015ft\u0131rma verileri&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Yat\u0131r\u0131m getirilerinin hesaplanmas\u0131&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>\u015eimdi, ister Google elektronik tablo form\u00fcllerini bilmeniz gerekiyor olsun, ister bir Excel elektronik tablo form\u00fclleri listesi istiyor olun, bunlar\u0131 bir sonraki b\u00f6l\u00fcmde bulabilirsiniz.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Her Kullan\u0131c\u0131n\u0131n \u0130htiyac\u0131 Olan Temel Form\u00fcller<\/h2>\n\n\n\n<p>Hem Excel hem de Google E-Tablolar farkl\u0131 hesaplamalar yapan y\u00fczlerce form\u00fcle sahiptir. Hepsini \u00f6\u011frenmek isterseniz birka\u00e7 ay\u0131n\u0131z\u0131 alacakt\u0131r. Ancak, a\u015fa\u011f\u0131da \u00e7ok kullan\u0131\u015fl\u0131 olan baz\u0131lar\u0131n\u0131 a\u00e7\u0131klad\u0131m.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Toplamlar i\u00e7in SUM<\/strong><\/li>\n<\/ul>\n\n\n\n<p>SUM() komutu, se\u00e7ilen t\u00fcm h\u00fccreleri toplamak i\u00e7in kullan\u0131l\u0131r. Elbette, form\u00fcl\u00fcn \u00e7al\u0131\u015fmas\u0131 i\u00e7in h\u00fccrede say\u0131sal bir de\u011fer olmas\u0131 gerekir. Form\u00fcl, say\u0131sal olmayan hi\u00e7bir h\u00fccrede \u00e7al\u0131\u015fmaz.&nbsp;<\/p>\n\n\n\n<p>Ayra\u00e7 i\u00e7inde, eklemek istedi\u011finiz elektronik tablo b\u00f6l\u00fcm\u00fcn\u00fcn ilk ve son h\u00fccrelerini iki nokta \u00fcst \u00fcste ile ay\u0131rarak belirtmeniz gerekir.&nbsp;<\/p>\n\n\n\n<p>Dolay\u0131s\u0131yla, ilk s\u00fctunda 3'ten 7'ye kadar olan sat\u0131rlar\u0131n i\u00e7eri\u011fini toplamak istersem, form\u00fcl\u00fc \u015fu \u015fekilde yazar\u0131m: TOPLA(A3:A7). Form\u00fcl birden \u00e7ok sat\u0131rda da \u00e7al\u0131\u015f\u0131r.<\/p>\n\n\n\n<p>Ayr\u0131ca, bu form\u00fcl hem Google E-Tablolar hem de Excel i\u00e7in ayn\u0131 kal\u0131r.<\/p>\n\n\n\n<p>\u015eu \u00f6rne\u011fe bak\u0131n:&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"630\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SUM-for-totals.jpg\" alt=\"\" class=\"wp-image-20576\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SUM-for-totals.jpg 969w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SUM-for-totals-300x195.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SUM-for-totals-768x499.jpg 768w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SUM-for-totals-18x12.jpg 18w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/><\/figure><\/div>\n\n\n<p>En basit SUM i\u015flevinin yan\u0131 s\u0131ra, a\u015fa\u011f\u0131daki t\u00fcrde eklemeler de yapabilirsiniz:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SUMIF: Bir ko\u015fulu kar\u015f\u0131layan bir aral\u0131ktaki say\u0131lar\u0131 toplar<br><\/li>\n\n\n\n<li>SUMIFS: Birden \u00e7ok ko\u015fulu kar\u015f\u0131layan bir aral\u0131ktaki say\u0131lar\u0131 toplama<br><\/li>\n\n\n\n<li>SUMPRODUCT: Dizilerdeki kar\u015f\u0131l\u0131k gelen de\u011ferleri \u00e7arp\u0131n ve ard\u0131ndan sonu\u00e7lar\u0131 toplay\u0131n<br><\/li>\n\n\n\n<li>SUMSQ: Bir aral\u0131ktaki say\u0131lar\u0131n karelerini toplar<br><\/li>\n\n\n\n<li>SUMX2MY2: \u0130ki aral\u0131ktaki kar\u015f\u0131l\u0131k gelen de\u011ferler i\u00e7in (x\u00b2 - y\u00b2) sonucunu toplar<br><\/li>\n\n\n\n<li>SUMX2PY2: \u0130ki aral\u0131ktaki kar\u015f\u0131l\u0131k gelen de\u011ferler i\u00e7in (x\u00b2 + y\u00b2) sonucunu toplar<br><\/li>\n\n\n\n<li>SUMXMY2: \u0130ki aral\u0131k i\u00e7in (x - y)\u00b2 farklar\u0131n\u0131n karelerini toplar<br><\/li>\n\n\n\n<li>DSUM: Bir veritaban\u0131 tablosunda tan\u0131mlanan \u00f6l\u00e7\u00fctleri kar\u015f\u0131layan bir s\u00fctuna de\u011ferler ekleyin<br><\/li>\n\n\n\n<li>IMSUM: Karma\u015f\u0131k say\u0131lar\u0131 toplay\u0131n.<br><\/li>\n\n\n\n<li>SERIESSUM: Verilen katsay\u0131lar\u0131 kullanarak bir kuvvet serisinin toplam\u0131n\u0131 hesaplay\u0131n.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"504\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-1024x504.jpg\" alt=\"\" class=\"wp-image-20577\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-1024x504.jpg 1024w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-300x148.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-768x378.jpg 768w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-1536x756.jpg 1536w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-18x9.jpg 18w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM.jpg 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u0130\u00e7g\u00f6r\u00fcler i\u00e7in ORTALAMA<\/strong><\/li>\n<\/ul>\n\n\n\n<p>AVERAGE() form\u00fcl\u00fc, elektronik tablonuzdaki belirli bir h\u00fccre k\u00fcmesinin ortalamas\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r.&nbsp;<\/p>\n\n\n\n<p>Yine, \u00e7al\u0131\u015fma hemen hemen ayn\u0131d\u0131r. \u0130lk ve son h\u00fccre numaras\u0131n\u0131 iki nokta \u00fcst \u00fcste ile ay\u0131rarak parantez i\u00e7ine koyars\u0131n\u0131z, \u00f6rne\u011fin, AVERAGE(E2:E11), ve bu size se\u00e7ilen h\u00fccrelerin ortalamas\u0131n\u0131 verir.<\/p>\n\n\n\n<p>Yine, ortalama i\u00e7in form\u00fcl Google E-Tablolar'da oldu\u011fu gibi Excel'de de ayn\u0131d\u0131r.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"847\" height=\"501\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/AVERAGE-for-insights.jpg\" alt=\"\" class=\"wp-image-20578\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/AVERAGE-for-insights.jpg 847w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/AVERAGE-for-insights-300x177.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/AVERAGE-for-insights-768x454.jpg 768w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/AVERAGE-for-insights-18x12.jpg 18w\" sizes=\"auto, (max-width: 847px) 100vw, 847px\" \/><\/figure><\/div>\n\n\n<p>ORTALAMA form\u00fcl\u00fcndeki k\u00fc\u00e7\u00fck varyasyonlar, ko\u015fullu hesaplamalarda size yard\u0131mc\u0131 olabilir, \u00f6rne\u011fin:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>ORTALAMA: Bir aral\u0131ktaki say\u0131lar\u0131n aritmetik ortalamas\u0131n\u0131 hesaplamak i\u00e7in<br><\/li>\n\n\n\n<li>AVERAGEA: Say\u0131lar, metin ve mant\u0131ksal de\u011ferler dahil olmak \u00fczere ortalama istedi\u011finizde kullan\u0131n<br><\/li>\n\n\n\n<li>AVERAGEIF: Bu komut, bir ko\u015fulu kar\u015f\u0131layan say\u0131lar\u0131n ortalamas\u0131 i\u00e7indir<br><\/li>\n\n\n\n<li>AVERAGEIFS: Bu, birden fazla ko\u015fulu kar\u015f\u0131layan say\u0131lar\u0131n ortalamas\u0131n\u0131 hesaplar<br><\/li>\n\n\n\n<li>DAVERAGE: Belirtilen kriterleri kar\u015f\u0131layan bir veritaban\u0131 s\u00fctunundaki de\u011ferlerin ortalamas\u0131n\u0131 hesaplar<br><\/li>\n\n\n\n<li>\u00d6\u011feleri izlemek i\u00e7in HESAP<\/li>\n<\/ul>\n\n\n\n<p>Bu komut, elektronik tablonuzda say\u0131sal veri i\u00e7eren h\u00fccrelerin say\u0131s\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131\u015fl\u0131d\u0131r.&nbsp;<\/p>\n\n\n\n<p>Verileriniz yaln\u0131zca birka\u00e7 sat\u0131rla s\u0131n\u0131rl\u0131 oldu\u011funda bunu kullanmak mant\u0131kl\u0131 olmayacakt\u0131r, ancak y\u00fczlerce sat\u0131r veriniz varsa ve bunlar\u0131n ka\u00e7\u0131n\u0131n say\u0131sal de\u011fer oldu\u011funu bilmek istiyorsan\u0131z, ula\u015faca\u011f\u0131n\u0131z \u015fey budur.<\/p>\n\n\n\n<p>Bu da benzer \u015fekilde yaz\u0131l\u0131r, yani = i\u015fareti ile ba\u015flan\u0131r, ard\u0131ndan COUNT komutundan bahsedilir, parantez a\u00e7\u0131l\u0131r, iki nokta \u00fcst \u00fcste ile ayr\u0131lm\u0131\u015f ilk ve son h\u00fccrenizden bahsedilir ve parantez kapat\u0131l\u0131r.<\/p>\n\n\n\n<p>Form\u00fcl hem Google E-Tablolar'da hem de Excel'de ayn\u0131d\u0131r.<\/p>\n\n\n\n<p>\u00d6rne\u011fin, <strong>=COUNT(E1:E100)<\/strong><\/p>\n\n\n\n<p>SUM ve AVERAGE form\u00fclleri gibi COUNT da birka\u00e7 farkl\u0131 \u015fekilde kullan\u0131labilir, \u00f6rn,&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>COUNTA: Bo\u015f olmayan h\u00fccreleri (say\u0131lar, metin veya de\u011ferler) saymak i\u00e7in.<br><\/li>\n\n\n\n<li>COUNTBLANK: Bir aral\u0131ktaki yaln\u0131zca bo\u015f h\u00fccreleri sayar<br><\/li>\n\n\n\n<li>COUNTIF: Bir ko\u015fulu kar\u015f\u0131layan h\u00fccreleri sayar<br><\/li>\n\n\n\n<li>COUNTIFS: Birden fazla ko\u015fulu kar\u015f\u0131layan h\u00fccreleri saymak i\u00e7in kullan\u0131n<br><\/li>\n\n\n\n<li>DCOUNT: Bu, belirtilen \u00f6l\u00e7\u00fctleri kar\u015f\u0131layan bir veritaban\u0131 s\u00fctunundaki say\u0131sal de\u011ferleri sayar<br><\/li>\n\n\n\n<li>DCOUNTA: Belirtilen kriterleri kar\u015f\u0131layan bir veritaban\u0131 s\u00fctunundaki bo\u015f olmayan de\u011ferleri saymak i\u00e7in kullan\u0131l\u0131r<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"468\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-1024x468.jpg\" alt=\"\" class=\"wp-image-20579\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-1024x468.jpg 1024w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-300x137.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-768x351.jpg 768w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-1536x702.jpg 1536w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-18x8.jpg 18w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items.jpg 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">Veri Analizi \u0130\u00e7in Geli\u015fmi\u015f Form\u00fcller<\/h2>\n\n\n\n<p>\u00c7o\u011fu kullan\u0131c\u0131 i\u00e7in, daha \u00f6nce bahsetti\u011fim form\u00fcller fazlas\u0131yla yeterli olacakt\u0131r. Bununla birlikte, baz\u0131 form\u00fcller geli\u015fmi\u015f hesaplamalar i\u00e7in gereklidir ve \u00e7al\u0131\u015fman\u0131z veri analizi i\u00e7eriyorsa \u00e7ok kullan\u0131\u015fl\u0131 olurlar.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Aramalar i\u00e7in D\u00dc\u015eEYARA<\/strong><\/li>\n<\/ul>\n\n\n\n<p>D\u00dc\u015eEYARA form\u00fcl\u00fc, bir tablodaki bir de\u011feri bulmak ve ayn\u0131 sat\u0131rdan ilgili bilgileri d\u00f6nd\u00fcrmek i\u00e7in kullan\u0131l\u0131r.<\/p>\n\n\n\n<p>Daha basit bir ifadeyle, D\u00dc\u015eEYARA girdi\u011finizde, elektronik tablonuzdan bir tablonun ilk s\u00fctununda bir de\u011fer aramas\u0131n\u0131 ve ard\u0131ndan size o sat\u0131rdaki ba\u015fka bir s\u00fctundan bir de\u011fer vermesini istersiniz.<\/p>\n\n\n\n<p>\u00d6rnek sayfam\u0131zda, A s\u00fctununda \u00fcr\u00fcn kimlikleri ve C s\u00fctununda birim ba\u015f\u0131na fiyat varsa, belirli bir \u00fcr\u00fcn kimli\u011fini aramak ve C s\u00fctunundan fiyat\u0131n\u0131 almak i\u00e7in D\u00dc\u015eEYARA'y\u0131 kullanabiliriz.&nbsp;<\/p>\n\n\n\n<p>VLOOKUP(\u201cP-1001\u201d, A:C, 3, FALSE) olarak yaz\u0131lacakt\u0131r.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"522\" height=\"290\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/VLOOKUP-for-searches.jpg\" alt=\"\" class=\"wp-image-20581\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/VLOOKUP-for-searches.jpg 522w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/VLOOKUP-for-searches-300x167.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/VLOOKUP-for-searches-18x10.jpg 18w\" sizes=\"auto, (max-width: 522px) 100vw, 522px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Mant\u0131k i\u00e7in IF ifadeleri<\/strong><\/li>\n<\/ul>\n\n\n\n<p>IF fonksiyonu bir elektronik tabloda mant\u0131ksal kararlar vermek i\u00e7in kullan\u0131l\u0131r. Basit\u00e7e sayfaya bir ko\u015ful do\u011fru oldu\u011funda ne yap\u0131laca\u011f\u0131n\u0131 ve yanl\u0131\u015f oldu\u011funda ne yap\u0131laca\u011f\u0131n\u0131 s\u00f6yler.<\/p>\n\n\n\n<p>Bir E\u011eER deyimi yazmak i\u00e7in = i\u015faretiyle ba\u015flar, E\u011eER komutunu ekler, parantezleri a\u00e7ar ve ard\u0131ndan ko\u015fulunuzu a\u00e7\u0131klars\u0131n\u0131z.<\/p>\n\n\n\n<p>Bundan sonra, bir virg\u00fcl ekleyin ve ko\u015ful kar\u015f\u0131lan\u0131rsa sayfan\u0131n ne yapmas\u0131n\u0131 istedi\u011finizi belirtin. Ard\u0131ndan bir virg\u00fcl daha ekleyin ve komut yerine getirilmezse ne olmas\u0131n\u0131 istedi\u011finizi belirtin.<\/p>\n\n\n\n<p>\u00d6rne\u011fin, \u00f6\u011frencilerin sonu\u00e7lar\u0131n\u0131 i\u00e7eren bir sayfa hayal edersek ve 50 veya \u00fczeri bir puan\u0131n ge\u00e7me puan\u0131, 50\u2019nin alt\u0131ndakinin ise kalma puan\u0131 oldu\u011funa dair bir ko\u015ful belirtmek istersek, IF mant\u0131\u011f\u0131n\u0131 kullanabiliriz.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"582\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic-1024x582.jpg\" alt=\"\" class=\"wp-image-20582\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic-1024x582.jpg 1024w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic-300x170.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic-768x436.jpg 768w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic-18x10.jpg 18w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic.jpg 1162w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>Bunu \u015fu \u015fekilde yazacaks\u0131n\u0131z: =IF(A1&gt;=50, \u201cGe\u00e7ti\u201d, \u201cKald\u0131\u201d)<\/p>\n\n\n\n<p>Sayfa h\u00fccredeki de\u011feri tarayacak, 50'den b\u00fcy\u00fckse \u00f6\u011frencinin ge\u00e7ti\u011fini g\u00f6sterecektir. Aksi takdirde, ba\u015far\u0131s\u0131z olduklar\u0131n\u0131 belirtecektir.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Arama i\u00e7in INDEX &amp; MATCH<\/strong><\/li>\n<\/ul>\n\n\n\n<p>INDEX ve MATCH, bir tablodaki bilgileri LOOKUP form\u00fcl\u00fcnden daha esnek bir \u015fekilde aramak i\u00e7in birlikte kullan\u0131l\u0131r.&nbsp;<\/p>\n\n\n\n<p>MATCH fonksiyonu, bir sat\u0131r veya s\u00fctundaki bir de\u011ferin konumunu bulmaktan sorumludur. Tablonuzda bir de\u011fer aramak i\u00e7in MATCH i\u015flevini kullan\u0131n; de\u011ferin kendisini d\u00f6nd\u00fcrmez. De\u011ferin nerede g\u00f6r\u00fcnd\u00fc\u011f\u00fcn\u00fc temsil eden bir say\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p>\n\n\n\n<p>\u00d6rne\u011fin, bir \u00fcr\u00fcn kimli\u011fi listedeki be\u015finci \u00f6\u011feyse, MATCH 5 de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/p>\n\n\n\n<p>INDEX i\u015flevi, bir tablo veya s\u00fctundaki belirli bir konumdan bir de\u011fer d\u00f6nd\u00fcrmek i\u00e7in bu konum numaras\u0131n\u0131 kullan\u0131r. Yani, belirtti\u011finiz sat\u0131rda hangi de\u011fer varsa onu al\u0131r.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"325\" height=\"336\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/INDEX-MATCH-for-lookup.jpg\" alt=\"\" class=\"wp-image-20583\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/INDEX-MATCH-for-lookup.jpg 325w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/INDEX-MATCH-for-lookup-290x300.jpg 290w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/INDEX-MATCH-for-lookup-12x12.jpg 12w\" sizes=\"auto, (max-width: 325px) 100vw, 325px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">Yayg\u0131n Form\u00fcl Hatalar\u0131ndan Ka\u00e7\u0131nmak \u0130\u00e7in \u0130pu\u00e7lar\u0131<\/h2>\n\n\n\n<p>Daha \u00f6nce g\u00f6rm\u00fc\u015f olabilece\u011finiz gibi, hem Excel hem de Google E-Tablolar form\u00fcllerinizi 100% do\u011frulukla girmenizi gerektirir.<\/p>\n\n\n\n<p>Form\u00fcl\u00fcn\u00fcz\u00fcn yaz\u0131m\u0131ndaki herhangi bir hata size sonu\u00e7 vermeyecek, sadece #N\/A yazan bir hata mesaj\u0131 alacaks\u0131n\u0131z.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"493\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/Common-Formula-Errors.jpg\" alt=\"\" class=\"wp-image-20584\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/Common-Formula-Errors.jpg 678w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/Common-Formula-Errors-300x218.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/Common-Formula-Errors-18x12.jpg 18w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n<p>\u0130\u015fte bu hata mesaj\u0131ndan ka\u00e7\u0131nman\u0131za yard\u0131mc\u0131 olacak baz\u0131 ipu\u00e7lar\u0131.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Parantezleri dikkatlice kontrol edin<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Form\u00fcl tam olarak yukar\u0131da a\u00e7\u0131klanan bi\u00e7imde yaz\u0131lmal\u0131d\u0131r. Herhangi bir ihtimalle parantezleri a\u00e7\u0131k b\u0131rak\u0131rsan\u0131z veya h\u00fccre aral\u0131\u011f\u0131n\u0131z\u0131 parantezler olmadan tan\u0131mlarsan\u0131z, verilerinizi hesaplatamazs\u0131n\u0131z.&nbsp;<\/p>\n\n\n\n<p>Her zaman hem a\u00e7\u0131k hem de kapal\u0131 parantezlerin yerinde oldu\u011fundan emin olun. Ayr\u0131ca, aral\u0131\u011f\u0131n\u0131z\u0131n ilk ve son h\u00fccresini birbirinden ay\u0131rmak i\u00e7in iki nokta \u00fcst \u00fcste oldu\u011fundan emin olun.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Veri t\u00fcrlerini izleyin<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Elektronik tablo form\u00fclleri yaln\u0131zca belirli veri t\u00fcrleriyle en iyi \u015fekilde \u00e7al\u0131\u015f\u0131r. \u00d6rne\u011fin, \u00f6l\u00e7\u00fclebilir olmayan veriler, yani tan\u0131mlay\u0131c\u0131 veri bi\u00e7imleri i\u00e7in bir ortalama de\u011fer bekleyemezsiniz.&nbsp;<\/p>\n\n\n\n<p>Form\u00fcl eklerken, ge\u00e7ersiz bir h\u00fccre aral\u0131\u011f\u0131 girmemek i\u00e7in h\u00fccrelerinizdeki verileri iki kez kontrol edin.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>D\u00f6ng\u00fcsel referanslardan ka\u00e7\u0131n\u0131n<\/strong><\/li>\n<\/ul>\n\n\n\n<p>D\u00f6ng\u00fcsel referans, elektronik tablonuzun tan\u0131mland\u0131\u011f\u0131 kendi h\u00fccresine geri d\u00f6nd\u00fc\u011f\u00fc anlam\u0131na gelir. Cevap alamayaca\u011f\u0131n\u0131z sonsuz bir dola\u015f\u0131m d\u00f6ng\u00fcs\u00fc yarat\u0131r ve bunun yerine yaln\u0131zca bir hata mesaj\u0131 g\u00f6r\u00fcnt\u00fcler.<\/p>\n\n\n\n<p>\u00d6rne\u011fin, A10 h\u00fccresine TOPLA(A1:A10) girerseniz, h\u00fccrenin s\u00fcrekli olarak A10 h\u00fccresinde toplanan de\u011feri eklemek zorunda kalaca\u011f\u0131 ve bu i\u015flemin hi\u00e7 bitmeyece\u011fi dairesel bir d\u00f6ng\u00fc olu\u015fturmu\u015f olursunuz.<\/p>\n\n\n\n<p>Form\u00fcl\u00fcn A10 h\u00fccresinin de\u011ferini bulmak i\u00e7in kendi sonucunu bilmesi gerekir.<\/p>\n\n\n\n<p>Her zaman elektronik tablo form\u00fcl\u00fcn\u00fcz\u00fc girdi\u011finiz h\u00fccrenin form\u00fcl h\u00fccre aral\u0131\u011f\u0131n\u0131n bir par\u00e7as\u0131 olmad\u0131\u011f\u0131ndan emin olun.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Daha \u0130yi Verimlilik \u0130\u00e7in Form\u00fcllerin Birle\u015ftirilmesi<\/h2>\n\n\n\n<p>Elektronik tablolarda form\u00fclleri birle\u015ftirmek, karma\u015f\u0131k sorunlar\u0131 daha verimli bir \u015fekilde \u00e7\u00f6zmenizi sa\u011flar. Daha \u00f6nce bahsetti\u011fim basit form\u00fclleri kullan\u0131rken, bir\u00e7ok h\u00fccrede ad\u0131m ad\u0131m hesaplama yapars\u0131n\u0131z. <\/p>\n\n\n\n<p>Birle\u015fik bir form\u00fclde, bir form\u00fcl\u00fcn di\u011ferini do\u011frudan besleyece\u011fi \u015fekilde birden fazla hesaplamay\u0131 i\u00e7 i\u00e7e yerle\u015ftirebilirsiniz.<\/p>\n\n\n\n<p>\u00d6rne\u011fin, yaln\u0131zca belirli ko\u015fullar\u0131 kar\u015f\u0131layan de\u011ferleri toplamak i\u00e7in IF ile SUM'\u0131 birle\u015ftirebilirsiniz.<\/p>\n\n\n\n<p>Ayr\u0131ca verileri daha hassas bir \u015fekilde analiz etmek i\u00e7in SAYIM veya ORTALAMA'y\u0131 ko\u015fullarla birle\u015ftirebilirsiniz.<\/p>\n\n\n\n<p>Bununla birlikte, form\u00fclleri birle\u015ftirmek ilk ba\u015fta kolay de\u011fildir. Ger\u00e7ek bir \u00f6\u011frenme e\u011frisi vard\u0131r ve basit form\u00fclleri birka\u00e7 kez kullanmadan karma\u015f\u0131k i\u00e7 i\u00e7e form\u00fcllere atlarsan\u0131z, sonunda kafan\u0131z kar\u0131\u015f\u0131r.<\/p>\n\n\n\n<p>Bu nedenle, her zaman \u00f6nce basit form\u00fcllerle pratik yap\u0131n. Kendinizi rahat hissetti\u011finizde, kademeli olarak iki fonksiyonu, ard\u0131ndan \u00fc\u00e7 fonksiyonu ve nihayetinde daha geli\u015fmi\u015f kurulumlar\u0131 birle\u015ftirerek geli\u015ftirin.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ger\u00e7ek D\u00fcnyadaki G\u00f6revler \u0130\u00e7in Form\u00fclleri Kullanma<\/h2>\n\n\n\n<p>Bu form\u00fcllere al\u0131\u015ft\u0131\u011f\u0131n\u0131zda, zaten yapt\u0131\u011f\u0131n\u0131z \u015feylere ne kadar s\u0131k uyguland\u0131klar\u0131n\u0131 fark etmeye ba\u015flayacaks\u0131n\u0131z.<\/p>\n\n\n\n<p>Mesela:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>K\u00fc\u00e7\u00fck bir i\u015fletme sahibi \u015fu form\u00fcl\u00fc kullanabilir <strong>SUMIF<\/strong> harcamalar\u0131 kategoriye g\u00f6re takip etmek i\u00e7in<\/li>\n\n\n\n<li>Ya da bir \u00f6\u011fretmen \u015funlar\u0131 birle\u015ftirebilir <strong>E\u011eER<\/strong> ile <strong>COUNTIF<\/strong> \u00d6devlerinde geride kalan \u00f6\u011frencileri i\u015faretleme i\u015flevleri<\/li>\n\n\n\n<li>M\u00fc\u015fteri faturalar\u0131n\u0131 y\u00f6neten serbest \u00e7al\u0131\u015fanlar i\u00e7in de durum ayn\u0131d\u0131r. Basit bir ara\u00e7 kullanabilirler <strong>VLOOKUP<\/strong> komutunu kullanarak sat\u0131rlar\u0131 manuel olarak kayd\u0131rmadan bir ana listeden m\u00fc\u015fteri oranlar\u0131n\u0131 \u00e7ekebilirsiniz.<\/li>\n<\/ul>\n\n\n\n<p>Mesele \u015fu ki, hangi form\u00fcl\u00fcn sizin \u00f6zel durumunuza uygun oldu\u011funu bilmek neredeyse i\u015fin yar\u0131s\u0131d\u0131r. \u0130\u015fte tam da bu noktada Undetectable'\u0131n <a href=\"https:\/\/undetectable.ai\/ai-chat\" target=\"_blank\" rel=\"noreferrer noopener\">Yapay Zeka Sohbet Robotu<\/a> rehberiniz olabilir.&nbsp;<\/p>\n\n\n\n<p>Ne yapmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z\u0131 basit bir dille anlatabilirsiniz ve o da g\u00f6reviniz i\u00e7in do\u011fru form\u00fcl\u00fc \u00f6nerecektir.<\/p>\n\n\n\n<p>Art\u0131k her s\u0131k\u0131\u015ft\u0131\u011f\u0131n\u0131zda ping atabilece\u011finiz hesap tablosu konusunda bilgili bir i\u015f arkada\u015f\u0131n\u0131z var ve bu sadece Excel veya Google hesap tablosu sorgular\u0131yla s\u0131n\u0131rl\u0131 de\u011fil.<\/p>\n\n\n\n<p>Yapay Zeka Dedekt\u00f6r\u00fcm\u00fcz\u00fcn ve Humanizer'\u0131n i\u00e7eri\u011finizi nas\u0131l geli\u015ftirebilece\u011fini a\u015fa\u011f\u0131da ke\u015ffedin!<\/p>\n\n\n\n<div id=\"uai-widget\" data-affiliate-link=\"https:\/\/undetectable.ai\/?_by=hi4km\"><script>var js = document.createElement(\"script\");js.async = true;js.src = \"https:\/\/widget.undetectable.ai\/js\/widget-loader.js?t=\"+Date.now();document.getElementsByTagName(\"head\")[0].appendChild(js);<\/script><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Son D\u00fc\u015f\u00fcnceler<\/h2>\n\n\n\n<p>Umar\u0131m bu makale elektronik tablo form\u00fclleri hakk\u0131nda bir iki \u015fey \u00f6\u011frenmenize yard\u0131mc\u0131 olmu\u015ftur.&nbsp;<\/p>\n\n\n\n<p>Bunlar\u0131 ne kadar \u00e7ok kullan\u0131rsan\u0131z o kadar iyi olursunuz ve hangi form\u00fcl dizisini kullanman\u0131z gerekti\u011fi konusunda kafan\u0131z kar\u0131\u015ft\u0131\u011f\u0131nda Undetectable AI'ya ba\u015fvurman\u0131z yeterlidir <a href=\"https:\/\/undetectable.ai\/ai-chat\" target=\"_blank\" rel=\"noreferrer noopener\">Yapay Zeka Sohbeti<\/a>, ve istedi\u011finiz hesaplama i\u00e7in hangi komutun en iyi \u015fekilde \u00e7al\u0131\u015faca\u011f\u0131na karar vermenize yard\u0131mc\u0131 olacakt\u0131r.&nbsp;<\/p>\n\n\n\n<p>Ayr\u0131ca, herhangi bir hata yapmad\u0131\u011f\u0131n\u0131z\u0131 do\u011frulamak i\u00e7in form\u00fcl\u00fcn\u00fcz\u00fc AI Chat \u00fczerinden \u00e7al\u0131\u015ft\u0131rarak iki kez kontrol edebilirsiniz.<\/p>\n\n\n\n<p>Deneyin <a href=\"https:\/\/undetectable.ai\/\" target=\"_blank\" rel=\"noreferrer noopener\">Tespit Edilemeyen Yapay Zeka<\/a> Bug\u00fcn!<\/p>","protected":false},"excerpt":{"rendered":"","protected":false},"author":15,"featured_media":20575,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-20569","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai-news"],"_links":{"self":[{"href":"https:\/\/undetectable.ai/blog\/tr\/wp-json\/wp\/v2\/posts\/20569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/undetectable.ai/blog\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/undetectable.ai/blog\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/undetectable.ai/blog\/tr\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/undetectable.ai/blog\/tr\/wp-json\/wp\/v2\/comments?post=20569"}],"version-history":[{"count":5,"href":"https:\/\/undetectable.ai/blog\/tr\/wp-json\/wp\/v2\/posts\/20569\/revisions"}],"predecessor-version":[{"id":20585,"href":"https:\/\/undetectable.ai/blog\/tr\/wp-json\/wp\/v2\/posts\/20569\/revisions\/20585"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/undetectable.ai/blog\/tr\/wp-json\/wp\/v2\/media\/20575"}],"wp:attachment":[{"href":"https:\/\/undetectable.ai/blog\/tr\/wp-json\/wp\/v2\/media?parent=20569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/undetectable.ai/blog\/tr\/wp-json\/wp\/v2\/categories?post=20569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/undetectable.ai/blog\/tr\/wp-json\/wp\/v2\/tags?post=20569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}