There are a lot of built-in functions supported by Aspose.Grid. These functions belong to following categories:

• Math Functions, provides a huge set of functions that can be used in numerous mathematical calculations
• Text and Data Functions, provides various functions to perform different kinds of operations on text and data
• Date and Time Functions, provides some useful functions related to data and time
• Logical Functions, provides a small set of logical functions to handle some logical operation on data

 

Math Functions

ABS,ACOS,ACOSH,ASIN,ASINH,ATAN,ATAN2,ATANH,AVERAGE

CEILING,COMBIN,COS,COSH,COUNTIF

DEGREES

EVEN,EXP

FACT,FLOOR

INT

LN,LOG,LOG10

MOD

ODD

PI,POWER,PRODUCT

RADIANS,RAND,ROUND,ROUNDDOWN,ROUNDUP

SIGN,SIN,SINH

SQRT,SUM,SUMIF,SUMPRODUCT,SUMSQ,SUMX2MY2,SUMX2PY2,SUMXMY2

TAN,TANH,TRUNC

 

Text and Data Functions

ASC

CHAR,CODE,CONCATENATE

DOLLAR

EXACT

FIND,FIXED

LEFT,LEN,LOWER

MID

REPLACE,REPT,RIGHT

SEARCH,SUBSTITUTE

T,TEXT,TRIM

UPPER

VALUE

WIDECHAR

 

Date and Time Functions

DATE,DAY

HOUR

MINUTE,MONTH

NOW

SECOND

TIME,TODAY

WEEKDAY

YEAR

 

Logical Functions

AND

FALSE

IF

NOT

OR

TRUE