REDUCE([initial_value], array, lambda(accumulator, value)) |
Returns the total value after reducing an array by applying a LAMBDA function. |
| [initial_value] | Sets the starting value for the accumulator. |
| array | An array to be reduced. |
| lambda | A LAMBDA that is called to reduce the array. |
| accumulator | The value totalled up and returned as the final result. |
| value | The calculation applied to each element in the array |
Remarks |
| * Added in Microsoft 365 and is only available to Office Insiders at the moment. * This function uses the LAMBDA function. * This function was released in July 2021. * For the Microsoft documentation refer to support.microsoft.com |
|
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top