{"id":1228,"date":"2018-01-27T19:48:35","date_gmt":"2018-01-27T18:48:35","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=1228"},"modified":"2018-01-27T19:51:28","modified_gmt":"2018-01-27T18:51:28","slug":"promenljive-u-excel-formulama","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/","title":{"rendered":"[:sr]Promenljive u Excel formulama[:en]Variables in Excel[:]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_88 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">[:sr]Sadr\u017eaj[:en] Contents[:]<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/#Davanje_imena_pojedinacnoj_celiji\" >Davanje imena pojedina\u010dnoj \u0107eliji<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/#Davanje_imena_grupi_celija\" >Davanje imena grupi \u0107elija<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/#Give_a_name_to_an_individual_cell\" >Give a name to an individual cell\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/#Giving_a_name_to_an_individual_cell_can_be_done_in_several_ways_The_first_way_is_by_right-clicking_the_mouse_and_then_selecting_the_Define_Name_option_You_are_now_typing_the_name_you_want_to_use\" >Giving a name to an individual cell can be done in several ways. The first way is by right-clicking the mouse, and then selecting the Define Name option. You are now typing the name you want to use.<\/a><\/li><\/ul><\/nav><\/div>\n[:sr]Uvo\u0111enjem imena promenljive koji zamenjuju od jedne do n \u0107elija tabele Microsoft je omogu\u0107io da kod upotrebljavanja formula ne moramo vi\u0161e brinuti o apsolutnim I relativnim adresama kod kopiranja formula.<\/p>\n<p>Koje ime smo\u00a0 upotrebili I koje \u0107elije tabele ono obuhvata mo\u017eemo videte na traci sa alatima <strong>Formulas<\/strong> u delu<strong> Name Manager<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1229\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s1.png\" alt=\"\" width=\"751\" height=\"194\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s1.png 751w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s1-350x90.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s1-300x77.png 300w\" sizes=\"auto, (max-width: 751px) 100vw, 751px\" \/><\/p>\n<p>esu. Ta adresa predstavlja kombinaciju broja reda i slova kolona. Na primer, A1 je prva \u0107elija, zatim sledi B1 itd.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1230\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s2.png\" alt=\"\" width=\"288\" height=\"298\" \/><\/p>\n<p>Kombinovanjem vi\u0161e adresa dobijamo jedinstvenu adresu za vi\u0161e \u0107elija. Na primer, A1:A10 su sve \u0107elije iz kolone A sa brojevima od 1 do 10.<\/p>\n<p>Adrese su \u00a0 nam potrebne zbog rada sa formulama. \u0106elije koje predstavljaju argumente formule moramo da precizno selektujemo. Me\u0111utim, umesto apstraktnih adresa koje se te\u0161ko pamte, mo\u017eemo da svakoj \u0107eliji ili grupi \u0107elija damo ime. Na taj na\u010din, kada kasnije pi\u0161emo formulu, umesto adrese \u0107elija koristimo\u00a0njeno ime. Pokaza\u0107emo vam kako se to radi.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Davanje_imena_pojedinacnoj_celiji\"><\/span><strong>Davanje imena pojedina\u010dnoj \u0107eliji<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Davanje imena pojedina\u010dnoj \u0107eliji se mo\u017ee uraditi na nekoliko na\u010dina. Prvi na\u010din predstavlja klik desnim tasterom mi\u0161a, pa potom odabir opcije Defini\u0161i ime. Sada ukucate ime koje \u017eelite da koristite.<\/p>\n<p>Drugi direktan na\u010din je da selektujete \u0107elijum pa potom u polju za ime samo prekucate novo ime. To mo\u017eete uraditi sa bilo kojom \u0107elijom.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1231\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s3.png\" alt=\"\" width=\"380\" height=\"367\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s3.png 380w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s3-350x338.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s3-300x290.png 300w\" sizes=\"auto, (max-width: 380px) 100vw, 380px\" \/><\/p>\n<p>Kasnije kada pravite formule, umesto adrese koja sadr\u017ei broj \u0107elije, mo\u017eete koristiti njeno ime.<\/p>\n<p>Ime je lako zapamtiti i mo\u017eete ga koristiti bilo gde u celom dokumentu, nezavisno od lista u kome se nalazite.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Davanje_imena_grupi_celija\"><\/span><strong>Davanje imena grupi \u0107elija<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ime ne moramo da damo samo pojedina\u010dnoj \u0107eliji. Ime se mo\u017ee dati i grupi \u0107elija, koje imaju neku zajedni\u010dku osobinu.<\/p>\n<p>Potrebno je samo da selektujemo tu grupu \u0107elija, pa ukucamo ime kao na prethodni na\u010din.<\/p>\n<p>Sada grupu \u0107elija mo\u017eemo referencirati u formuli, sli\u010dno kao u prethodnom primeru.[:en]By introducing a variable name that replaces one to n cells of the table, Microsoft has made it possible, when using formulas, not to worry more about absolute and relative addresses when copying formulas.<\/p>\n<p>We&#8217;ve used the name and what cell of the table that it covers, and we can see it on the <strong> Formulas \/\u00a0<strong>Name Manager.<\/strong><\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-1229\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s1.png\" alt=\"\" width=\"751 \" height=\" 194 \" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s1.png 751w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s1-350x90.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s1-300x77.png 300w\" sizes=\"(max-width: 751px) 100vw, 751px\" \/><\/p>\n<p>esu. This address represents a combination of the number of columns and columns. For example, A1 is the first cell, followed by B1, etc.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-1230\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s2.png\" alt=\"\" width=\"288 \" height=\" 298 \" \/><\/p>\n<p>By combining multiple addresses, we get a unique address for multiple cells. For example, A1: A10 are all cells from column A with numbers 1 to 10.<\/p>\n<p>We need adresses for working with formulas. The cells that represent the arguments of the formula must be precisely selected. However, instead of abstract addresses that are hard to remember, we can give a name to each cell or group of cells. In this way, when we write a formula later, we use its name instead of cell address. We&#8217;ll show you how it works.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Give_a_name_to_an_individual_cell\"><\/span><strong> Give a name to an individual cell\u00a0<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"Giving_a_name_to_an_individual_cell_can_be_done_in_several_ways_The_first_way_is_by_right-clicking_the_mouse_and_then_selecting_the_Define_Name_option_You_are_now_typing_the_name_you_want_to_use\"><\/span>Giving a name to an individual cell can be done in several ways. The first way is by right-clicking the mouse, and then selecting the Define Name option. You are now typing the name you want to use.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The second direct way is to select a cell and then just type the new name in the name field. You can do this with any cell.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-1231\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s3.png\" alt=\"\" width=\"380 \" height=\" 367 \" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s3.png 380w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s3-350x338.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s3-300x290.png 300w\" sizes=\"(max-width: 380px) 100vw, 380px\" \/><\/p>\n<p>Later when you make a formula, instead of the address containing the cell number, you can use its name.<\/p>\n<p>The name is easy to remember and you can use it anywhere throughout the document, regardless of the sheet you are in.<\/p>\n<p><strong> Name the cell group\u00a0<\/strong><\/p>\n<p>We do not have to give a name to an individual cell alone. A name can also be given to a group of cells that have some common property.<\/p>\n<p>We only need to select this group of cells, so we type the name as in the previous way.<\/p>\n<p>Now we can refer to a group of cells in the formula, similar to the one in the previous example.[:]\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;1228&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;[:sr] Ocenite [:en]Rate this [:]post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]Promenljive u Excel formulama[:en]Variables in Excel[:]&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            <span class=\"kksr-muted\">[:sr] Ocenite [:en]Rate this [:]post<\/span>\n    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>[:sr]Uvo\u0111enjem imena promenljive koji zamenjuju od jedne do n \u0107elija tabele Microsoft je omogu\u0107io da kod upotrebljavanja formula ne moramo<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49,50],"tags":[],"class_list":["post-1228","post","type-post","status-publish","format-standard","hentry","category-saveti-napredni-excel","category-saveti-poslovni-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>[:sr]Promenljive u Excel formulama[:en]Variables in Excel[:] - Kalkulacija u osnovi svega!<\/title>\n<meta name=\"description\" content=\"Uvo\u0111enjem imena promenljive koji zamenjuju od jedne do n \u0107elija tabele Microsoft je omogu\u0107io da kod upotrebljavanja formula ne moramo vi\u0161e brinuti o apsolutnim I relativnim adresama kod kopiranja formula.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[:sr]Promenljive u Excel formulama[:en]Variables in Excel[:] - Kalkulacija u osnovi svega!\" \/>\n<meta property=\"og:description\" content=\"Uvo\u0111enjem imena promenljive koji zamenjuju od jedne do n \u0107elija tabele Microsoft je omogu\u0107io da kod upotrebljavanja formula ne moramo vi\u0161e brinuti o apsolutnim I relativnim adresama kod kopiranja formula.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-27T18:48:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-01-27T18:51:28+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s1.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/promenljive-u-excel-formulama\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/promenljive-u-excel-formulama\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"[:sr]Promenljive u Excel formulama[:en]Variables in Excel[:]\",\"datePublished\":\"2018-01-27T18:48:35+00:00\",\"dateModified\":\"2018-01-27T18:51:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/promenljive-u-excel-formulama\\\/\"},\"wordCount\":689,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/promenljive-u-excel-formulama\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/s1.png\",\"articleSection\":[\"Saveti za napredni excel\",\"Saveti za poslovni excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/promenljive-u-excel-formulama\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/promenljive-u-excel-formulama\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/promenljive-u-excel-formulama\\\/\",\"name\":\"[:sr]Promenljive u Excel formulama[:en]Variables in Excel[:] - Kalkulacija u osnovi svega!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/promenljive-u-excel-formulama\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/promenljive-u-excel-formulama\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/s1.png\",\"datePublished\":\"2018-01-27T18:48:35+00:00\",\"dateModified\":\"2018-01-27T18:51:28+00:00\",\"description\":\"Uvo\u0111enjem imena promenljive koji zamenjuju od jedne do n \u0107elija tabele Microsoft je omogu\u0107io da kod upotrebljavanja formula ne moramo vi\u0161e brinuti o apsolutnim I relativnim adresama kod kopiranja formula.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/promenljive-u-excel-formulama\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/promenljive-u-excel-formulama\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/promenljive-u-excel-formulama\\\/#primaryimage\",\"url\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/s1.png\",\"contentUrl\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/s1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/promenljive-u-excel-formulama\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Promenljive u Excel formulama\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[:sr]Promenljive u Excel formulama[:en]Variables in Excel[:] - Kalkulacija u osnovi svega!","description":"Uvo\u0111enjem imena promenljive koji zamenjuju od jedne do n \u0107elija tabele Microsoft je omogu\u0107io da kod upotrebljavanja formula ne moramo vi\u0161e brinuti o apsolutnim I relativnim adresama kod kopiranja formula.","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:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/","og_locale":"en_US","og_type":"article","og_title":"[:sr]Promenljive u Excel formulama[:en]Variables in Excel[:] - Kalkulacija u osnovi svega!","og_description":"Uvo\u0111enjem imena promenljive koji zamenjuju od jedne do n \u0107elija tabele Microsoft je omogu\u0107io da kod upotrebljavanja formula ne moramo vi\u0161e brinuti o apsolutnim I relativnim adresama kod kopiranja formula.","og_url":"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2018-01-27T18:48:35+00:00","article_modified_time":"2018-01-27T18:51:28+00:00","og_image":[{"url":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s1.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"[:sr]Promenljive u Excel formulama[:en]Variables in Excel[:]","datePublished":"2018-01-27T18:48:35+00:00","dateModified":"2018-01-27T18:51:28+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/"},"wordCount":689,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/#primaryimage"},"thumbnailUrl":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s1.png","articleSection":["Saveti za napredni excel","Saveti za poslovni excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/","url":"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/","name":"[:sr]Promenljive u Excel formulama[:en]Variables in Excel[:] - Kalkulacija u osnovi svega!","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/#primaryimage"},"thumbnailUrl":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s1.png","datePublished":"2018-01-27T18:48:35+00:00","dateModified":"2018-01-27T18:51:28+00:00","description":"Uvo\u0111enjem imena promenljive koji zamenjuju od jedne do n \u0107elija tabele Microsoft je omogu\u0107io da kod upotrebljavanja formula ne moramo vi\u0161e brinuti o apsolutnim I relativnim adresama kod kopiranja formula.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/#primaryimage","url":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s1.png","contentUrl":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/s1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Promenljive u Excel formulama"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/1228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=1228"}],"version-history":[{"count":3,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/1228\/revisions"}],"predecessor-version":[{"id":2509,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/1228\/revisions\/2509"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=1228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=1228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=1228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}