Hi there, ive got a pretty difficult problem with excel that I just cant seem to work out. I have a cell with an equation in it, and the result given in the cell can sometimes return an error depending on the values used. What I would like to do is have the cell work so that if an error is shown it shows it as the value zero in the cell itself. But if the value of the equation isnt an error I would like it to show the result of that equation. I would also like it to display a zero when there is no information in the sheet i.e. when the error is #DIV/0! Any help is appreciated!