Forum Discussion

kheldar's avatar
kheldar
Iron Contributor
Mar 15, 2022

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...
Excel
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Mar 15, 2022

kheldar 

Sorry but I haven't got the remotest idea what the formula is meant to achieve.  I don't know what is returned by A2#, nor what value S3 may contain.  I would need to see what

ModMatchStart

ModStart

refer to.  At first sight, the initial Lambda and the null parameter string does nothing but return the LET and the LET itself does very little and could be eliminated.

 

  • kheldar's avatar
    kheldar
    Iron Contributor
    Mar 15, 2022

    PeterBartholomew1 

     

    I'll try to prepare a sample file tonight. I know LET can be eliminated but it helps me visualize things better.

    ModMatchStart = identifies if there is a matching value.
    ModStart = retrieves the matching value.

     

    This is ModMatchStart:

    =LAMBDA(start,name,COUNTIFS(RawMMP[Name],name,RawMMP[Start],start,RawMMP[Non-Mod],"Mod"))

     This is ModStart:

     

    =LAMBDA(start,name,SUMIFS(RawMMP[Duration1],RawMMP[Name],name,RawMMP[Start],start,RawMMP[Non-Mod],"Mod"))

Resources