formula returns #N/A
 

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

formula returns #N/A
 

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
.

formula returns #N/A
 

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
.