The Excel File Connector includes support for the following formulas:
ABS |
ACOS |
ACOSH |
ACOTH |
ADDRESS |
AND |
ASIN |
ASINH |
ATAN |
ATAN2 |
ATANH |
AVEDEV |
AVERAGE |
AVERAGEA |
CEILING |
CHAR |
CHOOSE |
CLEAN |
CODE |
COLUMN |
COMBIN |
CONCATENANTE |
COS |
COSH |
COT |
COTH |
COUNT |
COUNTA |
DATE |
DATEDIF |
DATEVALUE |
DAY |
DAYS |
DEGREES |
EOMONTH |
EVEN |
EXACT |
EXP |
FACT |
FALSE |
FIND |
FIXED |
FLOOR |
HLOOKUP |
HOUR |
IF |
IFERROR |
INDEX |
INDIRECT |
INT |
IRR |
ISBLANK |
ISERR |
ISERROR |
ISEVEN |
ISFORMULA |
ISLOGICAL |
ISNA |
ISNONTEXT |
ISNUMBER |
ISODD |
ISREF |
ISTEXT |
LEFT |
LEN |
LN |
LOG |
LOG10 |
LOOKUP |
LOWER |
MATCH |
MAX |
MAXA |
MID |
MIN |
MINA |
MINUTE |
MEDIAN |
MOD |
MODE |
MONTH |
N |
NA |
NORMSDIST |
NOT |
NOW |
NPV |
ODD |
OR |
PI |
PMT |
POWER |
PRODUCT |
RADIANS |
RAND |
RANDBETWEEN |
RANK.AVG |
RANK.EQ |
RATE |
REPLACE |
REPT |
RIGHT |
ROUND |
ROUNDDOWN |
ROUNDUP |
ROW |
SECOND |
SIGN |
SIN |
SINH |
SQRT |
STDEV |
STDEVA |
STDEVP |
STDEVPA |
SUBSTITUTE |
SUBTOTAL |
SUM |
SUMPRODUCT |
T |
TAN |
TANH |
TEXT |
TIME |
TIMEVALUE |
TODAY |
TRIM |
TRUE |
TRUNC |
TYPE |
UPPER |
VALUE |
VAR |
VARA |
VARP |
VARPA |
VLOOKUP |
WEEKDAY |
XIRR |
YEAR |
YEARFRAC |
|
|
|
|
|
|
|
|
|
Related information
Adding the Excel File Connector
Excel File Connector Properties, Events, and Methods
Privacy | Trademarks | Terms of Use | Feedback
Updated: 01 July 2024
© 2016 - 2024 Pegasystems Inc. Cambridge, MA All rights reserved.