---
title: Functions and Operators
description: >-
  Reference guide for functions and operators available in Sheets calculated
  columns and sheet formulas, including text, date, logical, math, lookup,
  statistical, and financial operations.
breadcrumbs: Docs > Sheets > Functions and Operators
---

# Functions and Operators

## Overview{% #overview %}

Use functions and operators in Sheets to analyze and transform your data. Functions are available in two contexts:

- **Table calculated columns**: Functions that transform or enrich individual row values in a table, applied at the column level.
- **Sheets**: Functions entered directly in a [sheet](https://docs.datadoghq.com/sheets/#sheet-preview) tab, allowing you to reference other sheet or table tabs (when applicable).

## Operators{% #operators %}

| Operator | Name                  | Example        |
| -------- | --------------------- | -------------- |
| `+`      | Addition              | `=A1+B1`       |
| `-`      | Subtraction           | `=A1-B1`       |
| `*`      | Multiplication        | `=A1*B1`       |
| `/`      | Division              | `=A1/B1`       |
| `^`      | Power                 | `=2^10`        |
| `&`      | Concatenate           | `="Hello "&A1` |
| `=`      | Equal                 | `=A1=B1`       |
| `<>`     | Not equal             | `=A1<>0`       |
| `>`      | Greater than          | `=A1>100`      |
| `<`      | Less than             | `=A1<100`      |
| `>=`     | Greater than or equal | `=A1>=100`     |
| `<=`     | Less than or equal    | `=A1<=100`     |

## Functions{% #functions %}

### Text{% #text %}

{% dl %}

{% dt %}
`REGEXMATCH(text_string, regular_expression)`
{% /dt %}

{% dd %}
Evaluates whether a text string matches a regular expression.**Example**: `REGEXMATCH("ABC 123 def", "\\\\d+") => TRUE`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`REGEXEXTRACT(text_string, regular_expression)`
{% /dt %}

{% dd %}
Extracts the first substring that matches a specified regex pattern.**Example**: `REGEXEXTRACT("ABC 123 def", "\\\\d+") => "123"`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`REGEXCOUNT(text_string, regular_expression)`
{% /dt %}

{% dd %}
Counts the number of times a regex pattern appears in a text string.**Example**: `REGEXCOUNT("abc 123 def", "\\\\d+") => 1`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`REGEXREPLACE(text_string, regular_expression, replacement)`
{% /dt %}

{% dd %}
Replaces all substrings matching a regex with a replacement string.**Example**: `REGEXREPLACE("abc 123 def", "\\\\d+", "NUM") => "abc NUM def"`**Available in**: Table
{% /dd %}

{% dt %}
`LEN(string)`
{% /dt %}

{% dd %}
Returns the length of a string.**Example**: `LEN("Hello World")`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`LOWER(string)`
{% /dt %}

{% dd %}
Returns the string in lowercase.**Example**: `LOWER("HELLO WORLD")`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`UPPER(string)`
{% /dt %}

{% dd %}
Returns the string in uppercase.**Example**: `UPPER("hello world")`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`LEFT(string, number_of_characters)`
{% /dt %}

{% dd %}
Returns a substring from the beginning of a specified string.**Example**: `LEFT("Datadog", 4)`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`RIGHT(string, number_of_characters)`
{% /dt %}

{% dd %}
Returns a substring from the end of a specified string.**Example**: `RIGHT("DATADOG", 3)`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`MID(text, start, length)`
{% /dt %}

{% dd %}
Returns characters from the middle of text.**Example**: `MID("Hello World", 7, 5) => "World"`**Available in**: Sheet
{% /dd %}

{% dt %}
`CONCATENATE(string1, string2, ...)`
{% /dt %}

{% dd %}
Appends strings to one another. Equivalent to the `&` operator.**Example**: `CONCATENATE("data", "dog")`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`CONTAINS(string, substring)`
{% /dt %}

{% dd %}
Returns TRUE if the string contains the substring, FALSE otherwise.**Example**: `CONTAINS("is the word string in this sentence?", "string")`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`SUBSTITUTE(text, old_text, new_text, [instance_num])`
{% /dt %}

{% dd %}
Replaces occurrences of old_text with new_text. If instance_num is omitted, all occurrences are replaced; otherwise, only the specified instance is replaced.**Example**: `SUBSTITUTE("hello world", "world", "Datadog") => "hello Datadog"`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...])`
{% /dt %}

{% dd %}
Combines the text from multiple strings with the specified delimiter.**Example**: `TEXTJOIN(" ", TRUE, "hello", "world")`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`FIND(search_for, text_to_search)`
{% /dt %}

{% dd %}
Finds the position of text within text (case-sensitive). Returns an error if not found.**Example**: `FIND("World", "Hello World") => 7`**Available in**: Sheet
{% /dd %}

{% dt %}
`CHAR(number)`
{% /dt %}

{% dd %}
Converts a number into a character according to the Unicode character set.**Example**: `CHAR(65) => "A"`**Available in**: Sheet
{% /dd %}

{% dt %}
`CLEAN(text)`
{% /dt %}

{% dd %}
Removes non-printable characters from text.**Example**: `CLEAN(A1)`**Available in**: Sheet
{% /dd %}

{% dt %}
`TEXT(number, format)`
{% /dt %}

{% dd %}
Formats a number as text using a format pattern. Supports number, date, and time formatting.**Example**: `TEXT(1234.5, "#,##0.00") => "1,234.50"`**Available in**: Sheet
{% /dd %}

{% dt %}
`TRIM(text)`
{% /dt %}

{% dd %}
Removes leading, trailing, and extra spaces from text.**Example**: `TRIM(" hello ") => "hello"`**Available in**: Sheet
{% /dd %}

{% dt %}
`VALUE(text)`
{% /dt %}

{% dd %}
Converts text to a number.**Example**: `VALUE("123") => 123`**Available in**: Sheet
{% /dd %}

{% /dl %}

### Logical{% #logical %}

{% dl %}

{% dt %}
`IF(logical_expression, value_if_true, value_if_false)`
{% /dt %}

{% dd %}
Returns one value if a logical expression is TRUE and another if it is FALSE.**Example**: `IF(42>9, "all good", "something is wrong in the matrix")`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], …)`
{% /dt %}

