Table of Contents
MIN in Google Sheets is a function that allows users to find and return the smallest numerical value in a given range of cells. This can be useful for finding the minimum value in a set of data, such as sales figures or test scores. To use MIN, simply enter the function followed by the range of cells you want to search within. This function can also be combined with other functions to perform more complex calculations. By utilizing MIN in Google Sheets, users can efficiently analyze and manipulate data to make informed decisions.
MIN
Returns the minimum value in a numeric dataset.
Returns the minimum value in a data column.
Sample Usage
MIN(table_name!price)
Syntax
MIN(column)
column: The data column to consider when calculating the minimum value.
Tip: Returning minimum value across multiple columns is not supported
Sample Usage
MIN(A2:A100,B2:B100,4,26)
MIN(1,2,3,4,5,C6:C20)
Syntax
MIN(value1, [value2, ...])
value1– The first value or range to consider when calculating the minimum value.value2, ...– [ OPTIONAL ] – Additional values or ranges to consider when calculating the minimum value.
Notes
Although
MINis specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.Each
valueargument must be a cell, a number, or a range containing numbers. Cells without numbers or ranges are ignored. Entering text values will causeMINto return the#VALUE!error. To allow text values, useMINA.
See Also
SMALL: Returns the nth smallest element from a data set, where n is user-defined.
RANK: Returns the rank of a specified value in a dataset.
QUARTILE: Returns a value nearest to a specified quartile of a dataset.
PERCENTRANK: Returns the percentage rank (percentile) of a specified value in a dataset.
PERCENTILE: Returns the value at a given percentile of a dataset.
MINA: Returns the minimum numeric value in a dataset.
MEDIAN: Returns the median value in a numeric dataset.
MAXA: Returns the maximum numeric value in a dataset.
MAX: Returns the maximum value in a numeric dataset.
LARGE: Returns the nth largest element from a data set, where n is user-defined.
AVERAGEA: Returns the numerical average value in a dataset.
AVERAGE: The AVERAGE function returns the numerical average value in a dataset, ignoring text.
Examples
[wpcc-iframe height=”300″ width=”500″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdEN4NEJnaHVJbUM0Q2VpcFRXMkh5RlE&output=html”]
Cite this article
stats writer (2024). How can I use MIN in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-min-in-google-sheets/
stats writer. "How can I use MIN in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-min-in-google-sheets/.
stats writer. "How can I use MIN in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-min-in-google-sheets/.
stats writer (2024) 'How can I use MIN in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-min-in-google-sheets/.
[1] stats writer, "How can I use MIN in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use MIN in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.