use of ISERROR
 

Hi,

A customer has asked me to supress any hashes. Typically the error is

#div/0!

I tried iserror(a2) and it came back true. If I change the value its false
so that works. The thing is hiding the #div/0! and hiding the result of the
iserror.

So I need another formula with this logic

if a2 is #div/0! then

a2 = ""

else if

a2 = the value of A2 ( it can contain a number)

and a1 (the result of Iserror)

= "" (all the time no matter if is true or false)

Thanks

Nathan

use of ISERROR
 

You need to use an if statement with it change A2 to your formula
=IF(ISERROR(A2),"",A2)
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"NathanG" wrote:

Hi,

A customer has asked me to supress any hashes. Typically the error is

#div/0!

I tried iserror(a2) and it came back true. If I change the value its false
so that works. The thing is hiding the #div/0! and hiding the result of the
iserror.

So I need another formula with this logic

if a2 is #div/0! then

a2 = ""

else if

a2 = the value of A2 ( it can contain a number)

and a1 (the result of Iserror)

= "" (all the time no matter if is true or false)

Thanks

Nathan

use of ISERROR
 

=IF(ISERROR(A2),"",A2)
Iow, you do not need ISERROR on its own in A1

You could also say =IF(ISERROR(C1/D1),"",C1/D1) If say D1 equals 0 or "",
then the cell containing the formula wil have "", else it will show the
outcome, eg C1 = 10, D1 = 2, it will show 5
--
Hth

Kassie Kasselman


"NathanG" wrote:

Hi,

A customer has asked me to supress any hashes. Typically the error is

#div/0!

I tried iserror(a2) and it came back true. If I change the value its false
so that works. The thing is hiding the #div/0! and hiding the result of the
iserror.

So I need another formula with this logic

if a2 is #div/0! then

a2 = ""

else if

a2 = the value of A2 ( it can contain a number)

and a1 (the result of Iserror)

= "" (all the time no matter if is true or false)

Thanks

Nathan

use of ISERROR
 

Are you sure that masking errors is a good idea? Wouldn't it be wise to
check out why you get the #DIV/0?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"NathanG" wrote in message
...
Hi,

A customer has asked me to supress any hashes. Typically the error is

#div/0!

I tried iserror(a2) and it came back true. If I change the value its false
so that works. The thing is hiding the #div/0! and hiding the result of
the
iserror.

So I need another formula with this logic

if a2 is #div/0! then

a2 = ""

else if

a2 = the value of A2 ( it can contain a number)

and a1 (the result of Iserror)

= "" (all the time no matter if is true or false)

Thanks

Nathan

use of ISERROR
 

That helped but the #div/0! is still showing but the result of isr=error is.
I need both cells blank if a2 is #div/0! or if it isn't, the iserror result
must be hidden but the value of A2 still show.

Thanks

"John Bundy" wrote:

You need to use an if statement with it change A2 to your formula
=IF(ISERROR(A2),"",A2)
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"NathanG" wrote:

Hi,

A customer has asked me to supress any hashes. Typically the error is

#div/0!

I tried iserror(a2) and it came back true. If I change the value its false
so that works. The thing is hiding the #div/0! and hiding the result of the
iserror.

So I need another formula with this logic

if a2 is #div/0! then

a2 = ""

else if

a2 = the value of A2 ( it can contain a number)

and a1 (the result of Iserror)

= "" (all the time no matter if is true or false)

Thanks

Nathan

use of ISERROR
 

If the source is legitimately 0, you could use a formula like

=IF(M1=0,"",N1/M1)

which is far better than using ISERROR IMO.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Bob Phillips" wrote in message
...
Are you sure that masking errors is a good idea? Wouldn't it be wise to
check out why you get the #DIV/0?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"NathanG" wrote in message
...
Hi,

A customer has asked me to supress any hashes. Typically the error is

#div/0!

I tried iserror(a2) and it came back true. If I change the value its
false
so that works. The thing is hiding the #div/0! and hiding the result of
the
iserror.

So I need another formula with this logic

if a2 is #div/0! then

a2 = ""

else if

a2 = the value of A2 ( it can contain a number)

and a1 (the result of Iserror)

= "" (all the time no matter if is true or false)

Thanks

Nathan

use of ISERROR
 

Close again but not quite. The cell with#div/0! is still showing.

