Additional Functions

The Report Publisher is an add-on module to the Chromeleon software and provides numerous additional functions for creating user-defined formulas in the Printer Layout. For more information about the formulas, select Additional Functions in the index of the Chromeleon online Help.

For an application example, refer to How to …: Creating and Using Report Tables  Entering User-defined Formulas.

For an overview of the available functions, refer to the following lists:

Date and Time

DATE

DATEVALUE

DAY

DAYS360

HOUR

MINUTE

MONTH

NOW

SECOND

TIME

TIMEVALUE

TODAY

WEEKDAY

YEAR

 

 

Mathematics and Trigonometry

ABS

ACOS

ACOSH

ASIN

ASINH

ATAN

ATAN2

ATANH

CEILING

COS

COSH

EVEN

EXP

FACT

FLOOR

INT

LN

LOG

LOG10

MOD

ODD

PI

PRODUCT

RAND

ROUND

ROUNDDOWN

ROUNDUP

SIN

SINH

SQRT

SIGN

SUM

SUMIF

SUMSQ

TAN

TANH

 

Statistics

AVERAGE

COUNT

COUNTA

COUNTIF

MAX

MIN

STDEV

STDEVP

VAR

VARP

 

 

Addressing

ADDRESS

COLUMN

COLUMNS

HLOOKUP

INDEX

INDIRECT

LOOKUP

MATCH

OFFSET

ROW

ROWS

VLOOKUP

 

Text

ASC

CHAR

CLEAN

CODE

CONCATENATE

DBCS

EXACT

FIND

FINDB

FIXED

LEFT

LEFTB

LEN

LENB

LOWER

MID

MIDB

PROPER

REPLACE

REPLACEB

REPT

RIGHT

RIGHTB

SEARCH

SEARCHB

SUBSTITUTE

A

TEXT

TRIM

TRUNC

UPPER

VALUE

 

 

Logic

AND

FALSE

IF

NOT

OR

 

TRUE

 

Information

CHOOSE

ERROR.TYPE

ISBLANK

ISERR

ISERROR

ISLOGICAL

ISNA

ISNONTEXT

ISNUMBER

ISREF

ISTEXT

N

NA

TYPE