Forward this email to your friends so they can subscribe themselves. Click on the heading to visit the EzyLearn Blog

One of the most efficient features available in Microsoft Excel is the ability to create a formula and then copy it into a large number of subsequent cells. When you perform a dbroad copy and paste like this, Depending on the type of data, you’ll get either a #DIV/0 or a #VALUE error if the source cells don’t contain the correct data. You could scan the spreadsheet manually and modify each cell that contains such an error or use the IFERROR function when creating your original formula.

The IFERROR function is composed of two parts – the original function that you wanted to create (such as dividing two numbers) and a value to use when this function doesn’t make sense (like trying to divide by 0 or a word).

Let’s take a basic table of data that contains three columns. The total amount of a restaurant bill is in the first column, and the second column is comprised of the number of people in the party that received the bill. In the third column, we want to calculate the price per person.

Task: Use the IFERROR function

(1)     Create the spreadsheet above using the data in columns A & B.

(2)     Perform a simple calculation to divide the Total Price by the number of people to get the answer in Colum C

(3)     Notice the error messages

(4)     Click on cell C2 and type the following function =IFERROR(A2/B2,”Unknown”)

(5)     Use the fill handle to copy it down the column. Notice that where-ever the error normally occurred; it has been replaced by the word Unknown.

(6)     This time try =IFERROR(A2/B2,””) and notice that the cells where an error occurred are now showing no value.

If you’d like to participate in our online Microsoft Excel training course visit this link.

Want to do a course online but not sure how online training courses work?

If you want to have a group of people trained in your office or our training centre call us on (02) 9971 0000 or visit our online schedule to enrol into Class-Based Training in Chatswood, Sydney.

Steve Slisar

Steve Slisar has been training people how to use computers since 1994, opened a training centre in 1999 in Dee Why and by 2005 had 3 training centres and created over 35 individual courses that include Screen videos with audio commentary, training workbooks for those who prefer to read to learn, and exercise files that are used with the tasks in the workbooks so you get practical experience in the software you are trying to learn. Now the creator of 5 of the most popular online MYOB training courses in Australia.

Recent Posts

Remote Working Internship

Working with our graduates we've discovered that organisations are still looking for staff who can…

3 days ago

Should you learn MYOB, Xero or QuickBooks First?

We receive lots of bookkeeping course enquiries from students who are changing careers and want…

5 days ago

What’s happening PEPPOL?

Am I speaking gibberish or just crazy? No, I'm speaking the language of eInvoicing! PEPPOL…

3 weeks ago

Xero Training Course Workbooks from under $35

If your finances are under pressure and you need to learn Xero then our current…

4 weeks ago

Do you want to earn an obscene amount of money?

Someone made contact with me recently and told me about an opportunity where "I could…

1 month ago

I’ve been away for 5 days and everything is out of date

There are times when I wish we all had the choice to only upgrade our…

1 month ago