Forum Discussion
Lambda Without Paramaters N/A Error
Hello, I've got a pretty complex set of lambdas referencing child lambdas. =LAMBDA(LET(calc,ModStart($S$3,A2#),
IFS(ModMatchStart($S$3,A2#)>0,calc,
ModMatchStart($S$3-1,A2#)>0,ModStart($S...
I can't wrap my head around what you are trying to do but what I do see is that you are using IFS(). As I started my experiments with LAMBDA I also used IFS() and found out that it does not check the condition(s) and then perform the corresponding action, it will calculate every parameter in the set and then perform the IFS action. I don't know if that is your problem but I had a recursive action so the LAMBDA kept calling itself even though it should have stopped when it reached my target value, the IFS() would try to calculate all the terms and therefor kept recursively calling itself until it reached its stack limit and failed.
- Hmm... But on the grid it works as intended. Could it be still the same issue?
- I don't know. I don't know what each of those Lambda functions (ModMatchStart, ModStart, LambdaModStart) are and I don't know what you mean by 'on the grid' mean vs. what?
I mean if I call the lambda in a cell with its formulas using () at the end, it works. That famous Excel expert woman uses that term so I learnt it from her 🙂 I don't know what else it's called.
