expand icon
book New Perspectives on Microsoft Excel 2010 1st Edition by June Jamrich Parsons ,Dan Oja,Roy Ageloff ,Patrick Carey cover

New Perspectives on Microsoft Excel 2010 1st Edition by June Jamrich Parsons ,Dan Oja,Roy Ageloff ,Patrick Carey

Edition 1ISBN: 978-0538742917
book New Perspectives on Microsoft Excel 2010 1st Edition by June Jamrich Parsons ,Dan Oja,Roy Ageloff ,Patrick Carey cover

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
Verified
like image
like image

Inserting Comments to Worksheet Cell
Co...

close menu
New Perspectives on Microsoft Excel 2010 1st Edition by June Jamrich Parsons ,Dan Oja,Roy Ageloff ,Patrick Carey
cross icon