Table of Contents
A function in excel can be created to return the largest number in a specified range of cells by using the MAX function. This function takes in a range of cells as its argument and returns the largest value within that range. By using this function, users can easily find the largest number in a specific set of data without having to manually search for it. This not only saves time but also ensures accuracy in retrieving the largest value.
This article describes the formula syntax and usage of the LARGE function in Microsoft Excel.
Description
Returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score.
Syntax
LARGE(array, k)
The LARGE function syntax has the following arguments:
Array Required. The array or range of data for which you want to determine the k-th largest value.
K Required. The position (from the largest) in the array or cell range of data to return.
Remarks
If array is empty, LARGE returns the #NUM! error value.
If k ≤ 0 or if k is greater than the number of data points, LARGE returns the #NUM! error value.
If n is the number of data points in a range, then LARGE(array,1) returns the largest value, and LARGE(array,n) returns the smallest value.
Cite this article
stats writer (2024). How can I create a function in excel that returns the largest number in a specified range of cells?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-create-a-function-in-excel-that-returns-the-largest-number-in-a-specified-range-of-cells/
stats writer. "How can I create a function in excel that returns the largest number in a specified range of cells?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-create-a-function-in-excel-that-returns-the-largest-number-in-a-specified-range-of-cells/.
stats writer. "How can I create a function in excel that returns the largest number in a specified range of cells?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-create-a-function-in-excel-that-returns-the-largest-number-in-a-specified-range-of-cells/.
stats writer (2024) 'How can I create a function in excel that returns the largest number in a specified range of cells?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-create-a-function-in-excel-that-returns-the-largest-number-in-a-specified-range-of-cells/.
[1] stats writer, "How can I create a function in excel that returns the largest number in a specified range of cells?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I create a function in excel that returns the largest number in a specified range of cells?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.