VALUE error

E

evil91

I need a way to avoid the #value! error, i.e. something along the lines
of IF(ISNA. All i want to do is to change the value of the cell to "0"
if there is a #VALUE! error.
TIA
 
D

David Biddulph

That gives #N/A if no error, so try
=IF(ISERR(A1),IF(ERROR.TYPE(A1)=3,0,A1),A1)
 
Top