Excel-Compatible Functions

Name Description
SUM Returns the sum of a set of values contained in a specified field on a query.
AVERAGE Returns the average (arithmetic mean) of the arguments.
COUNT Counts the number of cells that contain numbers, and counts numbers within the list of arguments.
CEILING Returns number rounded up, away from zero, to the nearest multiple of significance.
ROUND Round a number to the nearest number.
ROW Returns the number of rows in a reference or array.
COLUMN Returns the number of columns in an array or reference.
ADDRESS Returns the address of a cell in a worksheet.
INDIRECT Returns the reference specified by a text string.

Extended functions only be supported by ReoGrid

Name Description
RANGE Return a range reference by specified number

The more functions will be available in the future version, if you need some functions that is not supported in current version, tell us or post an issue for it.

Return to Formula

Last edited Apr 22, 2014 at 12:08 AM by unvell, version 7