View source for Excel to Analytica Mappings

This page provides mappings from functions found in Excel to the equivalent method in Analytica.

= [[Excel to Analytica Mappings/Database Functions|Database Functions]] =

Includes these functions:
DAVERAGE
DCUONT
DCOUNTA
DGET
DMAX
DMIN
DPRODUCT
DSTDEV
DSTDEVP
DSUM
DVAR
DVARP

= [[Excel to Analytica Mappings/Date and Time Functions|Date and Time Functions]] =

Includes these functions:

DATE
DATEVALUE
DAY
DAYS360
EDATE
EOMONTH
HOUR
MINUTE
MONTH
NETWORKDAYS
NOW
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WORKDAY
YEAR
YEARFRAC

= [[Excel to Analytica Mappings/Engineering Functions|Engineering Functions]] =

Includes these functions:

BESSELI 
BESSELJ 
BESSELK
BESSELY
BIN2DEC
BIN2HEX
BIN2OCT
COMPLEX
CONVERT
DEC2BIN
DEC2HEX
DEC2OCT
DELTA
ERF
ERFC
GESTEP
HEX2BIN
IMABS
IMAGINARY
IMARGUMENT
IMCONJUGATE
IMCOS
IMDIV
IMEXP
IMLN
IMLOG10
IMLOG2
IMPOWER
IMPRODUCT
IMREAL
IMSIN
IMSQRT
IMSUB
IMSUM
OCT2BIN
OCT2DEC
OCT2HEX

= [[Excel to Analytica Mappings/Financial Functions|Financial Functions]] =

Includes these functions:

ACCRINT
ACCRINTM
AMORDEGRC
AMORLINC
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
CUMIPMT
CUMPRINC
DB
DDB
DISC
DOLLARDE
DOLLARFR
DURATION
EFFECT
FV
FVSCHEDULE
INTRATE
IMPT
IRR
ISPMT
MDURATION
MIRR
NOMINAL
NPER
NPV
ODDFPRICE
ODDFYEILD
ODDLPRICE
ODDLYIELD
PMT
PPMT
PRICE
PRICEDISC
PRICEMAT
PV
RATE
RECEIVED
SLN
SYD
TBILLEQ
TBILLPRICE
TBILLYIELD
VDB
XIRR
XNPV
YIELD
YIELDDISC
YIELDMAT

= [[Excel to Analytica Mappings/Information Functions|Information Functions]] =

Includes these functions:

CELL
ERROR.TYPE
INFO
ISBLANK
ISERR
ISERROR
ISEVEN
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISREF
ISTEXT
N
NA
TYPE

= [[Excel to Analytica Mappings/Logical Functions|Logical Functions]] =

AND
FALSE
IF
NOT
OR
TRUE

= [[Excel to Analytica Mappings/Lookup Functions|Lookup Functions]] =

INDEX
ADDRESS
AREAS
CHOOSE
COLUMN
COLUMNS
GETPIVOTDATA
HLOOKUP
HYPERLINK
INDEX
INDIRECT
LOOKUP
MATCH
OFFSET
ROW
ROWS
RTD
TRANSPOSE
VLOOKUP

= [[Excel to Analytica Mappings/Math Functions|Math 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
MDETERM
MINVERSE
MMULT
MOD
MROUND
MULTINOMIAL
ODD
PI
POWER
PRODUCT
QUOTIENT
RADIANS
RAND
RANDBETWEEN
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SERIESSUM
SIGN
SIG
SINH
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
TAN
TANH
TRUNC

= [[Excel to Analytica Mappings/Statistical Functions|Statistical Functions]] =

AVEDEV
AVERAGE
AVERAGEA
BETADIST
BETAINV
BINOMDIST
CHIDIST
CHIINV
CHITEST
CONFIDENCE
CORREL
COUNT
COUNTA
COUNTBLANK
COUNTIF
COVAR
CRITBINOM
DEVSQ
EXPONDIST
FDIST
FINV
FISHER
FISHERINV
FORECAST
FREQUENCY
FTEST
GAMMADIST
GAMMAINV
GAMMALN
GEOMEAN
GROWTH
HARMEAN
HYPGEOMDIST
INTERCEPT
KURT
LARGE
LINEST
LOGEST
LOGINV
LOGNORMDIST
MAX
MAXA
MEDIAN
MIN
MINA
MODE
NEGBINOMDIST
NORMDIST
NORMINV
NORMSDIST
NORMSINV
PEARSON
PERCENTILE
PERCENTRANK
PERMUT
POISSON
PROB
QUARTILE
RANK
RSQ
SKEW
SLOPE
SMALL
STANDARDIZE
STDEV
STDEVA
STDEVP
STDEVPA
STEYX
TDIST
TINV
TREND
TRIMMEAN
TTEST
VAR
VARA
VARP
VARPA
WEIBULL
ZTEST

= [[Excel to Analytica Mappings/Text and Data Functions|Text and Data Functions]] =

ASC
BAHTTEXT
CHAR
CLEAN
CODE
CONCATENATE
COLLAR
EXACT
FIND
FINDB
FIXED
JIS
LEFT
LEFTB
LEN
LENB
LOWER
MID
MIDB
PHONETIC
PROPER
REPLACE
REPLACEB
REPT
RIGHT
RIGHTB
SEARCH
SEARCHB
SUBSTITUTE
T
TEXT
TRIM
UPPER
VALUE