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.
(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.
Working with our graduates we've discovered that organisations are still looking for staff who can…
We receive lots of bookkeeping course enquiries from students who are changing careers and want…
Am I speaking gibberish or just crazy? No, I'm speaking the language of eInvoicing! PEPPOL…
If your finances are under pressure and you need to learn Xero then our current…
Someone made contact with me recently and told me about an opportunity where "I could…
There are times when I wish we all had the choice to only upgrade our…