Ask Your Question

How do I hide: #DIV/0!

asked 2015-04-29 23:34:26 +0200

TarryFaster gravatar image

updated 2015-04-29 23:35:37 +0200

These formula results are in a column and I can't add other numbers in that column with #DIV/0! showing in the otherwise vacant cells.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-04-30 00:03:26 +0200

Lupp gravatar image

updated 2015-04-30 00:10:49 +0200

Suppose you have =A7/B7 in cell C7 and row 7 shall be regarded "unused" if B7 is blank (disregarding A7?). You can avoid the "DivisionByZero error" using the formula =IF(B7="";"";A7/B7). The empty string won't interfere with calculating SUMs or AVERAGEs...

If B7 is actually zero there is no sense in hiding the error which is an inevitable fact then. Only Chuck Norris can divide by zero.

See attachment.ask50076AvoidDivByZero001.ods

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-04-29 23:34:26 +0200

Seen: 4,576 times

Last updated: Apr 30 '15