REPT – Excel Function
What it does: The REPT() function repeats text a given number of times. Plain English: This function repeats text a given
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
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
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
SUMIF – Excel Function
What it does: The SUMIF() Functions sum together values based on criteria you provide. Plain English: The SUMIF() formula is
ISBLANK – Excel Function
What it does: The ISBLANK() Function returns a boolean result – whether or not the cell is blank. Plain English: This
IFERROR – Excel Function
What it does: The IFERROR() Function is a function designed to trap errors when they occur. It is enacted when the
CHAR – Excel Function
What it does: The CHAR() returns the character specified by a number. Plain English: When you see CHAR(), think
UPPER – Excel Function
What it does: The UPPER() Function converts text to lowercase. Plain English: Simple. This function converts text to be all