{% dd %}
Evaluates one or more condition/value pairs and returns the value for the first true condition. Use TRUE as the final condition to define a default value.**Example**: `IFS(A1>90, "A", A1>80, "B", TRUE, "C")`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`AND(logical_expression1, [logical_expression2, …])`
{% /dt %}

{% dd %}
Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.**Example**: `AND(A1=1, A2=2)`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`OR(logical_expression1, [logical_expression2, …])`
{% /dt %}

{% dd %}
Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.**Example**: `OR(A1=1, A2=2)`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`NOT(logical_expression)`
{% /dt %}

{% dd %}
Returns the opposite of a logical value.**Example**: `NOT(TRUE)`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`TRUE()`
{% /dt %}

{% dd %}
Returns the logical value TRUE.**Example**: `TRUE()`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`FALSE()`
{% /dt %}

{% dd %}
Returns the logical value FALSE.**Example**: `FALSE()`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`IFERROR(value, value_if_error)`
{% /dt %}

{% dd %}
Returns a specified value if a formula evaluates to an error; otherwise returns the result of the formula.**Example**: `IFERROR(1/0, "Division Error")`**Available in**: Sheet
{% /dd %}

{% dt %}
`IFNA(value, value_if_na)`
{% /dt %}

{% dd %}
Returns a specified value if a formula evaluates to #N/A; otherwise returns the result of the formula.**Example**: `IFNA(VLOOKUP("x", A1:B10, 2, FALSE), "Not found")`**Available in**: Sheet
{% /dd %}

{% dt %}
`SWITCH(expression, case1, value1, ..., [default])`
{% /dt %}

{% dd %}
Compares expression to cases and returns the corresponding value.**Example**: `SWITCH(A1, 1, "One", 2, "Two", "Other")`**Available in**: Sheet
{% /dd %}

{% dt %}
`XOR(logical_expression1, [logical_expression2, …])`
{% /dt %}

