#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

One way ..

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

--
Rgds
Max
xl 97
--
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
---
"Pat" wrote in message
...
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