#VALUE! issue

[Pat]

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

 

[Max]

One way ..

Try: =IF(ISERROR(J33),"",E33-J33)