MIN function: Note: I have given here descriptions of the formula syntax and usage of the MIN function in Microsoft Excel. Description Returns the lowest value in a set of values. Syntax MIN(number1, [number2], ...) The MIN function syntax has the following arguments: Number1, number2, ... Number1 is required, subsequent numbers are optional. 1 to 255 numbers for which you want to find the minimum value. Remarks Arguments can either be numbers or names, arrays, or references that contain numbers. Question: How to find the minimum number in the selected area? = Type the function as follows in the cell that you would like to get the result in: =Min(D3:D14) For more understanding, look at the screenshot please: MINA function: I have given here about formula syntax and usage of the MINA function in Microsoft Excel. Description: Returns the smallest value in the list of arguments. Syntax: MINA(value1, [value2], ...) The MINA function syntax has the following arguments: Value1, value2, ... Value1 is required, subsequent values are optional. 1 to 255 values for which you want to find the smallest value. Remarks: Arguments can be the following: numbers; names, arrays, or references that contain numbers; text representations of numbers; or logical values, such as TRUE and FALSE, in a reference. Arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero). If the arguments contain no values, MINA returns 0 (zero). If you do not want to include logical values and text representations of numbers in a reference as part of the calculation, use the MIN function. Q: How to use MINA function to find the lowest value in the student marks sheet? Type the function as follows in the cell that you would like to get the result in: =MINA(E3:E14) For more understanding, look at the screenshot please: MINIFS function: I have given here about formula syntax and usage of MINIFS, which is one of the statistical functions in Excel. Note: This feature is only available if you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office. Description: The MINIFS function returns the minimum value among cells specified by a given set of conditions or criteria. Syntax: MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) Remarks: The size and shape of the min_range and criteria_rangeN arguments must be the same, otherwise these functions return the #VALUE! error. Q: How to find the lowest number of Bananas sold in the sales record sheet? Type the function as follows in the cell that you would like to get the result in: =MINIFS(C2:C9,B2:B9,"Bananas") For more understanding, look at the screenshot please:
0 Comments
|
Archives |