Google Sheets 함수

범위에 SQL 같은 쿼리를 실행하여 하나의 수식으로 필터링, 정렬, 그룹화, 집계를 수행하세요.

수식을 전체 범위에 한 번에 적용하여 복사 없이 자동으로 아래로 채워지게 합니다.

다른 Google Sheets 파일에서 실시간 셀 범위를 가져옵니다.

주식이나 통화의 현재 또는 과거 시장 데이터를 가져옵니다.

구분 기호로 텍스트를 별도의 열로 나눕니다.

정규식과 일치하는 첫 번째 부분 문자열을 추출합니다.

범위의 첫 번째 열에서 값을 찾아 같은 행의 다른 열에서 값을 반환합니다.

VLOOKUP과 HLOOKUP의 현대적 대체 — 어떤 열이든 검색하고 어떤 방향으로든 어떤 열이든 반환합니다.

범위 내에서 지정한 행과 열 위치의 값을 반환합니다.

행이나 열 내에서 값의 위치를 반환합니다.

조건이 참일 때 한 값을, 거짓일 때 다른 값을 반환합니다.

여러 조건을 순서대로 확인하여 처음으로 참인 조건의 값을 반환합니다.

수식이 오류를 일으키면 사용자 지정 결과를 반환하고, 그렇지 않으면 수식의 결과를 반환합니다.

단일 조건을 만족하는 셀을 더합니다.

여러 조건을 동시에 만족하는 셀을 더합니다.

범위에서 단일 조건을 만족하는 셀을 셉니다.

여러 조건을 동시에 만족하는 셀을 셉니다.

여러 셀이나 범위의 텍스트를 각 항목 사이에 구분 기호를 넣어 결합합니다.

두 날짜 사이의 차이를 연, 월, 또는 일 단위로 계산합니다.

범위의 맨 위 행에서 값을 찾아 같은 열의 다른 행에서 값을 반환합니다.

숫자 범위를 더합니다.

숫자 범위의 산술 평균을 계산합니다.

숫자를 지정한 자릿수로 반올림합니다.

여러 셀이나 범위의 텍스트를 하나의 문자열로 결합합니다.

텍스트 문자열의 시작 부분에서 지정한 개수의 문자를 반환합니다.

시작 위치와 길이를 지정하여 텍스트 문자열의 가운데에서 문자를 반환합니다.

텍스트 문자열의 문자 수를 반환합니다.

텍스트에서 여분의 공백을 제거하고 단어 사이에 공백 하나만 남깁니다.

현재 날짜를 반환하며, 매일 자동으로 업데이트됩니다.

어떤 날짜의 지정한 개월 수만큼 전 또는 후인 달의 마지막 날을 반환합니다.

모든 조건이 참일 때만 TRUE를 반환합니다.

적어도 하나의 조건이 참일 때 TRUE를 반환합니다.

배열에서 대응하는 항목을 곱하고 그 결과를 합산합니다 — 가중 합계와 다중 조건 합계에 적합합니다.

단일 조건을 만족하는 셀의 평균을 냅니다.

범위에서 가장 큰 값을 반환합니다.

범위에서 가장 작은 값을 반환합니다.

데이터세트 내에서 값의 백분위수 순위를 반환합니다.

데이터 세트의 최소값, 사분위수 또는 최대값을 반환합니다.

선형 추세에서 미래 가치를 예측합니다.

비어 있지 않은 셀(숫자와 텍스트)을 셉니다.

텍스트 문자열의 끝에서 지정한 개수의 문자를 반환합니다.

한 텍스트 문자열이 다른 문자열 안에서 차지하는 위치를 반환합니다(대소문자 구분).

문자열 안에서 특정 텍스트가 나타나는 부분을 바꿉니다.

숫자나 날짜를 특정 형식의 텍스트로 변환합니다.

주말(및 선택적 공휴일)을 제외하고 두 날짜 사이의 근무일을 셉니다.

날짜의 요일을 숫자로 반환합니다.

식을 값 목록과 비교하여 처음으로 일치하는 결과를 반환합니다.

위치 번호를 기준으로 목록에서 값을 반환합니다.

이자율이 일정한 대출의 정기 상환액을 계산합니다.

