Can you show an example ,,, sounds like an IFISERROR would fix ,, but post an
example so we can be sure.

"Maracay" wrote:

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