Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
How do I display the result of one cell each time a change anothe. | Excel Worksheet Functions | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Cell Change Color - Need Help | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |