In Office365 Excel, how to define a named lambda function without using the Name Manager "Refers to" field?

huangapple go评论77阅读模式
英文:

In Office365 Excel, how to define a named lambda function without using the Name Manager "Refers to" field?

问题

首选在工作表中定义的 Lambda 函数。Google Bard 建议使用 name() 函数,但在 Excel 中没有这样的函数。还尝试了“从选择创建”方法,其中名称位于单元格 A1 中,而 Lambda 函数位于单元格 B1 中,但也不起作用。

在名称管理器的“引用”字段中定义的问题在于 Lambda 函数会失去其格式,使其难以阅读。在单元格中定义它将保留缩进和空格,但我还没有找到这种方法可以工作的方式... 现在。

英文:

Preferably the lambda function defined in the worksheet. Google Bard said to use the name() function, but there is no such function in Excel. Also tried the "Create from Selection" approach where the name is in cell A1 and the lambda function is in cell B1, but that doesn't work either.

The problem with defining it in the name manager "Refers to" field is the lambda function loses its formatting making it hard to read. Defining it in a cell would retain indentation and spaces but I haven't found a way for this to work... yet.

答案1

得分: 5

为什么不使用高级公式环境

这是创建Lambda函数和编辑公式的更简单方法。如链接所示,它以可读的方式格式化复杂的公式。

举个简单的例子,你可以像这样创建一个名为Add的Lambda:

In Office365 Excel, how to define a named lambda function without using the Name Manager "Refers to" field?

在名称管理器中看起来像这样:

In Office365 Excel, how to define a named lambda function without using the Name Manager "Refers to" field?

你可以像这样使用它:

In Office365 Excel, how to define a named lambda function without using the Name Manager "Refers to" field?

英文:

Why not use the Advanced Formula Environment?

This is an easier way to create lambdas and to edit formulas generally. As shown in the link, it formats complicated formulas in a readable way.

As a trivial example, you could create a lambda called Add like this:

In Office365 Excel, how to define a named lambda function without using the Name Manager "Refers to" field?

and it looks like this in Name Manager:

In Office365 Excel, how to define a named lambda function without using the Name Manager "Refers to" field?

and you can use it like this:

In Office365 Excel, how to define a named lambda function without using the Name Manager "Refers to" field?

huangapple
  • 本文由 发表于 2023年6月16日 07:49:52
  • 转载请务必保留本文链接:https://go.coder-hub.com/76486145.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定