Removing #N/A from formula results
Wrap your formula in an IF statement.....
=IF(ISNA(YourFormula),"",YourFormula)
Vaya con Dios,
Chuck, CABGx3
"Holly" wrote in message
...
Hi All,
Is there a way to remove #N/A as a result from a formula, for example to
return a blank or zero result instead?
--
Cheers,
Holly
|