an error.type test
 

Hi,

depending on error.type test result, i would like that my cell as a special
value.
for example i have 3 columns
L : column where are the amounts of cartridges needed in stock
J : column where are the amounts of cartridges used during last period
K : result of (L/J) if L/J different from #DIV/0, and =0 if L/J = #DIV/0

so my formula is the following one :
=IF(ERROR.TYPE(L3/J3)=2;0;(L3/J3))

but when L/J is different that #DIV/0, it display #N/A and not result of L/J.

why ?
thanks a lot,
Maileen