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