Eliminating #DIV/0!

[Cirby]

I need to hide the content of cells showing this error message, however I do not want to eliminate the formula in the cell. The error is being cause by a formula that looks to divide something by zero. I want the cell to appear blank in this case. Once the cell that is going to be the denominator is populated with a value, I would want the cell to show the results of the formula. For example: Cell A1=1 Cell A2=0 Cell A3=A1/A2 I would want nothing to show in A3. If Cell A2 was changed to = 2, I would want cell A3 to show .5. Any help is greatly appreciated.

Thanks

 

[DonkeyOte]

if(iserror(a1/a2),"",a1/a2)

 

[Aladin Akyurek]

On 2002-09-19 10:29, Cirby wrote:
I need to hide the content of cells showing this error message, however I do not want to eliminate the formula in the cell. The error is being cause by a formula that looks to divide something by zero. I want the cell to appear blank in this case. Once the cell that is going to be the denominator is populated with a value, I would want the cell to show the results of the formula. For example: Cell A1=1 Cell A2=0 Cell A3=A1/A2 I would want nothing to show in A3. If Cell A2 was changed to = 2, I would want cell A3 to show .5. Any help is greatly appreciated.

Thanks

In A3 enter:

=IF(A2,A1/A2,"")