Report Publisher
Additional Functions

In addition to the four basic arithmetical operations, the Report Publisher add-on provides numerous functions for creating formulas. The functions can be grouped in the following categories:

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

T

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