{% dd %}
Returns TRUE if an odd number of arguments are TRUE.**Example**: `XOR(TRUE, FALSE)`**Available in**: Sheet
{% /dd %}

{% /dl %}

### Math{% #math %}

{% dl %}

{% dt %}
`ABS(number)`
{% /dt %}

{% dd %}
Returns the absolute value of a number.**Example**: `ABS(26.34)`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`CEILING(number, factor)`
{% /dt %}

{% dd %}
Rounds a number up to the nearest integer multiple of the specified factor.**Example**: `CEILING(826.645, 10)`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`FLOOR(number, factor)`
{% /dt %}

{% dd %}
Rounds a number down to the nearest integer multiple of the specified factor.**Example**: `FLOOR(826.645, 10)`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`MOD(number1, number2)`
{% /dt %}

{% dd %}
Returns the result of the modulo operator, the remainder after a division operation.**Example**: `MOD(5, 2)`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`POWER(number, power)`
{% /dt %}

{% dd %}
Returns a number raised to a power.**Example**: `POWER(2, 3)`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`ROUND(number, places)`
{% /dt %}

{% dd %}
Rounds a number to a certain number of decimal places.**Example**: `ROUND(826.645, 1)`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`COUNT(value1, [value2, ...])`
{% /dt %}

{% dd %}
Counts the number of numeric values in a range.**Example**: `COUNT(A1:A10)`**Available in**: Sheet
{% /dd %}

{% dt %}
`COUNTA(value1, [value2, ...])`
{% /dt %}

{% dd %}
Counts the number of non-empty values in a range.**Example**: `COUNTA('Logs'#"service")`**Available in**: Sheet
{% /dd %}

{% dt %}
`COUNTBLANK(range)`
{% /dt %}

{% dd %}
Counts the number of empty cells in a range.**Example**: `COUNTBLANK(A1:A10)`**Available in**: Sheet
{% /dd %}

{% dt %}
`COUNTIF(range, criteria)`
{% /dt %}

{% dd %}
Counts the number of cells in a range that meet a specified criteria.**Example**: `COUNTIF('Logs'#"status", "error")`**Available in**: Sheet
{% /dd %}

{% dt %}
`COUNTIFS(range1, criteria1, [range2, criteria2, ...])`
{% /dt %}

{% dd %}
Counts the number of cells in a range that meet multiple criteria.**Example**: `COUNTIFS('Logs'#"status", "error", 'Logs'#"env", "prod")`**Available in**: Sheet
{% /dd %}

{% dt %}
`COUNTUNIQUE(value1, [value2, ...])`
{% /dt %}

{% dd %}
Counts the number of unique values in a range.**Example**: `COUNTUNIQUE('Logs'#"service")`**Available in**: Sheet
{% /dd %}

{% dt %}
`MAX(value1, [value2, ...])`
{% /dt %}

{% dd %}
Returns the largest number from a set of values.**Example**: `MAX('APM'#"duration")`**Available in**: Sheet
{% /dd %}

{% dt %}
`MAXIFS(max_range, range1, criteria1, ...)`
{% /dt %}

{% dd %}
Returns the maximum value in a range that meets multiple criteria.**Example**: `MAXIFS('APM'#"duration", 'APM'#"env", "prod")`**Available in**: Sheet
{% /dd %}

{% dt %}
`MIN(value1, [value2, ...])`
{% /dt %}

{% dd %}
Returns the smallest number from a set of values.**Example**: `MIN('APM'#"duration")`**Available in**: Sheet
{% /dd %}

{% dt %}
`MINIFS(min_range, range1, criteria1, ...)`
{% /dt %}

{% dd %}
Returns the minimum value in a range that meets multiple criteria.**Example**: `MINIFS('APM'#"duration", 'APM'#"env", "prod")`**Available in**: Sheet
{% /dd %}

{% dt %}
`PI()`
{% /dt %}

{% dd %}
Returns the value of π to 15 digits of precision.**Example**: `PI()`**Available in**: Sheet
{% /dd %}

{% dt %}
`RAND()`
{% /dt %}

{% dd %}
Returns a random number between 0 and 1.**Example**: `RAND()`**Available in**: Sheet
{% /dd %}

