VALUE error
 

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

VALUE error
 

=IF(ERROR.TYPE(A1)=3,0,A1)
--
David Biddulph

wrote in message
ups.com...
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

VALUE error
 

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

"David Biddulph" wrote in message
...
=IF(ERROR.TYPE(A1)=3,0,A1)

wrote in message
ups.com...
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