• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

#DIV/0! Problem

A

AMIT ANAND

New Member
I have spreadsheet which takes input from another software. The sofware gives me #DIV/0! value if it divides something by zero. We copy the values from the software and put it in the spreadsheet and this #DIV/0! is also taken as input. But in the output spreadsheet i dont wand this #DIV/0!. How to get rid of it given we are not doing any calculation in the cell in which this #DIV/0! is taken as input.
 
Dear Amit,

If there isn't any calculation or formulas in that cell, then you can replace that blank space. You can use find and replace dialogue box to replace this error.

If any formula is there, in that cell, then please use IFERROR formula (for 2007 and above) to replace the error values with your desired values

and there also so many options, to get rid of this. You can use googled that one
 
You must log in or register to reply here.
Back
Top