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

Jerry knows all about email..

Jerry Lame is a serial entrepreneur and loves shiny new objects. He was a corporate…

2 weeks ago

I’m not sure what to say..

Have you ever been in that situation? There's lots going on and you have a…

2 weeks ago

Do you need to learn Email Marketing?

I must admit that I have written a lot about email marketing lately and it's…

3 weeks ago

New menu items have been added for ‘Customers & leads’ and ‘Budgets’

There have been some big changes in Intuit QuickBooks Online navigation that have given our…

3 weeks ago

Why MYOB makes you log in after inactivity

Have you noticed a change in how MYOB makes you login? They're starting to do…

3 weeks ago

Are you Selling Your Property?

They say that Spring is the season to sell your home but is that the…

4 weeks ago