{% dt %}
`SQRT(number)`
{% /dt %}

{% dd %}
Returns the positive square root of a number.**Example**: `SQRT(16) => 4`**Available in**: Sheet
{% /dd %}

{% dt %}
`SUM(value1, [value2, ...])`
{% /dt %}

{% dd %}
Returns the sum of a series of numbers and/or cells.**Example**: `SUM('Cloud Cost'#"cost")`**Available in**: Sheet
{% /dd %}

{% dt %}
`SUMIF(range, criteria, sum_range)`
{% /dt %}

{% dd %}
Adds the values in a range that meet criteria you specify.**Example**: `SUMIF('Cloud Cost'#"service", "ec2", 'Cloud Cost'#"cost")`**Available in**: Sheet
{% /dd %}

{% dt %}
`SUMIFS(sum_range, range1, criteria1, ...)`
{% /dt %}

{% dd %}
Adds the values in a range that meet multiple criteria.**Example**: `SUMIFS('Cloud Cost'#"cost", 'Cloud Cost'#"service", "ec2", 'Cloud Cost'#"env", "prod")`**Available in**: Sheet
{% /dd %}

{% /dl %}

### Date and time{% #date-and-time %}

{% dl %}

{% dt %}
`DATE(year, month, day)`
{% /dt %}

{% dd %}
Converts a provided year, month, and day into a date.**Example**: `DATE(2021, 10, 31)`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`DATEDIF(start_date, end_date, unit)`
{% /dt %}

{% dd %}
Calculates the number of days, months, or years between two dates.**Example**: `DATEDIF("10/17/1979", "8/22/2019", "Y") => 39`**Available in**: Table, Sheet
{% /dd %}

{% dt %}
`TODAY()`
{% /dt %}

{% dd %}
Returns the current date.**Example**: `TODAY()`**Available in**: Sheet
{% /dd %}

{% dt %}
`NOW()`
{% /dt %}

{% dd %}
Returns the current date and time.**Example**: `NOW()`**Available in**: Sheet
{% /dd %}

{% dt %}
`TIME(hour, minute, second)`
{% /dt %}

{% dd %}
Converts a provided hour, minute, and second into a time.**Example**: `TIME(11, 40, 59)`**Available in**: Sheet
{% /dd %}

{% dt %}
`YEAR(date)`
{% /dt %}

{% dd %}
Extracts the year component from a date value.**Example**: `YEAR(DATE(2025, 12, 31))`**Available in**: Sheet
{% /dd %}

{% dt %}
`MONTH(date)`
{% /dt %}

{% dd %}
Extracts the month component from a date value.**Example**: `MONTH("2023-07-15")`**Available in**: Sheet
{% /dd %}

{% dt %}
`DAY(date)`
{% /dt %}

{% dd %}
Extracts the day component from a date value.**Example**: `DAY(DATE(2023, 12, 25))`**Available in**: Sheet
{% /dd %}

{% dt %}
`HOUR(time)`
{% /dt %}

{% dd %}
Extracts the hour component from a time value.**Example**: `HOUR("14:30:45")`**Available in**: Sheet
{% /dd %}

{% dt %}
`MINUTE(time)`
{% /dt %}

{% dd %}
Extracts the minute component from a time value.**Example**: `MINUTE("14:30:45")`**Available in**: Sheet
{% /dd %}

{% dt %}
`SECOND(time)`
{% /dt %}

{% dd %}
Extracts the second component from a time value.**Example**: `SECOND("14:30:45")`**Available in**: Sheet
{% /dd %}

{% dt %}
`EDATE(start_date, months)`
{% /dt %}

{% dd %}
Returns the date that is the indicated number of months before or after a start date.**Example**: `EDATE("2023-01-15", 6)`**Available in**: Sheet
{% /dd %}

{% dt %}
`EOMONTH(start_date, months)`
{% /dt %}

{% dd %}
Returns the last day of a month that is a specified number of months before or after a given date.**Example**: `EOMONTH(DATE(2023, 12, 12), 0)`**Available in**: Sheet
{% /dd %}

{% dt %}
`WEEKDAY(date, [type])`
{% /dt %}

