# Complete List of Google Sheets Functions

Explore and master every Google Sheets function with explanations and examples.

### ACCRINT Function in Google Sheets

Calculate the accrued interest for a security with periodic payments using the ACCRINT function.

### ACCRINTM Function in Google Sheets

Calculate the accrued interest for a security that pays interest at maturity using the ACCRINTM function.

### AMORLINC Function in Google Sheets

Calculate the prorated linear depreciation of an asset using the AMORLINC function.

### AND Function in Google Sheets

Evaluate multiple logical expressions in Google Sheets using the AND function.

### ARRAYFORMULA Function in Google Sheets

Apply a formula to a range of cells using the ARRAYFORMULA function.

### ARRAY_CONSTRAIN Function in Google Sheets

Limit the number of rows and columns in an array using the ARRAY_CONSTRAIN function.

### BIN2DEC Function in Google Sheets

Convert a binary number to a decimal number using the BIN2DEC function.

### BIN2HEX Function in Google Sheets

Convert a binary number to a hexadecimal number using the BIN2HEX function.

### BIN2OCT Function in Google Sheets

Convert a binary number to an octal number using the BIN2OCT function.

### BITAND Function in Google Sheets

Perform a bitwise AND operation on two numbers using the BITAND function.

### BITLSHIFT Function in Google Sheets

Shift a number's bits to the left by a specified amount using the BITLSHIFT function.

### BITOR Function in Google Sheets

Perform a bitwise OR operation on two numbers using the BITOR function.

### BITRSHIFT Function in Google Sheets

Shift a number's bits to the right by a specified amount using the BITRSHIFT function.

### BITXOR Function in Google Sheets

Perform a bitwise XOR operation on two numbers using the BITXOR function.

### BYROW Function in Google Sheets

Apply a custom function to each row in an array using the BYROW function.

### CELL Function in Google Sheets

Retrieve information about a cell in Google Sheets using the CELL function.

### CHOOSECOLS Function in Google Sheets

Select specific columns from an array using the CHOOSECOLS function.

### BYCOL Function in Google Sheets

Apply a custom function to each column in an array using the BYCOL function.

### CHOOSEROWS Function in Google Sheets

Select specific rows from an array using the CHOOSEROWS function.

### COUPDAYBS Function in Google Sheets

Calculate the number of days from the beginning of the coupon period to the settlement date using the COUPDAYBS function.

### COUPDAYS Function in Google Sheets

Calculate the number of days in the coupon period containing the settlement date using the COUPDAYS function.

### COUPDAYSNC Function in Google Sheets

Calculate the number of days from the settlement date to the next coupon date using the COUPDAYSNC function.

### COMPLEX Function in Google Sheets

Create a complex number using the COMPLEX function.

### COUPNCD Function in Google Sheets

Calculate the next coupon date after the settlement date using the COUPNCD function.

### COUPNUM Function in Google Sheets

Calculate the number of coupons payable between the settlement date and maturity date using the COUPNUM function.

### CUMIPMT Function in Google Sheets

Calculate the cumulative interest paid on a loan between two periods using the CUMIPMT function.

### COUPPCD Function in Google Sheets

Calculate the previous coupon date before the settlement date using the COUPPCD function.

### CUMPRINC Function in Google Sheets

Calculate the cumulative principal paid on a loan between two periods using the CUMPRINC function.

### DATE Function in Google Sheets

Creates a date value from year, month, and day components.

### DATEDIF Function in Google Sheets

Calculates the difference between two dates in specified units.

### DATEVALUE Function in Google Sheets

Converts a date in text format to a serial number date value.

### DAVERAGE Function in Google Sheets

Calculate the average of values in a database that meet specified criteria using the DAVERAGE function.

### DAY Function in Google Sheets

Extracts the day of the month from a date value.

### DAYS Function in Google Sheets

Calculates the number of days between two dates.

### DAYS360 Function in Google Sheets

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

### DB Function in Google Sheets

Calculate depreciation of an asset for a specific period using the DB function.

### DCOUNTA Function in Google Sheets

Count the number of non-empty cells in a database that meet specified criteria using the DCOUNTA function.

### DCOUNT Function in Google Sheets

Count the number of cells that contain numeric values in a database that meet specified criteria using the DCOUNT function.

