Quattro Pro Functions Equivalents
Most spreadsheet functions exist in both Microsoft Excel and Quattro Pro using the same name.
However, some Excel functions have a corresponding Quattro Pro function with a different name. The following table outlines these equivalent functions.
|
Excel function
|
QP equivalent
|
|
ACCRINT
|
ACCRINTXL
|
|
AVERAGE
|
AVG
|
|
COLUMNS
|
COLS
|
|
COMBIN
|
COMB
|
|
COUNTA
|
XCOUNT
|
|
FREQUENCY
|
FREQDIST
|
|
INT
|
INTXL
|
|
ISTEXT
|
ISSTRING
|
|
LEN
|
LENGTH
|
|
LOG
|
LOGBASE
|
|
LOG10
|
LOG
|
|
MDETERM
|
MDET
|
|
REPT
|
REPEAT
|
|
ROUNDDOWN
|
ROUNDDOWNXL
|
|
ROUNDUP
|
ROUNDUPXL
|
|
SMALL
|
SMALLEST
|
|
STDEV
|
STDS
|
|
STDEVP
|
STD
|
|
VAR
|
VARS
|
|
VARP
|
VAR
|
Quattro Pro Functions Equivalents