In Google Sheets, the function LARGE(data, n) is used to return the nth largest value from a range of data.

It is often used to find the top or bottom values in a dataset.

Here's how the LARGE function works:

data: This is the range of cells or an array of values from which you want to find the nth largest value. The data can be a single column or row, or a combination of columns and rows.

n: This is the position of the value you want to find in the sorted order. For example, if you set n as 1, the function will return the largest value in the range. If you set n as 2, it will return the second-largest value, and so on.

The syntax for the LARGE function in Google Sheets is as follows:

LARGE(data, n)

Here's an example to illustrate the usage of the LARGE function:

Suppose you have a dataset in cells A1 to A10 containing the following numbers: 5, 8, 2, 10, 6, 3, 9, 1, 4, 7. To find the second-largest value, you can use the LARGE function as follows:

=LARGE(A1:A10, 2)

The result will be 9, which is the second-largest value in the range A1 to A10.

You can use this function in various ways, such as finding the top three values, identifying outliers, or ranking values within a dataset based on their magnitude.