일련의 미래 현금 흐름의 순현재가치를 계산합니다.

Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.

Returns the reference specified by a text string.

Creates a cell reference as text, given specified row and column numbers.

Returns the row number of a reference.

Returns the column number of a reference.

Returns the number of rows in a reference or array.

Returns the number of columns in a reference or array.

Returns a value from a range or array that matches a specified lookup value.

Filters a range of data based on criteria you define.

Sorts the contents of a range or array.

Returns a list of unique values from a range or array.

Reverses the logical value of its argument.

Returns a specified value if the expression evaluates to an #N/A error, otherwise returns the result of the expression.

Returns the exclusive OR of all arguments.

Returns the logical value TRUE.

Returns the logical value FALSE.

Rounds a number up, away from zero.

Rounds a number down, toward zero.

Returns a number rounded to the nearest specified multiple.

Returns the remainder after a number is divided by a divisor.

Returns the absolute value of a number.

Rounds a number down to the nearest integer.

Rounds a number up to the nearest integer or to the nearest multiple of significance.

Rounds a number down to the nearest multiple of significance.

Returns the result of a number raised to a given power.

Returns the square root of a positive number.

Returns a subtotal in a list or database.

Multiplies all the numbers given as arguments and returns the product.

Returns a random number greater than or equal to 0 and less than 1.

Returns a random integer number between the numbers you specify.

Converts all characters in a text string to uppercase.

Converts all uppercase letters in a text string to lowercase.

Capitalizes the first letter in each word of a text string and converts all other letters to lowercase.

Replaces part of a text string with a different text string based on the number of characters you specify.

Returns the position of a text string within another text string, case-insensitive.

Converts a text string that represents a number into a number.

Converts text to a number in a locale-independent way.

Repeats a given text string a specified number of times.

Returns the character specified by the code number.

Returns a numeric code for the first character in a text string.

Checks whether two text strings are exactly the same.

Removes all non-printable characters from a text string.

Joins two or more text strings into one string.

Returns the current date and time formatted as a date and time.

Returns the year corresponding to a date.

Returns the month of a date represented by a serial number.

Returns the day of the month for a given date as a number from 1 to 31.

Returns the serial number of a particular date.

Converts a date stored as text into a serial number that Excel recognizes as a date.

Returns the serial number of the date that is the indicated number of months before or after the start date.

Returns a date that is the indicated number of working days before or after a start date.

Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters.

Returns the hour of a time value as a number from 0 to 23.

Returns the minute component of a time value as an integer ranging from 0 to 59.

Returns the decimal number for a particular time.

Calculates the fraction of the year represented by the number of whole days between two dates.

Returns the median of the given numbers.

Returns the most frequently occurring value in a dataset.

Returns the rank of a number in a list of numbers.

Returns the k-th largest value in a data set.

Returns the k-th smallest value in a data set.

Counts the number of cells that contain numbers in a range or list of arguments.

Counts the number of empty cells in a specified range of cells.

Returns the average of all cells that meet multiple criteria.

Returns the maximum value among cells specified by a given set of conditions or criteria.

Returns the minimum value among cells specified by a given set of conditions or criteria.

Estimates standard deviation based on a sample.

Calculates the standard deviation based on the entire population.

Calculates the variance based on a sample of data.

Returns the correlation coefficient between two data sets.

Returns the k-th percentile of values in a range.

Returns the quartile of a data set based on percentile values from 0 to 1.

Calculates or predicts a future value by using existing values along a linear trend.

Returns values along a linear trend.

Calculates how often values occur within a range of values and returns a vertical array of numbers.

Calculates the future value of an investment based on periodic, constant payments and a constant interest rate.

Calculates the present value of a loan or an investment based on a constant interest rate.

Returns the internal rate of return for a series of cash flows represented by the numbers in values.

Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.

Calculates the net present value for a schedule of cash flows that is not necessarily periodic.

Returns the interest rate per period of an annuity.

Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.

Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.

Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.

Calculates the straight-line depreciation of an asset for one period.

Calculates the depreciation of an asset for a specified period using the fixed-declining balance method.

Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.

Converts a vertical range of cells into a horizontal range, or vice versa.

Returns the formula at the given reference as a text string.

