#value!

[AFA]

Hi all

Cell Result Formula
(672.00) (672) =--SUBSTITUTE(+$Cell,".",",")
(10.00) (10) =--SUBSTITUTE(+$cell,".",",")
#VALUE! =--SUBSTITUTE(+$cell,".",",")

any idea if i need to change the result from "#Value! to "zero" if the cell
is "nil"

 

[minli]

If(iserror(A),"zero",A)

 

[Teethless mama]

=IF(A1="","zero",your formula)

 

[AFA]

thanks minli.

If(iserror(A),"zero",A)

 

[AFA]

thanks teethless mama!

=IF(A1="","zero",your formula)