Convert error info into a value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using the MATCH function to determine if a calcuation should be done. The problem is if a MATCH is not found "#N/A" is displayed in the cell. If this cell needs to be added into a column of numbers to get a total. But, because of the "#N/A" the total can not be reached.

My question is can an Error message like "#N/A" be converted into a value like 0.00?

Thanks for any advise... tjamestx
 
Sometimes #N/A can be of help since it shows your lookup value doesn't
match or is missing.
You can still total it using SUMIF

=SUMIF(MyRange,"<>#N/A")

will disregard the N/A

If not you can use

=IF(ISNA(MATCH(A1,Range,0)),0,Formula)
--

Regards,

Peo Sjoblom


tjamestx said:
I'm using the MATCH function to determine if a calcuation should be done.
Click to expand...
The problem is if a MATCH is not found "#N/A" is displayed in the cell. If
this cell needs to be added into a column of numbers to get a total. But,
because of the "#N/A" the total can not be reached.
 
Back
Top