Removing #N/A from formula results

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Holly - 18 Jan 2008 01:15 GMT

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?

Signature

Cheers,
Holly

Reply to this Message

CLR - 18 Jan 2008 01:21 GMT

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

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

Vaya con Dios,
Chuck, CABGx3

> Hi All,
>
[quoted text clipped - 3 lines]
> Cheers,
> Holly

Reply to this Message

Holly - 18 Jan 2008 01:28 GMT

My Formula is a v lookup as follows:

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

Signature

Cheers,
Holly

> Wrap your formula in an IF statement.....
>
[quoted text clipped - 10 lines]
> > Cheers,
> > Holly

Reply to this Message

Pete_UK - 18 Jan 2008 01:34 GMT

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

> My Formula is a v lookup as follows:
>
[quoted text clipped - 19 lines]
>
> - Show quoted text -

Reply to this Message

Pete_UK - 18 Jan 2008 01:26 GMT

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

> Hi All,
>
[quoted text clipped - 3 lines]
> Cheers,
> Holly

Reply to this Message