Mito
Search…
Formula Reference
This documentation lists all of the spreadsheet formulas that you can call within a Mito spreadsheet
Missing a formula? Let us know if your workflow requires formulas that Mito does not yet support. We prioritize adding functionality for active Mito users!

ABS

Returns the absolute value of the passed number or series.

Examples

  • ABS(-1.3)
  • ABS(A)

Syntax

ABS(value)

Syntax Elements

  • value: The value or series to take the absolute value of.

AND

Returns True if all of the provided arguments are True, and False if any of the provided arguments are False.

Examples

  • AND(True, False)
  • AND(Nums > 100, Nums < 200)
  • AND(Pay > 10, Pay < 20, Status == 'active')

Syntax

AND(boolean_condition1, [boolean_condition2, ...])

Syntax Elements

  • boolean_condition1: An expression or series that returns True or False values. See IF documentation for a list of conditons.
  • boolean_condition2 ... [OPTIONAL]: An expression or series that returns True or False values. See IF documentation for a list of conditons.

AVG

Returns the numerical mean value of the passed numbers and series.

Examples

  • AVG(1, 2)
  • AVG(A, B)
  • AVG(A, 2)

Syntax

AVG(value1, [value2, ...])

Syntax Elements

  • value1: The first number or series to consider when calculating the average.
  • value2, ... [OPTIONAL]: Additional numbers or series to consider when calculating the average.

BOOL

Converts the passed arguments to boolean values, either True or False. For numberic values, 0 converts to False while all other values convert to True.

Examples

  • BOOL(Amount_Payed)
  • AND(BOOL(Amount_Payed), Is_Paying)

Syntax

BOOL(series)

Syntax Elements

  • series: An series to convert to boolean values, either True or False.

CLEAN

Returns the text with the non-printable ASCII characters removed.

