{"id":3299,"date":"2022-06-23T14:36:24","date_gmt":"2022-06-23T12:36:24","guid":{"rendered":"https:\/\/kalkulacija.com\/wordpress\/?p=3299"},"modified":"2022-06-29T11:28:32","modified_gmt":"2022-06-29T09:28:32","slug":"kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/en\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/","title":{"rendered":"How to create new function in Excel with LAMBDA"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 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\">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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#Svrha_LAMBDA_funkcije_u_Excel-u\" >Svrha LAMBDA funkcije u Excel-u<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#Zasto_napraviti_novu_funkciju_u_Excel-u_upotrebom_LAMBDA\" >Za\u0161to napraviti novu funkciju u Excel-u upotrebom LAMBDA<\/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\/en\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#Prvi_primer_kako_napraviti_novu_funkciju_u_Excel-u_upotrebom_LAMBDA\" >Prvi primer: kako napraviti novu funkciju u Excel-u upotrebom LAMBDA<\/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\/en\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#Drugi_primer_Definicija_imena_nove_funkcije\" >Drugi primer: Definicija imena nove funkcije<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#The_purpose_of_the_LAMBDA_function_in_Excel\" >The purpose of the LAMBDA function in Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#Why_create_a_new_function_in_Excel_using_LAMBDA\" >Why create a new function in Excel using LAMBDA<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#First_example_how_to_create_a_new_function_in_Excel_using_LAMBDA\" >First example: how to create a new function in Excel using LAMBDA<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#Another_example_Definition_of_a_new_function_name\" >Another example: Definition of a new function name<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\nCreating a function in Excel using the LAMBDA function, allows the user to create their own function without knowledge of programming in VBA or other more complicated procedure.\u00a0This making is not difficult and is easy for everyone who went to primary school.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"The_purpose_of_the_LAMBDA_function_in_Excel\"><\/span><span id=\"Svrha_LAMBDA_funkcije_u_Excel-u\" class=\"ez-toc-section\"><\/span>The purpose of the LAMBDA function in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>in\u00a0<a href=\"https:\/\/kalkulacija.com\/istorijat-dodavanja-formula-u-excelu\/\">versions<\/a>\u00a0:\u00a0\u00a0<strong>2021, 365, for\u00a0\u00a0<span class=\"appliesToItem\">Mac<\/span>\u00a0\u00a0and for\u00a0\u00a0<span class=\"appliesToItem\">web<\/span><\/strong><\/p>\n<div class=\"field field-name-parameter-list field-type-ds field-label-above\">\n<div class=\"field-items\">\n<div class=\"field-item even\">\n<div class=\"field field-name-field-parameters field-type-parameter-field field-label-hidden\">\n<div class=\"field-items\">\n<div class=\"field-item even\">\n<div class=\"item-list\">\n<p><span class=\"\">Although\u00a0<\/span><a href=\"https:\/\/kalkulacija.com\/wordpress\/2021\/12\/13\/istorijat-dodavanja-formula-u-excelu\/\"><span class=\"\">Excel<\/span><\/a><span class=\"\">\u00a0appeared in 1987, it was only in the years of the pandemic that it underwent revolutionary changes.\u00a0<\/span><span class=\"\">Okay, maybe some more versions of Excel can get that adjective, but the advent of the LAMBDA function allows the user to create their own function without the need to know programming, Visual Basic, and the like.<\/span><\/p>\n<p>The whole idea of \u200b\u200bexpanding the set of functions did not come by chance.\u00a0You can read more about this in the\u00a0<a href=\"https:\/\/www.microsoft.com\/en-us\/research\/blog\/lambda-the-ultimatae-excel-worksheet-function\/\" target=\"_blank\" rel=\"noopener\">Microsoft Blog<\/a>\u00a0and the indisputable contribution of\u00a0<a href=\"https:\/\/en.wikipedia.org\/wiki\/Alonzo_Church\" target=\"_blank\" rel=\"noopener\">Alonzo Church<\/a>\u00a0, who made a great contribution to mathematical logic and the theory of computer science.<\/p>\n<p>In essence, the whole story of how to create a function in Excel using LAMBDA is actually the process of converting a formula into a function.\u00a0<span class=\"\">If you are worried about the concept of a function or formula in Excel, you can read more about it in our article\u00a0<\/span><a href=\"https:\/\/kalkulacija.com\/wordpress\/razlika-izmedu-formule-i-funkcije-u-excel-u\/\"><span class=\"\">The difference between a formula and a function in Excel.<\/span><\/a><\/p>\n<p>Simply, the first parameter of this function are the variables that we will use and the formula itself, which can be purely mathematical or formed from existing functions in excel.\u00a0For the simplest example, I used the variable ri mathematical formula of the square r * r.<\/p>\n<h2><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3303 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/lambda-02.png\" sizes=\"auto, (max-width: 711px) 100vw, 711px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/lambda-02.png 711w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/lambda-02-300x136.png 300w\" alt=\"\" width=\"711\" height=\"322\" \/><\/h2>\n<p>This simplest example is pointless to use, but it is good for us to write our first LAMBDA function.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Why_create_a_new_function_in_Excel_using_LAMBDA\"><\/span><span class=\"\">Why create a new function in Excel using LAMBDA<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you are ready to create your first custom function, keep in mind that it is not the same when you use\u00a0<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67\" target=\"_blank\" rel=\"noopener\">the LAMBDA function<\/a>\u00a0in a table cell or when it is named as a new function.<\/p>\n<p>The syntax of the function is: = LAMBDA (variable,\u2026, formula)<\/p>\n<p>LAMBDA functions are usually created and debugged in the formula bar on the worksheet, and then moved to the name manager to assign a name that can be used anywhere in the workbook.<\/p>\n<p>There are four basic steps to creating and using a custom LAMBDA feature:<\/p>\n<ol>\n<li>Check the logic you will use with the standard formula<\/li>\n<li>Create and test a generic (unnamed) LAMBDA version of the formula<\/li>\n<li>Name and define the LAMBDA formula using the name manager<\/li>\n<li>Call a new custom function with a defined name<\/li>\n<\/ol>\n<p>The examples below discuss these steps in more detail.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"First_example_how_to_create_a_new_function_in_Excel_using_LAMBDA\"><\/span><span id=\"Prvi_primer_kako_napraviti_novu_funkciju_u_Excel-u_upotrebom_LAMBDA\" class=\"ez-toc-section\"><\/span>First example: how to create a new function in Excel using LAMBDA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The simplest example is the quadratic function.\u00a0As you can see in the picture, there are ordinal numbers in the first column, and in the second column, the LAMBDA function is called after the equals sign.<\/p>\n<figure id=\"attachment_3302\" aria-describedby=\"caption-attachment-3302\" style=\"width: 553px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3302 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/lambda-01.png\" alt=\"Excel LAMBDA funkcija\" width=\"553\" height=\"551\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/lambda-01.png 553w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/lambda-01-300x300.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/lambda-01-150x150.png 150w\" sizes=\"auto, (max-width: 553px) 100vw, 553px\" \/><figcaption id=\"caption-attachment-3302\" class=\"wp-caption-text\">Excel LAMBDA function<\/figcaption><\/figure>\n<p>=\u00a0<strong>LAMBDA (r; r * r)<\/strong>\u00a0the first parameter is a variable that I have given here an arbitrary name (lowercase letter r) the second parameter is the formula itself, in this case simple when multiplying r times r.<\/p>\n<p>Behind the closed parenthesis are the cell addresses from the worksheet whose value will be calculated by this function in parentheses (B3), etc.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Another_example_Definition_of_a_new_function_name\"><\/span><span id=\"Drugi_primer_Definicija_imena_nove_funkcije\" class=\"ez-toc-section\"><\/span>Another example: Definition of a new function name<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>First, the essential definition = <strong>LAMBDA (r; r * r)<\/strong>\u00a0should be entered in the\u00a0<strong>Name Manager located on the\u00a0<\/strong><strong>Formulas<\/strong> toolbar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3319\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/lambda-03-300x231.png\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/lambda-03-300x231.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/lambda-03.png 332w\" alt=\"\" width=\"300\" height=\"231\" \/><\/p>\n<p>You can see how simple it is from the attached picture.<\/p>\n<p>You can download the finished file <a href=\"https:\/\/kalkulacija.com\/download\/lambda.xlsx\">here<\/a>.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\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;3299&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;2&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (2 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;How to create new function in Excel with LAMBDA&quot;,&quot;width&quot;:&quot;142.5&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: 142.5px;\">\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            5\/5 - (2 votes)    <\/div>\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>Creating a function in Excel using the LAMBDA function, allows the user to create their own function without knowledge of<\/p>\n","protected":false},"author":1,"featured_media":3323,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[62,42],"tags":[],"class_list":["post-3299","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel","category-napredni-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Kako napraviti novu funkciju u Excel-u upotrebom LAMBDA<\/title>\n<meta name=\"description\" content=\"Kako napraviti novu funkciju u Excel-u upotrebom LAMBDA, omogu\u0107ava se korisniku da kreira sopstvenu novu funkciju bez znanja programiranja.\" \/>\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\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kako napraviti novu funkciju u Excel-u upotrebom LAMBDA\" \/>\n<meta property=\"og:description\" content=\"Kako napraviti novu funkciju u Excel-u upotrebom LAMBDA, omogu\u0107ava se korisniku da kreira sopstvenu novu funkciju bez znanja programiranja.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/\" \/>\n<meta property=\"og:site_name\" content=\"Calculation in essence of everything!\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-23T12:36:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-29T09:28:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/Lambdas_Hero_updated.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1370\" \/>\n\t<meta property=\"og:image:height\" content=\"574\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"How to create new function in Excel with LAMBDA\",\"datePublished\":\"2022-06-23T12:36:24+00:00\",\"dateModified\":\"2022-06-29T09:28:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\\\/\"},\"wordCount\":1162,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/Lambdas_Hero_updated.jpg\",\"articleSection\":[\"Microsoft\u00ae Excel\",\"Advanced Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\\\/\",\"name\":\"Kako napraviti novu funkciju u Excel-u upotrebom LAMBDA\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/Lambdas_Hero_updated.jpg\",\"datePublished\":\"2022-06-23T12:36:24+00:00\",\"dateModified\":\"2022-06-29T09:28:32+00:00\",\"description\":\"Kako napraviti novu funkciju u Excel-u upotrebom LAMBDA, omogu\u0107ava se korisniku da kreira sopstvenu novu funkciju bez znanja programiranja.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/Lambdas_Hero_updated.jpg\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/Lambdas_Hero_updated.jpg\",\"width\":1370,\"height\":574,\"caption\":\"Kako napraviti novu funkciju upotrebom lambda\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kako napraviti novu funkciju u Excel-u upotrebom LAMBDA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Calculation in essence of everything!\",\"description\":\"Go ahead! Improve your data processing skills!\",\"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":"Kako napraviti novu funkciju u Excel-u upotrebom LAMBDA","description":"Kako napraviti novu funkciju u Excel-u upotrebom LAMBDA, omogu\u0107ava se korisniku da kreira sopstvenu novu funkciju bez znanja programiranja.","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\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/","og_locale":"en_US","og_type":"article","og_title":"Kako napraviti novu funkciju u Excel-u upotrebom LAMBDA","og_description":"Kako napraviti novu funkciju u Excel-u upotrebom LAMBDA, omogu\u0107ava se korisniku da kreira sopstvenu novu funkciju bez znanja programiranja.","og_url":"https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/","og_site_name":"Calculation in essence of everything!","article_published_time":"2022-06-23T12:36:24+00:00","article_modified_time":"2022-06-29T09:28:32+00:00","og_image":[{"width":1370,"height":574,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/Lambdas_Hero_updated.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"How to create new function in Excel with LAMBDA","datePublished":"2022-06-23T12:36:24+00:00","dateModified":"2022-06-29T09:28:32+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/"},"wordCount":1162,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/Lambdas_Hero_updated.jpg","articleSection":["Microsoft\u00ae Excel","Advanced Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/","url":"https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/","name":"Kako napraviti novu funkciju u Excel-u upotrebom LAMBDA","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/Lambdas_Hero_updated.jpg","datePublished":"2022-06-23T12:36:24+00:00","dateModified":"2022-06-29T09:28:32+00:00","description":"Kako napraviti novu funkciju u Excel-u upotrebom LAMBDA, omogu\u0107ava se korisniku da kreira sopstvenu novu funkciju bez znanja programiranja.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/Lambdas_Hero_updated.jpg","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/Lambdas_Hero_updated.jpg","width":1370,"height":574,"caption":"Kako napraviti novu funkciju upotrebom lambda"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Kako napraviti novu funkciju u Excel-u upotrebom LAMBDA"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Calculation in essence of everything!","description":"Go ahead! Improve your data processing skills!","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\/en\/wp-json\/wp\/v2\/posts\/3299","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/comments?post=3299"}],"version-history":[{"count":24,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/3299\/revisions"}],"predecessor-version":[{"id":3328,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/3299\/revisions\/3328"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media\/3323"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media?parent=3299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/categories?post=3299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/tags?post=3299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}