### DEC2HEX Function in Google Sheets

Convert a decimal number to a hexadecimal number using the DEC2HEX function.

### DEC2BIN Function in Google Sheets

Convert a decimal number to a binary number using the DEC2BIN function.

### DDB Function in Google Sheets

Calculate depreciation of an asset using the double-declining balance method with the DDB function.

### DEC2OCT Function in Google Sheets

Convert a decimal number to an octal number using the DEC2OCT function.

### DELTA Function in Google Sheets

Check if two numbers are equal using the DELTA function.

### DETECTLANGUAGE Function in Google Sheets

Detect the language of the given text using the DETECTLANGUAGE function.

### DGET Function in Google Sheets

Retrieve a single value from a database that meets specified criteria using the DGET function.

### DMAX Function in Google Sheets

Find the maximum value in a database that meets specified criteria using the DMAX function.

### DISC Function in Google Sheets

Calculate the discount rate of a security using the DISC function.

### DMIN Function in Google Sheets

Find the minimum value in a database that meets specified criteria using the DMIN function.

### DOLLARDE Function in Google Sheets

Convert a fractional dollar price into a decimal dollar price using the DOLLARDE function.

### DOLLARFR Function in Google Sheets

Convert a decimal dollar price into a fractional dollar price using the DOLLARFR function.

### DPRODUCT Function in Google Sheets

Calculate the product of values in a database that meet specified criteria using the DPRODUCT function.

### DSTDEV Function in Google Sheets

Estimate the standard deviation of a sample from a database that meets specified criteria using the DSTDEV function.

### DSTDEVP Function in Google Sheets

Estimate the standard deviation of an entire population from a database that meets specified criteria using the DSTDEVP function.

### DSUM Function in Google Sheets

Sum the values in a database that meet specified criteria using the DSUM function.

### DURATION Function in Google Sheets

Calculate the Macaulay duration of a security using the DURATION function.

### DVAR Function in Google Sheets

Calculates the variance of a database field based on specified criteria.

### DVARP Function in Google Sheets

Calculates the variance of an entire population based on specified criteria.

### EFFECT Function in Google Sheets

Calculate the effective annual interest rate using the EFFECT function.

### EDATE Function in Google Sheets

Returns the date that is a specified number of months before or after a given date.

### EPOCHTODATE Function in Google Sheets

Convert a Unix timestamp to a human-readable date format using the EPOCHTODATE function.

### EOMONTH Function in Google Sheets

Returns the end of the month that is a specified number of months before or after a given date.

### ERF.PRECISE Function in Google Sheets

Calculate the error function from 0 to a specified value using the ERF.PRECISE function.

### ERF Function in Google Sheets

Calculate the error function over a range using the ERF function.

### ERROR.TYPE Function in Google Sheets

Identify the error type of a value using the ERROR.TYPE function.

### FALSE Function in Google Sheets

Return the boolean value FALSE in Google Sheets using the FALSE function.

### FILTER Function in Google Sheets

Filter a range of data based on specified conditions using the FILTER function.

### FLATTEN Function in Google Sheets

Flatten multiple ranges into a single column using the FLATTEN function.

### FREQUENCY Function in Google Sheets

Calculate frequency distributions of data using the FREQUENCY function.

### FV Function in Google Sheets

Calculate the future value of an investment using the FV function.

### FVSCHEDULE Function in Google Sheets

Calculate the future value of an initial principal after applying a series of compound interest rates using the FVSCHEDULE function.

### GESTEP Function in Google Sheets

Compare a value to a step value using the GESTEP function.

### GOOGLEFINANCE Function in Google Sheets

Fetch financial data using the GOOGLEFINANCE function.

### GOOGLETRANSLATE Function in Google Sheets

Translate text from one language to another using the GOOGLETRANSLATE function.

### GROWTH Function in Google Sheets

Calculate exponential growth trends using the GROWTH function.

### HEX2DEC Function in Google Sheets

Convert a hexadecimal number to a decimal number using the HEX2DEC function.

### HEX2BIN Function in Google Sheets

Convert a hexadecimal number to a binary number using the HEX2BIN function.

### HEX2OCT Function in Google Sheets

