How can a#DIV/$\displaystyle 0$! error be corrected ?

To correct #DIV/$\displaystyle 0$! Error Following steps can be followed: Change the call reference to another cell Enter a value other than zero in the cell used as a divisor Enter the value #N/A into the cell referenced as the divisor, which changes the result of the formula to #N/A from # DIV/$\displaystyle 0$! to denote that the divisor value is not available Prevent the error value from displaying by using IF worksheet function