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.
Tradies are the critical workers in the Australian property market. They're responsible for new home…
Things are moving fast in the software industry as Intuit (QuickBooks), MYOB and Xero compete…
We've just updated our Job Outcomes page to showcase some of the jobs that EzyLearn…
The most common jobs for office admin and office support require confident knowledge of Microsoft…
The one thing I've found fascinating in accounting and bookkeeping is watching technology companies try…
Is your name on this list? I want to thank the following students for choosing…