Convert a hexadecimal number to an octal number using the HEX2OCT function.

### HSTACK Function in Google Sheets

Horizontally stack multiple ranges into a single range using the HSTACK function.

### IF Function in Google Sheets

Perform conditional logic in Google Sheets using the IF function.

### HOUR Function in Google Sheets

Extract the hour from a given time using the HOUR function.

### IFERROR Function in Google Sheets

Handle errors in formulas using the IFERROR function in Google Sheets.

### IFNA Function in Google Sheets

Handle

### IFS Function in Google Sheets

Evaluate multiple conditions in Google Sheets using the IFS function.

### IMABS Function in Google Sheets

Calculate the absolute value of a complex number using the IMABS function.

### IMAGE Function in Google Sheets

Display an image within a cell using the IMAGE function.

### IMAGINARY Function in Google Sheets

Extract the imaginary part of a complex number using the IMAGINARY function.

### IMARGUMENT Function in Google Sheets

Calculate the argument of a complex number using the IMARGUMENT function.

### IMCONJUGATE Function in Google Sheets

Compute the complex conjugate of a complex number using the IMCONJUGATE function.

### IMCOS Function in Google Sheets

Compute the cosine of a complex number using the IMCOS function.

### IMCOSH Function in Google Sheets

Compute the hyperbolic cosine of a complex number using the IMCOSH function.

### IMCOT Function in Google Sheets

Compute the cotangent of a complex number using the IMCOT function.

### IMCOTH Function in Google Sheets

Compute the hyperbolic cotangent of a complex number using the IMCOTH function.

### IMCSC Function in Google Sheets

Compute the cosecant of a complex number using the IMCSC function.

### IMCSCH Function in Google Sheets

Compute the hyperbolic cosecant of a complex number using the IMCSCH function.

### IMDIV Function in Google Sheets

Divide two complex numbers using the IMDIV function.

### IMEXP Function in Google Sheets

Compute the exponential of a complex number using the IMEXP function.

### IMLOG Function in Google Sheets

Compute the logarithm of a complex number with a specified base using the IMLOG function.

### IMLOG10 Function in Google Sheets

Compute the base-10 logarithm of a complex number using the IMLOG10 function.

### IMLOG2 Function in Google Sheets

Calculate the base-2 logarithm of a complex number using the IMLOG2 function.

### IMREAL Function in Google Sheets

Extract the real part of a complex number using the IMREAL function.

### IMPRODUCT Function in Google Sheets

Multiply complex numbers using the IMPRODUCT function.

### IMSEC Function in Google Sheets

Calculate the secant of a complex number using the IMSEC function.

### IMSECH Function in Google Sheets

Calculate the hyperbolic secant of a complex number using the IMSECH function.

### IMSINH Function in Google Sheets

Calculate the hyperbolic sine of a complex number using the IMSINH function.

### IMSUB Function in Google Sheets

Subtract one complex number from another using the IMSUB function.

### IMSIN Function in Google Sheets

Calculate the sine of a complex number using the IMSIN function.

### IMSUM Function in Google Sheets

Add multiple complex numbers using the IMSUM function.

### IMTANH Function in Google Sheets

Calculate the hyperbolic tangent of a complex number using the IMTANH function.

### IMTAN Function in Google Sheets

Calculate the tangent of a complex number using the IMTAN function.

### INTRATE Function in Google Sheets

Calculate the interest rate of a fully invested security using the INTRATE function.

### IPMT Function in Google Sheets

Calculate the interest portion of a payment for a given period using the IPMT function.

### IRR Function in Google Sheets

Calculate the internal rate of return for a series of cash flows using the IRR function.

### ISBLANK Function in Google Sheets

Check if a cell is empty using the ISBLANK function.

### ISDATE Function in Google Sheets

Verify if a value is a valid date using the ISDATE function.

### ISEMAIL Function in Google Sheets

Verify if a value is a valid email address using the ISEMAIL function.

### ISERR Function in Google Sheets

Determine if a value is an error, excluding the

### ISERROR Function in Google Sheets

Determine if a value is an error, including the

### ISFORMULA Function in Google Sheets

Check if a cell contains a formula using the ISFORMULA function.

### ISLOGICAL Function in Google Sheets

