how to ignore N/A in a range

[bezbid]

I have this formulas in 2 cells,

Please Login or Register  to view this content.

in Range Data!$GC$2:$GC$2101 and Data!GE$2:GE$2101, there are some #N/A values in the result, how to alter the above formula?

[Aardigspook]

Hi,

In Excel 2007+, use this to return a blank cell if there is an error:
=IFERROR(<your formula>,"")

For Excel 2003, use this:
=IF(ISERROR(<your formula>),"",<your formula)

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' on your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.

[samba_ravi]

Data!$GC$2:$GC$2101 in this range you have Numeric values or text string

[bezbid]

If i need the formula in Data!$GC$2:$GC$2101 and Data!GE$2:GE$2101 to return the #N/A as i want it for plotting chart, what is the alternative

[bezbid]

Data!$GC$2:$GC$2101 and Data!GE$2:GE$2101 in this range is numeric value

[bezbid]

the #N/A result is only at the last dozens rows of the range, the formula in Data!$GC$2:$GC$2101 is like this,

Please Login or Register  to view this content.