{"id":21946,"date":"2020-12-10T13:06:45","date_gmt":"2020-12-10T12:06:45","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=21946"},"modified":"2024-02-06T16:15:40","modified_gmt":"2024-02-06T15:15:40","slug":"lambda-function-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/lambda-function-in-excel\/","title":{"rendered":"LAMBDA Function in Excel &#8211; Create Custom Functions in Excel"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone wp-image-22015 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Lambda-Function.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Lambda-Function.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Lambda-Function-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Lambda-Function-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>The LAMBDA function in EXCEL 365 will revolutionize the way you can build custom functions in Excel.<\/p>\n<p>You can create a custom function in Excel without the use of <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/\" target=\"_blank\" rel=\"noopener\" title=\"VBA\" data-wpil-keyword-link=\"linked\">VBA<\/a> user-defined functions.<\/p>\n<p>In this article, we will cover the following points in detail:<\/p>\n<ul>\n<li><a href=\"#lambda-function-in-excel\"><strong>LAMBDA function in Excel<\/strong><\/a><\/li>\n<li><a href=\"#syntax-of-lambda-function\"><strong>Syntax of LAMBDA function<\/strong><\/a><\/li>\n<li><a href=\"#examples-of-lambda-function\"><strong>Examples of LAMBDA function<\/strong><\/a><\/li>\n<li><a href=\"#naming-a-lambda-function-in-excel\"><strong>Naming a LAMBDA function in Excel<\/strong><\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/lambda-function-in-excel\/#Want_to_know_how_to_use_the_LAMBDA_function\" title=\"Want to know how to use the LAMBDA function?\">Want to know how to use the LAMBDA function?<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Want_to_know_how_to_use_the_LAMBDA_function\"><\/span><em><strong>Want to know how to use the LAMBDA function?<\/strong><\/em><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/QHyX-VN1al0\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/QHyX-VN1al0?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Lambda.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Lambda.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download the youtube excel practice file<\/strong><\/span><span class=\"postTitle px-3\">Lambda.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>Follow the<strong> step-by-step tutorial<\/strong> below and make sure to download the Excel workbook to follow along:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/LAMBDA-Function.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Vlookup_Intro1.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">LAMBDA-Function.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"lambda-function-in-excel\"><\/a><span style=\"color: #339966;\">LAMBDA function in Excel<\/span><\/strong><\/h3>\n<p>What is this newly introduced function &#8211; Excel LAMBDA???<\/p>\n<p>The LAMBDA function in Excel can be<strong> used to create a custom function without any coding<\/strong> and then <strong>reuse it anywhere in your <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" title=\"spreadsheet\" data-wpil-keyword-link=\"linked\">spreadsheet<\/a><\/strong>. This Excel function is exclusively <strong>available in Excel 365 only.\u00a0 <\/strong><\/p>\n<p>At the time of publishing this article, it is being rolled out slowly around the world for<strong> Office Insiders who are signed up for Beta Channel<\/strong> (You can check what <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/what-microsoft-excel-version-do-i-have\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel version you have here<\/a>).<\/p>\n<p>You can <strong>use Excel&#8217;s own <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a> language<\/strong> to create custom functions. So, no need to learn complex coding language like VBA.<\/p>\n<p>You can <strong>call another function in this function<\/strong> as well. Hence, there is <strong>no limit to the power of this super useful function<\/strong>.<\/p>\n<p>Let&#8217;s take a quick look at the syntax of this function!<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"syntax-of-lambda-function\"><\/a><span style=\"color: #339966;\">Syntax of LAMBDA function<\/span><\/strong><\/h3>\n<p>The LAMBDA function syntax has the following arguments:<\/p>\n<h3><span style=\"color: #000000;\">=LAMBDA(parameter1, parameter2, &#8230;, calculation)<\/span><\/h3>\n<ul>\n<li><strong>parameter(s)<\/strong> &#8211; The value you want to use in the calculation. It can be a cell reference, range, or number. There can be numerous parameters in this function.<br \/>\n<em>This argument is optional.<\/em><\/li>\n<li><strong>calculations<\/strong> &#8211; The formula you want Excel to execute. It should be the last argument of the function.<br \/>\n<em>This argument is required.<\/em><\/li>\n<\/ul>\n<p>Let&#8217;s look at an example and understand how this function works.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"examples-of-lambda-function\"><\/a><span style=\"color: #339966;\">Examples of LAMBDA function<\/span><\/strong><\/h3>\n<p><span style=\"color: #339966;\"><strong>Example 1:<\/strong><\/span><\/p>\n<p>Suppose you have the formula<\/p>\n<h3><span style=\"color: #000000;\">=LAMBDA(start,end,end\/start-1)<\/span><\/h3>\n<p>Here,<\/p>\n<ul>\n<li><strong>start and end<\/strong> are the parameters<\/li>\n<li><strong>end\/start-1<\/strong> is the calculation<\/li>\n<\/ul>\n<h3><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-14.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22165\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-14.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"786\" height=\"357\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-14.png 786w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-14-300x136.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-14-768x349.png 768w\" sizes=\"(max-width: 786px) 100vw, 786px\" \/><\/a><\/h3>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\">Calling the LAMBDA function<\/span><\/h3>\n<p>We need one more step to conclude our LAMBDA function.\u00a0 <strong>If you skip this step, you will get #CALC! error.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-1036.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22168\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-1036.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"783\" height=\"327\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-1036.png 783w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-1036-300x125.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-1036-768x321.png 768w\" sizes=\"(max-width: 783px) 100vw, 783px\" \/><\/a><\/p>\n<p>In our example above, we need to enter the values for &#8220;start&#8221; and &#8220;end&#8221; <strong>within the parenthesis to call this function and get a result:<\/strong><\/p>\n<h3><span style=\"color: #000000;\">=LAMBDA(start,end, end\/start-1)<\/span><span style=\"color: #339966;\">(100,110)<\/span><\/h3>\n<p>Here,<\/p>\n<ul>\n<li><strong>100<\/strong> is the value that will be used for start<\/li>\n<li><strong>110<\/strong> is the value that will be used for end<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-15.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22166\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-15.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"788\" height=\"327\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-15.png 788w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-15-300x124.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-15-768x319.png 768w\" sizes=\"(max-width: 788px) 100vw, 788px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Excel will now <strong>replace<\/strong> the parameters with the valued and complete the calculation as:<\/p>\n<p>=110\/100-1<\/p>\n<p>=0.10<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-16.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22167\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-16.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"785\" height=\"355\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-16.png 785w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-16-300x136.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-16-768x347.png 768w\" sizes=\"(max-width: 785px) 100vw, 785px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>Example 2:<\/strong><\/span><\/p>\n<p>In the example below, we have a column with the <strong>pound values <\/strong>and\u00a0a column with the <strong>conversion rate<\/strong>.<\/p>\n<p>In the third column, we will be<strong> using the LAMBA function to create a custom function to convert the amount from pound to dollar<\/strong> using the conversion rate.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-17.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22169\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-17.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"801\" height=\"425\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-17.png 801w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-17-300x159.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-17-768x407.png 768w\" sizes=\"(max-width: 801px) 100vw, 801px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Follow the <strong>step-by-step tutorial<\/strong> below to know how to create custom functions in Excel using the LAMBA function:<\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 1:<\/strong><\/span> Start with an <strong>equal to sign<\/strong> and type the <strong>name of the formula.<\/strong><\/p>\n<h3><span style=\"color: #000000;\">=LAMBDA<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-18.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22170\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-18.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"802\" height=\"445\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-18.png 802w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-18-300x166.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-18-768x426.png 768w\" sizes=\"(max-width: 802px) 100vw, 802px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #339966;\">STEP 2:<\/span> Open parenthesis<\/strong> and type the <strong>first argument<\/strong> of the function i.e.<strong> The parameters<\/strong> (amount in pound and conversion rate)<\/p>\n<h3><span style=\"color: #339966;\"><span style=\"color: #000000;\">=LAMBDA <span style=\"color: #339966;\">(<\/span><\/span>pound, conversion,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-20.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22171\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-20.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"800\" height=\"424\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-20.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-20-300x159.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-20-768x407.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 3:<\/strong><\/span> Now, <strong>enter the custom calculation<\/strong> i.e. pound*conversion, and <strong>close the parenthesis<\/strong>.<\/p>\n<h3><span style=\"color: #339966;\"><span style=\"color: #000000;\">=LAMBDA (pound, conversion,<\/span> pound*conversion)<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-21.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22172\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-21.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"797\" height=\"422\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-21.png 797w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-21-300x159.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-21-768x407.png 768w\" sizes=\"(max-width: 797px) 100vw, 797px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 4:<\/strong><\/span> Next, you need to provide the inputs for this function within another parenthesis so we can get the results (If you skip this step, you will get #CALC! error).<\/p>\n<h3><span style=\"color: #339966;\"><span style=\"color: #000000;\">=LAMBDA (pound, conversion, pound*conversion)<\/span>(B6,C6)<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-23.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22173\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-23.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"800\" height=\"424\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-23.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-23-300x159.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-23-768x407.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 5:<\/strong> <\/span>The converted value in dollar will be displayed in the cells when you drag the formula all the way down.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-24.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22174\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-24.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"801\" height=\"415\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-24.png 801w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-24-300x155.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-24-768x398.png 768w\" sizes=\"(max-width: 801px) 100vw, 801px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><strong><a id=\"naming-a-lambda-function-in-excel\"><\/a>Naming a LAMBDA function in Excel<\/strong><\/span><\/h3>\n<p><strong>THIS IS WHERE THE POWER OF THE LAMBDA FUNCTION EXISTS!<\/strong><\/p>\n<p>Now that you have learned how to create the new LAMBDA function in Excel, let&#8217;s move forward and take a <strong>look a how you can store this function in Excel so that you can re-use it within your Excel workbook<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p>Follow the steps below to <strong>use Name Manager<\/strong> to store the LAMBDA function (created in Example 2) for re-use.<\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 1:<\/strong><\/span> Go to <strong><a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"Formulas\" data-wpil-keyword-link=\"linked\">Formulas<\/a><\/strong> &gt; <strong>Name Manager<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22006\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-5.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"1014\" height=\"126\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-5.png 1014w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-5-300x37.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-5-768x95.png 768w\" sizes=\"(max-width: 1014px) 100vw, 1014px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 2:<\/strong><\/span> In the Name Manager dialog box, click on the <strong>New<\/strong> button.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22007\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-6.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"554\" height=\"432\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-6.png 554w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-6-300x234.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 3:<\/strong> <\/span>In the New Name dialog box, enter the following details<\/p>\n<ul>\n<li><strong>Name<\/strong> of the function i.e. <strong>CurrencyConversion <\/strong>(Make sure there are no spaces)<\/li>\n<li>Brief <strong>description<\/strong> related to this function i.e. <strong>Use this function to convert pound to dollar.<\/strong><\/li>\n<li>The <strong>parameters<\/strong> of the function i.e. <strong>=LAMBDA(pound,conversion,pound*conversion)<\/strong>.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22008\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-7.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"434\" height=\"271\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-7.png 434w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-7-300x187.png 300w\" sizes=\"(max-width: 434px) 100vw, 434px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 4:<\/strong> <\/span>Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22009\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-8.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"388\" height=\"271\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-8.png 388w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-8-300x210.png 300w\" sizes=\"(max-width: 388px) 100vw, 388px\" \/><\/a><\/p>\n<p>That&#8217;s it! Your custom function is now ready for use.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22010\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-9.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"553\" height=\"434\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-9.png 553w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-9-300x235.png 300w\" sizes=\"(max-width: 553px) 100vw, 553px\" \/><\/a><\/p>\n<p>You can use this custom function by calling the function name &#8211; CurrencyConversion.<\/p>\n<h3><span style=\"color: #000000;\">=CurrencyConversion(316,1.4)\u00a0<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-29.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22175\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-29.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"802\" height=\"320\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-29.png 802w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-29-300x120.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-29-768x306.png 768w\" sizes=\"(max-width: 802px) 100vw, 802px\" \/><\/a><\/p>\n<p>Excel will return the value <strong>442.2<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-30.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"LAMBDA Function in Excel - Create Custom Functions in Excel\"  class=\"alignnone size-full wp-image-22176\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-30.png\" alt=\"LAMBDA Function in Excel - Create Custom Functions in Excel\" width=\"801\" height=\"257\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-30.png 801w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-30-300x96.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Screenshot-30-768x246.png 768w\" sizes=\"(max-width: 801px) 100vw, 801px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>This AWESOME function is available for Microsoft 365 users only who are on the Office Insider Beta program and will be rolled out gradually to the rest of the programs in the coming months. <a href=\"https:\/\/www.microsoft.com\/en-nz\/microsoft-365\/excel?rtc=1\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Click here<\/strong><\/a> to purchase Microsoft 365.<\/p>\n<p>You can also go through the Microsoft tutorial on the LAMBDA function in Excel by <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>clicking here<\/strong><\/a>!<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Make sure to download our FREE PDF on the<a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"> 333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14329 size-medium\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg\" alt=\"Microsoft Excel Training\" width=\"300\" height=\"200\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-1024x682.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-768x512.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups.jpg 1340w\" sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\"><\/a><\/p>\n<p>You can learn more about how to use Excel by viewing our FREE Excel webinar training on <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Formulas<\/a>, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Tables<\/a>, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/power-query-data-cleansing-webinar.html\" target=\"_blank\">Power Query<\/a>,<\/strong> and <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" target=\"_blank\" rel=\"noopener noreferrer\">Macros &amp; VBA<\/a><\/strong>!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The LAMBDA function in EXCEL 365 will revolutionize the way you can build custom functions in Excel. You can create a custom function in Excel without the use of VBA user-defined functions. In this article, we will cover the following points in detail: LAMBDA function in Excel Syntax of LAMBDA function Examples of LAMBDA function [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":22015,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,1],"tags":[705,706,704,707],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/21946"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=21946"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/21946\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/22015"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=21946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=21946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=21946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}