# Transitioning from Excel to R: Dictionary of common functions

Alyssa Columbus published maintains this GitHub repository with a great tutorial on how to move from Excel to R. Very useful for beginning useRs, the repository’s tutorial includes a translation table between Excel and R functions:

Excel Formula R Function Type
ABS `abs` Arithmetic
ADDRESS `assign` Essentials
AND `&`,`&&`,`all` Boolean
AVERAGE, AVG, AVERAGEIF `mean` Arithmetic
BETADIST `pbeta` Statistics
BETAINV `qbeta` Statistics
BINOMDIST `pbinom` when cumulative,`dbinom` when not Statistics
CEILING `ceiling` Arithmetic
CELL `str` has the same idea Essentials
CHIDIST, CHISQDIST `pchisq` Statistics
CHIINV, CHISQINV `qchisq` Statistics
CHITEST `chisq.test` Statistics
CHOOSE `switch` Essentials
CLEAN `gsub` Text
COLS, COLUMNS `ncol` Essentials
COLUMN `col`,`:`,`seq` Essentials
COMBIN `choose` Essentals
CONCATENATE `paste` Text
CONFIDENCE `-qnorm(alpha/2)*std/sqrt(n)` Statistics
CORREL `cor` Statistics
COUNT, COUNTIF `length` Arithmetic
COVAR `cov` Statistics
CRITBINOM `qbinom` Statistics
DELTA `identical` Boolean
EXACT `==` Boolean
EXP `exp` Arithmetic
EXPONDIST `pexp` when cumulative,`dexp` when not Statistics
FACT `factorial` Arithmetic
FACTDOUBLE `dfactorial` in the `phangorn` package Arithmetic
FDIST `pf` Statistics
FIND `regexpr`,`grepl`,`grep` Text
FINV `qf` Statistics
FISHER `atanh` Arithmetic
FISHERINV `tanh` Arithmetic
FIXED `format`,`sprintf`,`formatC` Essentials
FLOOR `floor` Arithmetic
FORECAST `predict` on an `lm` object Statistics
FREQUENCY `cut`,`table` Arithmetic
FTEST `var.test` Statistics
GAMMADIST `pgamma` if last argument T,`dgamma` if last arg. F Statistics
GAMMAINV `qgamma` Statistics
GAMMALN `lgamma` Statistics
GAUSS `pnorm(x) - 0.5` Statistics
GCD `gcd` Arithmetic
GEOMEAN `exp(mean(log(x)))` Arithmetic
GESTEP `>=` Boolean
HARMEAN `harmonic.mean` in the `psych` package Arithmetic
HLOOKUP `match`,`merge` Essentials
HYPGEOMDIST `dhyper` Statistics
IF `if`,`ifelse` Essentials
IFERROR `try`,`tryCatch` Essentials
INDEX `x[y,z]` Essentials
INDIRECT `get` Essentials
INT `as.integer`(not for negative numbers),`floor` Arithmetic
INTERCEPT first element of `coef` of an `lm` object Statistics
ISLOGICAL `is.logical` Boolean
ISNA `is.na` Boolean
ISNUMBER `is.numeric` Boolean
ISTEXT `is.character` Boolean
KURT `kurtosis` in the `moments` package Statistics
LARGE `sort` Statistics
LCM `scm` in the `schoolmath` package Arithmetic
LEFT `substr` Text
LEN, LENGTH `nchar` Text
LINEST `lm` Statistics
LN, LOG `log` Arithmetic
LOG10 `log10` Arithmetic
LOGINV `qlnorm` Statistics
LOGNORMDIST `plnorm` Statistics
LOWER `tolower` Text
MATCH `match`,`which` Essentials
MAX `max` (sometimes `pmax`) Arithmetic
MDETERM `det` Arithmetic
MEDIAN `median` Arithmetic
MID `substr` Text
MIN `min` (sometimes `pmin`) Arithmetic
MINVERSE `solve` Arithmetic
MMULT `%*%` Arithmetic
MOD `%%` Arithmetic
MODE `as.numeric(names(which.max(table(x))))` Arithmetic
MUNIT `diag` Arithmetic
N `as.numeric` Arithmetic
NEGBINOMDIST `dnbinom` Statistics
NORMDIST, NORMSDIST `pnorm` when cumulative,`dnorm` when not Statistics
NORMINV, NORMSINV `qnorm` Statistics
NOT `!` Boolean
NOW `date`,`Sys.time` Essentials
OR ` `,`
PEARSON `cor` Statistics
PERCENTILE `quantile` Statistics
PERCENTRANK `ecdf` Statistics
PERMUT `function(n,k) {choose(n,k)*factorial(k)}` Arithmetic
PERMUTATIONA `n^k` Arithmetic
PHI `dnorm` Statistics
POISSON `ppois` when cumulatic,`dpois` when not Statistics
POWER `^` Arithmetic
PROB `ecdf` Statistics
PRODUCT `prod` Arithmetic
PROPER `toupper` Text
QUARTILE `quantile` Arithmetic
QUOTIENT `%/%` Arithmetic
RAND `runif` Arithmetic
RANDBETWEEN `sample` Arithmetic
RANK `rank` Essentials
REPLACE `sub`,`gsub` Text
REPT `rep` and `paste` or `paste0` Text
RIGHT `substring` Text
ROUND `round` Arithmetic
ROUNDDOWN `floor` Arithmetic
ROUNDUP `ceiling` Arithmetic
ROW `row`,`:`,`seq` Essentials
ROWS `nrow` Essentials
RSQ `summary` of `lm` object Statistics
SEARCH `regexpr`,`grep` Text
SIGN `sign` Arithmetic
SKEW `skewness` in the `moments` package Statistics
SLOPE in `coef` of `lm` object Statistics
SMALL `sort` Arithmetic
SQRT `sqrt` Arithmetic
STANDARDIZE `scale` Statitics
STD, STDEV `sd` Arithmetic
STEYX `predict` on an `lm` object Statistics
STRING `format`,`sprintf`,`formatC` Text
SUBSTITUTE `sub`,`gsub`,`paste` Essentials
SUM, SUMIF `sum` Arithmetic
SUMPRODUCT `crossprod` Arithmetic
TDIST `pt` Statistics
TEXT `format`,`sprintf`,`formatC` Text
TINV `abs(qt(x/2,data))` Statistics
TODAY `Sys.Date` Essentials
TRANSPOSE `t` Arithmetic
TREND `fitted` of an `lm` object Statistics
TRIM `sub` Essentials
TRIMMEAN `mean(x,trim=tr/2)` Arithmetic
TRUNC `trunc` Essentials
TTEST `t.test` Statistics
TYPE `typeof`,`mode`,`class` Essentials
UPPER `toupper` Text
VALUE `as.numeric` Arithmetic
VAR `var` Essentials
VLOOKUP `match`,`merge` Essentials
WEEKDAY `weekdays` Essentials
WEIBULL `pweibull` when cumulative,`dweibull` when not Statistics
ZTEST `pnorm` Statistics