The following describe the formula functions that are available in Diamond Grid.

Math Functions

ABS ACOS ACOSH ASIN ASINH ATAN ATAN2 ATANH CEILING COMBIN COS

COSH DEGREES EVEN EXP FACT FLOOR INT LN LOG LOG10 MOD

ODD PI POWER PRODUCT QUOTIENT RADIANS RAND RANDBETWEEN ROUND ROUNDDOWN ROUNDUP

SIGN SIN SINH SQRT SUBTOTAL SUM SUMPRODUCT SUMSQ TAN TANH TRUNC

Financial Functions

DB DDB

FV NPER

PMT PV

SLN SYD

Miscellaneous Functions

COUNTBLANK ISBLANK ISEVEN ISLOGICAL ISNONTEXT ISNUMBER

ISODD ISREF ISTEXT N TYPE

AND FALSE IF NOT OR TRUE

Statistical Functions

AVERAGE COUNT COUNTA

MAX MEDIAN MIN

PERMUT RANK STDEV

STDEVP VAR VARP

Text Functions

CHAR CLEAN CODE CONCATENATE DOLLAR EXACT

FIND FIXED LEFT LEN LOWER MID

PROPER REPLACE REPT RIGHT SUBSTITUTE T

TEXT TRIM UPPER VALUE

Date Functions

DATE DATEDIF DATEVALUE DAY

HOUR MINUTE MONTH NOW

SECOND TIME TIMEVALUE TODAY

WEEKDAY WEEKNUM YEAR

Functions in alphabetical order

ABS ACOS ACOSH AND ASIN ASINH ATAN ATAN2 ATANH AVERAGE CEILING CHAR CLEAN CODE COMBIN CONCATENATE COS COSH COUNT COUNTA COUNTBLANK

DATE DATEDIF DATEVALUE DAY DB DDB DEGREES DOLLAR EVEN EXACT EXP FACT FALSE FIND FIXED FLOOR FV HOUR IF INT

ISBLANK ISEVEN ISLOGICAL ISNONTEXT ISNUMBER ISODD ISREF ISTEXT LEFT LEN LN LOG LOG10 LOWER MAX MEDIAN MID MIN MINUTE MOD

MONTH N NOT NOW NPER ODD OR PERMUT PI PMT POWER PRODUCT PROPER PV QUOTIENT RADIANS RAND RANDBETWEEN RANK

REPLACE REPT RIGHT ROUND ROUNDDOWN ROUNDUP SECOND SIGN SIN SINH SLN SQRT STDEV STDEVP SUBSTITUTE SUBTOTAL SUM SUMPRODUCT SUMSQ

SYD T TAN TANH TEXT TIME TIMEVALUE TODAY TRIM TRUE TRUNC TYPE UPPER VALUE VAR VARP WEEKDAY WEEKNUM YEAR

Copyright 2003-2005 Diamond Edge, Inc. All rights reserved.