Here are the values for the 2 cells concerned

a1: =IF(ISERROR(A2),"","")
a2: #div/0!

As it stands cell a2 needs to be made blank and cell a1 remain blank. If a2
has a number in it i.e 17182 this must be shown but the a1 still be hidden.

The customer is working on the logic for why #div occurs but we have been
asked for it now to show on the sheet.

Thanks

"Bob Phillips" wrote:

If the source is legitimately 0, you could use a formula like

=IF(M1=0,"",N1/M1)

which is far better than using ISERROR IMO.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Bob Phillips" wrote in message
...
Are you sure that masking errors is a good idea? Wouldn't it be wise to
check out why you get the #DIV/0?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"NathanG" wrote in message
...
Hi,

A customer has asked me to supress any hashes. Typically the error is

#div/0!

I tried iserror(a2) and it came back true. If I change the value its
false
so that works. The thing is hiding the #div/0! and hiding the result of
the
iserror.

So I need another formula with this logic

if a2 is #div/0! then

a2 = ""

else if

a2 = the value of A2 ( it can contain a number)

and a1 (the result of Iserror)

= "" (all the time no matter if is true or false)

Thanks

Nathan

use of ISERROR
 

It is A2 that I am referring to, check that formula and adjust so that you
don't get #DIV/0

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"NathanG" wrote in message
...
Close again but not quite. The cell with#div/0! is still showing.

Here are the values for the 2 cells concerned

a1: =IF(ISERROR(A2),"","")
a2: #div/0!

As it stands cell a2 needs to be made blank and cell a1 remain blank. If
a2
has a number in it i.e 17182 this must be shown but the a1 still be
hidden.

The customer is working on the logic for why #div occurs but we have been
asked for it now to show on the sheet.

Thanks

"Bob Phillips" wrote:

If the source is legitimately 0, you could use a formula like

=IF(M1=0,"",N1/M1)

which is far better than using ISERROR IMO.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Bob Phillips" wrote in message
...
Are you sure that masking errors is a good idea? Wouldn't it be wise to
check out why you get the #DIV/0?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"NathanG" wrote in message
...
Hi,

A customer has asked me to supress any hashes. Typically the error is

#div/0!

I tried iserror(a2) and it came back true. If I change the value its
false
so that works. The thing is hiding the #div/0! and hiding the result
of
the
iserror.

So I need another formula with this logic

if a2 is #div/0! then

a2 = ""

else if

a2 = the value of A2 ( it can contain a number)

and a1 (the result of Iserror)

= "" (all the time no matter if is true or false)

Thanks

Nathan

use of ISERROR
 

Let me see if I understand what's going on here.

Your working information is all really in A2, but you want to hide any error
displays in that cell, but for debugging/development purposes you want to see
that error in A1?
I'd something like this into the two cells:
in A1:
= If(IsError(N1/M1),N1/M1,"")
while in A2
= If(IsError(N1/M1),"",N1/M1)
substituting whatever the real formula used in A2 is right now for the N1/M1
statements in those formulas.


"NathanG" wrote:

Close again but not quite. The cell with#div/0! is still showing.

Here are the values for the 2 cells concerned

a1: =IF(ISERROR(A2),"","")
a2: #div/0!

As it stands cell a2 needs to be made blank and cell a1 remain blank. If a2
has a number in it i.e 17182 this must be shown but the a1 still be hidden.

The customer is working on the logic for why #div occurs but we have been
asked for it now to show on the sheet.

Thanks

"Bob Phillips" wrote:

If the source is legitimately 0, you could use a formula like

=IF(M1=0,"",N1/M1)

which is far better than using ISERROR IMO.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Bob Phillips" wrote in message
...
Are you sure that masking errors is a good idea? Wouldn't it be wise to
check out why you get the #DIV/0?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"NathanG" wrote in message
...
Hi,

A customer has asked me to supress any hashes. Typically the error is

#div/0!

I tried iserror(a2) and it came back true. If I change the value its
false
so that works. The thing is hiding the #div/0! and hiding the result of
the
iserror.

So I need another formula with this logic

if a2 is #div/0! then

a2 = ""

else if

a2 = the value of A2 ( it can contain a number)

and a1 (the result of Iserror)

= "" (all the time no matter if is true or false)

Thanks

Nathan