How to Bypass #NA

[avk]

I have use below two formula's.

In above formula we have formated as "general".
As per above formula if data not in listed then show as 0 (zero)
Now i want in those column as blank instead of 0 (zero).

In above formula we have formated as "date"
As per above formula if data not in listed then show as #NA
Here i want in those column as blank instead of #NA.

In view of the above can anyone solved my problem.

[contaminated]

There are several ways of bypassing this kind of error. All these ways had been discussed before. Bu in any case I'll show you 4 of them
First three formulas used in Excel 2003 and later

1. =IF(ISERROR(YourFormula),"",YourFormula)
2. If formula outputs are numbers only! =LOOKUP(99^99,CHOOSE({1,2},0,YourFormula))
3. If formula output is text only =LOOKUP(REPT("z",255),CHOOSE({1,2},"",YourFormula))
4. Excel 2007 or later =IFERROR(YourFormula,"")

And for the future. Never wrap formulas or other codes into HTML tages. They becomes hard to read. Use CODE tags instead.
Good Luck