If you are using Excel 2007, there is a new formula IFERROR you can
use it.

= IFERROR(a1-a2,"") in the cell B1

On Sep 16, 2:33*am, amirstal wrote:
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