Technology news August 2007 | AccountingWEB

Technology news August 2007


Excel 2min Tip: How to remove error messages such as #DIV/0!

When you use a formula to calculate a new column of numbers, Excel will sometimes display error messages such as #DIV/0! if a number has been divided by zero.Use the ISERROR function to eliminate error messages and keep the column of data tidyWorked example: Start up Excel. Open a blank worksheet.In cells A1 to A6, type: 10, 20, 30, 40, 50, 60 (no commas)In cells B1 to B6 type: 1, 2, 3, 4, 5, 6Now in B2 and B4, replace the 2 and the 4 with 0 (zero).In C1, divide B1 into A1 with the formula = A1/B1.

Excel Tip: Moving around the worksheet

There are several techniques for moving from one place to another on an Excel worksheet. Here are some of the most common techniques:Using the mouse:Use the mouse to click in any visible cell.


Premium content is currently locked