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

تمرين 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.