Forum Discussion
Element not allowed inside an array in a LAMBDA function
Can anyone advise why the array expression {a,b} in the LAMBDA expression below generates an error. =LAMBDA(a,b,IF(a<b,{0,0},{a,b}))(1,2) it indicates, "element not allowed inside an array...
Thanks!! This is correct.
If a & B are names ={a,b} fails, but ={1,2} works!!
Follow up Question is this issue concerning the Excel Braces Array Constructor only working with numbers documented anyplace?
Thanks
Not only numbers, any constants. Texts, Boolean, e.g. ={true, false}