Removing #N/A from formula results

[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?

 

[CLR]

Wrap your formula in an IF statement.....

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

Vaya con Dios,
Chuck, CABGx3

 

[Pete_UK]

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

 

[Holly]

My Formula is a v lookup as follows:

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

Wrap your formula in an IF statement.....

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

Vaya con Dios,
Chuck, CABGx3

 

[Pete_UK]

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

 

[jdemp42]

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?

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

 

[jdemp42]

Wrap your formula in an IF statement.....

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

Vaya con Dios,
Chuck, CABGx3

Awesome!! Big Help! Thank you very much!