Thread: IF with #VALUE!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default IF with #VALUE!
=if(iserror(f6),0,1)

But that traps all possible errors--not just #value!'s.

Ashby wrote:

Is it possible to return a value for #VALUE! ie

=IF(F6=#VALUE!,0,1)

???

--

Dave Peterson
Reply With QuoteReply With Quote