Spreadsheet Formula Reference

Formulas are equations that perform calculations on values in your worksheet. A formula starts with an equal sign (=). Jotspot Spreadsheets supports the following formulas and operators:

Functions
A number-type is an integer, float, exponential, or dollar value
`average(num1, num2...)`	Returns the average (arithmetic mean) of the cells or range of cells
`averagea(num1, num2...)`	Returns the average (arithmetic mean) of all non-empty cells or range of cells
`count(value1, value2...)`	Returns a count of number-type cells in the range
`counta(value1, value2...)`	Returns a count of non-empty number-type cells in the range
`min(number1, number2...)`	Returns the lowest number value in the range of cells
`max(number1, number2...)`	Returns the highest number value in the range of cells
`sum(number1, number2...)`	Returns the sum cells in the range
`product(number1, number2...)`	Returns the multiplication of all number-type cells in the range
`if(logical_test, value_if_true, value_if_false)`	Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.
`lookup(lookup_value, lookup_list, optional_return_list)`	Returns a value from lookup_list that is less than or equal to lookup_value. If optional_return_list is provided, the forumla returns the value at the same index as lookup_value is in lookup_list.

Formula Operators
`:`	Identify a range of cells (e.g., A1:B6)
`space`	Intersection
`-`	Negation
`%`	Percentage
`^`	Exponentiation
`*` or `/`	Multiplication and division
`+` or `-`	Addition and subtraction
`&`	Text operator
`=` `<` `>` `<=` `>=` `<>`	Comparisons
`,`	Union