View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Maracay Maracay is offline
external usenet poster
 
Posts: 11
Default Dealing with #VALUE!

Hi guys,

I created a function but in some rows I got a number and in other I got a
#VALUE!, that is OK, now I need to ask if cell 0 then do this if not do
that, but look like because the #VALUE! I am getting, the IF function is not
working properly, my question is how can I deal with #VALUE!, if I could make
#VALUE! Zero or €œ €œ depending on the case could be great

Thanks