MicrosoftLambda functions can be created with Excel Mac, just not quite as simple as with the Windows version. Once you have the know-how, it is OK. The first thing is to find out the how, that is the difficult bit.
Lambdas are set up in the usual way. But note the missing NameManager, just the Define Name. After you have created the LAMBDA you need to copy it minus the test data to the clipboard. You then click on "Define Name" resulting in the following:
At this point, you enter a name for the "data range" (as this is not a data range it is not obvious), in this case, "Hypotenuse". You then paste in or type in the LAMBDA Function into the "Select the range of cells" (again not an obvious choice/action). Click OK, and you now have a functioning LAMBDA function. Note: there is no option for adding a comment for your Function as with the Windows version. So if your code/function is complex then VBA would be a better way to go with decent in-code comments and documentation.
So, as you can see, it works and is useable, just getting to that point is not that obvious.
With respect to a VBA approach. VBA is quite reasonable in the Mac version and is the only option if you are wanting to preserve functions to share with others or to use as Add-ins to use with all your other Worksheets/projects.
