Excel-Compatible Functions

ReoGrid provides the following built-in functions that is compatible with Microsoft Excel. To learn about Excel format compatibility, see Excel file format.

Standard Built-in Functions

Statistics

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

Conditions

  • IF
  • AND
  • OR
  • NOT

Address

  • ADDRESS
  • COLUMN
  • INDIRECT
  • ROW
  • VLOOKUP

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

Add customize function

To add customize functions, see Customize function.


Return to Excel file format