Formula Functions

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.


Was the content of the page helpful?