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.