Sorts the contents of a range or array based on the values in a corresponding range or array.

Appends arrays horizontally and in sequence to return a larger array.

Appends arrays vertically to return a single combined array.

Returns the specified columns from an array.

Returns the specified rows from an array.

Returns the array in a single column.

Creates custom, reusable functions and calls them by a friendly name.

Applies a LAMBDA function to each row in an array and returns an array of results.

Applies a LAMBDA function to each column in an array and returns an array of the results.

Applies a LAMBDA function to each value in the provided arrays to create a new mapped array.

Reduces an array to an accumulated value by applying a LAMBDA to each element.

Scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value.

Checks whether a reference is to an empty cell and returns TRUE or FALSE.

Checks if a value is any error type and returns TRUE or FALSE.

Checks if a value is a number and returns TRUE or FALSE.

Checks if a value is text and returns TRUE or FALSE.

Checks whether a value is the #N/A error and returns TRUE or FALSE.

Returns the sum of the squares of the arguments.

Returns the greatest common divisor of two or more integers.

Returns the least common multiple of integers.

Returns the factorial of a number.

Returns the number of combinations for a given number of items.

Returns the number of permutations for a given number of objects.

Returns e raised to the power of a given number.

Returns the natural logarithm of a number.

Returns the logarithm of a number to a specified base.

Returns the base-10 logarithm of a number.

Returns the sign of a number.

Truncates a number to an integer by removing the fractional part.

Rounds a number up to the nearest even integer.

Rounds a number up to the nearest odd integer.

Returns the integer portion of a division operation.

Generates a list of sequential numbers in an array.

Returns an array of random numbers between 0 and 1 or within a specified range.

Converts a number to text using the currency format, with the decimals rounded to the specified place.

Rounds a number to a specified number of decimals and formats it as text with or without commas.

Returns the Unicode character that corresponds to the numeric value provided.

Returns the number (code point) corresponding to the first character of the text.

Checks whether a value is text and returns the text if it is, or an empty string if it is not.

Converts a time in the form of text to a serial number representing a time.

Returns the seconds of a time value as an integer from 0 to 59.

Returns the week number of a specific date within a year.

Returns the ISO 8601 week number of the year for a given date.

두 날짜 사이의 일수를 반환합니다.

Calculates the number of days between two dates based on a 360-day year.

Returns the number of whole working days between two dates using custom weekend parameters.

Calculates the variance based on a sample, including numbers, text, and logical values.

Calculates the average of a list of arguments, including numbers, text, and logical values.

Returns the geometric mean of an array or range of positive numeric data.

Returns the harmonic mean of a data set.

Returns the rank of a value in a data set as a percentage of the data set.

Returns the slope of the linear regression line through the given data points.

Calculates the y-intercept of a linear regression line using existing x and y values.

Returns the square of the Pearson product-moment correlation coefficient for data points in two arrays.

Returns a normalized value from a distribution characterized by mean and standard_dev.

Returns the depreciation of an asset for a specified period using the double-declining balance method or some other specified rate.

Returns the sum-of-years' digits depreciation of an asset for a specified period.

Calculates the modified internal rate of return for a series of periodic cash flows.

Returns the cumulative interest paid on a loan between two specified periods.

Returns the cumulative principal paid on a loan between two periods.

Calculates the effective annual interest rate for a given nominal annual interest rate and the number of compounding periods per year.

Returns the annual nominal interest rate for a given effective interest rate and number of compounding periods per year.

Returns the number of periods required for an investment to reach a specified value.

Returns the equivalent interest rate for the growth of an investment.

Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number.

Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction.

Returns the array as a single row.

Wraps a provided row or column of values into a two-dimensional array by row.

Wraps a provided row or column of values into columns by a specified count.

Returns a calculated array of a specified row and column size by applying a LAMBDA function.

Checks whether a reference contains a formula and returns TRUE or FALSE.

Checks if a value is a reference.

Checks if a value is a logical value (TRUE or FALSE) and returns TRUE or FALSE.

Returns TRUE if the number is even, and FALSE if it is odd.

Checks whether a value is odd and returns TRUE or FALSE.

Checks if a value is any error type except #N/A.

Checks if a value is not text and returns TRUE or FALSE.

Returns a value converted to a number.

