Avoiding #N/A result
in [Programming]
|
From: Wes_A on 27 Apr 2010 06:14 Is there a way to avoid getting the error result "#N/A" and rather having "" or 0 returned as the result? It's not a display issue, I don't want the error in the cell at all. Thanks for any suggestion.
From: joel on 27 Apr 2010 06:25 use an if statement for no returned results =if(error(your funcrtion),"",your function) or to return zero =if(error(your funcrtion),0,your function) -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=198752 http://www.thecodecage.com/forumz
From: Jacob Skaria on 27 Apr 2010 06:33 Handle that using ISNA() and IF() =IF(ISNA(yourformula),"",yourformula) OR =IF(ISNA(yourformula),0,yourformula) If you are using XL 2007 check out help for IFERROR() -- Jacob (MVP - Excel) "Wes_A" wrote: > Is there a way to avoid getting the error result "#N/A" and rather having "" > or 0 returned as the result? > It's not a display issue, I don't want the error in the cell at all. > Thanks for any suggestion.
From: ozgrid.com on 27 Apr 2010 20:26 It's far more efficient to let the #N/A happen, hide the column/row and reference the cell with; =IF(ISNA(A1),0,A1) http://www.ozgrid.com/Excel/stop-na-vlookup.htm -- Regards Dave Hawley www.ozgrid.com "Wes_A" <WesA(a)discussions.microsoft.com> wrote in message news:97F43545-939D-4FA6-BF74-DB1B7CFB43DA(a)microsoft.com... > Is there a way to avoid getting the error result "#N/A" and rather having > "" > or 0 returned as the result? > It's not a display issue, I don't want the error in the cell at all. > Thanks for any suggestion.
From: joel on 28 Apr 2010 00:51
It's far more efficient to let the #N/A happen, hide the column/row and reference the cell with; ????????? Efficient is an interesting word especially in this incident! What do you mean? Can you prove it? -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=198752 http://www.thecodecage.com/forumz |