User:Devon McCormick/ExceltoJRosetta

From J Wiki
Jump to: navigation, search

It would be useful to show J equivalents of Excel functions. The following lists all Excel functions as of Excel 2014. These are extracted from the Excel executable. Some of them - those preceded by a star (at the end) - are apparently internal functions but are included here for completeness.

If the J equivalent requires more than a small amount of space, you are encouraged to put it on another page and provide a link to it in the "J equivalent" column. The explanations of the Excel functions can be found on another page.

Excel Function J equivalent J Example
ABS | 1 2 = | _1 _2
ACCRINTM ([:*/(2{.]),(2{])%~2-~/\[:todayno 0 100 100(#:"1 0) _2{.]) ACCRINTM
ACCRINT
ACOSH _6 o. 0j3.14159 0j1.5708 0 1.31696 = _6 o. _1 0 1 2
ACOS _2 o.  3.14159 1.5708 0 = _2 o. _1 0 1
ADDRESS
AGGREGATE
AMORDEGRC
AMORLINC
AND *. 0 0 0 1 = 0 0 1 1 *. 0 1 0 1
AREAS
ASC
ASINH _5 o. _0.881374 0 0.881374 1.44364 = _5 o. _1 0 1 2
ASIN _1 o. _1.5708 0 1.5708 = _1 o. _1 0 1
ATAN2 _3 o. 0 0.785398 1.10715 = _3 o. 0 1 2
ATANH  _7 o. 0 0.549306 1.47222 2.64665 = _7 o. 0 0.5 0.9 0.99
ATAN _3 o. 0 0.785398 1.10715 = _3 o. 0 1 2
AVEDEV (+/%#)|(]-(+/%#)) 42 = (+/%#)|(]-(+/%#)) 1 10 100
AVERAGE (+/ % #) 37 = (+/ % #) 1 10 100
AVERAGEA
AVERAGEIFS
AVERAGEIF 1 : '(+/%#)y#~u y' 16 = 10&< (1 : '(+/%#)y#~u y') 4 5 6 12 20
BAHTTEXT
BESSELI
BESSELJ
BESSELK
BESSELY
BETA.DIST
BETA.INV
BETADIST
BETAINV
BIN2DEC
BIN2HEX
BIN2OCT
BINOM.DIST
BINOM.INV
BINOMDIST
CEILING.PRECISE
CEILING
CELL
CHAR
CHIDIST
CHIINV
CHISQ.DIST.RT
CHISQ.DIST
CHISQ.INV.RT
CHISQ.INV
CHISQ.TEST
CHITEST
CHOOSE
CLEAN
CODE
COLUMNS
COLUMN
COMBIN
COMPLEX
CONCATENATE
CONFIDENCE.NORM
CONFIDENCE.T
CONFIDENCE
CONVERT
CORREL
COSH
COS
COUNTA
COUNTBLANK
COUNTIFS
COUNTIF
COUNT
COUPDAYBS
COUPDAYSNC
COUPDAYS
COUPNCD
COUPNUM
COUPPCD
COVARIANCE.P
COVARIANCE.S
COVAR covar=: (([: +/ *&(- (+/ % #))) % [: # [) 2 = covar 1 2 3 4 5
CRITBINOM
CUBEKPIMEMBER
CUBEMEMBERPROPERTY
CUBEMEMBER
CUBERANKEDMEMBER
CUBESETCOUNT
CUBESET
CUBEVALUE
CUMIPMT
CUMPRINC
DATEVALUE
DATE
DAVERAGE
DAYS360
DAY
DBCS
DB
DCOUNTA
DCOUNT
DDB
DEC2BIN
DEC2HEX
DEC2OCT
DEGREES
DELTA
DEVSQ
DGET
DISC
DMAX
DMIN
DOLLARDE
DOLLARFR
DOLLAR
DPRODUCT
DSTDEVP
DSTDEV
DSUM
DURATION
DVARP
DVAR
EDATE
EFFECT
EOMONTH
ERF.PRECISE
ERFC.PRECISE
ERFC
ERF
EVEN
EXACT
EXPON.DIST
EXPONDIST
EXP
F.DIST.RT
F.DIST
F.INV.RT
F.INV
F.TEST
FACTDOUBLE
FACT
FALSE
FDIST
FINDB
FIND
FINV
FISHERINV
FISHER
FIXED
FLOOR.PRECISE
FLOOR
FORECAST
FREQUENCY
FTEST
FVSCHEDULE
FV
GAMMA.DIST
GAMMA.INV
GAMMADIST
GAMMAINV
GAMMALN.PRECISE
GAMMALN
GCD
GEOMEAN
GESTEP
GETPIVOTDATA
GROWTH
HARMEAN
HEX2BIN
HEX2DEC
HEX2OCT
HLOOKUP
HOUR
HYPERLINK
HYPGEOM.DIST
HYPGEOMDIST
IFERROR
IF
IMABS
IMAGINARY
IMARGUMENT
IMCONJUGATE
IMCOS
IMDIV
IMEXP
IMLN
IMLOG10
IMLOG2
IMPOWER
IMPRODUCT
IMREAL
IMSIN
IMSQRT
IMSUB
IMSUM
INDEX
INDIRECT
INFO
INTERCEPT
INTRATE
INT
IPMT
IRR
ISBLANK
ISERROR
ISERR
ISEVEN
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISPMT
ISREF
ISTEXT
ISTHAIDIGIT
KURT
LARGE
LCM
LEFTB
LEFT
LENB
LEN
LINEST
LN
LOG10
LOGEST
LOGINV
LOGNORM.DIST
LOGNORM.INV
LOGNORMDIST
LOG
LOOKUP
LOWER
MATCH
MAXA
MAX
MDETERM
MDURATION
MEDIAN
MIDB
MID
MINA
MINUTE
MINVERSE
MIN
MIRR
MMULT
MODE.MULT
MODE.SNGL
MODE
MOD
MONTH
MROUND
MULTINOMIAL
NA
NEGBINOM.DIST
NEGBINOMDIST
NETWORKDAYS.INTL
NETWORKDAYS
NOMINAL
NORM.DIST
NORM.INV
NORM.S.DIST
NORM.S.INV
NORMDIST
NORMINV
NORMSDIST
NORMSINV
NOT
NOW
NPER
NPV
N
OCT2BIN
OCT2DEC
OCT2HEX
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
ODD
OFFSET
OR
PEARSON
PERCENTILE.EXC
PERCENTILE.INC
PERCENTILE
PERCENTRANK.EXC
PERCENTRANK.INC
PERCENT
PERMUT
PHONETIC
PI
PMTRATE
POISSON.DIST
POISSON
PPMT
PRICEDISC
PRICEMAT
PRICE
PROB
PRODUCT
PROPER
PV
QUARTILE.EXC
QUARTILE.INC
QUARTILE
QUOTIENT
RADIANS
RANDBETWEEN
RAND
RANK.AVG
RANK.EQ
RANK
RANK
RECEIVED
REPLACEB
REPLACE
REPT
RIGHTB
RIGHT
ROMAN
ROUNDBAHTDOWN
ROUNDBAHTUP
ROUNDDOWN
ROUNDUP
ROUND
ROWS
ROW
RSQ
RTD
SEARCHB
SEARCH
SECOND
SERIESSUM
SIGN
SINH
SIN
SKEW
SLN
SLOPE
SMALL
SQRTPI
SQRT
STANDARDIZE
STDEV.P
STDEV.S
STDEVA
STDEVPA
STDEVP
STDEV
STEYX
SUBSTITUTE
SUBTOTAL
SUMIFS
SUMIF
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
SUM
SYD
T.DIST.2T
T.DIST.RT
T.DIST
T.INV.2T
T.INV
T.TEST
TANH
TAN
TBILLEQ
TBILLPRICE
TBILLYIELD
TDIST
TEXT
THAIDAYOFWEEK
THAIDIGIT
THAIMONTHOFYEAR
THAINUMSOUND
THAINUMSTRING
THAISTRINGLENGTH
THAIYEAR
TIMEVALUE
TIME
TINV
TODAY
TRANSPOSE
TREND
TRIMMEAN
TRIM
TRUE
TRUNC
TTEST
TYPE
T
UPPER
USDOLLAR
VALUE
VAR.P
VAR.S
VARA
VARPA
VARP
VAR
VDB
VLOOKUP
WEEKDAY
WEEKNUM
WEIBULL.DIST
WEIBULL
WORKDAY.INTL
WORKDAY
XIRR
XNPV
YEARFRAC
YEAR
YIELDDISC
YIELDMAT
YIELD
Z.TEST
ZTEST
*ABSREF
*ACTIVE.CELLS
*ADD.BAR
*ADD.COMMAND
*ADD.MENU
*ADD.TOOLBAR
*APP.TITLE
*ARGUMENT
*BREAK
*CALLER
*CALL
*CANCEL.KEY
*CHECK.COMMAND
*CREATE.OBJECT
*CUSTOM.REPEAT
*CUSTOM.UNDO
*DATEDIF
*DATESTRING
*DELETE.BAR
*DELETE.COMMAND
*DELETE.MENU
*DELETE.TOOLBAR
*DEREF
*DIALOG.BOX
*DIRECTORY
*DOCUMENTS
*ECHO
*ECMA.CEILING
*ELECTIONRESULT
*ELSE.IF
*ELSE
*ENABLE.COMMAND
*ENABLE.TOOL
*END.IF
*ERROR.TYPE
*ERROR
*EVALUATE
*EXECUTE
*EXEC
*FCLOSE
*FILES
*FOPEN
*FOR.CELL
*FORMULA.CONVERT
*FOR
*FPOS
*FREADLN
*FREAD
*FSIZE
*FWRITELN
*FWRITE
*GET.BAR
*GET.CELL
*GET.CHART.ITEM
*GET.DEF
*GET.DOCUMENT
*GET.FORMULA
*GET.LINK.
*GET.MOVIE
*GET.NAME
*GET.NOTE
*GET.OBJECT
*GET.PIVOT.FIELD
*GET.PIVOT.ITEM
*GET.PIVOT.TABLE
*GET.TOOLBAR
*GET.TOOL
*GET.WINDOW
*GET.WORKBOOK
*GET.WORKSPACE
*GOTO
*HALT
*HELP
*INFOGROUP
*INITIATE
*INPUT
*ISO.CEILING
*LAST.ERROR
*LINKS
*MOVIE.COMMAND
*NAMES
*NEXT
*NOTE
*NUMBERSTRING
*OPEN.DIALOG
*OPTIONS.LISTS.GET
*PAUSE
*PIVOT.ADD.DATA
*POKE
*POWER
*PRESS.TOOL
*REFTEXT
*REGISTER.ID
*REGISTER
*RELREF
*RENAME.COMMAND
*REQUEST
*RESET.TOOLBAR
*RESTART
*RESUME
*RETURN
*SAVE.DIALOG
*SAVE.TOOLBAR
*SCENARIO.GET
*SERIES
*SET.NAME
*SET.VALUE
*SHOW.BAR
*SPELLING.CHECK
*STEP
*TERMINATE
*TEXT.BOX
*TEXTREF
*UNREGISTER
*VIEW.GET
*VOLATILE
*WHILE
*WINDOW.TITLE
*WINDOWS