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?

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

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?

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

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?

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

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)