#value!
thanks teethless mama!
"Teethless mama" wrote:
=IF(A1="","zero",your formula)
"AFA" wrote:
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"
|