0

I'm trying to follow the example for lambda in this post, I tried to type the Name HEAD in the A1 and the formula =LAMBDA(str,IF(str="","error: HEAD of empty string", LEFT(str,1))) in B1, as per the following GIF.

lambda

I get a #CALC! error.

There does seem to be some functionality I'm unaware of here, as HEAD appears to be recognised as B1 in my formula. However, B5 reports an 'invalid cell reference` error:

Error

ZygD
  • 22,092
  • 39
  • 79
  • 102
Terry
  • 785
  • 1
  • 8
  • 20
  • Those are just to show what is in the named range. There is a named range called `HEAD` that has that formula in it. Then when the named range is called with the reference it works. – Scott Craner Oct 26 '21 at 15:28
  • Aah - I think you're right. Not very clear from that example that that's what's going on but I get it now. Thanks. – Terry Oct 26 '21 at 15:46
  • Also, you may not have the functionality as from the post: `LAMBDA is available to members of the Insiders: Beta program`. – Tragamor Oct 26 '21 at 17:22
  • Besides that, the article mentioned that *"Reversing a string is beyond the built-in functions of Excel and could only previously be written outside the formula language, by using Visual Basic or JavaScript."* which is simply not true. – JvdV Oct 26 '21 at 17:26

0 Answers0