Hiding formula results when blank cell within formula

  • Thread starter Thread starter Michael J. Malinsky
  • Start date Start date
M

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
 
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
 
Back
Top