supres #n/b


Posted by marc klaui on September 07, 2000 1:54 PM

I'm ussing index and match to finds a value in a datatabel,
BUT not all dat is filled al the time. So excel Say #N/B.
Now I want to fill the cell with "0". I think it's VEEEEERy simple.... But i can't figure out how to do
it.



Posted by Celia on September 07, 0100 8:25 PM

Marc
The stucture to do this for any formula is :-

=IF(ISERROR(your formula),0,your formula)

Instead of ISERROR, specific errors can be identified such as #N/A, #NUM, et cetera.
Have a look at "IS Functions" in on-line Help for details.
Celia