Notifications
Clear all
Topic starter
can any body explain this formula
REDUCE(0,H7:H10,LAMBDA(a,b,VSTACK(a,b)))
H7 1
H8 2
H9 3
H10 4
AND RESULT IS
0
4
7
9
10
Posted : 29/10/2024 1:19 pm
Hi Sohail,
The REDUCE function here isn't being used as it was intended. It is supposed to be used with a LAMBDA that accumulates to a single value. The VSTACK function in the LAMBDA returns an array, so essentially, all it's doing is adding a zero to the array. This formula could be simplified to:
=VSTACK(0,H7:H10)
Mynda
Posted : 29/10/2024 8:37 pm
As Mynda alluded to, the results you posted are not the result of that formula with those inputs, so clearly one of them is incorrect. The results appear to be a running total of the original range inverted.
Posted : 30/10/2024 5:52 am
