formula returns #N/A

[Kyler]

I have a formula which returns #N/A in some cells in a string--I need a
formula to ignore the error and leave the cell blank so that another formula
which reads the contents of that cell will skip over it and go to the next
cell

[Jason Morin]

The most common method:

=IF(ISNA(your_formula),"",your_formula)

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I have a formula which returns #N/A in some cells in a
string--I need a
>formula to ignore the error and leave the cell blank so
that another formula
>which reads the contents of that cell will skip over it
and go to the next
>cell
>.
>

[Fred Tuck]

Thanks very much--I have been looking for a solution for a while now and
this works like a charm--best regards!!!!

Kyler

"Jason Morin" wrote:

> The most common method:
>
> =IF(ISNA(your_formula),"",your_formula)
>
> HTH
> Jason
> Atlanta, GA
>
> >-----Original Message-----
> >I have a formula which returns #N/A in some cells in a
> string--I need a
> >formula to ignore the error and leave the cell blank so
> that another formula
> >which reads the contents of that cell will skip over it
> and go to the next
> >cell
> >.
> >
>

[MSP77079]

The more general solution is:

=IF(ISERROR(your_formula),"",your_formula)