Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to hide #N/A's?
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 |
#2
|
|||
|
|||
The best way to do this is
=if(isna(myformula),"",myformula) -- Don Guillett SalesAid Software "Todd" wrote in message ... 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 |
#3
|
|||
|
|||
I used this formula for that issue:
=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,A P19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP1 9: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 "Todd" wrote: 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 |
#4
|
|||
|
|||
I used this formula for that issue:
=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,A P19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP1 9: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 "Todd" wrote: 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 |
#5
|
|||
|
|||
I used this formula for that issue:
=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,A P19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP1 9: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 "Todd" wrote: 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 |
#6
|
|||
|
|||
I used this formula for that issue:
=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,A P19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP1 9: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 "Todd" wrote: 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 |
#7
|
|||
|
|||
I used this formula for that issue:
=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,A P19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP1 9: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 "Todd" wrote: 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 |
#8
|
|||
|
|||
I used this formula for that issue:
=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,A P19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP1 9: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 "Todd" wrote: 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 |
#9
|
|||
|
|||
I used this formula for that issue:
=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,A P19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP1 9: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 "Todd" wrote: 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 |
#10
|
|||
|
|||
I used this formula for that issue:
=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,A P19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP1 9: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 "Todd" wrote: 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 |
#11
|
|||
|
|||
Sorry about the multiples, I am using the M$ browser interface, and it kept
telling me my post did not get sent, so I kept trying. Now I know better. |
#12
|
|||
|
|||
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 in the range of data you selected. Hope this helps! Todd Wrote: 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 -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=276264 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I hide the outline of a Forms Group Box? | Excel Discussion (Misc queries) | |||
hide column but show chart | Charts and Charting in Excel | |||
Excel - hide erroer values | Excel Discussion (Misc queries) | |||
hide column | New Users to Excel | |||
Conditional Hide function for Excel | Excel Worksheet Functions |