Determine if a value is a logical value (TRUE or FALSE) using the ISLOGICAL function.

### ISNA Function in Google Sheets

Determine if a value is the

### ISNONTEXT Function in Google Sheets

Determine if a value is not text using the ISNONTEXT function.

### ISNUMBER Function in Google Sheets

Determine if a value is numeric using the ISNUMBER function.

### ISOWEEKNUM Function in Google Sheets

Find the ISO week number for a given date using the ISOWEEKNUM function.

### ISPMT Function in Google Sheets

Calculate the interest paid during a specific period of an investment using the ISPMT function.

### ISTEXT Function in Google Sheets

Determine if a value is text using the ISTEXT function.

### LAMBDA Function in Google Sheets

Create custom functions in Google Sheets using the LAMBDA function.

### LINEST Function in Google Sheets

Perform linear regression analysis using the LINEST function.

### ISREF Function in Google Sheets

Determine if a value is a cell reference using the ISREF function.

### LOGEST Function in Google Sheets

Perform exponential regression analysis using the LOGEST function.

### MAKEARRAY Function in Google Sheets

Create an array by applying a `LAMBDA` function to each cell using the MAKEARRAY function.

### MDETERM Function in Google Sheets

Calculate the determinant of a square matrix using the MDETERM function.

### MAP Function in Google Sheets

Apply a custom function to each element in one or more arrays using the MAP function.

### MDURATION Function in Google Sheets

Calculate the modified duration of a security with the MDURATION function.

### MINUTE Function in Google Sheets

Extract the minute from a given time using the MINUTE function.

### MINVERSE Function in Google Sheets

Calculate the inverse of a square matrix using the MINVERSE function.

### MIRR Function in Google Sheets

Calculate the modified internal rate of return for a series of cash flows using the MIRR function.

### MONTH Function in Google Sheets

Extract the month from a given date using the MONTH function.

### MMULT Function in Google Sheets

Multiply two matrices using the MMULT function.

### NA Function in Google Sheets

Return the

### N Function in Google Sheets

Convert a value to a number using the N function.

### NETWORKDAYS.INTL Function in Google Sheets

Calculate the number of working days between two dates, with customizable weekends and holidays, using the NETWORKDAYS.INTL function.

### NETWORKDAYS Function in Google Sheets

Calculate the number of working days between two dates using the NETWORKDAYS function.

### NOMINAL Function in Google Sheets

Calculate the nominal interest rate given the effective rate and periods per year using the NOMINAL function.

### NOW Function in Google Sheets

Get the current date and time using the NOW function.

### NPER Function in Google Sheets

Calculate the number of periods required for an investment to reach a target value using the NPER function.

### NPV Function in Google Sheets

Calculate the net present value of an investment based on a series of periodic cash flows using the NPV function.

### OCT2BIN Function in Google Sheets

Convert an octal number to a binary number using the OCT2BIN function.

### OCT2DEC Function in Google Sheets

Convert an octal number to a decimal number using the OCT2DEC function.

### OCT2HEX Function in Google Sheets

Convert an octal number to a hexadecimal number using the OCT2HEX function.

### PDURATION Function in Google Sheets

Calculate the number of periods required for an investment to grow to a future value using the PDURATION function.

### PMT Function in Google Sheets

Calculate the periodic payment for a loan based on constant payments and a constant interest rate using the PMT function.

### PPMT Function in Google Sheets

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

### PRICE Function in Google Sheets

Calculate the price of a security that pays periodic interest, based on expected yield.

### PRICEDISC Function in Google Sheets

Calculate the price of a discounted security, such as a treasury bill, per $100 face value.

### PRICEMAT Function in Google Sheets

Calculate the price of a security that pays interest at maturity, such as a bond.

### PV Function in Google Sheets

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

### QUERY Function in Google Sheets

Run a Google Visualization API Query Language query on the data using the QUERY function.

### RATE Function in Google Sheets

Calculate the interest rate per period of an annuity, given the number of periods, payment, present value, and future value.

### REDUCE Function in Google Sheets

Apply a custom function to reduce an array or range to a single value using the REDUCE function.

### RRI Function in Google Sheets

Calculate the equivalent annual interest rate of an investment based on its growth over a period of time.

### RECEIVED Function in Google Sheets

