{"id":2086,"date":"2023-10-18T23:45:41","date_gmt":"2023-10-18T23:45:41","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/"},"modified":"2023-12-10T06:04:44","modified_gmt":"2023-12-10T06:04:44","slug":"negatif-sayiyi-pozitife-cevir","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/","title":{"rendered":"Negatif bir say\u0131y\u0131 excel&#39;de pozitife nas\u0131l d\u00f6n\u00fc\u015ft\u00fcrebilirim?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1760201054\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Negatif say\u0131larla ba\u015fa \u00e7\u0131kmak i\u00e7in kullanabilece\u011finiz yedi farkl\u0131 y\u00f6ntemim oldu\u011funu \u00f6\u011frenince \u015fa\u015f\u0131racaks\u0131n\u0131z. <span style=\"font-family: inherit;\">Ge\u00e7en hafta abonelerimden birinden bir soru i\u00e7eren bir e-posta ald\u0131m.<\/span><\/p><p> <span style=\"font-family: inherit;\"><strong>Negatif bir say\u0131y\u0131 pozitif say\u0131ya d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in ka\u00e7 y\u00f6ntemimiz var?<\/strong><\/span><\/p><p> Biliyorsunuz, istedi\u011fi \u015fey ortak bir g\u00f6rev. Negatif say\u0131sal de\u011ferler ald\u0131\u011f\u0131n\u0131zda ve ard\u0131ndan bunlar\u0131 pozitif de\u011ferlere d\u00f6n\u00fc\u015ft\u00fcrd\u00fc\u011f\u00fcn\u00fczde bu durumun s\u0131k s\u0131k ba\u015f\u0131n\u0131za geldi\u011finden eminim.<\/p><p> Bunda #rocketsbilim yok. Ancak farkl\u0131 y\u00f6ntemlerimin bunu yapman\u0131za nas\u0131l izin verdi\u011fini zaten kontrol ettiniz mi? Excel&#8217;de bir g\u00f6revi tamamlaman\u0131n farkl\u0131 y\u00f6ntemlerini her zaman merak etmi\u015fimdir.<\/p><p> Bu sefer bir ka\u011f\u0131t ald\u0131m ve negatif bir say\u0131y\u0131 pozitife \u00e7evirmek i\u00e7in kullanabilece\u011fim t\u00fcm y\u00f6ntemleri listeledim. O y\u00fczden bug\u00fcn bu yaz\u0131mda t\u00fcm bu y\u00f6ntemleri sizlerle payla\u015fmak istiyorum.<\/p><p> Ba\u015flayal\u0131m.<\/p><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> 1. Pozitif bir say\u0131ya d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in negatif olanla \u00e7arp\u0131n<\/h2><p> Benden farkl\u0131 olarak, e\u011fer matematikte iyiyseniz eminim ki iki eksi i\u015faretini \u00e7arpt\u0131\u011f\u0131n\u0131zda sonucun her zaman pozitif olaca\u011f\u0131n\u0131 biliyorsunuzdur. Yani negatif bir say\u0131y\u0131 pozitife d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in Excel&#8217;de ayn\u0131 y\u00f6ntemi kullanabilirsiniz.<\/p><p> Tek yapman\u0131z gereken negatif bir de\u011feri -1 ile \u00e7arpmak; negatif yerine pozitif say\u0131y\u0131 d\u00f6nd\u00fcrecektir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=negative_value*-1<\/code><\/pre><p> A\u015fa\u011f\u0131da negatif say\u0131lara sahip bir dizi h\u00fccre var. Yani bunlar\u0131 pozitife d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in form\u00fcl\u00fc B2 h\u00fccresine girip son h\u00fccreye s\u00fcr\u00fcklemeniz yeterli. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nombre-negatif-en-positif-avec-simple-multiplication-avec-moins-un-1.gif\" sizes=\"\" srcset=\"\" alt=\"Negatif say\u0131y\u0131 pozitife \u00e7evirmek i\u00e7in basit bir i\u015flemle bizimle bir \u00e7arp\u0131n\"><\/figure><\/div><p class=\"mynote\"> Kar\u0131\u015f\u0131k say\u0131lar\u0131n\u0131z varsa (pozitif ve negatif), bunun yerine a\u015fa\u011f\u0131daki y\u00f6ntemi kullanabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\"><kbd>=IF(A1&lt;0,A1*-1,A1)<\/kbd><\/code><\/pre><h2 id=\"tab-con-5\" class=\"wp-block-heading\"> 2. ABS i\u015fleviyle mutlak say\u0131ya d\u00f6n\u00fc\u015ft\u00fcr\u00fcn<\/h2><p> Negatif bir say\u0131y\u0131 pozitife d\u00f6n\u00fc\u015ft\u00fcrmek ABS ile olduk\u00e7a kolayd\u0131r. Bu i\u015flev \u00f6zellikle bu g\u00f6reve y\u00f6neliktir.<\/p><p class=\"qt-tip\"> <strong>H\u0131zl\u0131 Giri\u015f:<\/strong> Herhangi bir say\u0131y\u0131 mutlak say\u0131ya d\u00f6n\u00fc\u015ft\u00fcrebilir. Basit bir ifadeyle i\u015faretini kald\u0131rd\u0131ktan sonra bir say\u0131 d\u00f6nd\u00fcrecektir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-Visual Basic\" lang=\"Visual Basic\">=ABS(number)<\/code><\/pre><p> Fonksiyonda negatif bir say\u0131ya referans vermeniz yeterlidir; bu, onu pozitif bir de\u011fere d\u00f6n\u00fc\u015ft\u00fcrecektir.<\/p><ol><li> A\u015fa\u011f\u0131daki \u00f6rnekte A2:A11 aral\u0131\u011f\u0131nda negatif de\u011ferleriniz var.<\/li><li> B2&#8217;ye <code><strong>=ABS(A2)<\/strong><\/code> girin ve onu son h\u00fccreye s\u00fcr\u00fckleyin. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nombre-negatif-en-positif-avec-fonction-abs-1.gif\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Bu i\u015flev, kar\u0131\u015f\u0131k say\u0131lar\u0131n\u0131z (pozitif ve negatif) oldu\u011funda bile \u00e7al\u0131\u015f\u0131r.<\/p><h2 id=\"tab-con-6\" class=\"wp-block-heading\"> 3. <a href=\"https:\/\/exceladvisor.org\/tr\/ozel-carpim-yapistir\/\">\u00d6zel yap\u0131\u015ft\u0131rma kullanarak \u00e7oklu<\/a><\/h2><p> Pozitif say\u0131lar\u0131 farkl\u0131 bir s\u00fctunda almak yerine ayn\u0131 s\u00fctunda bulundurman\u0131z gereken farkl\u0131 bir durumu d\u00fc\u015f\u00fcnelim.<\/p><p> Bunun i\u00e7in \u00f6zel yap\u0131\u015ft\u0131rma se\u00e7ene\u011fini kullanabilirsiniz. Nas\u0131l oldu\u011funu merak ediyor musun? Sana s\u00f6yleyeyim. Yap\u0131\u015ft\u0131r \u00f6zel se\u00e7ene\u011finde basit hesaplamalar\u0131 ger\u00e7ekle\u015ftirmek i\u00e7in kullanabilece\u011finiz &#8220;i\u015flem&#8221; se\u00e7enekleri bulunmaktad\u0131r. Negatif say\u0131lar\u0131 pozitif yapmak i\u00e7in form\u00fcl kullanmadan veya fazladan s\u00fctun eklemeden ayn\u0131 se\u00e7enekleri kullanabilirsiniz. Sadece \u015fu ad\u0131mlar\u0131 izleyin. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nombre-negatif-en-positif-avec-pate-speciale-1.gif\" sizes=\"\" srcset=\"\" alt=\"negatif say\u0131y\u0131 \u00f6zel macunla pozitife \u00e7evirme\"><\/figure><\/div><ol><li> \u00d6ncelikle e-tablonuzdaki herhangi bir h\u00fccreye -1 girin.<\/li><li> Bundan sonra kopyalay\u0131n.<\/li><li> \u015eimdi negatif say\u0131lar\u0131n bulundu\u011fu h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7in.<\/li><li> Sa\u011f t\u0131klay\u0131n \u21e2 \u00d6zel Yap\u0131\u015ft\u0131r \u21e2 \u0130\u015flemler \u21e2 \u00c7arp.<\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><p> T\u00fcm negatif say\u0131lar pozitif say\u0131lara d\u00f6n\u00fc\u015ft\u00fcr\u00fcl\u00fcr.<\/p><p> Dikkat etmeniz gereken tek \u015fey dinamik bir y\u00f6ntem olmamas\u0131d\u0131r. Bu nedenle, verilerinizi s\u0131k s\u0131k g\u00fcncelliyorsan\u0131z bunu tekrar tekrar yapman\u0131z gerekir. Ancak bu y\u00f6ntemin kullan\u0131m\u0131 h\u0131zl\u0131 ve kolayd\u0131r ve bir form\u00fcle ihtiyac\u0131n\u0131z yoktur.<\/p><h2 id=\"tab-con-7\" class=\"wp-block-heading\"> 4. H\u0131zl\u0131 Doldurma ile negatif i\u015fareti kald\u0131r\u0131n<\/h2><p> Eminim hayat\u0131n\u0131zda bir kez fla\u015f dolgu kullanm\u0131\u015fs\u0131n\u0131zd\u0131r ve kullanmad\u0131ysan\u0131z mutlaka kullanmal\u0131s\u0131n\u0131z, bu bir oyun de\u011fi\u015ftiricidir. Bu, negatif say\u0131lar\u0131 pozitif say\u0131lara d\u00f6n\u00fc\u015ft\u00fcrmenin \u00e7\u0131lg\u0131n bir y\u00f6ntemidir; i\u015fte ad\u0131mlar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nombre-negatif-en-positif-avec-remplissage-flash-1.gif\" sizes=\"\" srcset=\"\" alt=\"fla\u015f dolgusu ile negatif say\u0131y\u0131 pozitife \u00e7evirme\"><\/figure><\/div><ol><li> \u00d6ncelikle A2 h\u00fccresindeki negatif say\u0131n\u0131n pozitif say\u0131s\u0131n\u0131 B2 h\u00fccresine girin.<\/li><li> Bundan sonra B3 h\u00fccresine gelin ve Ctrl + E k\u0131sayol tu\u015funa bas\u0131n.<\/li><li> Bu noktada B s\u00fctununda t\u00fcm say\u0131lar pozitif formdad\u0131r.<\/li><li> \u015eimdi B s\u00fctununun sa\u011f taraf\u0131nda bulunan k\u00fc\u00e7\u00fck simgeye t\u0131klay\u0131n ve \u201c\u00d6nerileri kabul et\u201d se\u00e7ene\u011fini se\u00e7in.<\/li><\/ol><p> Tebrikler, t\u00fcm negatif say\u0131lar\u0131 flash dolguyla pozitif say\u0131lara d\u00f6n\u00fc\u015ft\u00fcrd\u00fcn\u00fcz.<\/p><p><mark class=\"has-inline-color\" style=\"background-color: #f5e053;\"> <em><strong>Bu y\u00f6ntem ayn\u0131 zamanda dinamik de\u011fil, h\u0131zl\u0131 ve kullan\u0131m\u0131 kolayd\u0131r.<\/strong><\/em><\/mark><\/p><h2 id=\"tab-con-8\" class=\"wp-block-heading\"> 5. Pozitif say\u0131lar olarak g\u00f6r\u00fcnt\u00fclemek i\u00e7in \u00f6zel bi\u00e7imlendirme uygulay\u0131n<\/h2><p> Negatif bir say\u0131y\u0131 d\u00f6n\u00fc\u015ft\u00fcrmek yerine onu pozitif bir say\u0131 olarak g\u00f6r\u00fcnt\u00fclemek de m\u00fcmk\u00fcnd\u00fcr. Ve bu durumda \u00f6zel bi\u00e7imlendirmeyi kullanabilirsiniz. \u0130zlenecek ad\u0131mlar \u015funlard\u0131r.<\/p><ol><li> \u00d6ncelikle pozitif say\u0131lara d\u00f6n\u00fc\u015ft\u00fcrmeniz gereken h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7in.<\/li><li> Bundan sonra Ctrl + 1 k\u0131sayol tu\u015funa bas\u0131n. Bu, \u00f6zel bi\u00e7imlendirme se\u00e7eneklerini a\u00e7acakt\u0131r.<\/li><li> \u015eimdi \u201c\u00d6zel\u201de gidin ve t\u00fcr giri\u015f \u00e7ubu\u011funa \u201c#,###;#,###\u201d girin.<\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-format-personnalise-dans-la-barre-de-saisie-pour-convertir-un-nombre-negatif-en-min-positif-1.png\" sizes=\"\" srcset=\"\" alt=\"Negatif say\u0131y\u0131 pozitife d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in giri\u015f \u00e7ubu\u011funa \u00f6zel format ekleyin\"><\/figure><\/div><p> Bu, t\u00fcm negatif say\u0131lar\u0131 pozitif olarak g\u00f6sterecektir. Ancak ger\u00e7ekte bunlar h\u00e2l\u00e2 negatif say\u0131lard\u0131r, yaln\u0131zca bi\u00e7imlendirme de\u011fi\u015fmi\u015ftir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nombre-negatif-en-positif-toujours-negatif-dans-la-barre-de-formule-min-1.png\" sizes=\"\" srcset=\"\" alt=\"Pozitif negatif say\u0131 form\u00fcl \u00e7ubu\u011funda her zaman negatiftir\"><\/figure><\/div><p> Bir h\u00fccre se\u00e7ip form\u00fcl \u00e7ubu\u011funa bakarsan\u0131z bunun h\u00e2l\u00e2 negatif bir say\u0131 oldu\u011funu do\u011frulayabilirsiniz. Yani bunu daha sonraki bir hesaplamada kulland\u0131\u011f\u0131n\u0131zda negatif bir say\u0131 gibi davranacakt\u0131r.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> 6. Pozitif say\u0131lara d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in VBA kodunu \u00e7al\u0131\u015ft\u0131r\u0131n<\/h2><p> E\u011fer VBA a\u015f\u0131\u011f\u0131ysan\u0131z, negatif say\u0131lar\u0131n i\u015faretini an\u0131nda tersine \u00e7evirmek i\u00e7in basit bir kod kullanabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub numberP2N() Dim myCell As Range For Each myCell In Selection If myCell.Value &lt;&gt; \"\" Then If IsNumeric(myCell.Value) Then myCell.Value = Abs(myCell.Value) End If End If Next myCell End Sub<\/code><\/pre><p> Bu kodu kullanmak i\u00e7in negatif say\u0131 aral\u0131\u011f\u0131n\u0131 se\u00e7ip bu makroyu \u00e7al\u0131\u015ft\u0131rman\u0131z yeterlidir.<\/p><p> \u00d6ncelikle her se\u00e7im h\u00fccresinin say\u0131sal bir de\u011fer i\u00e7erip i\u00e7ermedi\u011fini kontrol edecek ve ard\u0131ndan bunu pozitif bir de\u011fere d\u00f6n\u00fc\u015ft\u00fcrecektir.<\/p><p> <a href=\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\">Bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131ktan<\/a> sonra i\u015fleminizi geri alamazs\u0131n\u0131z.<\/p><p> <em>\u0130lgili: <a href=\"https:\/\/exceladvisor.org\/tr\/vba\/\">VBA E\u011fitimi<\/a><\/em><\/p><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> 7. Pozitif Say\u0131lar\u0131 Al&#8217;a d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in Power Query&#8217;yi kullan\u0131n<\/h2><p> Evet, negatif bir say\u0131y\u0131 pozitif bir say\u0131ya d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in g\u00fc\u00e7 sorgusu kullanabilirsiniz ve en iyi yan\u0131, bunun tek seferlik bir kurulum olmas\u0131d\u0131r. Sadece bu basit ad\u0131mlar\u0131 izleyin.<\/p><ul><li> \u00d6ncelikle veri aral\u0131\u011f\u0131nda negatif say\u0131lar\u0131n bulundu\u011fu h\u00fccrelerden birini se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/convertir-un-nombre-negatif-en-positif-a-laide-de-la-requete-de-puissance-selectionner-la-cellule-min-1.png\" sizes=\"\" srcset=\"\" alt=\"G\u00fc\u00e7 sorgusu se\u00e7me h\u00fccresini kullanarak negatif say\u0131y\u0131 pozitife d\u00f6n\u00fc\u015ft\u00fcr\u00fcn\"><\/figure><\/div><ul><li> Bundan sonra Veri sekmesi \u279c Tablodan se\u00e7ene\u011fine gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/convertir-un-nombre-negatif-en-positif-a-laide-dune-requete-de-puissance-cliquez-sur-a-partir-du-tableau-min-1.png\" sizes=\"\" srcset=\"\" alt=\"G\u00fc\u00e7 sorgusunu kullanarak negatif say\u0131y\u0131 pozitife d\u00f6n\u00fc\u015ft\u00fcr\u00fcn, tabloya t\u0131klay\u0131n\"><\/figure><\/div><ul><li> Aral\u0131\u011f\u0131 bir tabloya d\u00f6n\u00fc\u015ft\u00fcrecek ve g\u00fc\u00e7l\u00fc sorgu d\u00fczenleyicisine y\u00fckleyecektir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/convertir-un-nombre-negatif-en-positif-en-utilisant-les-donnees-de-requete-de-puissance-dans-lediteur-min-1.png\" sizes=\"\" srcset=\"\" alt=\"D\u00fczenleyicideki g\u00fc\u00e7 sorgusu verilerini kullanarak negatif say\u0131y\u0131 pozitife d\u00f6n\u00fc\u015ft\u00fcr\u00fcn\"><\/figure><\/div><ul><li> \u015eimdi s\u00fctuna sa\u011f t\u0131klay\u0131n ve D\u00f6n\u00fc\u015ft\u00fcr \u279c Mutlak De\u011fer&#8217;e gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/convertir-un-nombre-negatif-en-positif-en-utilisant-une-requete-de-puissance-cliquez-sur-la-valeur-absolue-min-1.png\" sizes=\"\" srcset=\"\" alt=\"g\u00fc\u00e7 sorgusunu kullanarak negatif say\u0131y\u0131 pozitife d\u00f6n\u00fc\u015ft\u00fcr\u00fcn mutlak de\u011feri t\u0131klay\u0131n\"><\/figure><\/div><ul><li> Sonunda, Power Query D\u00fczenleyicisi&#8217;nde Giri\u015f sekmesi \u279c Kapat \u279c Kapat ve Y\u00fckle&#8217;ye gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/convertir-un-nombre-negatif-en-positif-en-utilisant-une-requete-de-puissance-cliquez-sur-charger-min-1.png\" sizes=\"\" srcset=\"\" alt=\"G\u00fc\u00e7 sorgusu t\u0131klama y\u00fck\u00fcn\u00fc kullanarak negatif say\u0131y\u0131 pozitife d\u00f6n\u00fc\u015ft\u00fcr\u00fcn\"><\/figure><\/div><p> <em>\u0130lgili: <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/\">Power Query E\u011fitimi<\/a><\/em><\/p><h2 id=\"t-1597320234891\" class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Dedi\u011fim gibi negatif bir say\u0131y\u0131 pozitif bir say\u0131ya d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in roket bilimini kullanman\u0131za gerek yok. Tek bir y\u00f6ntem bile yeterli olabilir ancak farkl\u0131 durumlarla ba\u015fa \u00e7\u0131kman\u0131za yard\u0131mc\u0131 olmak i\u00e7in bu y\u00f6ntemlerin hepsini listeledim.<\/p><p> Eminim t\u00fcm bu y\u00f6ntemleri faydal\u0131 buldunuz, ama \u015fimdi bana bir \u015feyi s\u00f6ylemeniz gerekiyor.<\/p><p> Bunun i\u00e7in ba\u015fka bir y\u00f6ntem biliyor musunuz? L\u00fctfen g\u00f6r\u00fc\u015flerinizi yorum k\u0131sm\u0131nda benimle payla\u015f\u0131n. Sizden haber almay\u0131 \u00e7ok isterim ve bunu arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n, eminim takdir edeceklerdir.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/excelin-temelleri\/\">Microsoft Excel Temelleri (Bile\u015fenler, Par\u00e7alar ve Bilgi Notlar\u0131)<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zaman-damgasi\/\">Excel&#8217;e zaman damgas\u0131 ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pire\/\">Excel&#8217;e madde i\u015faretleri ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bir-ok-ekle\/\">Excel&#8217;de bir h\u00fccreye ok ekleme<\/a><\/li><li> Excel&#8217;de seri numaralar\u0131n\u0131 otomatik olarak ekleme<\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2086","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Negatif bir say\u0131y\u0131 Excel&#039;de pozitife nas\u0131l d\u00f6n\u00fc\u015ft\u00fcrebilirim?<\/title>\n<meta name=\"description\" content=\"Excel&#039;de negatif bir say\u0131y\u0131 pozitife \u00e7evirmek i\u00e7in 7 farkl\u0131 y\u00f6ntem listeledim.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Negatif bir say\u0131y\u0131 Excel&#039;de pozitife nas\u0131l d\u00f6n\u00fc\u015ft\u00fcrebilirim?\" \/>\n<meta property=\"og:description\" content=\"Excel&#039;de negatif bir say\u0131y\u0131 pozitife \u00e7evirmek i\u00e7in 7 farkl\u0131 y\u00f6ntem listeledim.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:04:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nombre-negatif-en-positif-avec-simple-multiplication-avec-moins-un-1.gif\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/\",\"name\":\"Negatif bir say\u0131y\u0131 Excel&#39;de pozitife nas\u0131l d\u00f6n\u00fc\u015ft\u00fcrebilirim?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nombre-negatif-en-positif-avec-simple-multiplication-avec-moins-un-1.gif\",\"datePublished\":\"2023-10-18T23:45:41+00:00\",\"dateModified\":\"2023-12-10T06:04:44+00:00\",\"description\":\"Excel&#39;de negatif bir say\u0131y\u0131 pozitife \u00e7evirmek i\u00e7in 7 farkl\u0131 y\u00f6ntem listeledim.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nombre-negatif-en-positif-avec-simple-multiplication-avec-moins-un-1.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nombre-negatif-en-positif-avec-simple-multiplication-avec-moins-un-1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Negatif bir say\u0131y\u0131 excel&#39;de pozitife nas\u0131l d\u00f6n\u00fc\u015ft\u00fcrebilirim?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Negatif bir say\u0131y\u0131 Excel&#39;de pozitife nas\u0131l d\u00f6n\u00fc\u015ft\u00fcrebilirim?","description":"Excel&#39;de negatif bir say\u0131y\u0131 pozitife \u00e7evirmek i\u00e7in 7 farkl\u0131 y\u00f6ntem listeledim.","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:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/","og_locale":"tr_TR","og_type":"article","og_title":"Negatif bir say\u0131y\u0131 Excel&#39;de pozitife nas\u0131l d\u00f6n\u00fc\u015ft\u00fcrebilirim?","og_description":"Excel&#39;de negatif bir say\u0131y\u0131 pozitife \u00e7evirmek i\u00e7in 7 farkl\u0131 y\u00f6ntem listeledim.","og_url":"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:04:44+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nombre-negatif-en-positif-avec-simple-multiplication-avec-moins-un-1.gif","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"7 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/","url":"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/","name":"Negatif bir say\u0131y\u0131 Excel&#39;de pozitife nas\u0131l d\u00f6n\u00fc\u015ft\u00fcrebilirim?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nombre-negatif-en-positif-avec-simple-multiplication-avec-moins-un-1.gif","datePublished":"2023-10-18T23:45:41+00:00","dateModified":"2023-12-10T06:04:44+00:00","description":"Excel&#39;de negatif bir say\u0131y\u0131 pozitife \u00e7evirmek i\u00e7in 7 farkl\u0131 y\u00f6ntem listeledim.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nombre-negatif-en-positif-avec-simple-multiplication-avec-moins-un-1.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nombre-negatif-en-positif-avec-simple-multiplication-avec-moins-un-1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Negatif bir say\u0131y\u0131 excel&#39;de pozitife nas\u0131l d\u00f6n\u00fc\u015ft\u00fcrebilirim?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2086","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=2086"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2086\/revisions"}],"predecessor-version":[{"id":2757,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2086\/revisions\/2757"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2086"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}