Forum Discussion
long texts with arrays in conditional functions
PeterBartholomew1 , tboulden or someone else
Perhaps you know the workaround, even with lambdas. In simplest case
=IF( 1, REPT("a", 256) ) works
=IF( {1}, REPT("a", 256) ) returns #VALUE!
...
Sorry, I haven't got around to looking at the forum until now. Try
= REDUCE("",SEQUENCE(512),
LAMBDA(concat,k, concat&"a")
)
or
= CONCAT(
MAP(SEQUENCE(512),
LAMBDA(k,"a")
)
)