You do something like this:

=if(or(a1="",b1=""),"",a1-a2)

If you are willing to trap all errors, you could do:

=if(iserror(a1-a2),"",a1-a2)

Regards,
Fred.

"amirstal" wrote in message
...
A simple formula (let's say B1=A1-A2) returns a value when A1 and A2
have a value in them, but returns an error (#VALUE) when A1 NS a2 are
empty. Is there a way EXCEL can disregard the error/#VALUE and show
nothing ON B1 when A1 and A2 are empty while returning a value on B1
when A1 and A2 do have a value in them?

Thanks,

Amir