This video walks through writing your first custom function in Excel using the LAMBDA function. It's part of a (still growing) series - you can find the whole playlist here: • Write your own functio...
it seems like sum(range1*range2) gives the same output as sumproduct(range1;range2), didn't know that! copying the lambda function to another workbook takes care of the "NamedRange". I'm already less intimidated. Thank you for so clearly explaining this.
Yes, I almost never use SUMPRODUCT anymore (almost because old habits die hard!). Although it’s good to remember if you need backward compatibility. And I’m glad to hear it made it less intimidating!
Hi I am trying to write a lambda function to calculate the margin of a debt, based on a specific leverage ratio, so I am trying to find a lambda to avoid circularity...Hope you continue this series of videos.