ReoGrid provides the following formula functions that are compatible with Microsoft Excel.
Standard Functions
Statistics
- SUM
- SUMIF
- AVERAGE
- AVERAGEIF
- COUNT
- COUNTIF
- MIN
- MAX
Conditions
- IF
- AND
- OR
- NOT
Logical
Address
- ADDRESS
- COLUMN
- INDIRECT
- ROW
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
Adding Custom Function
To add customize functions, see Customize function.