Examples

  • CLEAN('ABC
    ')

Syntax

CLEAN(string)

Syntax Elements

  • string: The string or series whose non-printable characters are to be removed.

CONCAT

Returns the passed strings and series appended together.

Examples

  • CONCAT('Bite', 'the bullet')
  • CONCAT(A, B)

Syntax

CONCAT(string1, [string2, ...])

Syntax Elements

  • string1: The first string or series.
  • string2, ... [OPTIONAL]: Additional strings or series to append in sequence.

CORR

Computes the correlation between two series, excluding missing values.

Examples

  • =CORR(A, B)
  • =CORR(B, A)

Syntax

CORR(series_one, series_two)

Syntax Elements

  • series_one: The number series to convert to calculate the correlation.
  • series_two: The number series to convert to calculate the correlation.

DATEVALUE

Converts a given string to a date series.

Examples

  • DATEVALUE(A)
  • DATEVALUE('2012-12-22')

Syntax

DATEVALUE(date_string)

Syntax Elements

  • date_string: The date string to turn into a date object.

DAY

Returns the day of the month that a specific date falls on, as a number.

Examples

  • DAY(A)
  • DAY('2012-12-22')

Syntax

DAY(date)

Syntax Elements

  • date: The date or date series to get the day of.

EXP

Returns e, the base of the natural logarithm, raised to the power of passed series.

Examples

  • =EXP(data)
  • =EXP(A)

Syntax

EXP(series)

Syntax Elements

  • series: The series to raise e to.

FILLNAN

Replaces the NaN values in the series with the replacement value.

Examples

  • FILLNAN(A, 10)
  • FILLNAN(A, 'replacement')

Syntax

FILLNAN(series, replacement)

Syntax Elements

  • series: The series to replace the NaN values in.
  • replacement: A string, number, or date to replace the NaNs with.

FIND

Returns the position at which a string is first found within text, case-sensitive. Returns 0 if not found.

Examples

  • FIND(A, 'Jack')
  • FIND('Ben has a friend Jack', 'Jack')

Syntax

FIND(text_to_search, search_for)

Syntax Elements

  • text_to_search: The text or series to search for the first occurrence of search_for.
  • search_for: The string to look for within text_to_search.

IF

Returns one value if the condition is True. Returns the other value if the conditon is False.

Examples

  • IF(Status == 'success', 1, 0)
  • IF(Nums > 100, 100, Nums)
  • IF(AND(Grade >= .6, Status == 'active'), 'pass', 'fail')

Syntax

IF(boolean_condition, value_if_true, value_if_false)

Syntax Elements

  • boolean_condition: An expression or series that returns True or False values. Valid conditions for comparison include ==, !=, >, <, >=, <=.
  • value_if_true: The value the function returns if condition is True.
  • value_if_false: The value the function returns if condition is False.

KURT

Computes the unbiased kurtosis, a measure of tailedness, of a series, excluding missing values.

Examples

  • =KURT(A)
  • =KURT(A * B)

Syntax

KURT(series)

Syntax Elements

  • series: The series to calculate the unbiased kurtosis of.

LEFT

Returns a substring from the beginning of a specified string.

Examples

  • LEFT(A, 2)
  • LEFT('The first character!')

Syntax

LEFT(string, [number_of_characters])

Syntax Elements

  • string: The string or series from which the left portion will be returned.
  • number_of_characters [OPTIONAL, 1 by default]: The number of characters to return from the start of string.

LEN

Returns the length of a string.

Examples

  • LEN(A)
  • LEN('This is 21 characters')

Syntax

LEN(string)

Syntax Elements

  • string: The string or series whose length will be returned.

LOWER

Converts a given string to lowercase.

Examples

  • =LOWER('ABC')
  • =LOWER(A)
  • =LOWER('Nate Rush')

Syntax

LOWER(string)

Syntax Elements

  • string: The string or series to convert to lowercase.

MAX

Returns the maximum value among the passed arguments.

Examples

  • MAX(10, 11)
  • MAX(Old_Data, New_Data)

Syntax

MAX(value1, [value2, ...])

Syntax Elements

  • value1: The first number or column to consider for the maximum value.
  • value2, ... [OPTIONAL]: Additional numbers or columns to compute the maximum value from.

MID

Returns a segment of a string.

Examples

  • MID(A, 2, 2)
  • MID('Some middle characters!', 3, 4)

Syntax

MID(string, starting_at, extract_length)

Syntax Elements

  • string: The string or series to extract the segment from.
  • starting_at: The index from the left of string from which to begin extracting.
  • extract_length: The length of the segment to extract.

MIN

Returns the minimum value among the passed arguments.

Examples

  • MIN(10, 11)
  • MIN(Old_Data, New_Data)

Syntax

MIN(value1, [value2, ...])

Syntax Elements

  • value1: The first number or column to consider for the minumum value.
  • value2, ... [OPTIONAL]: Additional numbers or columns to compute the minumum value from.

MONTH

Returns the month that a specific date falls in, as a number.

Examples

  • MONTH(A)
  • MONTH('2012-12-22')

Syntax

MONTH(date)

Syntax Elements

  • date: The date or date series to get the month of.

MULTIPLY

Returns the product of two numbers.

Examples

  • MULTIPLY(2,3)
  • MULTIPLY(A,3)

Syntax

MULTIPLY(factor1, [factor2, ...])

Syntax Elements

  • factor1: The first number to multiply.
  • factor2, ... [OPTIONAL]: Additional numbers or series to multiply.

OR

Returns True if any of the provided arguments are True, and False if all of the provided arguments are False.

Examples

  • OR(True, False)
  • OR(Status == 'success', Status == 'pass', Status == 'passed')

Syntax

OR(boolean_condition1, [boolean_condition2, ...])

Syntax Elements

  • boolean_condition1: An expression or series that returns True or False values. See IF documentation for a list of conditons.
  • boolean_condition2 ... [OPTIONAL]: An expression or series that returns True or False values. See IF documentation for a list of conditons.

POWER

The POWER function can be used to raise a number to a given power.

Examples

  • POWER(4, 1/2)
  • POWER(Dose, 2)

Syntax

POWER(value, exponent)

Syntax Elements

  • value: Number to raise to a power.
  • exponent: The number to raise value to.

PROPER

Capitalizes the first letter of each word in a specified string.

Examples

  • =PROPER('nate nush')
  • =PROPER(A)

Syntax

PROPER(string)

Syntax Elements

  • string: The value or series to convert to convert to proper case.

RIGHT

Returns a substring from the beginning of a specified string.

Examples

  • RIGHT(A, 2)
  • RIGHT('The last character!')

Syntax

RIGHT(string, [number_of_characters])

Syntax Elements

  • string: The string or series from which the right portion will be returned.
  • number_of_characters [OPTIONAL, 1 by default]: The number of characters to return from the end of string.

ROUND

Rounds a number to a given number of decimals.

Examples

  • ROUND(1.3)
  • ROUND(A, 2)

Syntax

ROUND(value, [decimals])

Syntax Elements

  • value: The value or series to round.
  • decimals: The number of decimals to round to. Default is 0.

SKEW

Computes the skew of a series, excluding missing values.

Examples

  • =SKEW(A)
  • =SKEW(A * B)

Syntax

SKEW(series)

Syntax Elements

  • series: The series to calculate the skew of.

STDEV

Computes the standard deviation of a series, excluding missing values.

Examples

  • =STDEV(A)
  • =STDEV(A * B)

Syntax

STDEV(series)

Syntax Elements

  • series: The series to calculate the standard deviation of.

SUBSTITUTE

Replaces existing text with new text in a string.

Examples

  • SUBSTITUTE('Better great than never', 'great', 'late')
  • SUBSTITUTE(A, 'dog', 'cat')

Syntax

SUBSTITUTE(text_to_search, search_for, replace_with, [count])

Syntax Elements

  • text_to_search: The text within which to search and replace.
  • search_for: The string to search for within text_to_search.
  • replace_with: The string that will replace search_for.
  • count: The number of times to perform the substitute. Default is all.

SUM

Returns the sum of the given numbers and series.

Examples

  • SUM(10, 11)
  • SUM(A, B, D, F)
  • SUM(A, B, D, F)

Syntax

SUM(value1, [value2, ...])

Syntax Elements

  • value1: The first number or column to add together.
  • value2, ... [OPTIONAL]: Additional numbers or columns to sum.

TEXT

Turns the passed series into a string.

Examples

  • =TEXT(Product_Number)
  • =TEXT(Start_Date)

Syntax

TEXT(series)

Syntax Elements

  • series: The series to convert to a string.

TRIM

Returns a string with the leading and trailing whitespace removed.

Examples

  • =TRIM(' ABC')
  • =TRIM(' ABC ')
  • =TRIM(A)

Syntax

TRIM(string)

Syntax Elements

  • string: The value or series to remove the leading and trailing whitespace from.

TYPE

Returns the type of each element of the passed series. Return values are 'number', 'str', 'bool', 'datetime', 'object', or 'NaN'.

Examples

  • TYPE(Nums_and_Strings)
  • IF(TYPE(Account_Numbers) != 'NaN', Account_Numbers, 0)

Syntax

TYPE(series)

Syntax Elements

  • series: The series to get the type of each element of.

UPPER

Converts a given string to uppercase.

Examples

  • =UPPER('abc')
  • =UPPER(A)
  • =UPPER('Nate Rush')

Syntax

UPPER(string)

Syntax Elements

  • string: The string or series to convert to uppercase.

VALUE

Converts a string series to a number series. Any values that fail to convert will return an NaN.

Examples

  • =VALUE(A)
  • =VALUE('123')

Syntax

VALUE(string)

Syntax Elements

  • string: The string or series to convert to a number.

VAR

Computes the variance of a series, excluding missing values.

Examples

  • =VAR(A)
  • =VAR(A - B)

Syntax

VAR(series)

Syntax Elements

  • series: The series to calculate the variance of.

WEEKDAY

Returns the day of the week that a specific date falls on. 1-7 corresponds to Monday-Sunday.

Examples

  • WEEKDAY(A)
  • WEEKDAY('2012-12-22')

Syntax

WEEKDAY(date)

Syntax Elements

  • date: The date or date series to get the weekday of.

YEAR

Returns the day of the year that a specific date falls in, as a number.

Examples

  • YEAR(A)
  • YEAR('2012-12-22')

Syntax

YEAR(date)

Syntax Elements

  • date: The date or date series to get the month of.
Missing a formula? Let us know if your workflow requires formulas that Mito does not yet support. We prioritize adding functionality for active Mito users!
Last modified 11h ago