How to get a cell with a zero errorto show the cell as blank

[jsunshine]

[Roger Govier]

Hi

Do you mean something like
=IF(ISERROR(your_formula),"",your_formula)

Substitute the formula you have that is giving the divide by zero error
for "your_formula"

--
Regards

Roger Govier


"jsunshine" <jsunshine@discussions.microsoft.com> wrote in message
news:AC4F9B83-49C4-4865-AA7B-732406E90308@microsoft.com...
>

[jsunshine]

Thank you! It worked perfectly.

"Roger Govier" wrote:

> Hi
>
> Do you mean something like
> =IF(ISERROR(your_formula),"",your_formula)
>
> Substitute the formula you have that is giving the divide by zero error
> for "your_formula"
>
> --
> Regards
>
> Roger Govier
>
>
> "jsunshine" <jsunshine@discussions.microsoft.com> wrote in message
> news:AC4F9B83-49C4-4865-AA7B-732406E90308@microsoft.com...
> >
>
>
>