Excel File Connector Formulas

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

Excel File Connector Overview

Adding the Excel File Connector

Creating a Range Object

Excel File Connector Properties, Events, and Methods

Range Properties and Methods

 


Privacy | Trademarks | Terms of Use | Feedback

Updated: 18 June 2020

© 2016 - 2020 Pegasystems Inc.  Cambridge, MA All rights reserved.

 

OpenSpan data classification label