Thread: Formula returns #value! if value is not found
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arno Arno is offline
external usenet poster
  
Posts: 60
Default Formula returns #value! if value is not found
Hello,

Formula returns #value! if value is not found:

=SMALL(V14:V21,IF(COUNTIF(V14:V21,"<0"),1,COUNTIF( V14:V21,0)+1))

Is there a solution to avoid #value! I need only to see the minimum

Thanks Arno
Reply With QuoteReply With Quote