Formula presumes cells have data
 

The following formula presumes there is data in N75 and J75

=IF(ISNUMBER($R75)*($R75<0),"",IF(AND($N75-$J750,$Q75=1),0,$N75-$J75))

When no data can be found #VALUE! error is returned. I need to have the
formula to be returned without any errors.

I have tried varies combinations but none were successful. Here is one of
them:

=IF(ISNUMBER($R74)*($R74<0),"",IF(AND(ISNUMBER($N 74)-($J740),$Q74=1),0,ISNUMBER($N74)-($J74)))


Thanks if you can fix it.
Pat

No need to post same question more than once

--

Regards,

Peo Sjoblom


"Pat" wrote in message
...
The following formula presumes there is data in N75 and J75

=IF(ISNUMBER($R75)*($R75<0),"",IF(AND($N75-$J750,$Q75=1),0,$N75-$J75))

When no data can be found #VALUE! error is returned. I need to have the
formula to be returned without any errors.

I have tried varies combinations but none were successful. Here is one of
them:


=IF(ISNUMBER($R74)*($R74<0),"",IF(AND(ISNUMBER($N 74)-($J740),$Q74=1),0,ISN
UMBER($N74)-($J74)))


Thanks if you can fix it.
Pat