When we create a sales report, sometimes we want to show the values in their original form, and sometimes they can be recalculated values, such as thousands or millions. Such a report is created in a very simple way using the Data Validation option, which allows you to select the desired unit size, and recalculate values with help of the Excel LAMBDA function. Let’s create a report like this with a chart to visualize the data.
When creating business reports, there is often a requirement that they should be displayed in multiple currencies, that is, the user can choose the currency in which a report is displayed. This can be achieved in several ways and one of them, very elegant, is with the help of the LAMBDA function. In this “recipe” you will find out how you can use it to display sales reports in different currencies.
Writing Excel formulas with the help of Name Manager can be a demanding job. When you write simple formulas, you will still somehow manage. With complex formulas or changing existing ones, there is a high chance that you will make a mistake. The LAMBDA feature allows you to create your own functions as names added in the Name Manager, and to make this job easier, Microsoft has created an Excel add-in for creating complex formulas: Advanced Formula Environment.
It is a common practice in domestic retail outlets to keep a large number of items under one code. In fact, it is one item, but its additional attributes are not taken into account, such as: color, size, design, season … Consequently, the stocks are incorrect. How to form item codes in such a way that, within the code itself, all its attributes are taken into account? We will use permutations!
This is a logical function used as an argument by the LAMBDA function, and it aims to check if any of the arguments have been omitted. When using the LAMBDA function, it is mandatory to provide as many arguments as initially given. Since it returns the value TRUE or FALSE it is used in combination with the IF function in the part of the LAMBDA function where it is necessary to specify the value it returns.