MINIFS Function
This function returns the smallest value in a list or array of numbers that satisfy multiple conditions.
Syntax: MINIFS(min_range, criteria_range1, criteria1 [,criteria_range2, criteria2] [..])
- min_range: The actual cells to min.
- criteria_range1: The range of cells you want to be evaluated.
- criteria1: The expression that contains the criteria.
- criteria_range2: (Optional) The range of cells you want to be evaluated.
- criteria2: (Optional) The expression that contains the criteria.
To Utilize this Function:
- Click the Insert function dialog box on the Formulas tab.
- Enter MINIFS in the “Search for a Function” dialog box, then click the GO button and select OK.
- The min_range and criteria_range1 dialog boxes will appear, enter the text and click OK.
6 New Functions or Formulas in Excel 2019
A formula is a mathematical expression that computes a cell’s value. Functions are predefined formulas found in Excel. Based on the values specified as arguments or parameters, functions perform specific calculations in a specific order. For instance, =SUM (C1:C10). This function adds the values from cells C1 to C10. In the math and trigonometry, statistical, engineering, date and time, lookup and reference, logical, and text function categories, several new functions are added. In addition, the Web category is introduced, along with a few Web service features. Some Basic functions in Excel were discovered earlier that can be used to perform basic operations.
We also have a Statistical function in Excel that can be used in industries and businesses for better and more effective results.