Thread: #VALUE! issue
View Single Post
  #1   Report Post  
Pat
 
Posts: n/a
Default #VALUE! issue

Is there a way to avoid a #VALUE! error being returned where there is no
value to return?

The formula I am using is simple =E33-J33 however J33 contains a formula
and in this particular instance does not return a value, so the error I am
getting stems from here.

Anyone know of a solution?
Many thanks for any suggestions.
Pat