Interested in Learning Excel? Click Here for 50% off our Bestselling Course

## The IF Function in Excel & Boolean Logic

If new to Excel and building formulas, there’s a concept I think is very important to understand before learning to

## DATE – Excel Function

What it does: The DATE() formula returns the serial number that represents a particular date. Plain English: This formula

## IF – Excel Function

What it does: The IF() Function evaluates an argument. If the argument is TRUE, the formula does one thing. If the argument

## 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