Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Articles
  • Videos
  • Merch
  • Excel Courses

Functions

  • Home
  •   »  
  • Functions   »   Page 2
Functions
REPT – Excel Function

REPT – Excel Function

What it does: The REPT() function repeats text a given number of times. Plain English: This function repeats text a given

Functions Text Functions
RIGHT – Excel Function

RIGHT – Excel Function

What it does: The RIGHT() Function removes a string from the right side of a given piece of text according to parameters you

Functions Text Functions
LEFT – Excel Function

LEFT – Excel Function

What it does: The LEFT() Function removes a string from the left side of a given piece of text according to parameters you

Functions Text Functions
MID – Excel Function

MID – Excel Function

What it does: The MID() Function returns a specific part of a larger text string, subject to the arguments you provide. Plain

Functions Math Functions
SUMIF – Excel Function

SUMIF – Excel Function

What it does: The SUMIF() Functions sum together values based on criteria you provide. Plain English: The SUMIF() formula is

Functions Informational Functions
ISBLANK – Excel Function

ISBLANK – Excel Function

What it does: The ISBLANK() Function returns a boolean result – whether or not the cell is blank. Plain English: This

Functions Logical Functions
IFERROR – Excel Function

IFERROR – Excel Function

What it does: The IFERROR() Function is a function designed to trap errors when they occur. It is enacted when the

Functions Text Functions
Char Function Microsoft Excel

CHAR – Excel Function

What it does: The CHAR() returns the character specified by a number. Plain English: When you see CHAR(), think

Functions Text Functions
UPPER – Excel Function

UPPER – Excel Function

What it does: The UPPER() Function converts text to lowercase. Plain English: Simple. This function converts text to be all

Posts navigation

« 1 2 3 … 5 »
  • Articles
  • Videos
  • Online Training
  • About
  • Contact
  • Excel Functions
    • Text Functions
    • Math Functions
    • Logical Functions
    • Lookup and Reference Functions
Copyright ©2022 Excel Nerds - Learn Pivot Tables, Vlookup, and Data Analysis
Developed by WOWLayers.com