Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Removing #N/A from formula results

17,427 views
Skip to first unread message

Holly

unread,
Jan 17, 2008, 8:15:01 PM1/17/08
to
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

CLR

unread,
Jan 17, 2008, 8:21:08 PM1/17/08
to
Wrap your formula in an IF statement.....

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

Vaya con Dios,
Chuck, CABGx3


"Holly" <Ho...@discussions.microsoft.com> wrote in message
news:F94B1373-A8F6-4C71...@microsoft.com...

Pete_UK

unread,
Jan 17, 2008, 8:26:09 PM1/17/08
to
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

unread,
Jan 17, 2008, 8:28:00 PM1/17/08
to
My Formula is a v lookup as follows:

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

Pete_UK

unread,
Jan 17, 2008, 8:34:08 PM1/17/08
to
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

> > > Holly- Hide quoted text -
>
> - Show quoted text -

Message has been deleted

jde...@gmail.com

unread,
Sep 6, 2012, 6:10:57 PM9/6/12
to
Awesome!! Big Help! Thank you very much!
Message has been deleted

Roger Govier

unread,
Mar 4, 2017, 8:28:59 AM3/4/17
to
If you have XL2007 or later, you could just wrap your formula in IFERROR()

=IFERROR(your formula,0)

Jake Johnson

unread,
Jan 22, 2022, 8:57:21 PM1/22/22
to
On Saturday, March 4, 2017 at 8:28:59 AM UTC-5, roger...@gmail.com wrote:
> If you have XL2007 or later, you could just wrap your formula in IFERROR()
>
> =IFERROR(your formula,0)
Just use the =IFNA(your formula))
0 new messages