Excel Functions Supported in Smart Forms

Several Excel functions are supported in Smart Forms.

Excel Functions Supported in Smart Forms in Alphabetic Order

Table 12-1 Alphabetical List of Excel Functions Supported in Smart Forms

Function Category
ABS Math and trigonometry
ACCRINT Financial
ACCRINTM Financial
ACOS Math and trigonometry
ACOSH Math and trigonometry
AMORDEGRC Financial
AMORLINC Financial
AND Logical
ASIN Math and trigonometry
ASINH Math and trigonometry
ATAN Math and trigonometry
ATAN2 Math and trigonometry
ATANH Math and trigonometry
AVERAGE Statistical
AVERAGEA Statistical
CEILING Math and trigonometry
COMBIN Math and trigonometry
COS Math and trigonometry
COSH Math and trigonometry
COUNT Statistical
COUNTA Statistical
COUPDAYBS Financial
COUPDAYS Financial
COUPDAYSNC Financial
COUPNCD Financial
COUPNUM Financial
COUPPCD Financial
CUMIPMT Financial
CUMPRINC Financial
DATE Date and time
DAY Date and time
DAYS360 Date and time
DB Financial
DDB Financial
DEGREES Math and trigonometry
DISC Financial
DOLLARDE Financial
DOLLARFR Financial
DURATION Financial
EDATE Date and time
EFFECT Financial
EOMONTH Date and time
EVEN Math and trigonometry
EXP Math and trigonometry
FACT Math and trigonometry
FACTDOUBLE Math and trigonometry
FLOOR Math and trigonometry
FV Financial
FVSCHEDULE *** Financial
GCD Math and trigonometry
HOUR Date and time
IF Logical
IFERROR Logical
- TRUE Logical
- FALSE Logical
INT Math and trigonometry
INTRATE Financial
IPMT Financial
IRR Financial
ISERR Information
ISERROR Information
ISPMT Financial
LCM Math and trigonometry
LEFT Text
LN Math and trigonometry
LOG Math and trigonometry
LOG10 Math and trigonometry
MAX Statistical
MDURATION Financial
MID Text
MIN Statistical
MINUTE Date and time
MIRR Financial
MOD Math and trigonometry
MONTH Date and time
MROUND Math and trigonometry
MULTINOMIAL Math and trigonometry
NETWORKDAYS Date and time
NOMINAL Financial
NOT Logical
NOW Date and time
NPER Financial
NPV Financial
ODD Math and trigonometry
OR Logical
PI Math and trigonometry
PMT Financial
POWER Math and trigonometry
PPMT Financial
PRICE Financial
PRICEDISC Financial
PRICEMAT Financial
PRODUCT Math and trigonometry
PV Financial
QUOTIENT Math and trigonometry
RADIANS Math and trigonometry
RAND Math and trigonometry
RANDBETWEEN Math and trigonometry
RATE Financial
RECEIVED Financial
RIGHT Text
ROUND Math and trigonometry
ROUNDDOWN Math and trigonometry
ROUNDUP Math and trigonometry
SECOND Date and time
SIGN Math and trigonometry
SIN Math and trigonometry
SINH Math and trigonometry
SLN Financial
SQRT Math and trigonometry
SQRTPI Math and trigonometry
SUM Math and trigonometry
SUMSQ Math and trigonometry
SYD Financial
TAN Math and trigonometry
TANH Math and trigonometry
TBILLEQ Financial
TBILLPRICE Financial
TBILLYIELD Financial
TIME Date and time
TODAY Date and time
TRUNC Math and trigonometry
WEEKDAY Date and time
WEEKNUM Date and time
WORKDAY Date and time
XIRR Financial
XNPV Financial
YEAR Date and time
YEARFRAC Date and time
YIELD Financial
YIELDDISC Financial
YIELDMAT Financial

***When using the FVSCHEDULE function in Smart Forms, use cell references to existing data, rather than arrays of data. For example, use =FVSCHEDULE(C10,B15:B17). Do not use =FVSCHEDULE(C10,{0.09,0.11,0.1}).

Excel Functions Supported in Smart Forms by Category

Financial Functions

ACCRINT

ACCRINTM

AMORDEGRC

AMORLINC

COUPDAYBS

COUPDAYS

COUPDAYSNC

COUPNCD

COUPNUM

COUPPCD

CUMIPMT

CUMPRINC

DB

DDB

DISC

DOLLARDE

DOLLARFR

DURATION

EFFECT

FV

FVSCHEDULE ***

INTRATE

IPMT

IRR

ISPMT

MDURATION

MIRR

NOMINAL

NPER

NPV

PMT

PPMT

PRICE

PRICEDISC

PRICEMAT

PV

RATE

RECEIVED

SLN

SYD

TBILLEQ

TBILLPRICE

TBILLYIELD

XIRR

XNPV

YIELD

YIELDDISC

YIELDMAT

***When using the FVSCHEDULE function in Smart Forms, use cell references to existing data, rather than arrays of data. For example, use =FVSCHEDULE(C10,B15:B17). Do not use =FVSCHEDULE(C10,{0.09,0.11,0.1}).

Information Functions

ISERR

ISERROR

Logical Functions

AND

IF

NOT

OR

IFERROR

  • TRUE

  • FALSE

Statistical Functions

AVERAG

AVERAGEA

COUNT

COUNTA

MAX

MIN

Text Functions

LEFT

RIGHT

MID

Date and Time Functions

DATE

DAY

DAYS360

EDATE

EOMONTH

HOUR

MINUTE

MONTH

NETWORKDAYS

NOW

SECOND

TIME

TODAY

WEEKDAY

WEEKNUM

WORKDAY

YEAR

YEARFRAC

Math and Trigonometry Functions

ABS

ACOS

ACOSH

ASIN

ASINH

ATAN

ATAN2

ATANH

CEILING

COMBIN

COS

COSH

DEGREES

EVEN

EXP

FACT

FACTDOUBLE

FLOOR

GCD

INT

LCM

LN

LOG

LOG10

MOD

MROUND

MULTINOMIAL

ODD

PI

POWER

PRODUCT

QUOTIENT

RADIANS

RAND

RANDBETWEEN

ROUND

ROUNDDOWN

ROUNDUP

SIGN

SIN

SINH

SQRT

SQRTPI

SUM

TAN

TANH

TRUNC