Functions

Learn how to build datasets in Convert_

PMT calculates the periodic payment for a loan with fixed installments and a constant interest rate.

REGEXMATCH

This article explains how to use the REGEXMATCH() function

COUPON

This article explains how to use COUPON function

FILTER

MAP

TABLESORT

The TABLESORT function in Excel allows you to sort a Table or Datasheet based on a column

INDEX

The INDEX function is a versatile function that allows you to return a value from a table or range based on the row and column numbers you specify.

CONVERTCURRENCY

This article explains how to convert currencies in your functions

IFS

This article explains how to use the IFS function

CONVERT

FormulaScript

DISTANCE

This article explains how to use our unique DISTANCE functions in combination with the Place element

FINDMANY & FINDFIRST

Learn how to use the FINDMANY and FINDFIRST functions

Table Functions

This article explains how to use our unique table functions.

CHOOSE

This article explains how to use the CHOOSE function

DATEDIF

This article explains how to use the DATEDIF() function

TEXT

This article explains how to use the TEXT()-function.

SUMIFS

This article explains how to use SUMIFS functions

FINDIFS

This article explains how to use the FINDIFS function

HLOOKUP

This article explains how to use the HLOOKUP function

VLOOKUP

This article explains how to use the VLOOKUP function

GOOGLESHEET

This article explains how to use GOOGLESHEET functions

OR

This article explains how to use the OR function

AND

This article explains how to use the AND function

IF

This article explains how to use IF() functions

Supported functions