Returns the error value #N/A.

Returns an integer representing the data type of a value.

Returns a number corresponding to an error type.

Returns information about the formatting, location, or contents of a cell.

Returns the value of the mathematical constant Pi, accurate to 15 digits.

Returns the sine of a given angle.

Returns the cosine of a given angle.

Returns the tangent of a given angle.

Returns the arctangent of the specified x and y coordinates.

Converts an angle from radians to degrees.

Converts degrees to radians.

Rounds a number up to the nearest integer or to the nearest multiple of significance.

Rounds a number down to the nearest integer or to the nearest multiple of significance.

Returns the matrix product of two arrays.

Returns the inverse matrix for the matrix stored in an array.

Returns the matrix determinant of an array.

Returns the ratio of the factorial of a sum of values to the product of factorials of those values.

Returns the skewness of a distribution, which characterizes the degree of asymmetry of a distribution around its mean.

Returns the kurtosis of a data set.

Returns the sum of squares of deviations of data points from their sample mean.

Returns the average of the absolute deviations of data points from their mean.

Returns the mean of the interior of a data set by excluding a specified percentage of data points from the top and bottom tails.

Calculates the statistics for a line by using the 'least squares' method to calculate a straight line that best fits your data.

Calculates predicted exponential growth by using existing data.

Calculates the interest paid during a specific period of an investment.

Adds the numbers in a column of a list or database that match conditions you specify.

Returns the average of entries in a database column that match specified conditions.

Counts the number of cells containing numbers in a database that match specified conditions.

Counts the number of non-empty cells in a database column that match specified conditions.

Extracts a single record from a database that matches specified conditions.

Returns the largest number in a column of a list or database that matches specified conditions.

Returns the smallest number in a field of records in a database that match the specified conditions.

Multiplies the values in a particular field of records in a database that match the specified criteria.

Estimates the standard deviation of a population based on a sample of entries in a database that match specified conditions.

Estimates the variance of a population based on a sample from entries in a database that match specified conditions.

Converts a number from one measurement system to another.

Converts a decimal number to binary.

Converts a binary number to a decimal number.

Converts a decimal number to a hexadecimal number.

Converts a hexadecimal number to a decimal number.

Returns a bitwise 'AND' of two numbers.

Returns a bitwise OR of two numbers.

Returns a bitwise 'exclusive OR' of two numbers.

Tests whether two values are equal.

Returns 1 if a number is greater than or equal to a threshold, and 0 otherwise.

Converts an Arabic numeral to Roman, as text.

Converts a Roman numeral to an Arabic numeral.

Converts a number into a text representation with the given radix (base).

Converts a text representation of a number in a given base into a decimal number.

Returns the number of combinations with repetitions for a given number of items.

Returns the sum of a power series based on the formula: x^n + m*x^(n+m) + m^2*x^(n+2m) + ...

Returns the arccosine of a number.

Returns the arcsine of a number in radians.

Returns the arctangent of a number in radians.

Returns the inverse hyperbolic cosine of a number.

Returns the inverse hyperbolic sine of a number.

Returns the inverse hyperbolic tangent of a number.

Returns the hyperbolic cosine of a number.

Returns the hyperbolic sine of a number.

Returns the hyperbolic tangent of a number.

Returns the cotangent of an angle given in radians.

Returns the secant of an angle.

Returns the cosecant of an angle.

Converts an octal number to a decimal number.

Converts a decimal number to an octal number.

Converts a binary number to a hexadecimal number.

Converts a hexadecimal number to a binary number.

Converts an octal number to binary.

Converts a binary number to octal.

Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.

Returns the absolute value (modulus) of a complex number.

Returns the real coefficient of a complex number in x + yi or x + yj text format.

Returns the error function integrated between lower and upper limits.

Returns the complementary error function integrated between x and infinity.

Shifts a number to the left by the specified number of bits.

Shifts the bits of a number to the right by a specified number of places.

Returns the Fisher transformation for a specified value.

Returns the inverse of the Fisher transformation for a specified value.

Returns the standard error of the predicted y-value for each x in the regression.

Returns the Pearson product-moment correlation coefficient of two data sets.

Returns the natural logarithm of the gamma function, Γ(x).