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

P.S According to my sent folder this message has already been sent, however
I am unable to trace it in this newsgroup.

Hi
try
=IF(ISNUMBER(J33),E33-J33,"")


"Pat" wrote:

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

P.S According to my sent folder this message has already been sent, however
I am unable to trace it in this newsgroup.

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

P.S According to my sent folder this message has already been sent,
however
I am unable to trace it in this newsgroup.