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
=IF(ISNA(YourFormula),"",YourFormula)
Vaya con Dios,
Chuck, CABGx3
"Holly" <Ho...@discussions.microsoft.com> wrote in message
news:F94B1373-A8F6-4C71...@microsoft.com...
=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
=VLOOKUP(D223,Cashflow!P:R,3,FALSE)
--
Cheers,
Holly
=IF(ISNA(VLOOKUP(D223,Cashflow!P:R,3,FALSE)),"",VLOOKUP(D223,Cashflow!
P:R,3,FALSE))
Hope this helps.
Pete
> > > Holly- Hide quoted text -
>
> - Show quoted text -