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?
|