ReoGrid provides the following formula functions that are compatible with Microsoft Excel.

Standard Functions

Statistics

• SUM
• SUMIF
• AVERAGE
• AVERAGEIF
• COUNT
• COUNTA
• COUNTIF
• MIN
• MAX

Conditions

• IF
• AND
• OR
• NOT

Lookup & Reference

• VLOOKUP
• HLOOKUP
• ADDRESS
• CELL
• COLUMN
• INDIRECT
• ROW
• VALUE

Math Calculation

• ABS
• ACOS
• ASIN
• ATAN
• ATAN2
• CEILING
• COS
• EXP
• FLOOR
• LOG
• LOG10
• MOD
• POWER
• ROUND
• SIN
• TAN

Date & Time

• NOW
• TODAY
• TIME
• YEAR
• MONTH
• DAY
• HOUR
• MINUTE
• SECOND
• MILLISECOND
• DAYS

String

• LEFT
• RIGHT
• MID
• UPPER
• LOWER
• LEN
• FIND
• TRIM

System

• ISERROR
• ISNUMBER
• ISBLANK

ReoGrid-specific Functions

The following functions are available only in ReoGrid and are primarily used with conditional styles and data source scenarios.

• COLVAL
• COLVAL_OFFSET
• CIDVAL
• ROWVAL
• ROWVAL_OFFSET

Adding Custom Functions

To add custom functions, see Customize Function.