Calculate the amount received from a discounted security at maturity.

### SCAN Function in Google Sheets

Apply a custom function to accumulate values in an array or range using the SCAN function.

### SECOND Function in Google Sheets

Extract the second from a given time using the SECOND function.

### SLN Function in Google Sheets

Calculate the straight-line depreciation of an asset over its useful life.

### SORT Function in Google Sheets

Sort a range of data based on one or more columns using the SORT function.

### SORTN Function in Google Sheets

Sort a range of data and return a specified number of sorted rows using the SORTN function.

### SPARKLINE Function in Google Sheets

Create a mini-chart within a cell using the SPARKLINE function.

### SUMX2MY2 Function in Google Sheets

Calculate the sum of the squares of the differences between corresponding values in two arrays using the SUMX2MY2 function.

### SUMPRODUCT Function in Google Sheets

Multiply corresponding components in given arrays and return the sum using the SUMPRODUCT function.

### SUMX2PY2 Function in Google Sheets

Compute the sum of the squares of the sums of corresponding values in two arrays using the SUMX2PY2 function.

### SUMXMY2 Function in Google Sheets

Compute the sum of squares of differences between corresponding values in two arrays using the SUMXMY2 function.

### SYD Function in Google Sheets

Calculate the sum-of-years' digits depreciation of an asset over its useful life.

### TBILLEQ Function in Google Sheets

Calculate the bond-equivalent yield for a Treasury bill using the TBILLEQ function.

### TBILLPRICE Function in Google Sheets

Calculate the price per $100 face value for a Treasury bill using the TBILLPRICE function.

### TBILLYIELD Function in Google Sheets

Calculate the yield of a Treasury bill using the TBILLYIELD function.

### TIME Function in Google Sheets

Create a time value from individual hour, minute, and second components using the TIME function.

### TIMEVALUE Function in Google Sheets

Convert a time string to a time value in Google Sheets using the TIMEVALUE function.

### TOCOL Function in Google Sheets

Convert an array into a single column using the TOCOL function.

### TODAY Function in Google Sheets

Get the current date using the TODAY function in Google Sheets.

### TOROW Function in Google Sheets

Convert an array into a single row using the TOROW function.

### TRANSPOSE Function in Google Sheets

Switch the rows and columns of an array or range using the TRANSPOSE function.

### TREND Function in Google Sheets

Predict values based on existing data trends using the TREND function.

### TYPE Function in Google Sheets

Determine the type of a value in Google Sheets using the TYPE function.

### UNIQUE Function in Google Sheets

Remove duplicate values from a range using the UNIQUE function.

### VDB Function in Google Sheets

Calculate the depreciation of an asset for any specified period using the VDB function.

### VSTACK Function in Google Sheets

Combine multiple ranges vertically using the VSTACK function.

### WEEKDAY Function in Google Sheets

Find the day of the week for a given date using the WEEKDAY function.

### WEEKNUM Function in Google Sheets

Determine the week number of a given date using the WEEKNUM function.

### WORKDAY.INTL Function in Google Sheets

Calculate a workday, allowing for custom weekends, using the WORKDAY.INTL function.

### WORKDAY Function in Google Sheets

Calculate a workday that is a specific number of days from a start date using the WORKDAY function.

### WRAPCOLS Function in Google Sheets

Wrap a range into multiple columns using the WRAPCOLS function.

### WRAPROWS Function in Google Sheets

Wrap a range into multiple rows using the WRAPROWS function.

### XIRR Function in Google Sheets

Calculate the internal rate of return for a series of cash flows using the XIRR function.

### XNPV Function in Google Sheets

Calculate the net present value for a series of cash flows using the XNPV function.

### YEAR Function in Google Sheets

Extract the year from a date using the YEAR function in Google Sheets.

### YEARFRAC Function in Google Sheets

Calculate the fraction of the year between two dates using the YEARFRAC function.

### YIELD Function in Google Sheets

Calculate the annual yield of a bond using the YIELD function.

### YIELDMAT Function in Google Sheets

Calculate the annual yield of a bond that pays interest at maturity using the YIELDMAT function.

### YIELDDISC Function in Google Sheets

Calculate the annual yield of a discounted security using the YIELDDISC function.