Prev: excel 2007
Next: Different First Page?
From: rvtrails on 5 Mar 2010 15:02
I would like to format an #N/A result to a blank cell or with a 0 when
instead of the #N/A.

Can anyone assist in how to accomplish that?
Thanks!
Linda
From: Niek Otten on 5 Mar 2010 15:27
=if(isna(YourFormula),"",YourFormula)
or, in Excel2007 and newer:
=iferror(YourFormula,"")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel











"rvtrails" <rvtrails(a)discussions.microsoft.com> wrote in message
news:E622EAFB-E891-4543-94F5-476965D80645(a)microsoft.com...
>I would like to format an #N/A result to a blank cell or with a 0 when
> instead of the #N/A.
>
> Can anyone assist in how to accomplish that?
> Thanks!
> Linda

From: rvtrails on 5 Mar 2010 15:33
Perfect!! Thank you!

"Niek Otten" wrote:

> =if(isna(YourFormula),"",YourFormula)
> or, in Excel2007 and newer:
> =iferror(YourFormula,"")
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
>
>
>
>
>
>
>
>
>
>
> "rvtrails" <rvtrails(a)discussions.microsoft.com> wrote in message
> news:E622EAFB-E891-4543-94F5-476965D80645(a)microsoft.com...
> >I would like to format an #N/A result to a blank cell or with a 0 when
> > instead of the #N/A.
> >
> > Can anyone assist in how to accomplish that?
> > Thanks!
> > Linda
>
 | 
Pages: 1
Prev: excel 2007
Next: Different First Page?