Google Sheets | REDUCE | Function | Returns Single Value | LAMBDA | Example | Spreadsheet | Tutorial
The Google Sheets REDUCE function returns the final result of a series of
intermediate calculations. For example, REDUCE returns the final price of a
product, by calculating the increase in price in each year, say over a five-year
period. The inputs to the REDUCE function are the initial cost of the product and percentage increase in price in each of the five years.
-------------------------------------
How to Use SCAN in Google Sheets?
It's easy to calculate running total, running count and the like with SCAN:
• Google Sheets | SCAN | Function | Cal...
-------------------------------------
How to Use QUERY in Google Sheets?
QUERY helps, among others, to extract specific or all data from a range:
• Google Sheets | QUERY | Function | Ex...
-------------------------------------
How to Use Convert to Table in Google Sheets?
Convert a data range into a table easily:
• Google Sheets | Convert to Table | Ch...
-------------------------------------
How to Use FREQUENCY in Google Sheets?
FREQUENCY returns the frequency distribution of data:
• Google Sheets | FREQUENCY | Function ...
-------------------------------------
How to Use COUNTIFS in Google Sheets?
Count values that fulfill one or more criteria:
• How to use COUNTIFS in Google Sheets ...
-------------------------------------
How to Use XLOOKUP to Extract Multiple Values in Google Sheets?
XLOOKUP can return a single row or column with the search key:
• Google Sheets | XLOOKUP | Function | ...
-------------------------------------
How to Use VLOOKUP in Google Sheets?
Use VLOOKUP to get a single value:
• VLOOKUP Google Sheets | How to Use VL...
-------------------------------------
How to Use IF in Google Sheets?
Use IF to compare one value with another:
• Google Sheets IF | Tutorial | IF Goog...
-------------------------------------
How to Create a Pivot Table in Google Sheets?
Create a pivot table for calculation and in-depth data analysis:
• Google Sheets | Pivot Table | How to ...
-------------------------------------
What is the Syntax of the REDUCE Function Formula?
The syntax is:
=REDUCE(initial_value, array_or_range, lambda)
initial_value is the value that the LAMBDA function applies to only the first element of array_or_range.
array_or_range is the data source.
lambda is a custom function. It is applied to each element of the array.
The lambda should have two name arguments and a formula expression, which uses these arguments.
What is an Example of the REDUCE Function?
Here is an example:
The initial cost of a product is Rs. 3400. It increases by 6%, 7%, 7.5%, 9%, and 9.45% in each year of a 5-year period. Assume that the percentages are in the cells of the range B2 to B6.
The formula after substituting the values in the formula is:
=REDUCE(3475,B2:B6,lambda(current_value, percent_increase, current_value+current_value*percent_increase))
The two name arguments are current_value and percent_increase.
The formula expression is current_value+current_value*percent_increase.
Note that the initial_value=current_value=3475 in the first iteration of calculation.
In the second iteration, current_value equals the result of the first-iteration calculation by the formula expression, and so on.
Review this video tutorial, which gives the steps to use the Google Sheets REDUCE function, with examples.