Find minimum and maximum dividends
Complete your analysis by looking at the series of dividends. What are the minimum and maximum dividend paid out by the company over the period?
To answer these questions, you cannot simply use MIN() and MAX(). As cells with 0 indicate “no dividend”, you must exclude them from the computations.
To do so, you should use MINIFS() and MAXIFS(). These functions, like COUNTIFS(), apply the desired operation to all the cells which meet one or more specific
conditions.
Contrarily to COUNTIFS(), MINIFS() and MAXIFS() require three mandatory arguments: the range of cells from which the minimum or the maximum is determined, the range of cells on which the condition applies, and the condition itself enclosed with quotes.
本练习是课程的一部分
在 Google Sheets 中进行金融分析
练习说明
In
F12, use the functionMINIFS()to find the smallest dividend paid by ABC during the period. Select all the dividends larger than zero as a condition in the function.In
F13, use the functionMAXIFS()to find the largest dividend paid by ABC during the period. Select all the dividends larger than zero as a condition in the function.