{% dd %}
Returns the day of the week as a number. Type 1 (default) = Sun–Sat (1–7), type 2 = Mon–Sun (1–7), type 3 = Mon–Sun (0–6).**Example**: `WEEKDAY(DATE(2023, 12, 12))`**Available in**: Sheet
{% /dd %}

{% dt %}
`WEEKNUM(date, [type])`
{% /dt %}

{% dd %}
Returns the week number of a specific date within the year.**Example**: `WEEKNUM("2023-01-15")`**Available in**: Sheet
{% /dd %}

{% /dl %}

### Lookup and reference{% #lookup-and-reference %}

{% dl %}

{% dt %}
`VLOOKUP(search_key, range, index, [is_sorted])`
{% /dt %}

{% dd %}
Searches for a value in the first column of a range and returns a value in the same row from a specified column.**Example**: `VLOOKUP("Apple", A1:C10, 2, FALSE)`**Available in**: Sheet
{% /dd %}

{% dt %}
`HLOOKUP(search_key, range, index, [is_sorted])`
{% /dt %}

{% dd %}
Searches for a value in the first row of a range and returns a value in the same column from a specified row.**Example**: `HLOOKUP("Apple", A1:D3, 2, FALSE)`**Available in**: Sheet
{% /dd %}

{% dt %}
`INDEX(reference, row, [column])`
{% /dt %}

{% dd %}
Returns the value of an element in a table based on row and column numbers.**Example**: `INDEX(A1:D3, 2, 3)`**Available in**: Sheet
{% /dd %}

{% dt %}
`MATCH(search_key, range, [search_type])`
{% /dt %}

{% dd %}
Returns the relative position of an item in an array that matches a specified value.**Example**: `MATCH("Apple", A1:A4, 0)`**Available in**: Sheet
{% /dd %}

{% dt %}
`CHOOSE(index, value1, value2, ...)`
{% /dt %}

{% dd %}
Returns a value from a list based on an index.**Example**: `CHOOSE(2, "A", "B", "C")`**Available in**: Sheet
{% /dd %}

{% dt %}
`ROW([reference])`
{% /dt %}

{% dd %}
Returns the row number of a reference.**Example**: `ROW(A5) => 5`**Available in**: Sheet
{% /dd %}

{% dt %}
`COLUMN([reference])`
{% /dt %}

{% dd %}
Returns the column number of a reference.**Example**: `COLUMN(C1) => 3`**Available in**: Sheet
{% /dd %}

{% /dl %}

### Statistical{% #statistical %}

{% dl %}

{% dt %}
`AVERAGE(value1, [value2, ...])`
{% /dt %}

{% dd %}
Returns the numerical average value in a dataset, ignoring text.**Example**: `AVERAGE('APM'#"duration")`**Available in**: Sheet
{% /dd %}

{% dt %}
`AVERAGEIF(range, criteria, [average_range])`
{% /dt %}

{% dd %}
Returns the average of cells that meet a specified criteria.**Example**: `AVERAGEIF('APM'#"env", "prod", 'APM'#"duration")`**Available in**: Sheet
{% /dd %}

{% dt %}
`AVERAGEIFS(average_range, range1, criteria1, ...)`
{% /dt %}

{% dd %}
Returns the average of cells that meet multiple criteria.**Example**: `AVERAGEIFS('APM'#"duration", 'APM'#"env", "prod", 'APM'#"service", "web")`**Available in**: Sheet
{% /dd %}

{% dt %}
`MEDIAN(value1, [value2, ...])`
{% /dt %}

{% dd %}
Returns the median (middle value) of a dataset. If the dataset has an even number of values, returns the average of the two middle values.**Example**: `MEDIAN('APM'#"duration")`**Available in**: Sheet
{% /dd %}

{% dt %}
`MODE(value1, [value2, ...])`
{% /dt %}

{% dd %}
Returns the most frequently occurring value in a dataset.**Example**: `MODE('Logs'#"status_code")`**Available in**: Sheet
{% /dd %}

{% dt %}
`PERCENTILE(data, percentile)`
{% /dt %}

