Removing #N/A from formula results
Something along these lines:
=IF(ISNA(your_formula),"",your_formula)
This returns a blank instead of #N/A - change the "" to 0 if you
prefer a zero.
Hope this helps.
Pete
On Jan 18, 1:15*am, Holly wrote:
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
|