Greetings EE Pros!
I have a WB with several WSs that when I reset my data input, I get a #/Div0 error. That's because the cells making a calculation are cleared and I have a divide by blank or -0- situation. In order to properly handle it, I began by using an "If/Then" condition but that didn't result in getting the error and displaying either blank "", or -0-. Then I tried Iferror but also didn't get a remedy for having #/Div0 not displayed when the error occurs. What is the simple formula to trap the error and then display either blank or -0-?