Getting rif of #DIV/0!
Getting rif of #DIV/0!
(OP)
Hi all,
I picked up a good tip for suppresing 0's in blank cells and it worked a treat. (0.00;;)
Does anyone know if it's possible to get rid of the #DIV/0! in a cell. I know what's causing it, but dont want it displayed on my spreadsheet with no input.
Thanks in advance for any help.
I picked up a good tip for suppresing 0's in blank cells and it worked a treat. (0.00;;)
Does anyone know if it's possible to get rid of the #DIV/0! in a cell. I know what's causing it, but dont want it displayed on my spreadsheet with no input.
Thanks in advance for any help.





RE: Getting rif of #DIV/0!
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: Getting rif of #DIV/0!
=IF(ISERROR(A1/A2),0,A1/A2)
where A1 and A2 are the respective cell references (substitute your own formula)
RE: Getting rif of #DIV/0!
Your IF and ISERROR solution worked like a charm. All I changed was replacing the 0 with "" to display a blank cell rather than a zero. Now my blank template looks good!
Thanks