ReoGrid provides the following built-in formula functions that are compatible with Microsoft Excel.
Statistics
| Function | Description |
|---|
SUM(range) | Sum of all values in a range |
SUMIF(range, criteria, [sum_range]) | Sum values that meet a condition |
AVERAGE(range) | Average of all values in a range |
AVERAGEIF(range, criteria, [avg_range]) | Average of values that meet a condition |
COUNT(range) | Count of numeric values in a range |
COUNTA(range) | Count of non-empty cells in a range |
COUNTIF(range, criteria) | Count of cells that meet a condition |
MIN(range) | Minimum value in a range |
MAX(range) | Maximum value in a range |
Conditions
| Function | Description |
|---|
IF(condition, true_value, false_value) | Return value based on condition |
AND(value1, value2, ...) | True if all arguments are true |
OR(value1, value2, ...) | True if any argument is true |
NOT(value) | Reverse a boolean value |
Lookup & Reference
| Function | Description |
|---|
VLOOKUP(value, range, col, [exact]) | Vertical lookup in a table |
HLOOKUP(value, range, row, [exact]) | Horizontal lookup in a table |
XLOOKUP(value, lookup_range, return_range) | Extended lookup (flexible search) |
MATCH(value, range, [match_type]) | Find position of a value in a range |
XMATCH(value, range) | Extended match |
ADDRESS(row, col, [abs_type]) | Create a cell address string |
INDIRECT(address) | Reference a cell by address string |
ROW([cell]) | Row number of a cell |
COLUMN([cell]) | Column number of a cell |
CELL(info, [cell]) | Information about a cell |
VALUE(text) | Convert text to a number |
See VLOOKUP for a detailed VLOOKUP tutorial.
Math
| Function | Description |
|---|
ABS(number) | Absolute value |
ROUND(number, digits) | Round to specified decimal places |
CEILING(number, significance) | Round up to nearest multiple |
FLOOR(number, significance) | Round down to nearest multiple |
MOD(number, divisor) | Remainder of division |
POWER(base, exponent) | Number raised to a power |
EXP(number) | e raised to a power |
LOG(number, [base]) | Logarithm |
LOG10(number) | Base-10 logarithm |
SIN(radians) | Sine |
COS(radians) | Cosine |
TAN(radians) | Tangent |
ASIN(number) | Arcsine |
ACOS(number) | Arccosine |
ATAN(number) | Arctangent |
ATAN2(x, y) | Arctangent of x/y |
Date & Time
| Function | Description |
|---|
NOW() | Current date and time |
TODAY() | Current date |
TIME(hour, minute, second) | Create a time value |
YEAR(date) | Year from a date |
MONTH(date) | Month from a date |
DAY(date) | Day from a date |
HOUR(time) | Hour from a time |
MINUTE(time) | Minute from a time |
SECOND(time) | Second from a time |
MILLISECOND(time) | Millisecond from a time |
DAYS(end_date, start_date) | Number of days between two dates |
String
| Function | Description |
|---|
LEFT(text, count) | Leftmost characters |
RIGHT(text, count) | Rightmost characters |
MID(text, start, count) | Substring from a position |
UPPER(text) | Convert to uppercase |
LOWER(text) | Convert to lowercase |
LEN(text) | Length of text |
FIND(find_text, within_text, [start]) | Find text position |
TRIM(text) | Remove leading/trailing spaces |
Error Checking
| Function | Description |
|---|
ISERROR(value) | True if value is an error |
ISNUMBER(value) | True if value is a number |
ISBLANK(cell) | True if cell is empty |
ReoGrid-Specific Functions
These functions are available only in ReoGrid, primarily used with conditional styles and data source scenarios:
| Function | Description |
|---|
COLVAL(column) | Get value from a column in the current data source row |
COLVAL_OFFSET(column, offset) | Get value from a column with offset |
CIDVAL(column_id) | Get value by column identifier |
ROWVAL(row) | Get value from a row |
ROWVAL_OFFSET(row, offset) | Get value from a row with offset |
Localization
ReoGrid supports localized function names. Use FormulaExtension to switch:
// Use standard English function names (default)
FormulaExtension.ChangeToStandardFunctionNames();
// Use Russian function names
FormulaExtension.ChangeToRussianFunctionNames();
Custom Functions
To add custom functions, see Custom Function.
