how to hide #N/A's?

how to hide #N/A's?

Post by VG9kZ » Wed, 10 Nov 2004 01:16:01



I am using a formula that returns #N/A frequently and I am wondering if
there is a way using conditional formatting or a different format feature to
not have those returns show? All the #N/A make the worksheet look cluttered.

TIA


Todd
 
 
 

how to hide #N/A's?

Post by Don Guille » Wed, 10 Nov 2004 01:19:13

The best way to do this is
=if(isna(myformula),"",myformula)

--
Don Guillett
SalesAid Software
XXXX@XXXXX.COM


to
cluttered.

 
 
 

how to hide #N/A's?

Post by RjZIYXd » Wed, 10 Nov 2004 01:24:01

I used this formula for that issue:

=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)))

Mine involves looking data up in a table, but I think the ISNA() function is
what you are looking for. Do a search for IS functions, and you will see all
of them.

Perhaps what you are looking for is something along these lines:
=IF(ISNA(your.formula), "", your.formula)

HTH!
Dave
 
 
 

how to hide #N/A's?

Post by RjZIYXd » Wed, 10 Nov 2004 01:24:02

I used this formula for that issue:

=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)))

Mine involves looking data up in a table, but I think the ISNA() function is
what you are looking for. Do a search for IS functions, and you will see all
of them.

Perhaps what you are looking for is something along these lines:
=IF(ISNA(your.formula), "", your.formula)

HTH!
Dave
 
 
 

how to hide #N/A's?

Post by RjZIYXd » Wed, 10 Nov 2004 01:24:03

I used this formula for that issue:

=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)))

Mine involves looking data up in a table, but I think the ISNA() function is
what you are looking for. Do a search for IS functions, and you will see all
of them.

Perhaps what you are looking for is something along these lines:
=IF(ISNA(your.formula), "", your.formula)

HTH!
Dave
 
 
 

how to hide #N/A's?

Post by RjZIYXd » Wed, 10 Nov 2004 01:24:05

I used this formula for that issue:

=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)))

Mine involves looking data up in a table, but I think the ISNA() function is
what you are looking for. Do a search for IS functions, and you will see all
of them.

Perhaps what you are looking for is something along these lines:
=IF(ISNA(your.formula), "", your.formula)

HTH!
Dave
 
 
 

how to hide #N/A's?

Post by RjZIYXd » Wed, 10 Nov 2004 01:24:06

I used this formula for that issue:

=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)))

Mine involves looking data up in a table, but I think the ISNA() function is
what you are looking for. Do a search for IS functions, and you will see all
of them.

Perhaps what you are looking for is something along these lines:
=IF(ISNA(your.formula), "", your.formula)

HTH!
Dave
 
 
 

how to hide #N/A's?

Post by RjZIYXd » Wed, 10 Nov 2004 01:24:06

I used this formula for that issue:

=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)))

Mine involves looking data up in a table, but I think the ISNA() function is
what you are looking for. Do a search for IS functions, and you will see all
of them.

Perhaps what you are looking for is something along these lines:
=IF(ISNA(your.formula), "", your.formula)

HTH!
Dave
 
 
 

how to hide #N/A's?

Post by RjZIYXd » Wed, 10 Nov 2004 01:24:07

I used this formula for that issue:

=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)))

Mine involves looking data up in a table, but I think the ISNA() function is
what you are looking for. Do a search for IS functions, and you will see all
of them.

Perhaps what you are looking for is something along these lines:
=IF(ISNA(your.formula), "", your.formula)

HTH!
Dave
 
 
 

how to hide #N/A's?

Post by RjZIYXd » Wed, 10 Nov 2004 01:24:07

I used this formula for that issue:

=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP19:AP800,0),2)))

Mine involves looking data up in a table, but I think the ISNA() function is
what you are looking for. Do a search for IS functions, and you will see all
of them.

Perhaps what you are looking for is something along these lines:
=IF(ISNA(your.formula), "", your.formula)

HTH!
Dave
 
 
 

how to hide #N/A's?

Post by Domeni » Wed, 10 Nov 2004 01:34:58


Try the following...

1) Select your data

2) Format > Conditional Formatting > Formula Is

3) Enter the following formula:

=ISNA(A1)

4) Choose your format, in this case "White" for the color of your font

5) Click OK

Change the cell reference in the formula from A1 to the first cell i
the range of data you selected.

Hope this helps!

Todd Wrote: