Below is a short list of basic, commonly-used Excel formulas and their R counterparts. The R functions are part of Base R, in that they do no require third-party packages. This is not an exhaustive list by any stretch.

### Basic Arithmetic Functions

Excel formula |
R function |
---|---|

SUM | sum |

AVERAGE | mean |

COUNTA | length |

MAX | max (sometimes pmax) |

MIN | min (sometimes pmin) |

STDEV | sd |

ABS | abs |

CEILING, ROUNDUP | ceiling |

FLOOR, ROUNDDOWN | floor |

ROUND | round |

EXP | exp |

LOG, LN | log |

SQRT | sqrt |

### Basic Text Functions

Excel formula |
R function |
---|---|

CONCATENATE | paste |

LEFT, MID, RIGHT | substr |

LOWER | tolower |

UPPER | toupper |

LEN | nchar |

FIND | grepl, grep and others |

REPLACE | gsub and others |

### More Formulas

Excel formula |
R function |
---|---|

ISNA | is.na |

MATCH | which |

REPT | rep |

RANK | rank |

VLOOKUP | merge (sort of) |

### Excel Features

Here are some Excel features and some of their close counterparts in R:

Excel Feature |
R function(s) |
---|---|

Format Cells | as.Date, as.numeric, as.character (sort of) |

Navigating / inspecting table | head, tail, str, summary, dim, nrow |

Text to Columns | strsplit (sort of) |

## Leave a Reply

Be the First to Comment!