Forum Discussion
Solved
Excel how to hide #DIV/0!
I am using this formula =SUM(60*I6)/(E6*F6) for a spreadhseet. If my cells are empty I would like to hide the error #DIV/0!. I have tried the IFERROR function but it says I have entered too few arg...
- To return an empty string (blank cell) instead of the error value, the format for IFERROR should be:
=IFERROR(SUM(60*I6)/(E6*F6),"")
Does that work for you? If not, can you share what you are trying?
To return an empty string (blank cell) instead of the error value, the format for IFERROR should be:
=IFERROR(SUM(60*I6)/(E6*F6),"")
Does that work for you? If not, can you share what you are trying?
=IFERROR(SUM(60*I6)/(E6*F6),"")
Does that work for you? If not, can you share what you are trying?
flexyourdata Thank you! That works. Just trying to get that cell hide the error. Thanks again