
New Perspectives on Microsoft Excel 2010 1st Edition by June Jamrich Parsons ,Dan Oja,Roy Ageloff ,Patrick Carey
Edition 1ISBN: 978-0538742917
New Perspectives on Microsoft Excel 2010 1st Edition by June Jamrich Parsons ,Dan Oja,Roy Ageloff ,Patrick Carey
Edition 1ISBN: 978-0538742917 Exercise 7
In cell X5, the formula =W5/W25 results in the error value #DIV/0! when W25 stores the value 0. Use the IF function to modify the formula =W5/W25 so that instead of the error value #DIV/0! being displayed when W25 stores 0, the message "Dividing by zero" appears in the cell.
Explanation
Inserting Comments to Worksheet Cell
Co...
New Perspectives on Microsoft Excel 2010 1st Edition by June Jamrich Parsons ,Dan Oja,Roy Ageloff ,Patrick Carey
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255

