How do i change cell display from #N/A to 0?

when the result of a formula is displayed in a cell, i want it to read "0"
not "#N/A" so that i can use it to link to other cells. how do i accomplish
this?

One way:

=IF(ISNA(<your formula>),0,<your formula>)

In article >,
osubigdog > wrote:

> when the result of a formula is displayed in a cell, i want it to read "0"
> not "#N/A" so that i can use it to link to other cells. how do i accomplish
> this?

Just for the record, in Excel 2007 you can use the new IFERROR function.
E.g.,

=IFERROR(your_formula, result_if_error)



"JE McGimpsey" > wrote in message
...
> One way:
>
> =IF(ISNA(<your formula>),0,<your formula>)
>
> In article >,
> osubigdog > wrote:
>
>> when the result of a formula is displayed in a cell, i want it to read
>> "0"
>> not "#N/A" so that i can use it to link to other cells. how do i
>> accomplish
>> this?

And, if you'd like, it's easy to implement IFERROR() in previous
versions, though usually less efficiently:

Public Function IfError(ByRef vTest As Variant, _
Optional ByRef vDefault _
As Variant = vbNullString) As Variant
If IsError(vTest) Then
IfError = vDefault
Else
IfError = vTest
End If
End Function


In article >,
"Chip Pearson" > wrote:

> Just for the record, in Excel 2007 you can use the new IFERROR function.
> E.g.,
>
> =IFERROR(your_formula, result_if_error)
>
>
>
> "JE McGimpsey" > wrote in message
> ...
> > One way:
> >
> > =IF(ISNA(<your formula>),0,<your formula>)