home.gif next.gif disprev.gif



A-Z Spreadsheet Function Reference


The following is a complete alphabetical reference for the functions that can be used within the cells of the TPA Spreadsheet

ABS

INDEX

PROPER

ACOS

INDIRECT

PV

ACOSH

INT

RAND

ADDRESS

IPMT

RATE

AND

IRR

REPLACE

ASIN

ISBLANK

REPT

ASINH

ISERR

RIGHT

ATAN

ISERROR

ROUND

ATAN2

ISLOGICAL

ROW

ATANH

ISNA

ROWS

AVERAGE

ISNONTEXT

SEARCH

CALL

ISNUMBER

SECOND

CEILING

ISREF

SIGN

CHAR

ISTEXT

SIN

CHOOSE

LEFT

SINH

CLEAN

LEN

SLN

CODE

LN

SQRT

COLUMN

LOG

STDEV

COLUMNS

LOG10

STDEVP

COS

LOOKUP

SUBSTITUTE

COSH

LOWER

SUM

COUNT

MATCH

SUMSQ

COUNTA

MAX

SYD

DATE

MID

T

DATEVALUE

MIN

TAN

DAY

MINUTE

TANH

DB

MIRR

TEXT

DDB

MOD

TIME

DOLLAR

MONTH

TIMEVALUE

ERROR.TYPE

N

TODAY

EVEN

NA

TRIM

EXACT

NOT

TRUE

EXP

NOW

TRUNC

FACT

NPER

TYPE

FALSE

NPV

UPPER

FIND

ODD

VALUE

FIXED

OFFSET

VAR

FLOOR

OR

VARP

FV

PI

VDB

HLOOKUP

PMT

VLOOKUP

HOUR

PPMT

WEEKDAY

IF

PRODUCT

YEAR