## Mastering Excel Formulas: IFERROR & XOR

#### Syed Raza, Web Developer | Entrepreneur-CEO www.claydesk.com

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
2 Videos (14m)
• Introduction

2:04
• Logical IFERROR and XOR formula

12:23

The old 80/20 rule for software—that 80% of a program’s users use only 20% of a program’s features—doesn’t apply to Microsoft Excel. Instead, this program probably operates under what could be called the 95/5 rule: Ninety-five percent of Excel users use a mere 5% of the program’s power!

On the other hand, most people know that they could be getting more out of Excel if they could only get a leg up on building formulas and using functions. Unfortunately, this side of Excel appears complex and intimidating to the uninitiated, shrouded as it is in the mysteries of mathematics, finance, and impenetrable spreadsheet jargon.

Here's the good news!

I have designed this practical course to give you the ability to master the excel formulas in this series!

In this tutorial, you will be able to learn important functions such as:

• Financial
• Logical
• Text
• Lookup & Reference, and many more

We will take a look at two important formulas in this class:

1. IFERROR

2. XOR

Trap and handle errors using the IFERROR function. It basically returns a value you specify if a formula evaluates to an error; otherwise, returns the result of theformula. Use the IFERROR function to trap and handle errors in a formula.

The XOR returns a logical Exclusive Or of all arguments.

So, let's jump right in and see these formulas in action!

See you in class.

Happy learning!

Syed

#### 4 of 4 students recommend

Great class! I enjoyed it.
##### Chris Lewis
A precise class! Just to my liking. Thanks.

53

Students

--

Projects

#### Syed Raza

Web Developer | Entrepreneur-CEO www.claydesk.com

Why are 60,000+ students (and counting) enrolled in my online courses?

1) I teach with passion and purpose! Every course is delivered with my students in mind.

2) My courses will help you gain real world skills and knowledge and change your life today!

3) My dedication to the teaching profession and teaching online. Udemy has named me one of its top instructors.

► Try enrolling in a course with me and see for yourself! ◄

__________________________________________________________________________

Want to learn how to become A Professional Web Developer?

Would you like to  Boost Your Career?

Or maybe acquire new skills.

Then Enroll in my Courses Today! You too can be doing this - and so much more!

__________________________________________________________________________