Learn R Programming

ExcelFunctionsR (version 0.1.4)

Imports Excel Functions to R

Description

Implements 'Excel' functions in 'R' for your calculation simplicity.You can use most of the aggregate functions, addressing functions,logical functions and text functions. Helps you a ton in learning how 'R' works as some 'Excel' users might be struggling with the program.

Copy Link

Version

Install

install.packages('ExcelFunctionsR')

Monthly Downloads

290

Version

0.1.4

License

GPL-3

Maintainer

Nika Salia

Last Published

June 22nd, 2020

Functions in ExcelFunctionsR (0.1.4)

COUNTIF

Basic COUNTIF function from excel
DATEDIF

Basic DATEDIF function from excel
LEN

Basic LEN function from excel
MONTH

Basic MONTH function from excel
LEFT

Basic LEFT function from excel
MINIFS

Basic MINIFS function from excel
DATETOEXCELSERIES

Date to excel date series function
LOWER

Basic LOWER function from excel
MATCH

Basic MATCH function from excel
DAYS

Basic DAYS function from excel
DAY

Basic DAY function from excel
INDEX

Basic INDEX function from excel
IFNA

Basic IFNA function from excel
AVERAGEIF

Basic AVERAGEIF function from excel
SUMIFS

Basic SUMIFS function from excel
ISBLANK

Basic ISBLANK function from excel
ISEVEN

Basic ISEVEN function from excel
MID

Basic MID function from excel
SUBSTITUTE

Basic SUBSTITUTE function from excel
UPPER

Basic UPPER function from excel
MINIF

Basic MINIF function from excel
ISLOGICAL

Basic ISLOGICAL function from excel
MAXIF

Basic MAXIF function from excel
SUMIF

Basic SUMIF function from excel
MAXIFS

Basic MAXIFS function from excel
OR

Basic OR function from excel
VLOOKUP

Basic VLOOKUP function from excel
Sales

Random Sales Data
ISNUMBER

Basic ISNUMBER function from excel
EOMONTH

Basic EOMONTH function from excel
RANDBETWEEN

Basic RANDBETWEEN function from excel
FIND

Basic FIND function from excel
ISODD

Basic ISODD function from excel
AVERAGEIFS

Basic AVERAGEIFS function from excel
REPT

Basic REPT function from excel
RIGHT

Basic RIGHT function from excel
NOT

Basic NOT function from excel
STDEV

Basic STDEV function from excel
RAND

Basic RAND function from excel.
WEEKDAY

Basic WEEKDAY function from excel
TODAY

Basic TODAY function from excel
Streets

Random Salesman Streets Data
NOW

Basic NOW function from excel
YEAR

Basic YEAR function from excel
AVERAGE

Basic AVERAGE function from excel
CONCATENATE

Basic Concatenate function from excel
COUNT

Basic COUNT function from excel
COUNTIFS

Basic COUNTIFS function from excel
AND

Basic AND function from excel
CONCAT

Basic Concat function from excel
DATE

Basic DATE function from excel
IF

Basic If function from excel