ExcelFunctionsR0.1.4 package

Imports Excel Functions to R

AND

Basic AND function from excel

AVERAGE

Basic AVERAGE function from excel

AVERAGEIF

Basic AVERAGEIF function from excel

AVERAGEIFS

Basic AVERAGEIFS function from excel

CONCAT

Basic Concat function from excel

CONCATENATE

Basic Concatenate function from excel

COUNT

Basic COUNT function from excel

COUNTIF

Basic COUNTIF function from excel

COUNTIFS

Basic COUNTIFS function from excel

DATE

Basic DATE function from excel

DATEDIF

Basic DATEDIF function from excel

DATETOEXCELSERIES

Date to excel date series function

DAY

Basic DAY function from excel

DAYS

Basic DAYS function from excel

EOMONTH

Basic EOMONTH function from excel

FIND

Basic FIND function from excel

IF

Basic If function from excel

IFNA

Basic IFNA function from excel

INDEX

Basic INDEX function from excel

ISBLANK

Basic ISBLANK function from excel

ISEVEN

Basic ISEVEN function from excel

ISLOGICAL

Basic ISLOGICAL function from excel

ISNUMBER

Basic ISNUMBER function from excel

ISODD

Basic ISODD function from excel

LEFT

Basic LEFT function from excel

LEN

Basic LEN function from excel

LOWER

Basic LOWER function from excel

MATCH

Basic MATCH function from excel

MAXIF

Basic MAXIF function from excel

MAXIFS

Basic MAXIFS function from excel

MID

Basic MID function from excel

MINIF

Basic MINIF function from excel

MINIFS

Basic MINIFS function from excel

MONTH

Basic MONTH function from excel

NOT

Basic NOT function from excel

NOW

Basic NOW function from excel

OR

Basic OR function from excel

RAND

Basic RAND function from excel.

RANDBETWEEN

Basic RANDBETWEEN function from excel

REPT

Basic REPT function from excel

RIGHT

Basic RIGHT function from excel

STDEV

Basic STDEV function from excel

SUBSTITUTE

Basic SUBSTITUTE function from excel

SUMIF

Basic SUMIF function from excel

SUMIFS

Basic SUMIFS function from excel

TODAY

Basic TODAY function from excel

UPPER

Basic UPPER function from excel

VLOOKUP

Basic VLOOKUP function from excel

WEEKDAY

Basic WEEKDAY function from excel

YEAR

Basic YEAR function from excel

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.

  • Maintainer: Nika Salia
  • License: GPL-3
  • Last published: 2020-06-22