{"id":24350,"date":"2021-06-25T16:32:00","date_gmt":"2021-06-25T14:32:00","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=24350"},"modified":"2024-02-06T19:20:10","modified_gmt":"2024-02-06T18:20:10","slug":"how-to-use-excel-let-function","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-use-excel-let-function\/","title":{"rendered":"How to use Excel LET function"},"content":{"rendered":"<p>If you<strong> write long complex <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> in Excel, then the new LET function is a perfect match for you.\u00a0It lets you <strong>define variables inside the <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><\/strong> and get calculation results. Excel LET function is <strong>useful when you use the same expression multiple times<\/strong> in a formula.<\/p>\n<p>This function is <strong>available exclusively for Excel 365<\/strong> subscribers.<\/p>\n<p><strong><a href=\"https:\/\/www.microsoft.com\/en-in\/microsoft-365\/buy\/compare-all-microsoft-365-products?tab=1&amp;irgwc=1&amp;OCID=AID2000142_aff_7593_1378045&amp;tduid=(ir__iefeis9zqskftzjdxmdf30kppu2xszvzei10s9pk00)(7593)(1378045)()()&amp;irclickid=_iefeis9zqskftzjdxmdf30kppu2xszvzei10s9pk00&amp;rtc=1\" target=\"_blank\" rel=\"nofollow noopener\">Sign up to Office 365<\/a><\/strong> to get access to all the <strong>cool updates and new functions<\/strong> that allow you to be more efficient in Excel.<\/p>\n<p>In this article, you will be provided a detailed guide on the following:<\/p>\n<ul>\n<li><strong><a href=\"#lesson1\">Introduction to Excel LET Function<\/a><\/strong><\/li>\n<li><a href=\"#lesson2\"><strong>Syntax &amp; Arguments<\/strong><\/a><\/li>\n<li><a href=\"#lesson3\"><strong>LET with one name-value pair<\/strong><\/a><\/li>\n<li><a href=\"#lesson4\"><strong>LET with five name-value pairs<\/strong><\/a><\/li>\n<li><a href=\"#lesson5\"><strong>LET with Emojis<\/strong><\/a><\/li>\n<li><a href=\"#lesson6\"><strong>LET using Name manager<\/strong><\/a><\/li>\n<\/ul>\n<p>Watch how to use the LET function in Excel on <a href=\"https:\/\/youtu.be\/rZPAogQwZ5w\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a>\u00a0and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/rZPAogQwZ5w \" 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<p>Download this Introduction to the <strong><a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\" title=\"Microsoft Excel\" data-wpil-keyword-link=\"linked\">Microsoft Excel<\/a> LET Function Tutorial workbook<\/strong> so you can practice along with us:<\/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\/2021\/06\/LetFunction-1.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/XLOOKUP.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">LetFunction-1.xlsx<\/span><\/a><\/p>\n<\/div>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><strong><a id=\"lesson1\"><\/a>Introduction to Excel LET function<\/strong><\/span><\/h3>\n<p>You might have used <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-a-named-range-in-excel\/\" target=\"_blank\">Named Range<\/a> in Excel<\/strong> while creating lengthy formulas and know how they make the formula easier to read. LET function is like an advanced version of named ranges.<\/p>\n<p>It lets you <strong>assign names directly to the calculation<\/strong>. In this way, Excel <strong>calculates the value of the variables just once<\/strong> and <strong>uses it several times<\/strong> within the same formula.<\/p>\n<p>The <strong>three benefits<\/strong> of using LET functions are:<\/p>\n<ul>\n<li><strong>Improves formula readability<\/strong>\u00a0&#8211; Assigning a <strong>user-friendly name to a range\/variable<\/strong> and using it repeatedly in the calculation will make the formula <strong>cleaner, easier to read and understand<\/strong>.<\/li>\n<li><strong>Improves performance<\/strong> &#8211; Excel LET function eliminates duplicate calculation. The <strong>expression is evaluated at the beginning of the formula<\/strong> and then <strong>reused multiple times<\/strong> without further calculation. This increases the speed and performance of the worksheet.<\/li>\n<li><strong>Easier to update<\/strong> &#8211; If you need to <strong>change the value of the defined variable<\/strong>, you can easily <strong>change it at the beginning<\/strong> instead of updating the same expressions multiple times.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><strong><a id=\"lesson2\"><\/a>Syntax &amp; Arguments<\/strong><\/span><\/h3>\n<p>The formula breakdown of the Excel LET function is:<\/p>\n<p><em>=LET (<span style=\"color: #3366ff;\">name1<\/span>, <span style=\"color: #3366ff;\">value1, <\/span><span style=\"color: #339966;\">[name2]<\/span>, <span style=\"color: #339966;\">[value2], <\/span><span style=\"color: #ff9900;\">calculation<\/span>)<\/em><\/p>\n<p>where:<\/p>\n<ul>\n<li><span style=\"color: #3366ff;\">name1 <\/span><span style=\"color: #000000;\">&#8211; the name of the first variable defined <em>(it should be without spaces, period, or special characters)<\/em>;<\/span><\/li>\n<li><span style=\"color: #000000;\"> <span style=\"color: #3366ff;\">value1<\/span>&#8211; the value that should be assigned to the first name <em>(it can be text, number, cell reference, or formula)<\/em>;<\/span><\/li>\n<li><span style=\"color: #ff9900;\"><span style=\"color: #339966;\">name2<\/span><\/span><span style=\"color: #000000;\"> &#8211; the name of the second variable <em>(optional)<\/em>;<\/span><\/li>\n<li><span style=\"color: #339966;\">value2<\/span><em><span style=\"color: #339966;\"><span style=\"color: #000000;\">&#8211; <\/span><\/span><\/em><span style=\"color: #339966;\"><span style=\"color: #000000;\">the value assigned to second variable <em>(optional)<\/em>;<\/span><\/span><\/li>\n<li><span style=\"color: #ff9900;\">calculation <\/span><span style=\"color: #ff9900;\"><span style=\"color: #339966;\"><span style=\"color: #000000;\">&#8211; the expression or formula that uses these defined variables.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><strong>For example:<\/strong><\/p>\n<p><em>=LET(x, 5, y, 9, x+y\/x)<\/em><\/p>\n<p>Here, Excel will assign 5 to variable x, 9 to variable y, and then perform the calculation &#8211; 5+9\/5. It will return the output as 6.8.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone wp-image-24423 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let-1.png\" alt=\"How to use Excel LET function\" width=\"571\" height=\"261\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let-1.png 571w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let-1-300x137.png 300w\" sizes=\"(max-width: 571px) 100vw, 571px\" \/><\/a><\/p>\n<p>You can define <strong>numerous pairs of names and their values<\/strong> and insert a calculation that uses all of them. Excel can handle a <strong>total of 126 name-value pairs<\/strong> in this function.<\/p>\n<p>Before you start using this incredible function, there are <strong>few things that you should note<\/strong>:<\/p>\n<ul>\n<li>LET function is <strong>not available in any of the older versions of Excel (2010, 2013, 2016, 2019)<\/strong>. Only in Excel for Microsoft 365.<\/li>\n<li>The <strong>scope of defined names is limited to that formula<\/strong> only. You can <strong>reuse these assigned names multiple times<\/strong> within the formula but not anywhere else.<\/li>\n<li>There should be <strong>several name-value pairs<\/strong> but the <strong>last argument should be &#8220;calculation&#8221;<\/strong>.<\/li>\n<li>The <strong>name<\/strong> argument <strong>should start with a letter, an underscore (_), or a backslash (\\)<\/strong>. It cannot start with an &#8220;r&#8221; or &#8220;c&#8221; as they are reserved for the R1C1 style.<\/li>\n<li>The name argument should<strong> follow the same convention as the named range<\/strong> i.e. <span style=\"color: #000000;\">it should be<strong> without spaces, period, or special characters<\/strong>.<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><strong><a id=\"lesson3\"><\/a>LET with one name-value pair<\/strong><\/span><\/h3>\n<p>Let&#8217;s start with an easy example of one name-value pair to simply understand the working of the Excel LET function.<\/p>\n<p>In this example, we have<strong> date, expected output, actual output in columns B, C, and D<\/strong> respectively. Since there is a discrepancy between the actual and expected output, we have<strong> calculated the difference in percentage<\/strong> between the two in<strong> column E<\/strong>.<\/p>\n<p>This will give an estimate regarding how much was actually produced over how much was expected to produce.<\/p>\n<div class=\"cue-group style-scope ytd-transcript-body-renderer\">\n<div class=\"cues style-scope ytd-transcript-body-renderer\">\n<div class=\"cue style-scope ytd-transcript-body-renderer\" tabindex=\"0\" role=\"button\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24425\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let-2.png\" alt=\"How to use Excel LET function\" width=\"666\" height=\"470\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let-2.png 666w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let-2-300x212.png 300w\" sizes=\"(max-width: 666px) 100vw, 666px\" \/><\/a><\/div>\n<\/div>\n<\/div>\n<div tabindex=\"0\" role=\"button\"><\/div>\n<div tabindex=\"0\" role=\"button\">Based on the difference % mentioned in column E, we would like to give feedback as below:<\/div>\n<ul>\n<li tabindex=\"0\" role=\"button\">If the difference is<strong> less than 0.8, we want to return the word &#8220;bad&#8221;<\/strong>. It was not a productive day as the units produced was below the expected units.<\/li>\n<li tabindex=\"0\" role=\"button\">If the difference is <strong>greater than 1, we want to return the word &#8220;good&#8221;<\/strong>. It was a productive day as we produced more than what we had expected.<\/li>\n<\/ul>\n<p>Now, we can use either<strong> the Nested IF function or the LET function<\/strong> to achieve this result.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>Nested IF Function<\/strong><\/span><\/p>\n<p>IF function is used to test a condition and return a value if the condition is met, and a value if it is not. The syntax of the IF function is:<\/p>\n<p>=IF(<span style=\"color: #0000ff;\">Logical Test<\/span>, <span style=\"color: #ff6600;\">Value if True<\/span>, <span style=\"color: #008000;\">Value if False<\/span>)<\/p>\n<p>In the example, you will be using the Nested IF function to test both conditions. So, let&#8217;s begin!<\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong><\/span>We need to enter the <strong>IF function<\/strong> in a blank cell:<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\">=IF(<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24428\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let3.png\" alt=\"How to use Excel LET function\" width=\"671\" height=\"492\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let3.png 671w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let3-300x220.png 300w\" sizes=\"(max-width: 671px) 100vw, 671px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>Enter the first argument &#8211;\u00a0<strong><em><span style=\"color: #0000ff;\">Logical_test<\/span><\/em><\/strong><\/p>\n<p><strong>What is your condition? <\/strong>The difference % should be greater than 1.<\/p>\n<h3 style=\"text-align: center;\">=IF(<span style=\"color: #0000ff;\">E5&gt;1,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24430\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let4.png\" alt=\"How to use Excel LET function\" width=\"679\" height=\"492\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let4.png 679w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let4-300x217.png 300w\" sizes=\"(max-width: 679px) 100vw, 679px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> <\/strong>Enter the second argument &#8211; <strong><em><span style=\"color: #0000ff;\">Value_if_true<\/span><\/em><\/strong><\/p>\n<p><strong>What value should be displayed if the condition is true?\u00a0<\/strong>We want &#8220;good&#8221; to be displayed.<\/p>\n<h3 style=\"text-align: center;\">=IF(E5&gt;1, <span style=\"color: #0000ff;\">&#8220;good&#8221;,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24431\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let5.png\" alt=\"How to use Excel LET function\" width=\"673\" height=\"488\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let5.png 673w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let5-300x218.png 300w\" sizes=\"(max-width: 673px) 100vw, 673px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span> <\/strong>Enter the third argument &#8211; <strong><em><span style=\"color: #0000ff;\">Value_if_false<\/span><\/em><\/strong><\/p>\n<p><strong>What value should be displayed if the condition is false?\u00a0<\/strong>If the condition is not met, we want to insert another IF function.<\/p>\n<h3 style=\"text-align: center;\">=IF(E5&gt;1, &#8220;good&#8221;, <span style=\"color: #0000ff;\">IF(E5&lt;0.8,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24432\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let6.png\" alt=\"How to use Excel LET function\" width=\"672\" height=\"490\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let6.png 672w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let6-300x219.png 300w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5:<\/span> <\/strong>Enter the value if the condition of the second IF function is met.<\/p>\n<h3 style=\"text-align: center;\">=IF(E5&gt;1, &#8220;good&#8221;, IF(E5&lt;0.8, <span style=\"color: #0000ff;\">&#8220;bad&#8221;<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24433\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let7.png\" alt=\"How to use Excel LET function\" width=\"672\" height=\"489\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let7.png 672w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let7-300x218.png 300w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 6:<\/span> <\/strong>Lastly, enter a blank when both conditions are not met.<\/p>\n<h3 style=\"text-align: center;\">=IF(E5&gt;1, &#8220;good&#8221;, IF(E5&lt;0.8,&#8221;bad&#8221;,<span style=\"color: #0000ff;\">&#8220;&#8221;)<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24434\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let8.png\" alt=\"How to use Excel LET function\" width=\"674\" height=\"492\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let8.png 674w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let8-300x219.png 300w\" sizes=\"(max-width: 674px) 100vw, 674px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 7:<\/span> <\/strong>Copy the formula below in the column.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24435\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let9.png\" alt=\"How to use Excel LET function\" width=\"682\" height=\"517\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let9.png 682w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let9-300x227.png 300w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>LET Function<\/strong><\/span><\/p>\n<p>In this example, we will assign the difference % to a variable &#8220;pchg&#8221; using the LET function and then calculate the result.<\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong><\/span>We need to enter the <strong>LET function<\/strong> in a blank cell:<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\">=LET(<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24438\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let10.png\" alt=\"How to use Excel LET function\" width=\"672\" height=\"437\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let10.png 672w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let10-300x195.png 300w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong><\/span>Enter the first argument i.e. name<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=LET(<\/span>pchg,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24439\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let11.png\" alt=\"How to use Excel LET function\" width=\"670\" height=\"435\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let11.png 670w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let11-300x195.png 300w\" sizes=\"(max-width: 670px) 100vw, 670px\" \/><\/a>&#8230;.<\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> <\/strong><\/span>Enter the second argument i.e. value to the name assigned. Here, the value is inserted in cell D5.<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=LET(pchg, <\/span>E5,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24440\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let12.png\" alt=\"How to use Excel LET function\" width=\"671\" height=\"436\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let12.png 671w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let12-300x195.png 300w\" sizes=\"(max-width: 671px) 100vw, 671px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 4:<\/span> <\/strong><\/span>Now enter the entire nested IF function and replace the cell reference D5 to the variable pchg.<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=LET(pchg, D5, <\/span>IF(pchg&gt;1,&#8221;good&#8221;,IF(pchg&lt;0.8,&#8221;bad&#8221;,&#8221;&#8221;))<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/LET13.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24441\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/LET13.png\" alt=\"How to use Excel LET function\" width=\"670\" height=\"435\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/LET13.png 670w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/LET13-300x195.png 300w\" sizes=\"(max-width: 670px) 100vw, 670px\" \/><\/a><\/p>\n<p>As you can see, the <strong>LET function does exactly what the IF function<\/strong> was doing when we are using just one variable.<\/p>\n<p>Let&#8217;s look at another example where using the LET function will be more useful than the nested IF .function.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>Example 2:<\/strong><\/span><\/p>\n<p>In this example, we have sales from two branches, and we need to calculate commission based on it:<\/p>\n<ul>\n<li>If the <strong>total sales are greater than $7,000<\/strong>, the commission will be <strong>10%<\/strong>;<\/li>\n<li>If the<strong> total sales are greater than $5,000<\/strong>, the commission will be <strong>8%<\/strong>;<\/li>\n<li>If the total sales are less than or equal to $5,000, the commission will be <strong>0<\/strong>.<\/li>\n<\/ul>\n<p>In the worksheet below, we have two columns E and F that will contain the commission amount calculated using LET and Nested If respectively.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let14.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24447\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let14.png\" alt=\"How to use Excel LET function\" width=\"577\" height=\"470\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let14.png 577w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let14-300x244.png 300w\" sizes=\"(max-width: 577px) 100vw, 577px\" \/><\/a><\/p>\n<p>Using the <strong>Nested IF function<\/strong>, we can use the following formula to total commission:<\/p>\n<h3 style=\"text-align: center;\">=IF(SUM(C5:D5)&gt;7000, SUM(C5:D5)*10%,IF(SUM(C5:D5)&gt;5000, SUM(C5:D5)*8%,0))<\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let15.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24448\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let15.png\" alt=\"How to use Excel LET function\" width=\"799\" height=\"512\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let15.png 799w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let15-300x192.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let15-768x492.png 768w\" sizes=\"(max-width: 799px) 100vw, 799px\" \/><\/a><\/p>\n<p>Follow the steps below to get the work done using the LET function:<\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong><\/span>Enter the <strong>LET function<\/strong> in a blank cell:<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\">=LET(<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let16.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24449\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let16.png\" alt=\"How to use Excel LET function\" width=\"777\" height=\"512\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let16.png 777w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let16-300x198.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let16-768x506.png 768w\" sizes=\"(max-width: 777px) 100vw, 777px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong><\/span>Enter the <strong>name for the variable to calculate the total sales<\/strong> i.e. total<\/p>\n<h3 style=\"text-align: center;\">=LET(<span style=\"color: #0000ff;\">total,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let17.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24450\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let17.png\" alt=\"How to use Excel LET function\" width=\"790\" height=\"510\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let17.png 790w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let17-300x194.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let17-768x496.png 768w\" sizes=\"(max-width: 790px) 100vw, 790px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> <\/strong><\/span>Enter the <strong>formula\u00a0for the defined variable <\/strong>i.e. SUM(C5:D5)<\/p>\n<h3 style=\"text-align: center;\">=LET(total, <span style=\"color: #0000ff;\">SUM(C5:D5),<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let18.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24451\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let18.png\" alt=\"How to use Excel LET function\" width=\"741\" height=\"508\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let18.png 741w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let18-300x206.png 300w\" sizes=\"(max-width: 741px) 100vw, 741px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 4:<\/span> <\/strong><\/span>Enter the IF formula using the variable &#8220;total&#8221;.<\/p>\n<h3 style=\"text-align: center;\">=LET(total,SUM(C5:D5), <span style=\"color: #0000ff;\">IF(total&gt;7000,total*10%,IF(total&gt;5000,total*8%,0))<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let19.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24452\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let19.png\" alt=\"How to use Excel LET function\" width=\"751\" height=\"511\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let19.png 751w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let19-300x204.png 300w\" sizes=\"(max-width: 751px) 100vw, 751px\" \/><\/a><\/p>\n<p>If we are using the<strong> Nested IF function<\/strong> only, Excel has to <strong>calculate the SUM function four times<\/strong>:<\/p>\n<h3 style=\"text-align: center;\">=IF(<span style=\"color: #3366ff;\">SUM(C5:D5)<\/span>&gt;7000, <span style=\"color: #3366ff;\">SUM(C5:D5)<\/span>*10%,IF(<span style=\"color: #3366ff;\">SUM(C5:D5)<\/span>&gt;5000, <span style=\"color: #3366ff;\">SUM(C5:D5)<\/span>*8%,0))<\/h3>\n<p>Whereas, when we are using the <strong>LET function<\/strong>, <strong>SUM is calculated just once<\/strong> at the beginning and the calculated value is used in the formula later. This makes the <strong>calculation faster and the formula cleaner<\/strong>.<\/p>\n<h3 style=\"text-align: center;\">=LET(total,<span style=\"color: #3366ff;\">SUM(C5:D5)<\/span><span style=\"color: #000000;\">, IF(total&gt;7000,total*10%,IF(total&gt;5000,total*8%,0))<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p>Using variables in Excel formulas makes <strong>updating the formula quick and easy<\/strong>.\u00a0 Let&#8217;s say we have added another branch in our calculation i.e. <strong>West Branch<\/strong> and you need to update the formula.<\/p>\n<p>To do so, simply <strong>edit the value of the defined variable from SUM(C5:D5) to SUM(C5:E5)<\/strong> and the total commission will be updated automatically.<\/p>\n<h3 style=\"text-align: center;\">=LET(total,<span style=\"color: #3366ff;\">SUM(C5:E5)<\/span><span style=\"color: #000000;\">, IF(total&gt;7000,total*10%,IF(total&gt;5000,total*8%,0))<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p>Until now, we have just used one name-value pair, let&#8217;s<strong> try using more<\/strong> and see how that works!<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><strong><a id=\"lesson4\"><\/a>LET with five name-value pairs<\/strong><\/span><\/h3>\n<p>In the previous feedback example instead of using one name-value pair, we will now be using 5.<\/p>\n<p>You can see that there are <strong>five variables<\/strong> that we can use in this formula:<\/p>\n<ul>\n<li>Difference % &#8211; <strong>pchg<\/strong><\/li>\n<li>Percentage you want to check if the difference is good &#8211; <strong>pergood<\/strong><\/li>\n<li>Percentage you want to check if the difference is bad- <strong>perbad<\/strong><\/li>\n<li>The text you want if the difference is good &#8211; <strong>textgood<\/strong><\/li>\n<li>The text you want if the difference is bad- <strong>textbad<\/strong><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong><\/span>We need to enter the Excel <strong>LET function<\/strong> in a blank cell:<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\">=LET(<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24438\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let10.png\" alt=\"How to use Excel LET function\" width=\"672\" height=\"437\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let10.png 672w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let10-300x195.png 300w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong><\/span>Enter the <strong>first argument<\/strong> i.e. name of the 1st variable<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=LET(<\/span>pchg,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24439\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let11.png\" alt=\"How to use Excel LET function\" width=\"670\" height=\"435\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let11.png 670w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let11-300x195.png 300w\" sizes=\"(max-width: 670px) 100vw, 670px\" \/><\/a>&#8230;.<\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> <\/strong><\/span>Enter the <strong>second argument<\/strong> i.e. value to the name assigned. Here, the value is inserted in cell D5.<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=LET(pchg, <\/span>E5,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24440\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let12.png\" alt=\"How to use Excel LET function\" width=\"671\" height=\"436\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let12.png 671w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let12-300x195.png 300w\" sizes=\"(max-width: 671px) 100vw, 671px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 4:<\/span> <\/strong><\/span>Enter the <strong>name for the 2nd variable <\/strong>i.e. <strong>pergood<\/strong><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=LET(pchg, E5, <\/span> pergood,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let22.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24455\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let22.png\" alt=\"How to use Excel LET function\" width=\"741\" height=\"510\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let22.png 741w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let22-300x206.png 300w\" sizes=\"(max-width: 741px) 100vw, 741px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 5:<\/span> <\/strong><\/span>Enter the <strong>value for the 2nd variable <\/strong>i.e.\u00a0<strong>1.<\/strong><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=LET(pchg, E5, pergood, <\/span>1,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let23.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24457\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let23.png\" alt=\"How to use Excel LET function\" width=\"745\" height=\"508\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let23.png 745w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let23-300x205.png 300w\" sizes=\"(max-width: 745px) 100vw, 745px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 6:<\/span> <\/strong><\/span>Enter the <strong>name for the 3rd variable <\/strong>i.e. <strong>textgood<\/strong><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=LET(pchg, E5, pergood, 1,<\/span> textgood,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let24.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24458\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let24.png\" alt=\"How to use Excel LET function\" width=\"769\" height=\"510\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let24.png 769w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let24-300x199.png 300w\" sizes=\"(max-width: 769px) 100vw, 769px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 7:<\/span> <\/strong><\/span>Enter the <strong>value for the 3rd variable <\/strong>i.e. <strong>&#8220;good&#8221;<\/strong>.\u00a0<em>Since it is a text make sure to put it within quotes.<\/em><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=LET(pchg, E5, pergood, 1, textgood,<\/span> &#8220;good&#8221;,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let25.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24460\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let25.png\" alt=\"How to use Excel LET function\" width=\"751\" height=\"510\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let25.png 751w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let25-300x204.png 300w\" sizes=\"(max-width: 751px) 100vw, 751px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 8:<\/span> <\/strong><\/span>Enter the <strong>name for the 4th variable <\/strong>i.e. <strong>perbad<\/strong><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=LET(pchg, E5, pergood, 1, textgood, &#8220;good&#8221;,<\/span> perbad,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let26.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24461\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let26.png\" alt=\"How to use Excel LET function\" width=\"747\" height=\"512\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let26.png 747w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let26-300x206.png 300w\" sizes=\"(max-width: 747px) 100vw, 747px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 9:<\/span> <\/strong><\/span>Enter the <strong>value for the 4th variable <\/strong>i.e. 0.8<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=LET(pchg, E5, pergood, 1, textgood, &#8220;good&#8221;, perbad,<\/span> 0.8,<\/span><\/h3>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let27.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24462\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let27.png\" alt=\"How to use Excel LET function\" width=\"750\" height=\"511\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let27.png 750w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let27-300x204.png 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/a><\/span><\/strong><\/span><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 10:<\/span> <\/strong><\/span>Enter the <strong>name for the 5th variable <\/strong>i.e. <strong>textbad<\/strong><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=LET(pchg, E5, pergood, 1, textgood, &#8220;good&#8221;, perbad, 0.8, <\/span>textbad,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let28.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24463\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let28.png\" alt=\"How to use Excel LET function\" width=\"757\" height=\"513\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let28.png 757w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let28-300x203.png 300w\" sizes=\"(max-width: 757px) 100vw, 757px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 11:<\/span> <\/strong><\/span>Enter the <strong>value\u00a0for the 5th variable <\/strong>i.e. <strong>&#8220;bad&#8221;<\/strong><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=LET(pchg, E5, pergood, 1, textgood, &#8220;good&#8221;, perbad, 0.8, textbad,<\/span> &#8220;bad&#8221;,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let29.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24464\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let29.png\" alt=\"How to use Excel LET function\" width=\"789\" height=\"507\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let29.png 789w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let29-300x193.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let29-768x494.png 768w\" sizes=\"(max-width: 789px) 100vw, 789px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 12:<\/span><\/strong><\/span> Lastly, enter the nested IF function and replace the cell reference, text, and numbers with the defined variables.<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=LET(pchg, E5, pergood, 1, textgood, &#8220;good&#8221;, perbad, 0.8, textbad, &#8220;bad&#8221;, <\/span>IF(pchg&gt;pergood, textgood, IF(pchg&lt;perbad, textbad, &#8220;&#8221;)))<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let30.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24465\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let30.png\" alt=\"How to use Excel LET function\" width=\"1116\" height=\"509\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let30.png 1116w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let30-300x137.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let30-1024x467.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let30-768x350.png 768w\" sizes=\"(max-width: 1116px) 100vw, 1116px\" \/><\/a><\/p>\n<p>Copy paste this formula to the remaining cells below.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let31.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24466\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let31.png\" alt=\"How to use Excel LET function\" width=\"754\" height=\"471\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let31.png 754w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let31-300x187.png 300w\" sizes=\"(max-width: 754px) 100vw, 754px\" \/><\/a><\/p>\n<p>Using the Excel LET function makes your formula easier to read and update if required in the future.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"lesson5\"><\/a>LET with Emojis<\/strong><\/h3>\n<p>Instead of showing the text &#8220;good&#8221; or &#8220;bad, we can even <strong>use emojis<\/strong>. In <a class=\"wpil_keyword_link\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/download-office\" target=\"_blank\" rel=\"noopener nofollow\" title=\"windows\" data-wpil-keyword-link=\"linked\">windows<\/a>, you can press keys &#8211; <strong>Windows + .<\/strong> to open the dialog box for emojis and simply click on the one you want to use.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let35.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24470\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let35.png\" alt=\"How to use Excel LET function\" width=\"339\" height=\"341\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let35.png 339w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let35-298x300.png 298w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let35-150x150.png 150w\" sizes=\"(max-width: 339px) 100vw, 339px\" \/><\/a><\/p>\n<p>In <strong>step 7, replace the text &#8220;good&#8221; with smile<\/strong> emoji:<\/p>\n<h3 style=\"text-align: center;\">=LET(pchg, E5, pergood, 1, textgood,&#8221;&#x1f60a;&#8221;<\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let32.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24467\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let32.png\" alt=\"How to use Excel LET function\" width=\"767\" height=\"508\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let32.png 767w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Let32-300x199.png 300w\" sizes=\"(max-width: 767px) 100vw, 767px\" \/><\/a><\/p>\n<p>In step 7, replace the text &#8220;bad&#8221; with a thumb down emoji:<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=LET(pchg, E5, pergood, 1, textgood, &#8220;&#x1f60a;&#8221;, perbad, 0.8, textbad, &#8220;&#x1f44e;&#8221;<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let36.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24471\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let36.png\" alt=\"How to use Excel LET function\" width=\"767\" height=\"436\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let36.png 767w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let36-300x171.png 300w\" sizes=\"(max-width: 767px) 100vw, 767px\" \/><\/a><\/p>\n<p>This is what the <strong>result<\/strong> will look like. Looks interesting, isn&#8217;t it?<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=LET(pchg, E5, pergood, 1, textgood, &#8220;&#x1f60a;&#8221;, perbad, 0.8, textbad, &#8220;&#x1f44e;&#8221;,IF(pchg&gt;pergood,textgood,IF(pchg&lt;perbad,textbad,&#8221;&#8221;)))<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let37.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24472\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let37.png\" alt=\"How to use Excel LET function\" width=\"1054\" height=\"512\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let37.png 1054w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let37-300x146.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let37-1024x497.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let37-768x373.png 768w\" sizes=\"(max-width: 1054px) 100vw, 1054px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"lesson6\"><\/a>LET using Name manager<\/strong><\/h3>\n<p>You can <strong>store the long LET formula using name manager<\/strong> and then easily <strong>reuse<\/strong> it whenever you want in the future without the need to type the formula again.<\/p>\n<p>Before we do that, if you look at the<strong> formula you will see that column E is a relative reference<\/strong> i.e. if you use this formula the reference will also change. So, if you<strong> paste this column in column H, the reference will change from E5 to F5<\/strong>.<\/p>\n<p>But we don&#8217;t want that. So, let&#8217;s <strong>lock column E<\/strong> by<strong> putting a dollar sign<\/strong> in front of it.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let38.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24473\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let38.png\" alt=\"How to use Excel LET function\" width=\"1124\" height=\"512\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let38.png 1124w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let38-300x137.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let38-1024x466.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let38-768x350.png 768w\" sizes=\"(max-width: 1124px) 100vw, 1124px\" \/><\/a><\/p>\n<p>Now that your formula is ready, follow the steps below to learn how to store it in name manager:<\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong><\/span> <strong>Copy the entire LET formula<\/strong> by pressing the keys Ctrl + C.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let39.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24474\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let39.png\" alt=\"How to use Excel LET function\" width=\"1138\" height=\"511\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let39.png 1138w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let39-300x135.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let39-1024x460.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let39-768x345.png 768w\" sizes=\"(max-width: 1138px) 100vw, 1138px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong><\/span> Go to <strong>Formula<\/strong> Tab &gt; <strong>Name Manager<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let40.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24475\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let40.png\" alt=\"How to use Excel LET function\" width=\"1091\" height=\"126\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let40.png 1091w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let40-300x35.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let40-1024x118.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let40-768x89.png 768w\" sizes=\"(max-width: 1091px) 100vw, 1091px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 3:<\/span><\/strong><\/span> In the dialog box, click on <strong>New<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let41.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24476\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let41.png\" alt=\"How to use Excel LET function\" width=\"553\" height=\"432\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let41.png 553w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let41-300x234.png 300w\" sizes=\"(max-width: 553px) 100vw, 553px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 4:<\/span><\/strong><\/span> Type the following in the dialog box:<\/p>\n<ul>\n<li><strong>Name<\/strong> &#8211; DisplayEmoji<\/li>\n<li><strong>Scope<\/strong> &#8211; Select Workbook<\/li>\n<li><strong>Refers to<\/strong> &#8211; Paste the formula using Ctrl +V<\/li>\n<li>Click <strong>OK<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let42.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24477\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let42.png\" alt=\"How to use Excel LET function\" width=\"300\" height=\"230\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 5:<\/span><\/strong><\/span> In cell H5, type the function<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=DisplayEmoji<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let43.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24478\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let43.png\" alt=\"How to use Excel LET function\" width=\"805\" height=\"482\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let43.png 805w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let43-300x180.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let43-768x460.png 768w\" sizes=\"(max-width: 805px) 100vw, 805px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong><span style=\"color: #ff0000;\">STEP 6:<\/span><\/strong><\/span> <strong>Copy-paste the formula below<\/strong> and you will see it is displaying the same result as before.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let44.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to use Excel LET function\"  class=\"alignnone size-full wp-image-24479\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let44.png\" alt=\"How to use Excel LET function\" width=\"791\" height=\"514\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let44.png 791w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let44-300x195.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/let44-768x499.png 768w\" sizes=\"(max-width: 791px) 100vw, 791px\" \/><\/a><\/p>\n<p>You can use this formula =DisplayEmoji anywhere in the <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> and it will display the same result!<\/p>\n<p>&nbsp;<\/p>\n<h3>Conclusion<\/h3>\n<p>The Excel LET function is a super useful function that helps you <strong>eliminate redundancy<\/strong> in a formula and<strong> make the formula easy to read and compose<\/strong>. It <strong>improves the performance of your spreadsheet<\/strong> since the variables in the Excel formulas are calculated at the beginning and reused later in the formula.<\/p>\n<p>This function is currently available for Office 365 users only. So if you want to use this function make sure to install Office 365 in your system!<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you write long complex formulas in Excel, then the new LET function is a perfect match for you.\u00a0It lets you define variables inside the formula and get calculation results. Excel LET function is useful when you use the same expression multiple times in a formula. This function is available exclusively for Excel 365 subscribers. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":24526,"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":[14],"tags":[753,752,751],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24350"}],"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=24350"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24350\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/24526"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=24350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=24350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=24350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}