Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 18th 07, 11:12 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 1
Default 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   Report Post  
Old January 18th 07, 11:17 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,624
Default 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   Report Post  
Old January 20th 07, 04:29 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 7,247
Default 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   Report Post  
Old January 20th 07, 07:00 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,624
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using an offset formula for the reference in a relative reference Cuda Excel Worksheet Functions 6 November 15th 06 06:12 PM
How do I display the result of one cell each time a change anothe. Mike S Excel Worksheet Functions 1 September 8th 06 08:17 AM
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
Cell Change Color - Need Help alani New Users to Excel 3 June 29th 05 03:50 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 08:49 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017