Imports Excel Functions to R


[Up] [Top]

Documentation for package ‘ExcelFunctionsR’ version 0.1.4

Help Pages

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
Sales Random Sales Data
STDEV Basic STDEV function from excel
Streets Random Salesman Streets Data
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