[Holly]

My Formula is a v lookup as follows:

=VLOOKUP(D223,Cashflow!P:R,3,FALSE)
--
Cheers,
Holly


"CLR" wrote:

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