formula returns #N/A

[Guest]

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

 

[Guest]

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

Kyler