Removing #N/A from formula results

  • Thread starter Thread starter Holly
  • Start date Start date
H

Holly

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?
 
Wrap your formula in an IF statement.....

=IF(ISNA(YourFormula),"",YourFormula)

Vaya con Dios,
Chuck, CABGx3
 
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
 
My Formula is a v lookup as follows:

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


CLR said:
Wrap your formula in an IF statement.....

=IF(ISNA(YourFormula),"",YourFormula)

Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
Then change it to this:

=IF(ISNA(VLOOKUP(D223,Cashflow!P:R,3,FALSE)),"",VLOOKUP(D223,Cashflow!
P:R,3,FALSE))

Hope this helps.

Pete
 
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?
Click to expand...

Awesome!! Big help!! Thank you very much!!
 
Back
Top