{"id":1639,"date":"2022-10-30T10:35:52","date_gmt":"2022-10-30T07:35:52","guid":{"rendered":"https:\/\/dnsbak.com\/blog\/?p=1639"},"modified":"2022-10-30T10:35:54","modified_gmt":"2022-10-30T07:35:54","slug":"libreoffice-calc-uzerinde-aritmetik-islemler-dort-islem","status":"publish","type":"post","link":"https:\/\/dnsbak.com\/blog\/libreoffice-calc-uzerinde-aritmetik-islemler-dort-islem\/","title":{"rendered":"LibreOffice Calc \u00dczerinde Aritmetik \u0130\u015flemler – D\u00f6rt \u0130\u015flem"},"content":{"rendered":"\n

Microsoft Ofisin en iyi alternatiflerinden olan LibreOffice, Microsoft Ofisin yapt\u0131\u011f\u0131 neredeyse t\u00fcm i\u015flemleri yapabilmekte. LibreOffice i\u00e7erisinde bulunan “Calc” ise uzun zamand\u0131r kulland\u0131\u011f\u0131m, en iyi “Excel” alternatifi yaz\u0131l\u0131mlardand\u0131r. Calc bir Excel alternatifi oldu\u011fundan onun sahip oldu\u011fu i\u015flemleri neredeyse ayn\u0131 \u015fekilde yapabilmekte. Bu i\u015flemlerin aras\u0131nda tablo olu\u015fturmak, verileri d\u00fczenlemek veya s\u0131ralamak, belirli de\u011ferlere g\u00f6re verileri renklendirme gibi i\u015flemlerin yan\u0131 s\u0131ra matematik form\u00fcllerini de \u00e7ok kolay ve h\u0131zl\u0131 bir \u015fekilde yapabilmekte. Form\u00fcllerin yap\u0131s\u0131 da Excel form\u00fcllerine olduk\u00e7a benzemekte. Hatta 4 i\u015flem form\u00fclleri ayn\u0131 \u015fekliyle kullan\u0131labilmekte. <\/p>\n\n\n\n

Toplama \u0130\u015flemi<\/h2>\n\n\n\n

Toplama i\u015flemi i\u00e7in birden fazla komut kullanabilirsiniz. Dilerseniz direkt olarak “=TOPLA(A1:B1)” komutunu yazabilirsiniz. Bunun yan\u0131 s\u0131ra daha kolay ak\u0131lda kalan ve yaz\u0131m\u0131 h\u0131zl\u0131 olan direkt sat\u0131r ve s\u00fctun yaz\u0131lan “=A1+B1” form\u00fcl\u00fcn\u00fc kullanabilirsiniz. \u0130ki form\u00fclde belirlenen h\u00fccreler \u00fczerinde toplama i\u015flemini ger\u00e7ekle\u015ftirecektir. Ayn\u0131 form\u00fcl \u015feklini kullanarak 2 veya daha fazla h\u00fccre \u00fczerinde toplama i\u015flemini ger\u00e7ekle\u015ftirebilirsiniz.<\/p>\n\n\n\n

\"Libre<\/a>
Libre Office Toplama \u0130\u015flemi<\/figcaption><\/figure>\n\n\n\n

\u00c7\u0131karma \u0130\u015flemi<\/h2>\n\n\n\n

\u00c7\u0131karma i\u015flemi i\u00e7in direkt olarak k\u0131sa olan komutumuzu kullanabiliriz. Bu i\u015flem i\u00e7in “=A1-B1” komutunu yaz\u0131yoruz. Bu sayede “A1” h\u00fccresine yazd\u0131\u011f\u0131m\u0131z say\u0131dan “B1” h\u00fccresine yazd\u0131\u011f\u0131m\u0131z say\u0131y\u0131 \u00e7\u0131kart\u0131cakt\u0131r ve sonucunu komutu yazd\u0131\u011f\u0131m\u0131z h\u00fccre olan “C1” h\u00fccresine yaz\u0131cakt\u0131r.<\/p>\n\n\n\n

\"LibreOffice<\/a>
LibreOffice \u00c7\u0131karma \u0130\u015flemi<\/figcaption><\/figure>\n\n\n\n

\u00c7arpma \u0130\u015flemi<\/h2>\n\n\n\n

\u00c7arpma i\u015fleminde toplamada oldu\u011fu gibi birden fazla \u015fekilde form\u00fcl kullan\u0131labiliniyor. \u0130\u015flem i\u00e7in “=\u00c7ARPIM(A1:B1)” form\u00fcl\u00fcn\u00fc kullanabilirsiniz. Ya da sadele\u015ftirilmi\u015f hali olan “=A1*B1” form\u00fcl\u00fcn\u00fc kullanabilirsiniz. Her iki form\u00fclde yaz\u0131lan h\u00fccrelerdeki say\u0131lar\u0131n \u00e7arp\u0131m\u0131n\u0131 form\u00fcl\u00fcn yaz\u0131ld\u0131\u011f\u0131 h\u00fccreye yaz\u0131cakt\u0131r.<\/p>\n\n\n\n

\"LibreOffice<\/a>
LibreOffice \u00c7arpma \u0130\u015flemi<\/figcaption><\/figure>\n\n\n\n

B\u00f6lme \u0130\u015flemi<\/h2>\n\n\n\n

B\u00f6lme i\u015flemi i\u00e7in yine ayn\u0131 formatta birden fazla \u015fekilde form\u00fcl kullanabilirsiniz. Burada kullanaca\u011f\u0131m\u0131z form\u00fcl “=B\u00d6L\u00dcM(A1;B1)” \u015feklinde olacakt\u0131r. Bir di\u011fer form\u00fcl “=A1\/B1” \u015feklindedir. Kullan\u0131m ve yaz\u0131m al\u0131\u015fkanl\u0131klar\u0131n\u0131za g\u00f6re form\u00fclleri diledi\u011finiz \u015fekilde kullanabilirsiniz. Her iki yaz\u0131m \u015fekli de size b\u00f6lme i\u015fleminizin sonucunu yazd\u0131racakt\u0131r.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"

Microsoft Ofisin en iyi alternatiflerinden olan LibreOffice, Microsoft Ofisin yapt\u0131\u011f\u0131 neredeyse t\u00fcm i\u015flemleri yapabilmekte. LibreOffice i\u00e7erisinde bulunan “Calc” ise uzun<\/p>\n","protected":false},"author":2,"featured_media":1656,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1,19,653],"tags":[656,655,670,660,658,659,671,674,667,666,664,668,662,654,673,675,663,661,672,665,669,657],"ppma_author":[213],"class_list":["post-1639","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel","category-nasil-yapilir","category-ofisuygulamalari","tag-libreoffice-alternative","tag-libreoffice-bolme-formulu","tag-libreoffice-bolme-islemi","tag-libreoffice-buton-ekleme","tag-libreoffice-buyuk-kucuk-harf-degistirme","tag-libreoffice-calc","tag-libreoffice-calc-arithmetic","tag-libreoffice-calc-toplama","tag-libreoffice-capma-islemi","tag-libreoffice-carpma-formulu","tag-libreoffice-cikarma-formulu","tag-libreoffice-cikarma-islemi","tag-libreoffice-download","tag-libreoffice-excel","tag-libreoffice-excel-toplama-islemi","tag-libreoffice-formuller","tag-libreoffice-mac","tag-libreoffice-nedir","tag-libreoffice-toplama","tag-libreoffice-toplama-formulu","tag-libreoffice-toplama-islemi","tag-libreoffice-vs-openoffice"],"aioseo_notices":[],"authors":[{"term_id":213,"user_id":2,"is_guest":0,"slug":"yigitkazanc","display_name":"Yi\u011fit Kazan\u00e7","avatar_url":{"url":"https:\/\/dnsbak.com\/blog\/wp-content\/uploads\/2021\/08\/yigitkazanc.jpg","url2x":"https:\/\/dnsbak.com\/blog\/wp-content\/uploads\/2021\/08\/yigitkazanc.jpg"},"user_url":"http:\/\/yigitkazanc.com","last_name":"Kazan\u00e7","first_name":"Yi\u011fit","description":"dnsbak.com ipbak.net"}],"_links":{"self":[{"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/posts\/1639","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/comments?post=1639"}],"version-history":[{"count":9,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/posts\/1639\/revisions"}],"predecessor-version":[{"id":1659,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/posts\/1639\/revisions\/1659"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/media\/1656"}],"wp:attachment":[{"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/media?parent=1639"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/categories?post=1639"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/tags?post=1639"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/dnsbak.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=1639"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}