Hiding formula results when blank cell within formula

[Michael J. Malinsky]

The following will return a null string if either A1 or B1 is blank.

=IF(OR(ISBLANK(A1),ISBLANK(B1)),"",B1-A1)

--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain

 

[Peter]

Has anyone got ANY idea how;

If cells A1 and A2 have dates in them, and A3 calculates
the number of days between those dates. How can I stop A3
from showing the result until the info in put into A2.

At the mo, if there is no date yet for A2, A3 simply show
the calculation as if A2 were 1st Jan 1900!


Thanks

 

[Jason Morin]

One way:

=IF(COUNT(A1:A2)<>2,"",A1-A2)

HTH
Jason
Atlanta, GA

 

[Andy B]

Peter

Try this:
=IF(A2<>"",yourformula,"")

Andy.

 

[Frank Kabel]

Hi Peter
try
=IF(A2<>"",A2-A1,"")