REDUCE Function Explained
The REDUCE function in Microsoft Excel is used to apply a given function to a range of cells, and then reduce the result by repeating the function for each intermediate result. It takes three arguments: a function, an array of values, and an optional initial value. The function is applied to the array of values from left to right, and the result of each application is used as the input for the next application. The optional initial value is used as the first input for the function.
REDUCE Function Syntax
REDUCE(function, range, [initial])
- function: The function to be applied to the range of cells.
- range: The range of cells to be reduced.
- initial: (Optional) The initial value to be used in the reduction.