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

The best way to do this is

=if(isna(myformula),"",myformula)

--

Don Guillett

SalesAid Software

XXXX@XXXXX.COM

to

cluttered.

=if(isna(myformula),"",myformula)

--

Don Guillett

SalesAid Software

XXXX@XXXXX.COM

to

cluttered.

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

=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

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

=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

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

=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

=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

=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

=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

=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

=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

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:

2. Weird Problem -- Repeating C's and N's

5. deleting empty lines from a variable containing \n's

6. Mofify data values of n's variables

7. 2 fields have embedded \n's, how to get rid of these?

8. index n's maximun values in an array

11. How to change the "N's" in proc report across time

12. Is is possible to count the Y/N's in a record?

13. Multiline tooltip problem... shows the \n's

14. Hidden folders questions - can I hide a hidden folder?

15. Hyperlink to hidden worksheet & hide worksheet automatically after done on the hidden worksheet

11 post • Page:**1** of **1**