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 1
In cell X5, the error value #DIV/0! appears when you divide by 0. What IFERROR function can you use with the formula =W5/W25 so that instead of the error value #DIV/0! being displayed, the message "Dividing by zero" appears in the cell
Explanation
Verified
like image
like image

IFERROR Function
In the given problem W...

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