![advanced uses of microsoft excel advanced uses of microsoft excel](https://www.wikigain.com/wp-content/uploads/2017/10/2017-10-29_23-11-08.jpg)
Excel provides IFERROR to replace error values, but there is no function to replace blank cells. Thanks to all of our Insiders for using the LAMBDA functions and giving us feedback! As a result we've also made a few changes that we'll outline below in addition to talking about the advanced formula authoring environment, a Microsoft Garage project.Ī task I regularly encounter is replacing certain values in a dataset, such as errors or blanks cells.
![advanced uses of microsoft excel advanced uses of microsoft excel](https://sanet.pics/storage-7/1021/GjMA3ou9AKHBeRVVmCelIxIV2yOiKnW2.jpg)
In conjunction with LAMBDA going to production, we are also announcing the release of a new add-in, the advanced formula environment, sponsored by the Microsoft Garage and Microsoft Research, which allows easy import/export and authoring of named LAMBDAs. We are excited to announce that LAMBDA and LAMBDA helper functions are now generally available to anyone using Production: Current Channel builds of Excel.