Hi guys,Have look at this formula, it keeps returning #VALUE! error, what's the wrong? Many thanks! =LET( x,"S"&SEQUENCE(5), REDUCE(,x,LAMBDA(a,v, LET(t,MAKEARRAY(10,1,LAMBDA(r,c,1)),t))))

yushang The formula returns the expected result in my sheet.

OliverScheurich I've double checked, it do return error. Any thing related to Excel version? I'm using Office 365, the Excel version is 16.0.16130.20298.

Forum Discussion

yushang

Brass Contributor

Mar 21, 2023

Why this formula does not work?

Hi guys,

Have look at this formula, it keeps returning #VALUE! error, what's the wrong? Many thanks!

=LET(
x,"S"&SEQUENCE(5),
REDUCE(,x,LAMBDA(a,v,
  LET(t,MAKEARRAY(10,1,LAMBDA(r,c,1)),t))))

excel

2 Replies

OliverScheurich
Gold Contributor
Mar 21, 2023
yushang
The formula returns the expected result in my sheet.
- yushang
  Brass Contributor
  Mar 22, 2023
  OliverScheurich I've double checked, it do return error. Any thing related to Excel version? I'm using Office 365, the Excel version is 16.0.16130.20298.