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
