I WANT TO HIDE THIS #DIV0!

I had a formula in a cell, that when ocurred I want it to hide, it says
#DIV0! and when I try to sort that column it mess everything that message.
I would like for example to say 0 instead of that error message, but I don't
know how to do it.
I would appriciate any help.
Thank you

Hi herman,

use in an if function in your cell eg. =if(iserror(a1/a2),0,(a1;a2))

change a1 a2 per your original formulas

hth
regards from Brazil
Marcelo

"HERNAN" escreveu:

> I had a formula in a cell, that when ocurred I want it to hide, it says
> #DIV0! and when I try to sort that column it mess everything that message.
> I would like for example to say 0 instead of that error message, but I don't
> know how to do it.
> I would appriciate any help.
> Thank you

One way:

If your formula is, for example,

=A1/B1

then use

=IF(B1<>0,A1/B1,0)

In article <[email protected]>,
HERNAN <[email protected]> wrote:

> I had a formula in a cell, that when ocurred I want it to hide, it says
> #DIV0! and when I try to sort that column it mess everything that message.
> I would like for example to say 0 instead of that error message, but I don't
> know how to do it.
> I would appriciate any help.
> Thank you

Note that this will mask other valid errors as well (e.g., a #VALUE! or
#REF! error), so that those errors may not be noticed.

Generally, one should trap only for expected errors.

In article <[email protected]>,
Marcelo <[email protected]> wrote:

> Hi herman,
>
> use in an if function in your cell eg. =if(iserror(a1/a2),0,(a1;a2))
>
> change a1 a2 per your original formulas
>
> hth
> regards from Brazil
> Marcelo
>
> "HERNAN" escreveu:
>
> > I had a formula in a cell, that when ocurred I want it to hide, it says
> > #DIV0! and when I try to sort that column it mess everything that message.
> > I would like for example to say 0 instead of that error message, but I
> > don't
> > know how to do it.
> > I would appriciate any help.
> > Thank you

Thank you, but There is any other way because I have more than 1500 formulas,
and I don't want to go each by each one.
Something like formating or view
O brigado


"Marcelo" wrote:

> Hi herman,
>
> use in an if function in your cell eg. =if(iserror(a1/a2),0,(a1;a2))
>
> change a1 a2 per your original formulas
>
> hth
> regards from Brazil
> Marcelo
>
> "HERNAN" escreveu:
>
> > I had a formula in a cell, that when ocurred I want it to hide, it says
> > #DIV0! and when I try to sort that column it mess everything that message.
> > I would like for example to say 0 instead of that error message, but I don't
> > know how to do it.
> > I would appriciate any help.
> > Thank you

1500 formulas is easy to replace if they are equal. How many /different/
formulas do you have that returns Div0 ?
I believe you should get rid of the error, not the error message.

Best wishes Harald

"HERNAN" <[email protected]> skrev i melding
news:[email protected]...
> Thank you, but There is any other way because I have more than 1500
formulas,
> and I don't want to go each by each one.
> Something like formating or view
> O brigado
>
>
> "Marcelo" wrote:
>
> > Hi herman,
> >
> > use in an if function in your cell eg. =if(iserror(a1/a2),0,(a1;a2))
> >
> > change a1 a2 per your original formulas
> >
> > hth
> > regards from Brazil
> > Marcelo
> >
> > "HERNAN" escreveu:
> >
> > > I had a formula in a cell, that when ocurred I want it to hide, it
says
> > > #DIV0! and when I try to sort that column it mess everything that
message.
> > > I would like for example to say 0 instead of that error message, but I
don't
> > > know how to do it.
> > > I would appriciate any help.
> > > Thank you

Yes boths works, but there is anyway to format the hole column at once so
doesn't show the errors

"JE McGimpsey" wrote:

> One way:
>
> If your formula is, for example,
>
> =A1/B1
>
> then use
>
> =IF(B1<>0,A1/B1,0)
>
> In article <[email protected]>,
> HERNAN <[email protected]> wrote:
>
> > I had a formula in a cell, that when ocurred I want it to hide, it says
> > #DIV0! and when I try to sort that column it mess everything that message.
> > I would like for example to say 0 instead of that error message, but I don't
> > know how to do it.
> > I would appriciate any help.
> > Thank you
>

Is a payment sheet so all the time I'm going to have ceros on the accounts.
But I only need to sort the ones that have numbers on it, when I try to do
it. sorts the #DIV!0 first, and I don't want that.

"Harald Staff" wrote:

> 1500 formulas is easy to replace if they are equal. How many /different/
> formulas do you have that returns Div0 ?
> I believe you should get rid of the error, not the error message.
>
> Best wishes Harald
>
> "HERNAN" <[email protected]> skrev i melding
> news:[email protected]...
> > Thank you, but There is any other way because I have more than 1500
> formulas,
> > and I don't want to go each by each one.
> > Something like formating or view
> > O brigado
> >
> >
> > "Marcelo" wrote:
> >
> > > Hi herman,
> > >
> > > use in an if function in your cell eg. =if(iserror(a1/a2),0,(a1;a2))
> > >
> > > change a1 a2 per your original formulas
> > >
> > > hth
> > > regards from Brazil
> > > Marcelo
> > >
> > > "HERNAN" escreveu:
> > >
> > > > I had a formula in a cell, that when ocurred I want it to hide, it
> says
> > > > #DIV0! and when I try to sort that column it mess everything that
> message.
> > > > I would like for example to say 0 instead of that error message, but I
> don't
> > > > know how to do it.
> > > > I would appriciate any help.
> > > > Thank you
>
>
>

You can just copy the formula in the first cell, then paste it down the
column as far as you need. That will fix the whole column.

-Simon

"HERNAN" wrote:

> Yes boths works, but there is anyway to format the hole column at once so
> doesn't show the errors
>
> "JE McGimpsey" wrote:
>
> > One way:
> >
> > If your formula is, for example,
> >
> > =A1/B1
> >
> > then use
> >
> > =IF(B1<>0,A1/B1,0)
> >
> > In article <[email protected]>,
> > HERNAN <[email protected]> wrote:
> >
> > > I had a formula in a cell, that when ocurred I want it to hide, it says
> > > #DIV0! and when I try to sort that column it mess everything that message.
> > > I would like for example to say 0 instead of that error message, but I don't
> > > know how to do it.
> > > I would appriciate any help.
> > > Thank you
> >

I understand that you want the #Div0 to go away or behave differently, and I
am trying to help you with it. But I can't do that unless you give me the
information I ask for.

The #Div0 is shown in a formula cell. What is the formula ?

Best wishes Harald

"HERNAN" <[email protected]> skrev i melding
news:[email protected]...
> Is a payment sheet so all the time I'm going to have ceros on the
accounts.
> But I only need to sort the ones that have numbers on it, when I try to do
> it. sorts the #DIV!0 first, and I don't want that.
>
> "Harald Staff" wrote:
>
> > 1500 formulas is easy to replace if they are equal. How many /different/
> > formulas do you have that returns Div0 ?
> > I believe you should get rid of the error, not the error message.
> >
> > Best wishes Harald
> >
> > "HERNAN" <[email protected]> skrev i melding
> > news:[email protected]...
> > > Thank you, but There is any other way because I have more than 1500
> > formulas,
> > > and I don't want to go each by each one.
> > > Something like formating or view
> > > O brigado
> > >
> > >
> > > "Marcelo" wrote:
> > >
> > > > Hi herman,
> > > >
> > > > use in an if function in your cell eg.
=if(iserror(a1/a2),0,(a1;a2))
> > > >
> > > > change a1 a2 per your original formulas
> > > >
> > > > hth
> > > > regards from Brazil
> > > > Marcelo
> > > >
> > > > "HERNAN" escreveu:
> > > >
> > > > > I had a formula in a cell, that when ocurred I want it to hide, it
> > says
> > > > > #DIV0! and when I try to sort that column it mess everything that
> > message.
> > > > > I would like for example to say 0 instead of that error message,
but I
> > don't
> > > > > know how to do it.
> > > > > I would appriciate any help.
> > > > > Thank you
> >
> >
> >