{% dd %}
Returns the value at a given percentile of a dataset using linear interpolation.**Example**: `PERCENTILE('APM'#"duration", 0.95)`**Available in**: Sheet
{% /dd %}

{% dt %}
`STDEV(value1, [value2, ...])`
{% /dt %}

{% dd %}
Calculates the standard deviation of a sample dataset.**Example**: `STDEV('APM'#"duration")`**Available in**: Sheet
{% /dd %}

{% dt %}
`VAR(value1, [value2, ...])`
{% /dt %}

{% dd %}
Calculates the sample variance of a dataset.**Example**: `VAR('APM'#"duration")`**Available in**: Sheet
{% /dd %}

{% dt %}
`FORECAST(x, data_y, data_x)`
{% /dt %}

{% dd %}
Predicts a future value using existing values and linear regression.**Example**: `FORECAST(5, {1,2,3,4}, {10,20,30,40})`**Available in**: Sheet
{% /dd %}

{% dt %}
`SUMPRODUCT(array1, [array2, ...])`
{% /dt %}

{% dd %}
Multiplies corresponding elements in arrays and returns the sum of those products.**Example**: `SUMPRODUCT({1,2,3}, {4,5,6}) => 32`**Available in**: Sheet
{% /dd %}

{% /dl %}

### Financial{% #financial %}

{% dl %}

{% dt %}
`PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])`
{% /dt %}

{% dd %}
Calculates the payment for a loan based on constant payments and a constant interest rate.**Example**: `PMT(0.05/12, 60, 20000)`**Available in**: Sheet
{% /dd %}

{% dt %}
`PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])`
{% /dt %}

{% dd %}
Calculates the present value of an investment.**Example**: `PV(0.05/12, 60, -377.42)`**Available in**: Sheet
{% /dd %}

{% dt %}
`FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])`
{% /dt %}

{% dd %}
Calculates the future value of an investment based on periodic, constant payments and a constant interest rate.**Example**: `FV(0.06/12, 240, -500)`**Available in**: Sheet
{% /dd %}

{% dt %}
`NPV(discount, cashflow1, [cashflow2, ...])`
{% /dt %}

{% dd %}
Calculates the net present value of an investment based on a discount rate and a series of future cash flows.**Example**: `NPV(0.10, -50000, 8000, 9200, 10400)`**Available in**: Sheet
{% /dd %}

{% dt %}
`IRR(cashflow_amounts, [rate_guess])`
{% /dt %}

{% dd %}
Calculates the internal rate of return for a series of cash flows.**Example**: `IRR({-50000, 8000, 9200, 10400, 11600, 12800})`**Available in**: Sheet
{% /dd %}

{% dt %}
`NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])`
{% /dt %}

{% dd %}
Calculates the number of periods for an investment or loan.**Example**: `NPER(0.05/12, -377.42, 20000)`**Available in**: Sheet
{% /dd %}

{% dt %}
`RATE(number_of_periods, payment_amount, present_value, [future_value], [end_or_beginning], [guess])`
{% /dt %}

{% dd %}
Calculates the interest rate per period of an annuity.**Example**: `RATE(48, -200, 8000)`**Available in**: Sheet
{% /dd %}

{% dt %}
`RRI(number_of_periods, present_value, future_value)`
{% /dt %}

{% dd %}
Calculates the equivalent interest rate for the growth of an investment.**Example**: `RRI(10, 100, 200)`**Available in**: Sheet
{% /dd %}

{% /dl %}

### Info{% #info %}

{% dl %}

{% dt %}
`ISBLANK(value)`
{% /dt %}

{% dd %}
Tests whether a cell is blank.**Example**: `ISBLANK(A1)`**Available in**: Sheet
{% /dd %}

{% dt %}
`ISNUMBER(value)`
{% /dt %}

{% dd %}
Tests whether a value is a number.**Example**: `ISNUMBER(123)`**Available in**: Sheet
{% /dd %}

{% dt %}
`TYPE(value)`
{% /dt %}

{% dd %}
Returns the data type of a value as a number (1 = number, 2 = text, 4 = logical, 16 = error).**Example**: `TYPE(123) => 1`**Available in**: Sheet
{% /dd %}

{% /dl %}