Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Articles
  • Videos
  • Excel Courses

if else

  • Home
  •   »  
  • if else
Excel
top things to know in Excel

Top 5 Things to Know in Excel

I remember listing “Microsoft Excel” as a skill on my resume just out of college. The only functions I knew how

Excel
Using iferror in Excel

Using IFERROR to trap and handle errors

When I first found out about IFERROR, I was a little confused. “There’s a formula to use if we generate an error?

Excel
if function in Excel

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

Functions Logical Functions
IF – Excel Function

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

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 Logical Functions
OR – Excel Function

OR – Excel Function

What it does: The OR() checks if at least one condition you listed is TRUE. Plain English: The OR() function is similar to

Functions Logical Functions
AND – Excel Function

AND – Excel Function

What it does: The AND() checks if all conditions that you list are TRUE. Plain English: The AND() formula is often used in

  • 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